Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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