Note These error messages are displayed in SQL Server 2008 Analysis Services and in SQL Server 2008 R2 Analysis Services.
- Server: The operation has been cancelled
- The text of the error that is returned to the client application
- The SQL Profiler Error event text
- The Errorcolumn for various events in SQL Profiler
Service pack information for SQL Server 2008To resolve this problem, obtain the latest service pack for SQL Server 2008. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
Service pack information for SQL Server 2008 R2To resolve this problem, obtain the latest service pack for SQL Server 2008 R2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
When you install SQL Server 2008 SP2 or SQL Server 2008 R2 SP2, the following six error messages are added to clarify some cases in which the generic “Server: The operation has been cancelled” error message is returned.
Note These messages do not replace the generic error message in every case. In some scenarios, you may still receive the generic error message.
|Hexadecimal Hresult||Decimal HResult||Decimal return code||Error message text||Scenario|
|0xC11C0006||-1055129594||3239837702||The current operation was cancelled because another operation in the transaction failed.||Processing can run multiple operations in parallel. When one of these jobs fails, it causes all other active jobs to fail. The additional failures generate this error. Check for the cause of the failure in another error.|
|0xC11C0007||-1055129593||3239837703||Proactive caching was cancelled because newer data became available.||Proactive caching starts to process, but a new notification is received that would cause the MOLAP cache to become stale. Therefore, the server cancels the processing operation and then restarts that operation so that the MOLAP cache reflects the new data.|
|0xC11C0008||-1055129592||3239837704||The session was cancelled because session objects were modified by another transaction.||A session cube or grouping cube is created on the session. However, one of the objects on which the session cube or grouping cube was based is modified by another transaction. The state of the cube cannot be recovered when this happens. Therefore, the server cancels the session and generates this error.|
|0xC11C0009||-1055129591||3239837705||The operation was cancelled because of locking conflicts.||When two concurrent transactions try to take locks that conflict with one another, the lock manager may detect a deadlock. If this occurs, the lock manager cancels one of the transactions. That cancelation causes this error.|
|0xC11C000A||-1055129590||3239837706||The operation was cancelled by the user.||The user sends a Cancel request on the session. This causes the active operation to be canceled.|
|0xC11C000B||-1055129589||3239837707||The session was cancelled because it exceeded a timeout setting (session orphaned timeout or session idle timeout) or it exceeded the session memory limit.||This error covers the following cases:|
รหัสบทความ: 2216456 - การตรวจสอบครั้งสุดท้าย: 14 พ.ค. 2012 - ฉบับแก้ไข: 1