Error messages from IQ - Revision history

Psap at 09:13, 24 February 2009

2009-02-24T09:13:50Z

Psap at 16:34, 9 January 2008

2008-01-09T16:34:52Z

Psap at 08:38, 28 December 2007

2007-12-28T08:38:33Z

Psap at 16:07, 19 April 2007

2007-04-19T16:07:46Z

New page

Sybase IQ sometimes gives some confusing error messages.
Look at this one:

Exception Thrown from db_txnInfo.cxx:833, Err# 1, tid 143 origtid 143
O/S Err#: 0, ErrID: 1025 (db_catalogException); SQLCode: -1000029, SQLState: 'QDA29', Severity: 14
[20689]: Cannot open the requested object for write in the current transaction (1722819). Another user has write access in transaction 1722818.
-- (db_txnInfo.cxx 833)

When you get this message in the IQ message file, it means that only a single session can update the same table at the same time. Although the text of the message indicates that an exception in the catalog was detected, you will see this error also for base IQ tables.

[[Category:IQ]]

@@ Line 1: / Line 1: @@
 Sybase IQ sometimes gives some confusing error messages. Here are some messages and a possible solution
-===QDA11===
+===QDA11 - Transaction <nr> attempted to access an object created by transaction <other-number>===
   Exception Thrown from db_txnInfo.cxx:690, Err# 0, tid 478 origtid 478
      O/S Err#: 0, ErrID: 1025 (db_catalogException); SQLCode: -1000011, SQLState: 'QDA11', Severity: 14
@@ Line 9: / Line 9: @@
 See http://www.petersap.nl/SybaseWiki/index.php/Versioning_and_locks for a detailed discussion.
-===QDA29===
+===QDA29 - Cannot open the requested object for write in the current transaction===
   Exception Thrown from db_txnInfo.cxx:833, Err# 1, tid 143 origtid 143
      O/S Err#: 0, ErrID: 1025 (db_catalogException); SQLCode: -1000029, SQLState: 'QDA29', Severity: 14
@@ Line 17: / Line 17: @@
 When you get this message in the IQ message file, it means that only a single session can update the same table at the same time. Although the text of the message indicates that an exception in the catalog was detected, you will see this error also for base IQ tables.
-===Msg 17901===
+===QXA11 - Not enough server threads available for this query===
   Msg 17901, Level 16, State 0:
   RAISERROR executed:  The userid "<user-name>" cannot be found in the User Admin tables.  See the database administrator.

@@ Line 1: / Line 1: @@
 Sybase IQ sometimes gives some confusing error messages. Here are some messages and a possible solution
-===1===
+===QDA11===
   Exception Thrown from db_txnInfo.cxx:833, Err# 1, tid 143 origtid 143
      O/S Err#: 0, ErrID: 1025 (db_catalogException); SQLCode: -1000029, SQLState: 'QDA29', Severity: 14
@@ Line 7: / Line 15: @@
   -- (db_txnInfo.cxx 833)
-When you get this message in the IQ message file, it means that only a single session can update the same table at the same time. Although the text of the message indicates that an exception in the catalog was detected, you will see this error also for base IQ tables. This message could be seen quite often in 12.6 but should be solved in 12.7, although I still occasionaly get one in 12.7 esd 3.
+When you get this message in the IQ message file, it means that only a single session can update the same table at the same time. Although the text of the message indicates that an exception in the catalog was detected, you will see this error also for base IQ tables.
-===2===
+===Msg 17901===
   Msg 17901, Level 16, State 0:
   RAISERROR executed:  The userid "<user-name>" cannot be found in the User Admin tables.  See the database administrator.