Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
khalander
Creator II
Creator II

Not able to extract full data from Oracle database

Hi,

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

Please do the needful

10 Replies
Anil_Babu_Samineni

Any error?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ecolomer
Master II
Master II

It's better that you use ODBC for Oracle.

What version of Oracle Database are you using?

khalander
Creator II
Creator II
Author

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vinieme12
Champion III
Champion III

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?

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

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
Creator II
Creator II
Author

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

Does it load the data if you just did a

select field_key from table?

khalander
Creator II
Creator II
Author

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