Qlik Replicate not able to process ACDOCA SAP HANA Table

Bill_Steinagle · Jun 13, 2023 3:27:10 AM

This Table in SAP HANA is defined at the DB Level with no Primary Key column which using this Endpoint requires the Tables to have a PK on the Table.

[SOURCE_UNLOAD ]W: The table 'SAPHANADB'.'ACDOCA' has no PK. CDC will not work for this table (saphana_endpoint_artifacts.c:872)

Resolution

If the SAP HANA DB is running in SLT Mode and the access to the Application Layer Tables in the SAP HANA Source you can add the Table to the Qlik Replicate Task and should show the PK's on the table in the Transform Panel under the Table Specifications. Can run the below command to verify if you have access to the Application Layer Table in SAP HANA:

select * from SAPHANADB.DD03L where tabname='ACDOCA'

The result set from the query against the SAP HANA Source Endpoint will return the Columns and the 6 Column PK that make up this Table PK List. If you do not get the result set the Qlik Replicate user may not have the proper permissions to read this Table.

Qlik Replicate Table Transform should show the PK listed for this Table if its setup and user has proper permissions

Qlik Replicate Table Transform.png

Since the PK's are now showing the current Triggers for the Table will need to be dropped manually and a Reload for the Table so it can recreate the Triggers with the 6 Primary Key columns.

Cause

The SAP HANA Endpoint was enhanced in the 2022.5 version with the Service Pack 05 applied to read the Metadata information from the SAP HANA Application layer and not from the SAP HANA DB where the PK information would not be found for this Table. The new versions allow the change to query the Application Table DD03L to get the PK details for the Table.

Qlik Replicate not able to process ACDOCA SAP HANA Table