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

Start a new topic

Answered

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

started a topic almost 2 years ago

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

Xavier Meunier said almost 2 years ago

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

said almost 2 years ago

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.