topic Re: Console error in QlikView

Console error

nahuel04 — Sat, 16 Nov 2024 20:47:24 GMT

Hello,

thanks in advance ,

I have the next problem with script and reload a qvw from a console.

my script in a .qvw:

Sub GetFiles(vPath)
For each vFile in FileList('$(vPath)\*.*')
ARCHIVOS_Gaviport:
Load
UPPER(RIGHT('$(vFile)', LEN( TRIM('$(vFile)')) - INDEX('$(vFile)', '.', -1))) AS EXTENSION_G ,
RIGHT('$(vFile)', LEN( TRIM('$(vFile)')) - INDEX('$(vFile)', '\', -1)) AS ARCHIVO_CORTO_G ,
'$(vPath)' AS CARPETA_G ,
'$(vFile)' AS ARCHIVO_LARGO_G ,
NUM(FileSize('$(vFile)') / 1024, '#.##0 kB') AS TAMAÑO_G ,
FileTime('$(vFile)') AS FECHA_G
AutoGenerate(1)
;
Next

End Sub

Call GetFiles('\\192.168.10.152\Fotos\Compras\');

when I running it from qlikview desktop works properly , but when I try to running this from qlikview management console I have next console error(attach a word).

In addition I checked folder security and it is ok.

thanks

Re: Console error

rwunderlich — Mon, 27 May 2019 14:30:27 GMT

You will want to look at the document script log to find out what the specific reload error was.

-Rob

Re: Console error

nahuel04 — Mon, 27 May 2019 21:07:22 GMT

Thanks Rob ,

But where can I find it ?

I found this folder C:\ProgramData\QlikTech\DistributionService\1\Log\20190527 and I checked the log and it is the same that attached. I don't know whats appened .

Thanks,

Attached a log.

Re: Console error

rwunderlich — Mon, 27 May 2019 21:25:53 GMT

if Document Log is enabled, in that same folder you should have a file named "DocumentLog.txt". Also in the same folder as the QVW will be a file named same as qvw with ".log" suffix. E.g. for "sales.qvw" will be "sales.qvw.log".

If you don't find the document log in either location, it means it is not enabled for the document. Open the QVW, Settings, Document Properties, General, check "Generate Logfile". You will have to rerun the task at this point to get a logfile.

Every document should have a logfile. It drives me crazy that it's not the default. You can make it your default for future new qvws by updating Settings, User Preferences, Design, "Always use logfile for new documents".

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Console error

nahuel04 — Mon, 27 May 2019 22:09:52 GMT

thanks Rob again.

I attached my log , I don't understand what it's happening, because in QVW it work properly and from the management console doesn't work.

my script:

Sub GetFiles(vPath)

For each vFile in FileList('$(vPath)*.*')
ARCHIVOS_Indacor:
Load
UPPER(RIGHT('$(vFile)', LEN( TRIM('$(vFile)')) - INDEX('$(vFile)', '.', -1))) AS EXTENSION ,
RIGHT('$(vFile)', LEN( TRIM('$(vFile)')) - INDEX('$(vFile)', '\', -1)) AS ARCHIVO_CORTO ,
'$(vPath)' AS CARPETA ,
'$(vFile)' AS ARCHIVO_LARGO ,
NUM(FileSize('$(vFile)') / 1024, '#.##0 kB') AS TAMAÑO ,
FileTime('$(vFile)') AS FECHA
AutoGenerate(1) ;
Next

End Sub

Call GetFiles('\\192.168.10.152\Fotos\Compras\dbIndacor\');

thanks

Re: Console error

rwunderlich — Mon, 27 May 2019 23:14:56 GMT

It looks to me like zero files are being found in the FileList() function when run on the server. Best guess is that the account running the Distribution Service does not have permission to list files in that directory.

-Rob

Re: Console error

nahuel04 — Mon, 27 May 2019 23:43:26 GMT

thanks so much,
I have been trying to fix it for more than 6 hours and the problem was a permission in the directory, but this has permission. I do not know what it is, but I solved it copy all files to another directory and it works properly.

thanks for your time..