topic Re: Getting 0 records while reading data from oracle database in QlikView

Getting 0 records while reading data from oracle database

vireshkolagimat — Sun, 10 Dec 2017 10:08:33 GMT

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

Re: Getting 0 records while reading data from oracle database

settu_periasamy — Sun, 10 Dec 2017 10:42:34 GMT

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

Re: Getting 0 records while reading data from oracle database

vireshkolagimat — Sun, 10 Dec 2017 10:50:01 GMT

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

Regards,

Viresh

Re: Getting 0 records while reading data from oracle database

settu_periasamy — Sun, 10 Dec 2017 11:00:48 GMT

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?

Re: Getting 0 records while reading data from oracle database

vireshkolagimat — Sun, 10 Dec 2017 11:03:38 GMT

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

Re: Getting 0 records while reading data from oracle database

settu_periasamy — Sun, 10 Dec 2017 11:08:06 GMT

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?

Re: Getting 0 records while reading data from oracle database

vireshkolagimat — Sun, 10 Dec 2017 11:25:08 GMT

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,

Re: Getting 0 records while reading data from oracle database

settu_periasamy — Sun, 10 Dec 2017 11:30:55 GMT

ok. Can you check this. Extracting views from Oracle

Re: Getting 0 records while reading data from oracle database

vireshkolagimat — Sun, 10 Dec 2017 11:48:58 GMT

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?

Re: Getting 0 records while reading data from oracle database

vireshkolagimat — Tue, 12 Dec 2017 09:25:47 GMT

Hello,

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

Regards,

Viresh

Re: Getting 0 records while reading data from oracle database

jamshed07 — Wed, 22 Apr 2020 18:02:40 GMT

I am facing same issue, on the data preview it's showing the records but when insert script and load data after successful completion showing zero record fetch. Where i can find log to check what is the issue? Anybody could help?