Difference between revisions of "Error messages from IQ"
From SybaseWiki
| Line 1: | Line 1: | ||
| − | Sybase IQ sometimes gives some confusing error messages. | + | Sybase IQ sometimes gives some confusing error messages. Here are some messages and a possible solution |
| − | + | ||
| + | ===1=== | ||
Exception Thrown from db_txnInfo.cxx:833, Err# 1, tid 143 origtid 143 | 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 | O/S Err#: 0, ErrID: 1025 (db_catalogException); SQLCode: -1000029, SQLState: 'QDA29', Severity: 14 | ||
| Line 7: | Line 7: | ||
-- (db_txnInfo.cxx 833) | -- (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. | + | 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. |
| + | |||
| + | ===2=== | ||
| + | Msg 17901, Level 16, State 0: | ||
| + | RAISERROR executed: The userid "<user-name>" cannot be found in the User Admin tables. See the database administrator. | ||
| + | |||
| + | Can be resolved when you run "sp_iqmodifyadmin 'enable'". | ||
[[Category:IQ]] | [[Category:IQ]] | ||
Revision as of 09:38, 28 December 2007
Sybase IQ sometimes gives some confusing error messages. Here are some messages and a possible solution
1
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. 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.
2
Msg 17901, Level 16, State 0: RAISERROR executed: The userid "<user-name>" cannot be found in the User Admin tables. See the database administrator.
Can be resolved when you run "sp_iqmodifyadmin 'enable'".
