Update LOB failed to get next param data in Qlik Replicat

[Gopikrish6]

Hi All,

Am Facing issue with the update LOB failed to get next param data.

I gave Replicate LOB (Allow Unlimited LOB Size) .

ERROR:

[TARGET_APPLY ]E: Update LOB failed to get next param data [1022509] (odbc_util.c:3197)

Error in bulk, bulk state: bulk confirmed record id - '0', bulk last record id - '0', confirmed record id - '16880057', sorter confirmed record id - '16880057' (bulk_apply.c:2319)

00004116: 2022-08-16T01:19:12 [TARGET_APPLY ]E: RetCode: SQL_ERROR SqlState: 22018 NativeError: 0 Message: [Microsoft][ODBC Driver 17 for SQL Server]Invalid character value for cast specification Line: 1 Column: 1 [1022502] (ar_odbc_stmt.c:3072)

00004116: 2022-08-16T01:19:12 [TARGET_APPLY ]E: Update LOB failed to get next param data [1022509] (odbc_util.c:3197)

00004116: 2022-08-16T01:19:12 [TARGET_APPLY ]E: Error forwarding bulk [1022509] (bulk_apply.c:827)

00039712: 2022-08-16T01:19:12 [TASK_MANAGER ]I: Task error notification received from subtask 0, thread 1, status 1022509 (replicationtask.c:3433)

00039712: 2022-08-16T01:19:12 [TASK_MANAGER ]W: Task 'Vincent_SQL_T1' encountered a recoverable error (repository.c:5837

[Michael_Litz · Accepted solution]

Hi,

Just a quick thought to try using limited LOB size instead of unlimited LOB. If you can determine the max size of the LOB then you could use limited lob support and set the value to that max value.

Thanks,
Michael

[lyka]

Hello,

What is the source database? I have seen a similar error related to TIME datatypes

Thanks

Lyka

[Gopikrish6]

Source as DB2, Its Fixed. Thanks a lot Michael

[Michael_Litz · Accepted solution]

Hi,

That should work. Please do mark a solution as accepted if it does help fix the issue.

Thanks,
Michael