Schema changed after cursor was declared

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Schema changed after cursor was declared

Author

Topic

automatism
Starting Member

2 Posts

Posted - 2008-09-04 : 11:04:35

I'm using National Instruments TestStand to log test results to a SQL Server database and it is throwing up an error message sometimes when logging results. It has this problem more often when there is a large amount of data. The error message is from the server rather than TestStand. I'm hoping this counts as a 'data corruption issue' and haven't upset someone posting in the wrong place. Error message is below. Any ideas? I've searched on the web for this problem but not found anything that helped.

An error occurred calling 'LogResults' in 'ITSDBLog' of 'DBLog 1.0 Type Library'
An error occurred executing a statement.
Schema: T76 Record set.
Statement: Execution.
Could not complete cursor operation because the table schema changed after the cursor was declared.
Description: Could not complete cursor operation because the table schema changed after the cursor was declared.
Number: -2147467259
NativeError: 16943
SQLState: 42000
Reported by: Microsoft OLE DB Provider for SQL Server
Description: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Number: -2147217887
NativeError: 0
SQLState: 42000
Reported by: Microsoft OLE DB Provider for SQL Server

Source: TSDBLog

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-09-04 : 11:20:24

http://support.microsoft.com/kb/930775

Auto-shrink can cause this error, if the auto-shrink kicks in and re-arranges data pages while the cursor is open. Same with maintenance plans that do re-indexing.

Check neither of these are scheduled while your cursor process is running.

E 12°55'05.63"
N 56°04'39.26"

automatism
Starting Member

2 Posts

Posted - 2008-09-04 : 12:46:01

Autoshrink isn't enabled I'm afraid.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources