KepwareEx DataLogger -- Unable to query recordset No Reason given.

[just_lionel]

I've posted this on the ptc forum as well, but no luck with an answer (waiting for my service contract number)

I keep getting the following error on the DataLogger



I have recreated the table many times from scratch. With no luck. I finally got it running once with no issue. Then the computer restarted (dang Windows update) and stopped working again. I'm lost...and aggraved.

 

[TheWaterboy]

SQL permissions maybe? Does the DSN dialog make the ODBC connection without error ? Turn on its logging and see if that tells you anything.

 

[just_lionel]

Yes, no problem with the connection.

Log for this one only come back with this:

-- Query logging
--
-- Driver name: MySQL ODBC 8.0 Driver Version: 08.00.0036
-- Timestamp: 240407 5:51:32

1712483492:select TABLE_SCHEMA as TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,DATA_TYPE,COLUMN_TYPE as TYPE_NAME,IF(ISNULL(CHARACTER_MAXIMUM_LENGTH), CASE DATA_TYPE WHEN 'bit' THEN CAST((NUMERIC_PRECISION + 7) / 8 AS UNSIGNED) WHEN 'json' THEN 1073741823 ELSE NUMERIC_PRECISION END, CHARACTER_MAXIMUM_LENGTH) as COLUMN_SIZE,CASE DATA_TYPE WHEN 'json' THEN 4294967295 ELSE CHARACTER_OCTET_LENGTH END as BUFFER_LENGTH,NUMERIC_SCALE as DECIMAL_DIGITS,IF(ISNULL(NUMERIC_PRECISION), NULL, 10) as NUM_PREC_RADIX,IF(EXTRA LIKE '%auto_increment%', 'YES', IS_NULLABLE) as NULLABLE,COLUMN_COMMENT as REMARKS,IF(ISNULL(COLUMN_DEFAULT), 'NULL', IF(ISNULL(NUMERIC_PRECISION), CONCAT('\'', COLUMN_DEFAULT, '\''),COLUMN_DEFAULT)) as COLUMN_DEF,0 as SQL_DATA_TYPE,NULL as SQL_DATA_TYPE_SUB,CASE DATA_TYPE WHEN 'json' THEN 4294967295 ELSE CHARACTER_OCTET_LENGTH END as CHAR_OCTET_LENGTH,ORDINAL_POSITION,IF(EXTRA LIKE '%auto_increment%', 'YES', IS_NULLABLE) AS IS_NULLABLE,IF(DATA_TYPE like 'json', 4, MAXLEN) as CHAR_SIZE FROM information_schema.COLUMNS c LEFT JOIN information_schema.CHARACTER_SETS cs ON c.CHARACTER_SET_NAME = cs.CHARACTER_SET_NAME WHERE 1=1 AND c.TABLE_SCHEMA=DATABASE() AND c.TABLE_NAME LIKE ? ORDER BY ORDINAL_POSITION;
-- Query logging
--
-- Driver name: MySQL ODBC 8.0 Driver Version: 08.00.0036
-- Timestamp: 240407 5:51:32

1712483492:Using prepared statement;
1712483492:SELECT * FROM `sor_db` LIMIT 1;
1712483492:ssps has been executed;
1712483492:query has been executed;
1712483492:Using prepared statement;
1712483492:SELECT * FROM `sor_db` LIMIT 1;
1712483492:ssps has been executed;
1712483492:query has been executed;
1712483495:ROLLBACK;
-- Query logging
--
-- Driver name: MySQL ODBC 8.0 Driver Version: 08.00.0036
-- Timestamp: 240407 5:51:35

1712483495:select TABLE_SCHEMA as TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,DATA_TYPE,COLUMN_TYPE as TYPE_NAME,IF(ISNULL(CHARACTER_MAXIMUM_LENGTH), CASE DATA_TYPE WHEN 'bit' THEN CAST((NUMERIC_PRECISION + 7) / 8 AS UNSIGNED) WHEN 'json' THEN 1073741823 ELSE NUMERIC_PRECISION END, CHARACTER_MAXIMUM_LENGTH) as COLUMN_SIZE,CASE DATA_TYPE WHEN 'json' THEN 4294967295 ELSE CHARACTER_OCTET_LENGTH END as BUFFER_LENGTH,NUMERIC_SCALE as DECIMAL_DIGITS,IF(ISNULL(NUMERIC_PRECISION), NULL, 10) as NUM_PREC_RADIX,IF(EXTRA LIKE '%auto_increment%', 'YES', IS_NULLABLE) as NULLABLE,COLUMN_COMMENT as REMARKS,IF(ISNULL(COLUMN_DEFAULT), 'NULL', IF(ISNULL(NUMERIC_PRECISION), CONCAT('\'', COLUMN_DEFAULT, '\''),COLUMN_DEFAULT)) as COLUMN_DEF,0 as SQL_DATA_TYPE,NULL as SQL_DATA_TYPE_SUB,CASE DATA_TYPE WHEN 'json' THEN 4294967295 ELSE CHARACTER_OCTET_LENGTH END as CHAR_OCTET_LENGTH,ORDINAL_POSITION,IF(EXTRA LIKE '%auto_increment%', 'YES', IS_NULLABLE) AS IS_NULLABLE,IF(DATA_TYPE like 'json', 4, MAXLEN) as CHAR_SIZE FROM information_schema.COLUMNS c LEFT JOIN information_schema.CHARACTER_SETS cs ON c.CHARACTER_SET_NAME = cs.CHARACTER_SET_NAME WHERE 1=1 AND c.TABLE_SCHEMA=DATABASE() AND c.TABLE_NAME LIKE ? ORDER BY ORDINAL_POSITION;