Warning : DialogTable: Event PostSync is not defined.

This is merely a warning and has nothing to do with your INSERTs not being processed.

• What is the status of the INSERT job in the job queue? (FROZEN, TRUE, ...)
• Do you see any errors at these jobs?
• Is the queue (name) serviced by any job service?

Hi Markus, 

- All of the INSERT JOB (ScriptExecSingle = TRUE)  and has remained stagnant there. 

- No errors in the jobqueue, the last message was the above mentioned Warning message 

- Version 8.0.1

We further checked the logs dated yesterday and saw the following errors (this is when end to end synchronization was working)

ScriptName=CCC_UserStore_Insert <------ this is the scriptname that is tagged to the INSERT event, which did not run, but in the jobqueue, the custom process is shown

Error occurred in DbRequestQueue.Process (thread: Database Job Results)

[810023] Error during execution of statement : exec QBM_PJobSetRunParameter N'......

[810143] Database error 50000: detected in (SRV=W01TAMSPOC, DB=OneIM) Procedure QBM_PJobSetRunParameter, Line 3

[810143] Database error 50000: Process step does not exist (anymore) in Job Queue:

Maybe the above error has any involvement? 

Thank you Markus

Again, take a look at the Execution Status of each job in the queue. Are there any frozen jobs and if so are these also using the task ScriptExecSingle?

The error message is pointing to the fact that someone has deleted jobs from the job queue manually or via SQL.

Nope, there are no frozen jobs. And there are no jobs using the task ScriptExecSingle too.

We further tested other custom scripts via their custom processes and it produces the same problem, whereby the custom process is shown in the jobqueue, but remains as True. JobQueue logs did not update anything accordingly, and does not show any error.

We then tried OOTB process, by creating a UNSAccountB in the Object Browser. OOTB process triggered and successfully ran, but the custom process triggered remains there, with no errors shown in the log.. no clue why. 

Just for clarification, so no Jobs at all are being processed or just some?

No jobs at all are being processed. https://drive.google.com/open?id=1urWClDnNvGhlZmOoO47rL0hDIbg6i5LG 

https://drive.google.com/open?id=1-KQ215hZqjKRaXhKdNivuGMESgvGF4XH  

In the jobqueue, the custom process just stays there as True. However OOTB processes ran, and completes within minutes.

Is your DB Queue running?

Are you seeing any status messages (icons) in the status bar of Job Queue info, that indicates that the job queue processing is halted? (One reason could be that the database has to be compiled.)

DB queue has one row only saying

"Membership of UNS user accounts in UNS groups"

We have compiled the database everytime before running synchronization. 

But is the DB Queue working? Do you see any messages in the Journal?

Hi Markus,

Issue was solved when we restarted the whole server, the process immediately changed to PROCESSING-->DELETE. We suspect that this is due to some of the logs (VID_Write2Log) that were generated that had still references intact, despite deleting them. This may have caused the custom process to halt and not do anything, additionally not showing any error in the journal, nor shown in the DBQueue. Thank you so much for helping to assist!

Glad you got it working.

Glad you got it working.