Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

qwv document - working on a pc, not in an other

Hi everibody,

I have a serious problem. Since 2 days I'm trying to load data on document on a pc, but the strange thing is that on an other pc I CAN!

Script is as follow:

ANAGRAFICA_AZIENDA:

LOAD [codice azienda],

     [codice filiale],    

[rag. soc. anagrafica],    

[indirizzo anagrafico],    

[giorni contratto 5]

FROM PSAZF1.csv (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

LOAD [codice azienda],    

[codice filiale],    

[matricola dipendente],    

[cognome e nome]    

FROM PSDIP1.csv (ansi, txt, delimiter is ';', embedded labels, msq);

I'm using QV 9 SR6 on both computers.

If I load only PSAZF1.csv or PSDIP1.csv everything is working well.. but if I load PSAZF1.csv andPSDIP1.csv the script fails only in a pc.

In attachment files .csv and document info get from working and not working pc.

PLEASE HELP!

Thanks in advance.

Marco

11 Replies
Not applicable
Author

Hello Marco,

I tried to rebuild your example using the wizard. It created for both(!) files same "parameter line" which works fine:

. . .

FROM

X X X .csv

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

Check this out (for ex. "ansi"  instead of "txt")

Roland

Not applicable
Author

Hello again,

in addition to my post above:

What kind of error did you get?

May be you have trouble with missing RAM in your second PC (the according error message is like "OUT OF VIRTUAL AND/OR PHSYS MEM.  . ")?

RR

Anonymous
Not applicable
Author

Ciao Marco,

i use qlik version 10 and relod with no problem.

I have seen you have syn1 key .... how many record are the original data?

ciao Andrea

Not applicable
Author

You're loading two different files with different columns but have only specified one table! If you wanted one table you should add the concatenate keyword. If you wanted two tables, you need to specify two table names.

Anonymous
Not applicable
Author

Hi Roland

the error message is: "esecuzione dello script fallita" mean "script execution fail"

I've tried changing pareter line but it didn't work and same with table label.

Ciao

Marco

Not applicable
Author

Ciao Marco,

this message does't say much.

So the great question still is: What's the difference between the two computers?

I am sure you checked the spelling of pathnames, filenames.

What about the access-rights? Where is this little difference between the enviroments?

HtH

Roland

Anonymous
Not applicable
Author

No idea, in working.txt and not_working.txt computers look same... a little difference in ram. I've tried to load values copying the prova.qvw file in c:\ but doesn't work as well.

May be an enviromental value or variable.

Access right are ok (read-write).

We are also using ocx to load documents in our programa (I'm workin for a software house) and, strange thing it works but our customers may have the same situation.

I'm still working for a solution. If found l'll write down on community forum.

Thanks for help and (other) suggestions.

Marco

Not applicable
Author

OK,

very strange. Would you inform me, if you got the answer (or the name of the bug) ?

Buana fortuna!

Roland

Anonymous
Not applicable
Author

Ciao Marco,

did u try  to use  Genera file di log  ?  and relod data ..... maybe can help you to understand