无法完成游标操作，因为在声明游标后表格架构已更改 [英] Could not complete cursor operation because the table schema changed after the cursor was declared

问题描述

Hello，



我有一个应用程序SQL作业失败（只需一次迭代）



无法完成游标操作，因为声明了游标后表格架构发生了变化。 [SQLSTATE 42000]（错误16943） 无法完成游标操作，因为在声明游标后表格架构已更改。 [SQLSTATE 42000]（错误
16943）。 步骤失败。



我注意到有一个维护作业（重建索引），它在应用程序作业开始的同时开始（04 AM）。 有人可以向我解释这个
吗？这会因阻塞而发生吗？ 是否有永久性修复？

解决方案

https://dba.stackexchange.com/questions/218760/could - 未完成-光标操作，因为最表型模式改变的-后的-C

Hello,

I have an application SQL job which failed(just one iteration) by throwing this below error

Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943)  Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943).  The step failed.

I noticed there is a maintenance job(rebuild index) which starts (04 AM)at the same time when the application job starts.  Could someone explain to me this
? Does this occur due to blocking?  Is there a permanent fix?

解决方案

https://dba.stackexchange.com/questions/218760/could-not-complete-cursor-operation-because-the-table-schema-changed-after-the-c

这篇关于无法完成游标操作，因为在声明游标后表格架构已更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！