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

[Anonymous]

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

[#2]

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

[#3]

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]

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

[#5]

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]

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

[#7]

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]

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

[#9]

OK,

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

Buana fortuna!

Roland

[Anonymous]

Ciao Marco,

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