Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Getting 0 records while reading data from oracle database

Hi All,

I'm trying to load data into Qlikview (using ODBC connection) from the oracle database(views) but the query is executing fine and not getting any records.

If i query the same view in the SQL Developer IDE, i can see the data.

Please let me know if anybody have faced similar issue.

Thank you.

Regards,

Viresh

10 Replies
Highlighted

Re: Getting 0 records while reading data from oracle database

can you check your log file?  Is that showing any records read?

Highlighted
Creator III
Creator III

Re: Getting 0 records while reading data from oracle database

Hi, It says 37 fields found , 0 lines fetched.

Regards,

Viresh

Highlighted

Re: Getting 0 records while reading data from oracle database

Ok. are you using any filter (with where condition)?  May be it doesn't met the criteria.

Can you try to remove the filter and execute that?

Highlighted
Creator III
Creator III

Re: Getting 0 records while reading data from oracle database

Hi, I am not using any filter. The query looks like select * from view_name;

Highlighted

Re: Getting 0 records while reading data from oracle database

Are you really sure do you have the data for the table view_name?  (view_name is a view or table)

if it is view name, can you try load any other table name?

Highlighted
Creator III
Creator III

Re: Getting 0 records while reading data from oracle database

Hi,

view_name is a view.

The connection sting looks like below.

ODBC CONNECT TO [newebs;DBQ=EBS ] (XUserId is HFVUIcBPFDeKGZBOZE, XPassword is eQaMHcBPFDeKGZBOSA);


select * from apps.xxegc_QV_sales_order_v;


One more thing is, i can query some other tables but not the above view.


Regards,

VK

Highlighted

Re: Getting 0 records while reading data from oracle database

ok. Can you check this.    Extracting views from Oracle

Highlighted
Creator III
Creator III

Re: Getting 0 records while reading data from oracle database

The same query select * from view_name just works fine and fetches the data. In this case my back end database (Oracle EBS) and Qlikview desktop  are on the same domain.

I am facing issue while connecting the Qlikview desktop from other domain.

Is that causing the issue?

Highlighted
Creator III
Creator III

Re: Getting 0 records while reading data from oracle database

Hello,

I have added sql alter session set nls_language = 'AMERICAN'; statement after connection string and able to load the data.

Regards,

Viresh