Failure in creating query for getting table name by orig DB id:

[sampathjohndeere2023]

Hi Team,

We were using Qlik replicate tasks for our data migration from IBM DB2 to AWS postgres sql. We were seeing the following error in our Qlik replicate tasks.

Error:

Failure in creating query for getting table name by orig DB id: 'select CREATOR,NAME from SYSIBM.SYSTABLES where DBID='1719' and OBID='13' and (TYPE='T' or TYPE='H') for read only;'.

If anybody faced similar problem. Please help us to understand the issue. Thanks in advance.

[Steve_Nguyen]

@sampathjohndeere2023 

was there any more error before or after this error ?

what happen when you try to run the same query , on your source db , i assume this is a source_capture error.

[SwathiPulagam]

Hi @sampathjohndeere2023 ,

Could you please share your task log here?

Thanks,

Swathi

[sampathjohndeere2023]

Are you looking for full log Swathi?

[shashi_holla]

@sampathjohndeere2023 

This error usually occurs when ReOrg is done on the source with  KEEPDICTIONARY parameter is set to No. 

Task restart from timestamp should resolve the issue.

Recommendation is to set KEEPDICTIONARY to Yes during reorg.

Thank you,

[sampathjohndeere2023]

May I know, where this parameter present as I'm not seeing any parameter in my task.

[shashi_holla]

It's a DB2 parameter, please check with the DBA team.

Thank you,