QlikView loads old data from Oracle View

[manideep78]

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

[Blalock69]

---

@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.