• State Not Answered
  • Locked Locked
  • Replies 11 replies
  • Subscribers 93 subscribers
  • Views 4575 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Warning : DialogTable: Event PostSync is not defined.

nuruddinmazlan
over 5 years ago

Hi,

We have a custom table and an INSERT process tagged to it. Upon executing the synchronization from synchronization editor, as seen in the jobqueue, it triggers that INSERT event.

However, the script that is tagged to that INSERT event does not run at all. 

All of the INSERT events that were triggered remained in the jobqueue.

- Synchronization is fully functional and we could see all of the rows in the custom table.

- However, the script did not run. We have even put logs (VID_Write2Log) in the scripts, but none executed.

We found the following from the jobqueue:

"Warning : DialogTable: Event PostSync is not defined. 

The event Postsync was triggered for 1 object(s) of type DialogTable."

Before this, it was actually working perfectly from end to end.

We were suspecting if any of the configuration parameters in Designer that we may have accidentally edited that may have caused this issue.

Any idea that it may be a process orchestration issue? We doubt it is, because before it was working, we did not configure any processes.

Thank you! 

Parents
  • 0 over 5 years ago

    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?
    What version are you using?
  • 0 over 5 years ago in reply to Markus Weiss-Ehlers

    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

  • 0 over 5 years ago in reply to nuruddinmazlan

    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.

  • 0 over 5 years ago in reply to Markus Weiss-Ehlers

    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. 

  • 0 over 5 years ago in reply to nuruddinmazlan

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

  • 0 over 5 years ago in reply to Markus Weiss-Ehlers

    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.

  • 0 over 5 years ago in reply to nuruddinmazlan

    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.)

Reply Children