Cannot open the requested object for write in the current transaction (%2). Another user has write access in transaction %3. %1
Item |
Value |
|---|---|
SQLCode |
-1000029 |
Constant |
EMSG_CAT_ONLY1WRITER |
SQLState |
QDA29 |
ODBC State |
ERROR |
Parameter 1 |
origin of the exception |
Parameter 2 |
transaction ID of the user who is trying to write |
Parameter 3 |
transaction ID of the user currently writing |
The IQ catalog allows only one transaction at a time to have write access to an object. The user ID of the user who is currently writing to the object can be found by running sp_iqtransaction and scanning the output for the transaction ID of the writer that currently has write access.
See Chapter 9, “System Procedures” in the Sybase IQ Reference Manual for more information on the sp_iqtransaction stored procedure.
