Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
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.
please export the script and share here
Here is the script.
SampleData:
LOAD "DQ Rule #",
"DQ Dimension",
"ID"
;
SQL SELECT *
FROM DEV_DB."V_TEST"
WHERE "DQ Rule #" = 301;
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
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.
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