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

[vinieme12]

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;

[vinieme12]

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;

[manideep78]

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.

[vinieme12]

please export the script and share here

[manideep78]

Here is the script.

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

[vinieme12]

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

[manideep78]

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.

[vinieme12]

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