Job queue and CodeUnit execution.

Abdel1978Abdel1978 Member Posts: 10
edited 2022-02-03 in NAV Three Tier
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:
shd5wd98orxw.png
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


Best Answer

  • AlexDenAlexDen Member Posts: 85
    edited 2022-01-26 Answer ✓
    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');
    

Answers

  • AlexDenAlexDen Member Posts: 85
    edited 2022-01-26 Answer ✓
    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');
    
  • Abdel1978Abdel1978 Member Posts: 10
    Hi AlexDen,
    Thank you very much.
    It works well.
  • krikikriki Member, Moderator Posts: 9,094
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.