topic Re: SAP Error in Qlik Replicate

SAP Error

suvbin — Wed, 05 Jun 2024 04:06:11 GMT

Hi ,

Task has encountered an error at the source end. But the task is running. There is only one table in the task . Currently there is no incomming changes . It's a full load + cdc task.

00008864: 2024-06-04T21:37:16 [SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: S1000 NativeError: 129 Message: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;129 transaction rolled back by an internal error: AttributeStoreFile error while deserializing from file '<UT Main Column Reader>': AttributeEngine: error reading file; $attribute id$=201; $table name$=E1P::E8_LCST_FI_LCR_RESTRICTED:_SYS_SPLIT_PT_PCR_COST_REPORT_DETAIL_PRA_V2D~1 (t 214975); Server Connection Info: active channel (since 1210891mues) 509211 from 10.131.22.44:33314 to 36243 with method JOIN_EVALUATOR with id 6805848394143710401 on host hoeyp0102 on port 36243 from process hdbindexserver with servi [1022502] (ar_odbc_stmt.c:2871)

00008864: 2024-06-04T21:37:16 [SOURCE_CAPTURE ]E: Failed to execute 'Get Max event number' statement. [1022502] (saphana_trigger_based_cdc_original.c:433)

Found few links .. .. By the error and the links i could understand that there is some join query replicate is trying to run and then out of memory occurred.

https://userapps.support.sap.com/sap/support/knowledge/en/3467934

https://stackoverflow.com/questions/74347321/dbtech-jdbc-2048-column-store-error-while-selecting-from-hana

Please help.

Re: SAP Error

SushilKumar — Wed, 05 Jun 2024 04:36:52 GMT

Hello @suvbin

Thanks for reaching out to Qlik via Qlik Community Support page. Such issue requires through analysis of Settings and logs, hence request you to reach out to technical Support via a case and provide Diagnostics package.

And request you to not to upload any Log here as it can be access by larger Community member then the intended Support personal.

Please refer to Replicate https://community.qlik.com/t5/Knowledge/How-to-collect-Diagnostics-Package-from-Qlik-Replicate/ta-p/1815056

Regards,

Sushil Kumar

Re: SAP Error

john_wang — Wed, 05 Jun 2024 04:53:05 GMT

Hello @suvbin ,

Thanks for reaching out to Qlik Community!

1. Would you please share what's the Qlik Replicate version and build number? like Replicate 2023.11.0.282. We have a similar defect fix in a build of Replicate 2023.11.

2. Maybe set the user's memory limit helps, eg:

ALTER USER <user_name> CLEAR PARAMETER STATEMENT MEMORY LIMIT

3. How many records in the table? there is a limitation that HANA has limitation of 2B rows

Hope this helps,

John.

Re: SAP Error

john_wang — Wed, 05 Jun 2024 04:57:47 GMT

Hello @suvbin ,

Please have a look at SAP Hana source : General error 129 Search result size limit exceeded.

Hope it helps.

John.

Re: SAP Error

suvbin — Wed, 05 Jun 2024 06:07:58 GMT

1. Would you please share what's the Qlik Replicate version and build number? like Replicate 2023.11.0.282. We have a similar defect fix in a build of Replicate 2023.11.

2023.11.0.415

2. Maybe set the user's memory limit helps, eg:

ALTER USER <user_name> CLEAR PARAMETER STATEMENT MEMORY LIMIT --> this one do we need to sent to DBA to run at source end?

3. How many records in the table? --> in the full i could see that its 4,271,254 records and took one hour to complete

and there are no incomming changes.