Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
manideep78
Partner - Specialist
Partner - Specialist

QlikView loads old data from Oracle View

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

Labels (2)
1 Reply
Blalock69
Contributor
Contributor


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