topic Re: Handling new table failed in Qlik Replicate

Handling new table failed

DuongNguyen — Thu, 12 Oct 2023 08:08:33 GMT

Replicate task from SQL Server Source to ODBC (IBM DB2 for iSeries) Target

but table WOCCPF is exists

how to fix it?

in ODBC Target, i config Provider syntax = GenericWithoutSchema

Re: Handling new table failed

john_wang — Thu, 12 Oct 2023 13:14:36 GMT

Hello @DuongNguyen ,

Thanks for opening the article!

Not sure what the expected result? You want to drop/re-create the table if it exists, or truncate the data before full load, or you want to create a new table with same name but different schema ?

All the above scenarios are supported, you may control the behavior in Full Load Tuning , a sample:

And you can specify a target table schema in table setting.

Hope this helps.

Regards,

John.

Re: Handling new table failed

DuongNguyen — Thu, 12 Oct 2023 13:32:03 GMT

Hello @john_wang

I don't run the task with Full Load but I run the task with Apply Change. The task runs successfully, but when I insert data to source table it shows such error

Re: Handling new table failed

DuongNguyen — Fri, 13 Oct 2023 03:13:46 GMT

Hello @john_wang Can you help me, I really need it.

I add "exception_table_enabled":false in common_settings, error is Handling new table failed.

but I remove "exception_table_enabled":false, error is Cannot create exception table

I run task with Apply Change, it is not FullLoad, but i check table, it is exists.

Re: Handling new table failed

john_wang — Fri, 13 Oct 2023 03:32:40 GMT

Hello @DuongNguyen ,

Thanks for the clarification. please allow me some time , I will try to reproduce the behavior in my labs and understand the error further. Will get back to you later.

BTW, if you need to move the PoC forward quickly, it's better to reach out to your account manager and work with pre-sales team.

Regards,

John.

Re: Handling new table failed

john_wang — Fri, 13 Oct 2023 03:40:08 GMT

HI @DuongNguyen ,

Sure thing, I will try my best to get back to you in EOD.

Regards,

John.

Re: Handling new table failed

john_wang — Fri, 13 Oct 2023 06:57:06 GMT

Hello @DuongNguyen ,

I've done some research, I'm afraid we still need some more investigation on the DB2i Target. To move the PoC forward quickly, I strongly suggest you talk to your account manager for help.

Good luck and Best Regards,

John.