Loading
DUJ Failed Without Errors

Hi,

 

SLM version : 9.14

 

In customer premises, two days back the DUJ got stopped/failed. When we tried to find the error in logs, only empty space is there in the message. Had anyone come across this scenario? Or Do we need to only log a ticket with SNOW?

 

Even we are ready to upgrade the SLM to 9.18. But will the upgrade resolve this issue?

 

Thanks,

Mohamed Riswan M


  • Jelle Wijndelts (Flexera Software)

    Have any subsequent Duj’s completed without error? If they have completed without error then monitor the situation but no need to raise a ticket. If it has failed again then please raise a ticket.

    • Jelle Wijndelts (Flexera Software)

      Please raise a ticket as it will probably need resetting.

  • The KB article here may help in providing the relevant data to support.

     

    The table tblErrorLog typically holds any errors that occur but not always, e.g if your transaction log is full and the DUJ is stopped mid processing. Check the following if you haven't already done so...

     

    select * from SnowLicenseManager.dbo.tblErrorLog order by LogDate desc

     

    Review the Message column of the following query might give you an idea where the job stopped...

     

    select * from SnowLicenseManager.dbo.tblJobLog order by ActionStart asc

     

    ...but it looks like you may have checked this already and found them to be blank?

     

    If you wish to get your DUJ running again, you can reset the relevant tables using the following script (taken from this article)...

     

    --Step 1: Stop the job if necessary

    USE msdb

    GO

    EXEC dbo.sp_stop_job

    N'License Manager Data Update'

     

    --Step 2: Update Job Status

    USE SnowLicenseManager

    UPDATE tblJobStatus SET LastJobStatus = 'Job finished successfully'

     

    --Step 3: Update the log

    UPDATE tblJobLog SET Message = 'Job finished successfully' WHERE JobType = 'JOB_RUN'

     

    --Step 4: New Step for SLM 9 (DUJ 2.0): Zeroing out the temp tables

    UPDATE inv.tblJobParallelStep set [Status] = 0 where Status= -1

     

    --Step 5: Update System Info table (note this is needed to tell IIS to allow access to the SLM)

    UPDATE tblSystemInfo SET LastJobStatus = 'Job finished successfully'

    Expand Post

Loading
DUJ Failed Without Errors