NAV 2015 - Job Queue Log Entries Job stuck in Process doesn't upda

nav_studentnav_student Member Posts: 175
Hi guys,

I've a job that imports data from Excel Buffer that works fine if I run it manually ( although it takes 2 hours to import a 12MB file), but if it's running from the Job Queue it starts but doesn't update the End Date/Time and the Status keeps in Process.

Any ideas?

Answers

  • allenyyzhouallenyyzhou Member Posts: 142
    Hi

    Could you find any error log in Windows Event Log?
  • ErictPErictP Member Posts: 164
    If you are using the function ReadSheet from the table 'Excel Buffer' then add IF GUIALLOWED THEN before the call to ExcelBufferDialogMgt.
    ReadSheet()
    LastUpdate := CURRENTDATETIME;
    //Job Queue BEGIN
    IF GUIALLOWED THEN
    //Job Queue END
      ExcelBufferDialogMgt.Open(Text007);
    DELETEALL;
    
    Enumerator := XlWrkShtReader.GetEnumerator;
    RowCount := XlWrkShtReader.RowCount;
    WHILE Enumerator.MoveNext DO BEGIN
      CellData := Enumerator.Current;
      IF CellData.HasValue THEN BEGIN
        VALIDATE("Row No.",CellData.RowNumber);
        VALIDATE("Column No.",CellData.ColumnNumber);
        ParseCellValue(CellData.Value,CellData.Format);
        INSERT;
      END;
    //Job Queue BEGIN
      IF GUIALLOWED THEN BEGIN
    //Job Queue END
        i := i + 1;
        COMMIT;
        IF NOT UpdateProgressDialog(ExcelBufferDialogMgt,LastUpdate,i,RowCount) THEN BEGIN
          QuitExcel;
          ERROR(Text035)
        END;
    //Job Queue BEGIN
      END;
    //Job Queue END
    END;
    
    QuitExcel;
    //Job Queue BEGIN
    IF GUIALLOWED THEN
    //Job Queue END
      ExcelBufferDialogMgt.Close;
    
Sign In or Register to comment.