SCADAConnect Simulator adding a "#" symbol to SQL query

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

  • Created by Bentley Colleague
  • When: Tue, Mar 24 2020 3:16 PM
  • Revisions: 1
  • Comments: 0
Recommended
Related