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 (1)
8 Replies
vinieme12
Champion III
Champion III

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;

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

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;

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
manideep78
Partner - Specialist
Partner - Specialist
Author

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
Champion III
Champion III

please export the script and share here

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
manideep78
Partner - Specialist
Partner - Specialist
Author

Here is the script.

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

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

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
manideep78
Partner - Specialist
Partner - Specialist
Author

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
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.