Data reload issue

[#1]

Hi ,

In am facing a strange issue . The suppliers table has approximately 6 lac rows .. .when i do a preceeding load nd pull the data error pops up.i have attached the snapshot of it . it pulls 17000 rows and then comes the error.when i click on ok then comes this

Error:QVX_Unexpectd_end of data:SQL ##f - SQL State:22007,errorCode:0,Error Msg [Oracle][ODBC]Invalid date time format

  then i comment a date field ,then theres no error it only pulls those 17000 rows and finishes .

But in real there's 6lac rows. Why is it not able to load rest of the data ??

the server is qv11 sr 1 build 11282 64 bit

oracle client is ora_11g

oracle d/b is 9i 32 bit

I am using odbc connection

[Gysbert_Wassenaar]

There is probably at least one other field that's causing problems. You'll have to try to find out which field(s). Have you tried executing the sql statement in another tool like SQL Developer or sqlplus?

[#3]

yes . tried it from oracle tool . i didnt find it abnormal .  after i comment it out as i said previously , it doent show error but doesnt pull all the data only 17000

[erichshiino]

Hi,

Can you share your load script that fails?

Can you match oracle client and server versions?

Can you also try an OLEDB connection?

Regards,

Erich

[#5]

i didnt understand Can you match oracle client and server versions?

Looks like like an connectivity issue because when i ran the qvd generator script in differnt  32 bit qlikview ,32 bit hardware and default oracle driver  environment it works fine . it pulled all the data .

I havent tried oledb.

Is there any issue with odbc

OraClient is 32 bit .

script is as follows :

odbc connect to dsg (xuserid is sdffdd,xpassword is sfdgfdg);

qualify*;

suppliers :

sql select *

from imis.suppliers

store * from suppliers into C:\abc\suppliers.qvd

[erichshiino]

You have:

oracle client is ora_11g

oracle d/b is 9i 32 bit

Can you try to use oracle client 9i (same version of the DB)?

You could try to create an ODBC connection on windows and use the parameter connect32:

ODBC CONNECT32 TO dsg (... etc)

Hope it helps,

Erich

[#7]

I heeded to your advice of loading data using OLEDB , but another problem has surfaced .

I am trying to pull the data from oracle to qlikview ,there are some 10 tables in total .

after pulling 6 tables the qlikview terminates the connection  and says Execution of script failed. Reload Old Data ? , but data gets stored in QVD Generator .

So what i do is comment out the first 6 tables and try to execute the script , then it pulls the rest of the tables .

So why does it fail to pull all the 10 tables at once ??

I am using OLEDB connection to connect to oracle