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

nav_student

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?

allenyyzhou

Hi

Could you find any error log in Windows Event Log?

ErictP

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;