topic Re: Error on data in Qlik Replicate

Error on data

fj40wdh — Thu, 07 Sep 2023 11:08:42 GMT

When replicating data from Oracle to SQL Server we get this error, how can I find the source row that is causing the problem?

00018335: 2023-09-06T20:06:55 [TARGET_APPLY ]I: Net Changes table name for the task is 'attrep_changes1212E690E8B45FE9' (bulk_apply.c:3720)
00018335: 2023-09-06T20:06:56 [TARGET_APPLY ]I: Error in bulk, bulk state: bulk confirmed record id - '0', bulk last record id - '0', confirmed record id - '0', sorter confirmed record id - '0' (bulk_apply.c:2468)
00018332: 2023-09-06T20:06:56 [TASK_MANAGER ]I: Task error notification received from subtask 0, thread 1, status 1020100 (replicationtask.c:3433)
00018332: 2023-09-06T20:06:56 [TASK_MANAGER ]W: Task 'SYS_P6_BLOB_PC_Stream' encountered a fatal error (repository.c:5852)
00018336: 2023-09-06T20:06:56 [SORTER ]I: Final saved task state. Stream position 205;638296420099376860;20230209101829637005, Source id 5022, next Target id 13, confirmed Target id 0, last source timestamp 1694045207000000 (sorter.c:770)
00018335: 2023-09-06T20:06:56 [INFRASTRUCTURE ]E: Cannot allocate memory (apr status = 12) [1000104] (at_memory.c:428)
00018335: 2023-09-06T20:06:56 [TARGET_APPLY ]E: Failed to allocate array for parameter 'Param#059' in statement 'INSERT INTO [DBO].[attrep_changes1212E690E8B45FE9]([seq],[col1],[col2],[col3],[col4],[col5],[col6],[col7],[col8],[col9],[col10],[col11],[col12],[col13],[col14],[col15],[col16],[col17],[col18],[col19],[col20],[col21],[col22],[col23],[col24],[col25],[col26],[col27],[col28],[col29],[col30],[col31],[col32],[col33],[col34],[col35],[col36],[col37],[col38],[col39],[col40],[col41],[col42],[col43],[col44],[col45],[col46],[col47],[col48],[col49],[col50],[col51],[col52],[col53],[col54],[col55],[col56],[col57],[col58],[seg1]) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)' (size: 71680002000 bytes) [1020100] (ar_odbc_stmt.c:4399)
00018335: 2023-09-06T20:06:56 [TARGET_APPLY ]E: Failed to prepare statement 'INSERT INTO [DBO].[attrep_changes1212E690E8B45FE9]([seq],[col1],[col2],[col3],[col4],[col5],[col6],[col7],[col8],[col9],[col10],[col11],[col12],[col13],[col14],[col15],[col16],[col17],[col18],[col19],[col20],[col21],[col22],[col23],[col24],[col25],[col26],[col27],[col28],[col29],[col30],[col31],[col32],[col33],[col34],[col35],[col36],[col37],[col38],[col39],[col40],[col41],[col42],[col43],[col44],[col45],[col46],[col47],[col48],[col49],[col50],[col51],[col52],[col53],[col54],[col55],[col56],[col57],[col58],[seg1]) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)' [1020100] (sqlserver_endpoint_imp.c:3978)
00018335: 2023-09-06T20:06:56 [TARGET_APPLY ]E: Failed to get statement, func: insert row handler [1020100] (sqlserver_bulk.c:211)
00018335: 2023-09-06T20:06:56 [TARGET_APPLY ]E: Failed to send table 'ADMUSER.TASKRSRC' (5) events to changes table [1020100] (bulk_apply.c:6316)

Re: Error on data

fj40wdh — Thu, 07 Sep 2023 12:41:53 GMT

changed to Transactional apply and that fixed it. Why?

Re: Error on data

SachinB — Thu, 07 Sep 2023 13:14:13 GMT

Hello @fj40wdh ,

Thank you for reaching out to the Qlik community!

From the logs it appears that your batch is failing due to memory issue " Cannot allocate memory" Replicate will calculate memory based on the Max LOB size. Max LOB size* number of LOB columns * number of rows in that batch. The moment when you changed it from Batch optimized to "Transaction Apply" it went fine, As Transaction Apply works in one-by-one mode.

Error :
+++++++++++++++

00018335: 2023-09-06T20:06:56 [INFRASTRUCTURE ]E: Cannot allocate memory (apr status = 12) [1000104] (at_memory.c:428)

00018335: 2023-09-06T20:06:56 [TARGET_APPLY ]E: Failed to allocate array for parameter 'Param#059' in statement 'INSERT INTO [DBO].[attrep_changes1212E690E8B45FE9]([seq],[col1],[col2],[col3],[col4],[col5],[col6],[col7],[col8],[col9],[col10],[col11],[col12],[col13],[col14],[col15],[col16],[col17],[col18],[col19],[col20],[col21],[col22],[col23],[col24],[col25],[col26],[col27],[col28],[col29],[col30],[col31],[col32],[col33],[col34],[col35],[col36],[col37],[col38],[col39],[col40],[col41],[col42],[col43],[col44],[col45],[col46],[col47],[col48],[col49],[col50],[col51],[col52],[col53],[col54],[col55],[col56],[col57],[col58],[seg1]) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)' (size: 71680002000 bytes) [1020100] (ar_odbc_stmt.c:4399)

Regards,

Sachin B