Error ORA-28534 when communicating to the IM-server through ODBC
The query done by the third party software is:
SELECT LOGNAME, QUALITY, DATAVALUE, TIMESTAMP FROM numericlog WHERE LOGNAME in (‘TI520E01:IOPar.IO.Value’) and TIMESTAMP between ‘2021/03/11 10:14:24’ and ‘2021/03/11 10:24:24’Probably the strings in the query are not correctly converted to a date-time.
The region format setting is English-United States.
The capability table settings need to be checked, but where can I find these settings?
Or is there another problem?
(The ABB_ODA ODBC connection is working)
You can try this type of query, as I know it works. Change the "in" to "=" and get rid of the brackets around the log name. Use all CAPS in the log name.
THIS WORKS IN DD Excel SQL WINDOW:
select logname, datavalue, timestamp from numericlog where logname = 'COUNTER2/COUNT:VALUE' and timestamp >= '2012/06/12 16:45:00' and timestamp <= '2012/06/12 17:59:00';
If you have any questions, you should contact the US-L3 Support Group as they are responsible for the IM Product.
Retired Technical Support