General Error

Fri, 30 Oct 2009 14:34:07 GMT

Hi,

I'm doing a binary load that contains a sales and a positions table as well as several others.
after the binary I'm concatenating another sales and an other positions table.

The script runs perfectly on my pc. As soon as we try it on customer side (on several different pcs with same qv9 sr1 version) I'm getting an exit script: on line 0144 exit script General Script Error.

I found out that that there's an problem with positions (without positions it's working). But log file says that all
data is loaded "2.823.123 Sätze erhalten".
Does someone know what's this error caused by and why it's working on my pc?

Thanks for your help.

Aloah

General Error

Fri, 30 Oct 2009 16:09:45 GMT

what is the line 144 of your script ?

what are the previous lines ?

General Error

Fri, 30 Oct 2009 21:30:17 GMT

Script looks like this:
I misinterpreted the line 0144 -> this is form exit script tab at the end of the script.

I only get General error. Sorry for the confusion.

Is exit script making problem on reload tasks?

Thanks.

30.10.2009 08:53:59: Start der Skript-Ausführung
30.10.2009 08:53:59: QlikView Version:9.00.7257.6
30.10.2009 08:53:59: 0002 Binary base_data.qvw
30.10.2009 08:54:03: 0006 SET ThousandSep='.'
30.10.2009 08:54:03: 0007 SET DecimalSep=','
30.10.2009 08:54:03: 0008 SET MoneyThousandSep='.'
30.10.2009 08:54:03: 0009 SET MoneyDecimalSep=','
30.10.2009 08:54:03: 0010 SET MoneyFormat='#.##0,00 €;-#.##0,00 €'
30.10.2009 08:54:03: 0011 SET TimeFormat='hh:mm:ss'
30.10.2009 08:54:03: 0012 SET DateFormat='DD.MM.YYYY'
30.10.2009 08:54:03: 0013 SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]'
30.10.2009 08:54:03: 0014 SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez'
30.10.2009 08:54:03: 0015 SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So'

30.10.2009 08:54:03: 0020 Concatenate(Sales)
30.10.2009 08:54:03: 0021 LOAD Field1
30.10.2009 08:54:03: 0022 Field2,
.......
30.10.2009 08:54:03: 0109 Field89
30.10.2009 08:54:03: 0110 FROM
30.10.2009 08:54:03: 0111 qvd\Sales_total.qvd
30.10.2009 08:54:03: 0112 (qvd)
30.10.2009 08:54:03: 89 Felder gefunden: Field1, Field2,..., Field89, 324.212 Sätze erhalten
30.10.2009 08:54:05: 0114 Concatenate(Pos)
30.10.2009 08:54:05: 0115 LOAD PField1,
30.10.2009 08:54:05: 0116 PField2,
.....
30.10.2009 08:54:05: 0139 PField25
30.10.2009 08:54:05: 0140 FROM
30.10.2009 08:54:05: 0141 qvd\Pos_total.qvd
30.10.2009 08:54:05: 0142 (qvd)
30.10.2009 08:54:05: 25 Felder gefunden: PField1, PField2,....., Field25, 1.283.128 Sätze erhalten
30.10.2009 08:54:09: 0144 exit script
30.10.2009 08:54:10: General Script Error
30.10.2009 08:54:10: Fehler bei der Ausführung
30.10.2009 08:54:10: Ende der Skript-Ausführung

topic General Error in QlikView

General Error

General Error

General Error