Tab delimited text file -Not all rows gets loaded in qlikview

[aj0031724]

DEAR TEAM,

We are facing an issue in production where not all rows of tab delimited text file are getting loaded inside qlikview.

IF FOR EXAMPLE FILE HAS 1000 ROWS ONLY 500 GETTING LOADED AND THERE IS NO ERROR ALSO AND AT TIMES IT GIVES ERROR AS" File extdata.cpp, Line 2903""

Format of the data is attached in sample.

A)ONE WHERE ROWS ARE LOADED

B_ONE WHERE ROWS ARE NOT GETTING LOADED.

read that "msq"" or ""no qoutes"" can be used but I don't think this is causing an issue.

Pease guide and advise.

[trdandamudi]

Do you think there is an issue while generating the text file ? As you mentioned, while loading 1,000 lines and when it stopped at 500 lines, see if the next record (501) format is ok. To just test it out delete the rows from 501 to 505 and try to load it and see what happens....

[aj0031724]

Hi ,

Qllikview does not stop or throws error in between.Loading process shows reads XXX number of lines.

and the unfortunate thing I sthat the production file has X million of rows .

It is only when CUSOMER COMPLAINTS that DATA re not visible and when we investigate found that even though records are there in file bit qlikview does not load it.

Sampel provided as attached contains the format and all seems to be tab delimited

So the problem is why it doe snot gets loaded at once?

[trdandamudi]

Got it...Do you have enough space ? Also try to load that text file into a new qlikview file and see what happens....

[miguelbraga]

Hey there,

I've imported all your data and it seems that there is no problem with every row in your shared files. Can you please share a sample of your qvw?

Regards,

MB

[aj0031724]

Dear team,

This is what I have observerd also that those rows that are not getting loaded when I manually extract those rows only Qlikview si able to load it properly.

But when the whole file gets loaded it skips.

One thing that now I found out from the production file is that  that after  searching for quotes ""  I could see one field  value has an opening quotes only and closing quoutes is missing AND QLIKVIEW IS SKPIING ALL ROWS AFTER THAT .

SO THE ROOT CAUSE POSSIBLE IS MISSING QUOTES I THINK.

Example->"MBSTC

In the loading script I am using "msq" for quoting.

Can you let me know if the quoting is the problem here ?

[ToniKautto]

You are describing two separate symptoms, which do not occur at the same time. I would assume theses are then two differrent issues.

• No all rows loaded
• Error "File extdata.cpp, Line 2903"

What format definition does your load statement have? Same as below?

(txt, utf8, embedded labels, delimiter is '\t', no quotes, no eof)

The "File extdata.cpp, Line 2903" error is known to be caused by disk issues. Are you loading from a network drive? Is the storage a availabel when the issue occurs?

[aj0031724]

This is the load script which is being used:

LOAD Date_Ex,

     Path,

     RNC,

     Site,

     Utran_Cell,

     Carrier,

     Param,

     Value,

     Type,

     Id

FROM

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Also as you advised will check If there is enough disk space also in CUSTOMER SITE.

Many thanks .

[ToniKautto]

Try replacing "msq" with "no quotes, no eof" .

If you do not have quoted text in the file a misplaced quote character can lead to unexpected results. NO QUOTES will simply treat quote characters as any text.

If the text file has a end of file (EOF) charcter in it, the load will stop at that. NO EOF will ignore EOF characters and make sure the entire file is loaded.

[chetansehgal]

Hi Avinash,

Currently the problem is caused due to the double quote.

So you either replace all the quotes with some another  character or you have to close all the opened quotes.

Thanks,

Chetan