Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Yes @john_wang I'm getting the same error, will get support form Db team
Thanks for support
Thank you @SreehariPV for the wonderful support !
Hello @SreehariPV
If you are using View. Does this view created in multiple tables. and check the Where condition closely.
Regards,
Sushil Kumar