Not able to extract full data from Oracle database

[khalander]

Hi,

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

Please do the needful

[Anil_Babu_Samineni]

Any error?

[ecolomer]

It's better that you use ODBC for Oracle.

What version of Oracle Database are you using?

[khalander]

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

[Anil_Babu_Samineni]

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

[vinieme12]

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?

[sasiparupudi1]

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

[khalander]

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

[sasiparupudi1]

Does it load the data if you just did a

select field_key from table?

[khalander]

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