Error 1000029

"Cannot open the requested object for write in the current transaction (%2). Another user has write access in transaction %3. %1"

Item	Description
SQLCode	-1000029L
Constant	EMSG_CAT_ONLY1WRITER
SQLState	QDA29
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Sybase Error Code	20689
Severity Code	14
Parameter 1	location of the exception
Parameter 2	The transaction id of the hopeful writer.
Parameter 3	The transaction id of the user currently writing.

Probable cause

The ASIQ catalog allows only one transaction at a time to have write access to an object. The id of the user that 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.