SAP Error

[suvbin]

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-fro...

Please help.

[SushilKumar]

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/...

Regards,

Sushil Kumar

[john_wang]

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.

[john_wang]

Hello @suvbin ,

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

Hope it helps.

John.

[suvbin]

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.