Kepware Knowledge Base: Solution
Unable to Query Recordset on Log Group '<Group Name>' (Reason: 'Could Not Complete Cursor Operation Because the Table Schema Changed After the Cursor was Declared')
Last Update: 11/7/2018
Problem:
The following error message is received while logging data to a table in the SQL server with DataLogger: "Unable to query recordset on Log Group '<Group Name>' (Reason: 'Could not complete cursor operation because the table schema changed after the cursor was declared')". DataLogger continues to log data.
Possible Cause:
In most cases, the database or data table is locked by another user or a background maintenance task that cleans and compresses the data table.
Solution:
Ensure that no tasks are running that will lock the table while data is being logged.
Note: Users that cannot implement the solution should be aware that every time the error message is posted, data will not be logged.
©
2022
PTC Inc. All Rights Reserved.