Problem

Why am I not getting results for query in SCADAConnect when connecting to iHistorian?

I get the following error message:

Error Message: 'IhOLEDB.iHistorian.1' failed with no error message available, result code: DB_E_NOTABLE(0x80040E37).Error Details: System.Data.OleDb.OleDbException: 'IhOLEDB.iHistorian.1' failed with no error message available, result code: DB_E_NOTABLE(0x80040E37).

at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
...

Or:

**ERROR** API Error: DATA RETRIEVAL COUNT EXCEEDED
API Error: DATA RETRIEVAL COUNT EXCEEDED

Solution

iHistorian uses a different SQL syntax than what is used in SCADAConnect and therefore was not fully supported as of the initial release of v8i SELECTseries 5

An enhancement is now available as a patch to SELECTseries 5, adding functionality and support for iHistorian to WaterCAD and WaterGEMS.  This functionality will be included in the next release.

If you are using SCADAConnect with iHistorian, and using WaterGEMS SELECTseries 5, please contact our technical support group for the patch. 

See Also