topic Re: Error while doing FullLoad for a view from Oracle as source in Qlik Replicate

Error while doing FullLoad for a view from Oracle as source

SreehariPV — Wed, 08 May 2024 07:47:35 GMT

While loading a view from source, I received an error ORA-01427, should this be addressed by the DB team or is there anything I have to do with Qlik Replicate from my side

Re: Error while doing FullLoad for a view from Oracle as source

john_wang — Wed, 08 May 2024 08:03:18 GMT

Hello @SreehariPV ,

Thanks for reaching out to Qlik Community!

It's hard to tell the reason from the error code ORA-01427 this time. Would you please try to query the view in SQL Developer, or SQLPlus (out of Qlik Replicate) to see if you hit the same error not. If yes, please work with your DBA team to fix it.

Thanks,

John.

Re: Error while doing FullLoad for a view from Oracle as source

SreehariPV — Wed, 08 May 2024 08:32:50 GMT

Yes @john_wang I'm getting the same error, will get support form Db team
Thanks for support

Re: Error while doing FullLoad for a view from Oracle as source

john_wang — Wed, 08 May 2024 08:46:26 GMT

Thank you @SreehariPV for the wonderful support !

Re: Error while doing FullLoad for a view from Oracle as source

SushilKumar — Wed, 08 May 2024 09:59:50 GMT

Hello @SreehariPV

If you are using View. Does this view created in multiple tables. and check the Where condition closely.

Regards,

Sushil Kumar