SQL Export limited to 100000 rows

[Saminpa]

Hi All,

I am relatively new to GeoSCADA so maybe I am missing something but I am having some difficulty extracting a fairly large amount of data for offline analysis of a control problem.

What I had set up was a SQL Export to a csv file (below) but there were a number of issues with extracting the 10 points I needed.

1. I could not figure out how to [without creating a horrendous join] get the data to come out as timestamp + 10 columns instead of one concatenated column, hence the single-point query in the photo

2. I resigned myself to having to do 10 exports and align the data by hand but then realized that no matter what I did my csv file was truncated at 100000 rows even though (second photo below) Server Configuration\SQL Query Configuration\Parameters\Query Row & Size Limit are set at 5000000 and 250 MB

3. That meant that I had to do 50 individual exports to get all the data I needed and I'm still working on aligning all of it manually which is just a little bit insane, there has to be an easier way

Can someone please tell me what I am doing wrong?

Thanks!

[AndrewScott · Accepted solution]

The "HKEY_LOCAL_MACHINE\SOFTWARE\Schneider Electric\ClearSCADA\DriverSQLExport\MaxRows" registry setting defines the maximum number of rows returned by the queries in SQL export driver (default 100,000).

The driver will need to be restarted after changing this setting for it to take effect.

Care needs to taken when increasing this as it can adversely effect system performance if set too high.

[Samueljonas]

---

@Saminpa wrote: MonkeyCool

Hi All, 

I am relatively new to GeoSCADA so maybe I am missing something but I am having some difficulty extracting a fairly large amount of data for offline analysis of a control problem.

What I had set up was a SQL Export to a csv file (below) but there were a number of issues with extracting the 10 points I needed.

1. I could not figure out how to [without creating a horrendous join] get the data to come out as timestamp + 10 columns instead of one concatenated column, hence the single-point query in the photo

2. I resigned myself to having to do 10 exports and align the data by hand but then realized that no matter what I did my csv file was truncated at 100000 rows even though (second photo below) Server Configuration\SQL Query Configuration\Parameters\Query Row & Size Limit are set at 5000000 and 250 MB

3. That meant that I had to do 50 individual exports to get all the data I needed and I'm still working on aligning all of it manually which is just a little bit insane, there has to be an easier way

Can someone please tell me what I am doing wrong?

Thanks!

---

Do you know exact number of rows to be exported? Did you check it..