Product(s): |
WaterGEMS |
Version(s): |
CONNECT Edition |
Area: |
|
Problem
When importing historical SCADA data from the SQL server, a "#" is being added to the SQL query, which will not allow the data to be imported properly.
Solution
This can be resolved by adjusting the prefix and suffix for the data/time delimiters. To do this, go to the Database Connection in SCADAConnect Simulator and click the Advanced button. There you will find the Prefix and Suffix for SQL Query Date/Time Delimiters. Change these to an apostrophe (') symbol. This should help with the issue.
See Also
Using SCADAConnect Simulator