SQL Server Source to ODBC(IBM DB2 for iSeries) Target has error: Fail to get schema for table

DuongNguyen — Sun, 08 Oct 2023 03:44:11 GMT

I encountered this error

but when I check if AS400 is the source, qlik sees the schema and table

can you help me?

Re: SQL Server Source to ODBC(IBM DB2 for iSeries) Target has error: Fail to get schema for table

john_wang — Sun, 08 Oct 2023 04:14:31 GMT

Hello @DuongNguyen ,

Thanks for the post!

Seems we cannot find any subscription from Qlik System yet, looks like this is a PoC project. I'd like to propose:

1- Please contact your region sales manager or account manager for help, it's better to proceed with the PoC under Qlik technical support (pre-sales team) to avoid try-and-error on variable issues.

2- Please be mind that unless enabled through Professional Services and approved by your Account Manager, the ODBC target endpoint should not be used

3- Try to set the syntax to GenericWithoutSchema , The steps and a sample:

(1) Open DB2i ODBC target endpoint

(2) Go to Advanced tab

(3) Browse the Provider syntax

(4) Choose GenericWithoutSchema and run task again.

Hope this helps.

Regards,

John.

Re: SQL Server Source to ODBC(IBM DB2 for iSeries) Target has error: Fail to get schema for table

DuongNguyen — Sun, 08 Oct 2023 05:44:50 GMT

@john_wang thank you so much!

topic Re: SQL Server Source to ODBC(IBM DB2 for iSeries) Target has error: Fail to get schema for table in Qlik Replicate

SQL Server Source to ODBC(IBM DB2 for iSeries) Target has error: Fail to get schema for table

Re: SQL Server Source to ODBC(IBM DB2 for iSeries) Target has error: Fail to get schema for table

Re: SQL Server Source to ODBC(IBM DB2 for iSeries) Target has error: Fail to get schema for table