topic Re: Not able to extract full data from Oracle database in QlikView

Not able to extract full data from Oracle database

khalander — Sat, 19 Aug 2017 11:01:04 GMT

Hi,

I am not able to extract full data from oracle database. i am using OLE DB connection.

Please do the needful

Re: Not able to extract full data from Oracle database

Anil_Babu_Samineni — Sat, 19 Aug 2017 11:03:02 GMT

Any error?

Re: Not able to extract full data from Oracle database

ecolomer — Sat, 19 Aug 2017 11:03:15 GMT

It's better that you use ODBC for Oracle.

What version of Oracle Database are you using?

Re: Not able to extract full data from Oracle database

khalander — Sat, 19 Aug 2017 13:58:49 GMT

Not getting any error... we are using oracle 11g

Re: Not able to extract full data from Oracle database

Anil_Babu_Samineni — Sat, 19 Aug 2017 16:10:51 GMT

Check whether you are loading correct or nor? Connection success? If so, you can do Select from bottom pane to hit "Select" and then check proper Schema

Re: Not able to extract full data from Oracle database

vinieme12 — Sat, 19 Aug 2017 16:23:59 GMT

Your description of the problem needs more detail!

Can you confirm how many rows of data do you have in the DB table?

how many rows are you able to download?

is the number of rows that you are able to download always the same after multiple attempts?

Re: Not able to extract full data from Oracle database

sasiparupudi1 — Sat, 19 Aug 2017 16:37:01 GMT

If you are using any preceeding load on top of your SQL,please try commenting it out.

What sort of record counts are we looking at from the table?

May be try enabling the tracing on the dsn setting

Hth

Sasi

Re: Not able to extract full data from Oracle database

khalander — Sun, 20 Aug 2017 08:13:09 GMT

Hi,

I am getting same number records from both data base and QV.

But here problem is.. I have one filed which contains Data like '11O1' but i am not getting this record once loaded data into Qlikview.

Select * from table where filed_key='11O1'; -- I am getting this record.

Select * from table---- I am not getting that record,

I tried with both ODBC, OLEDB. and i have commented preceding load as well but no result

Re: Not able to extract full data from Oracle database

sasiparupudi1 — Sun, 20 Aug 2017 08:30:30 GMT

Does it load the data if you just did a

select field_key from table?

Re: Not able to extract full data from Oracle database

khalander — Sun, 20 Aug 2017 08:38:54 GMT

yes, i am able to load data but not getting data filed_key='11O1'

Re: Not able to extract full data from Oracle database

vinieme12 — Sun, 20 Aug 2017 10:58:10 GMT

"I am getting same number records from both data base and QV."

Check with your DBA if you have limitations on tablespace or your user profile