QlikView loads old data from Oracle View

manideep78 — Tue, 19 Apr 2022 12:45:38 GMT

Dear All,

I have an Oracle view which has 400 records previously. with the latest update it should have 0 records. But QlikView still loading 400 records which is incorrect.

Select * from View; ---> No records (Current view and right output for Oracle SQL Developer)

QlikView ---> OLEDB Connection --> 400 records (false output. )

I have compiled the view, created new view with same logic, used direct SQL in QlikView, created new OLEDB connection but still no Luck.

I have created a table out of the view which is working perfectly fine and has zero records as expected.

It seems strange and I never faced this issue.

anyone faced this or any suggestions?

Thanks for you help in advance.

Cheers,

Manideep

Re: QlikView loads old data from Oracle View

Blalock69 — Wed, 20 Apr 2022 11:11:41 GMT

@manideep78 wrote:

Dear All,

I have an Oracle view which has 400 records previously. with the latest update it should have 0 records. But QlikView still loading 400 records which is incorrect.

Select * from View; ---> No records (Current view and right output for Oracle SQL Developer)

QlikView ---> OLEDB Connection --> 400 records (false output. )

I have compiled the view, created new view with same logic, used direct SQL in QlikView, created new OLEDB connection but still no Luck.

I have created a table out of the view which is working perfectly fine and has zero records as expected.

It seems strange and I never faced this issue.

anyone faced this or any suggestions?

Thanks for you help in advance.

Cheers,

Manideep

Once you have created a connection to an Oracle database, you can select data and load it into a Qlik Sense app or a QlikView document. In Qlik Sense, you load data through the Add data dialog or the Data load editor. In QlikView, you load data through the Edit Script dialog.

topic Re: QlikView loads old data from Oracle View in QlikView

QlikView loads old data from Oracle View

Re: QlikView loads old data from Oracle View