Start a new topic
Answered

Sybase IQ error: "Transaction %Id1% attempted to access %tableName% created by transaction %Id2%"

My process includes several mapping with a Sybase IQ table as target.

One of the mapping fails during execution, raising an error message from Sybase IQ :

"Transaction %Id1% attempted to access %tableName% created by transaction %Id2%"

where %Id1% and %Id2% are Sybase IQ transation Ids, and %tableName% is a Sybase IQ table.

Yet, there isn't any concurrent process or mapping running in parallel.




Best Answer

The concurrency may come from the parent process itself, from an upstream mapping to the same Sybase IQ database.

This database might have kept a transaction open, from a previous mapping in the same process.

This can happen when one of the upstream mappings has a "Commit transaction" SybaseIQ template property unchecked.

1 Comment

Answer

The concurrency may come from the parent process itself, from an upstream mapping to the same Sybase IQ database.

This database might have kept a transaction open, from a previous mapping in the same process.

This can happen when one of the upstream mappings has a "Commit transaction" SybaseIQ template property unchecked.


1 person likes this
Login to post a comment