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

QlikView loads old data from Oracle View

manideep78 — Mon, 18 Apr 2022 20:31:41 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

vinieme12 — Tue, 19 Apr 2022 06:51:18 GMT

please post the complete script

it appear as though you are loading those 400 records from a previously stored qvd;

i'm assuming your script is like below

Load * from someqvd.qvd;

oled connect to____

SQL Select * from someview;

this way you will continue to see your 400 records;

Re: QlikView loads old data from Oracle View

vinieme12 — Tue, 19 Apr 2022 06:53:28 GMT

you might also want to check if the same viewname exists a different schema in the database and has the connection been created with a different default schema.

it's always best to include the schema name when querying the database

Select * from Schemaname.ViewName;

Re: QlikView loads old data from Oracle View

manideep78 — Tue, 19 Apr 2022 12:19:06 GMT

Hi @vinieme12,

Thanks for your response. I used an empty QVW from scratch and connected to nothing but just this view.

No other QVDs are loaded in this.

Also for your below answer, Yes I am using the schema name before the object.

FYI, I have only one instance of database.

Thanks.

Re: QlikView loads old data from Oracle View

vinieme12 — Tue, 19 Apr 2022 12:47:06 GMT

please export the script and share here

Re: QlikView loads old data from Oracle View

manideep78 — Tue, 19 Apr 2022 13:49:13 GMT

Here is the script.

SampleData: LOAD "DQ Rule #", "DQ Dimension", "ID" ; SQL SELECT * FROM DEV_DB."V_TEST" WHERE "DQ Rule #" = 301;

Re: QlikView loads old data from Oracle View

vinieme12 — Tue, 19 Apr 2022 14:30:44 GMT

do you have a different Dev and Prod database environment?

are you connecting to the environment where below table has 400 rows

DEV_DB."V_TEST"

Qlik does not create data out of nothing; it is definitely getting data from somewhere

I don't have any visibility on what or how your doing this so I can only speculate

Re: QlikView loads old data from Oracle View

manideep78 — Tue, 19 Apr 2022 15:27:14 GMT

Hi @vinieme12 ,

I have only one database environment. to double test, i deleted the view and it throw an error.

The same view had 400 records until last week. I updated the view and compiled and from sql developer it's showing nothing for the above sql statement. But in qlik i'm still getting those 400 records.

I took a new qvw file and just created the above script.

I know it's hard to believe until experience it.

Re: QlikView loads old data from Oracle View

vinieme12 — Tue, 19 Apr 2022 15:38:21 GMT

hold on, its a view ! you cannot truncate or delete data from a view!

everytime the query hits the view the view will fetch data from the source table;

does the source table have data or is source table empty?

try to delete your oledb connection and recreate it