topic Re: SAP Hana General error 129 - TrexColumnUpdate failed on table - Attribute engine function not implemented in Qlik Replicate

SAP Hana General error 129 - TrexColumnUpdate failed on table - Attribute engine function not implemented

OlivierChatelain — Fri, 26 Jan 2024 14:06:02 GMT

When running CDC mode we face a Sap Hana error that block our CDC Replicate process:

Message: [SAP AG][LIBODBCHDB SO][HDBODBC] General error;129 transaction rolled back by an internal error: TrexColumnUpdate failed on table 'QLIKDBUSER:_SYS_SPLIT_attrep_cdc_changes_cts~1' with error: Attribute engine function not implemented

Did someone solced that issue already?

Regards

Olivier

Re: SAP Hana General error 129 - TrexColumnUpdate failed on table - Attribute engine function not implemented

deepaksahirwar — Sun, 28 Jan 2024 09:18:26 GMT

Dear @OlivierChatelain ,

This error may occur when you try to run transactions on Hana database with the default transaction type, which is REPEATABLE_READ. This transaction type ensures that the data read by the transaction remains consistent throughout the transaction, but it may cause conflicts with other concurrent transactions that modify the same data.

Solution 1:
To get rid of this error, you can try to use transaction type READ_COMMITTED, which takes a snapshot of the data at the beginning and uses the same data throughout the transaction. It will also lock the rows it’s working on so that other transactions cannot modify it.
You can set the transaction type in the Replicate task settings, under the Advanced tab, in the Transaction Isolation Level field.

Solution 2:
Alternatively, you can also try to delete the entries from the table ‘_SYS_REPO:ACTIVE_OBJECTCROSSREF’ that match the condition 'from_object_name = ‘BICS_CUSTOMER’ and from_package_id = ‘bics.basic’ using a command like this:

delete from “_SYS_REPO”.“ACTIVE_OBJECTCROSSREF” where from_object_name = ‘BICS_CUSTOMER’ and from_package_id = ‘bics.basic’;

This may resolve the issue if the problem is caused by some corrupted entries in the table.

I hope these solution is helpful for you. 😊

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Best Regards,
Deepak

Re: SAP Hana General error 129 - TrexColumnUpdate failed on table - Attribute engine function not implemented

JitenderR — Fri, 30 Aug 2024 13:11:21 GMT

Hi @deepaksahirwar Thank You for the note. Can you advise the exact steps or section in task settings mentioned below? Also, please share any SAP documentation on detailing the error above.

You can set the transaction type in the Replicate task settings, under the Advanced tab, in the Transaction Isolation Level field.