1. Execute this query to verify that valid TempBatchJobLines exist
SELECT JL.*
FROM ENPRISE_JOBCOST_TEMPBATCHJOBLINES AS JL
INNER JOIN ENPRISE_JOBCOST_SUBJOB AS SJ ON JL.SUBJOBID = SJ.SUBJOBID
INNER JOIN ENPRISE_JOBCOST_JOB AS J ON SJ.JOBID = J.JOBID
LEFT JOIN ENPRISE_JOBCOST_TEMPBATCHNOTES JLN ON JL.NOTENO = JLN.SEQNO
LEFT JOIN ENPRISE_JOBCOST_RESOURCE AS RS ON JL.RESOURCENO = RS.SEQNO
LEFT JOIN OHEM AS OH ON JL.EMPID = OH."empID"
LEFT JOIN OITM OI1 ON OI1."ItemCode" = RS.DEFAULTSTOCKCODE
LEFT JOIN OITM OI2 ON OI2."ItemCode" = OH."U_DefStkCd"
WHERE JL.POSTED = 'N' AND JL.APPROVED = 'Y' AND JL.SUBMITTED = 'Y'
AND (JL.EXPREIMBURSE IS NULL OR JL.EXPREIMBURSE = 'N')
AND (JL.SSMIMPORTSTATUS IS NULL OR JL.SSMIMPORTSTATUS <> 1)
ORDER BY JL.SEQNO DESC;
2. Execute this query to check for any errors and when they were created
SELECT TOP 100 * FROM "ENPRISE_COMMON"."ENPRISE_SERVMAN_LOG" ORDER BY CREATEDAT DESC;
3. Verify the service is running in Task Manager
4. Verify there are no issues connecting to the Common DB.
5. Check the log file for any errors
The default location for of the Log file is C:\Program Files (x86)\Eralis Software\Eralis SAP Services Manager\Eralis_SAPServicesManager_Log.txt
Comments
0 comments
Article is closed for comments.