Reload of qvw file ends in error -1 =

[Lukas_H]

Hi,

i have a qvw file which should create a qvd.

If i reload it with my normal user it works fine but if i try to reload it with the service user from qlikview server it fails with the error -1 =.

Can anyone tell me what this error means? The service user and my user share the same permissons and the service user can read and write in the directory where i try to save the qvd.

Here is the qvw log:

2019-09-11 10:32:51 0002 SET ThousandSep=' '
2019-09-11 10:32:51 0003 SET DecimalSep=','
2019-09-11 10:32:51 0004 SET MoneyThousandSep=' '
2019-09-11 10:32:51 0005 SET MoneyDecimalSep=','
2019-09-11 10:32:51 0006 SET MoneyFormat='€ # ##0,00;-€ # ##0,00'
2019-09-11 10:32:51 0007 SET TimeFormat='hh:mm:ss'
2019-09-11 10:32:51 0008 SET DateFormat='YYYY-MM-DD'
2019-09-11 10:32:51 0009 SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]'
2019-09-11 10:32:51 0010 SET FirstWeekDay=0
2019-09-11 10:32:51 0011 SET BrokenWeeks=0
2019-09-11 10:32:51 0012 SET ReferenceDay=4
2019-09-11 10:32:51 0013 SET FirstMonthOfYear=1
2019-09-11 10:32:51 0014 SET CollationLocale='de-AT'
2019-09-11 10:32:51 0015 SET MonthNames='Jän;Feb;Mär;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez'
2019-09-11 10:32:51 0016 SET LongMonthNames='Jänner;Februar;März;April;Mai;Juni;Juli;August;September;Oktober;November;Dezember'
2019-09-11 10:32:51 0017 SET DayNames='Mo.;Di.;Mi.;Do.;Fr.;Sa.;So.'
2019-09-11 10:32:51 0018 SET LongDayNames='Montag;Dienstag;Mittwoch;Donnerstag;Freitag;Samstag;Sonntag'
2019-09-11 10:32:51 0023 MAP_Terminal_Type:
2019-09-11 10:32:51 0024 MAPPING LOAD
2019-09-11 10:32:51 0025 * INLINE [
2019-09-11 10:32:51 0026 @8, Terminal Type
2019-09-11 10:32:51 0027 B, POS
2019-09-11 10:32:51 0028 A, ATM
2019-09-11 10:32:51 0029 P, MOTO
2019-09-11 10:32:51 0030 M, E-COMMERCE
2019-09-11 10:32:51 0031 W, IMPRINTER
2019-09-11 10:32:51 0032 Y, OTHER
2019-09-11 10:32:51 0033 ]
2019-09-11 10:32:51 2 fields found: @8, Terminal Type,
2019-09-11 10:32:51 6 lines fetched
2019-09-11 10:32:51 0038 MAP_Request_Category:
2019-09-11 10:32:51 0039 MAPPING LOAD
2019-09-11 10:32:51 0040 * INLINE [
2019-09-11 10:32:51 0041 @7, Request Category
2019-09-11 10:32:51 0042 P, Advice
2019-09-11 10:32:51 0043 R, Reversal
2019-09-11 10:32:51 0044 J, Adjustment
2019-09-11 10:32:51 0045 A, Partial Advice
2019-09-11 10:32:51 0046 ]
2019-09-11 10:32:51 2 fields found: @7, Request Category,
2019-09-11 10:32:51 4 lines fetched
2019-09-11 10:32:51 0051 MAP_Add_Amount_Type:
2019-09-11 10:32:51 0052 MAPPING LOAD
2019-09-11 10:32:51 0053 * INLINE [
2019-09-11 10:32:51 0054 @32, Additional Amount Type
2019-09-11 10:32:51 0055 AS, ATM surcharge
2019-09-11 10:32:51 0056 PI, Point-Of-Interaction
2019-09-11 10:32:51 0057 CA, Cashback Amount
2019-09-11 10:32:51 0058 ]
2019-09-11 10:32:51 2 fields found: @32, Additional Amount Type,
2019-09-11 10:32:51 3 lines fetched
2019-09-11 10:32:51 0063 MAP_On_Off_Indicator:
2019-09-11 10:32:51 0064 MAPPING LOAD
2019-09-11 10:32:51 0065 * INLINE [
2019-09-11 10:32:51 0066 @43, Online/Offline Indicator
2019-09-11 10:32:51 0067 ONL, Online Auth.
2019-09-11 10:32:51 0068 OFC, Offline Auth. with Chip
2019-09-11 10:32:51 0069 OFM, Offline Auth. with Magstripe
2019-09-11 10:32:51 0070 ]
2019-09-11 10:32:51 2 fields found: @43, Online/Offline Indicator,
2019-09-11 10:32:51 3 lines fetched
2019-09-11 10:32:51 0072 TEST:
2019-09-11 10:32:51 0073 LOAD * INLINE [
2019-09-11 10:32:51 0074 ID, PathName, Folder, File_Name, FileExt, Size, FileTime, LoadFlag
2019-09-11 10:32:51 0075 ]
2019-09-11 10:32:51 8 fields found: ID, PathName, Folder, File_Name, FileExt, Size, FileTime, LoadFlag,
2019-09-11 10:32:51 0 lines fetched
2019-09-11 10:32:51 0077 STORE TEST INTO \\vmpbxap101\qlikview_root$\Qlikview\QVDs\TXE_LOADED.qvd (qvd)
2019-09-11 10:32:51 0079 DROP TABLE TEST
2019-09-11 10:32:51 0082 let vFilePath = 'Y:\01_MPTS\19_TXE'
2019-09-11 10:32:51 0083 searchStr = '\*.*'
2019-09-11 10:32:51 0084 rootPath = 'Y:\01_MPTS\19_TXE'
2019-09-11 10:32:51 0087 sub DoDir (Root)
2019-09-11 10:32:51 0121 call DoDir (rootPath)
2019-09-11 10:32:51 0089 for each File in filelist (Root&searchStr)
2019-09-11 10:32:51 0113 Concatenate LOAD * FROM [\\vmpbxap101\qlikview_root$\Qlikview\QVDs\TXE_LOADED.qvd] (qvd) WHERE NOT Exists(ID)
2019-09-11 10:32:51 8 fields found: ID, PathName, Folder, File_Name, FileExt, Size, FileTime, LoadFlag,
2019-09-11 10:32:51 -1 =
2019-09-11 10:32:51 Execution Failed
2019-09-11 10:32:51 Execution finished.

Thanks in advance!

[marcus_sommer]

The issue might be caused through different releases of your client and the server (any mixup between them isn't recommended). Further noticeable is your concatenate-statement in the loop. It comes without specifying any table to where the loadings should be concatenated - and there is none table anymore. Usually it takes without such specifying the last loaded table but the only "real" table (the mapping tables are specific ones) TEST was already dropped (especially directly before and the internal table-index may stumble in this case).

Depending on the releases and/or any settings the one ignored this mistakes or just skipped the part and the other fails.

- Marcus

[Lukas_H]

Hi Marcus,

my Server and Desktop client are the same release November 2017 SR8.

Also if i try like this:

Concatenate (TmpFileLog) LOAD * FROM \\...

It tells me it can't find the table TmpFileLog.

[marcus_sommer]

Within the code-example above is none TmpFileLog table.

I assume that the origin idea of the script was to concatenate the loop-loadings to the table TEST. Is this case add TEST to the concatenate and cut the drop and store from TEST and put it below the loop.

If you could ensure that all tables have the identically data-structure or at least all fields which are specified in the TEST table you could remove the whole TEST stuff and also the concatenate-statement.

- Marcus

[Brett_Bleess]

Only thing I can provide in addition to Marcus' comments are a couple of Design Blog posts that might help too:

https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543

https://community.qlik.com/t5/Qlik-Design-Blog/Do-Loop/ba-p/1472760

If Marcus' last comment got you where you needed to go, be sure to use the Accept as Solution button on that post, so he gets credit and others know that got things working.  If you did something different, consider posting that and then mark it as per above...  Sorry I do not have anything better.  If you still need help, drop and update note.

Regards,
Brett