Job queue and CodeUnit execution.

Abdel1978

Hello EveryOne,
I receive an error when I run one CodeUnit who save an XMLport as csv file from Job Queue in Nav 2016:
Everything is ok when I run manually the CodeUnit from Development Environment but when I run the CodeUnit from Job Queue, I receive the following error:

CodeUnit code is:
OnRun()
// FileMgt codeunit 419
// FileName Text
// OutFile File
// OutS OutStream
// Xmlp your XMLPort

FileName := FileMgt.ServerTempFileName('CSV');
OutFile.CREATE(FileName);
OutFile.CREATEOUTSTREAM(OutS);
Xmlp.FILENAME(FileName);
Xmlp.SETDESTINATION(OutS);
Xmlp.EXPORT;
OutFile.CLOSE;
FileMgt.DownloadToFile(FileName, 'c:\DB\ExportFile.csv');

Please any help will be welcome

AlexDen

Hi,

FileMgt.DownloadToFile(FileName, 'c:\DB\ExportFile.csv');

By this line of code you are trying to download created file from a server to a client.
But you don't have the client when running code via job queue, it's executed completely on the server.

If you want to copy this file on the server, then you have to use

Copy(FileName, 'c:\DB\ExportFile.csv');

AlexDen

Hi,

FileMgt.DownloadToFile(FileName, 'c:\DB\ExportFile.csv');

By this line of code you are trying to download created file from a server to a client.
But you don't have the client when running code via job queue, it's executed completely on the server.

If you want to copy this file on the server, then you have to use

Copy(FileName, 'c:\DB\ExportFile.csv');

Abdel1978

Hi AlexDen,
Thank you very much.
It works well.

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]