• State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 99 subscribers
  • Views 1649 views
  • Users 0 members are here
Options
Related

Issue after SQL Server upgrade – OIM 9.2.1 on Pre-Prod Environment

otoo buhss

Hello,

I'm facing a rather strange issue that I can't seem to explain.

In our pre-production environment, we're running OIM 9.2.1 on Windows Server 2019 with SQL Server 2019.

A few days ago, I updated SQL Server 2019 with the latest cumulative update. Checked all is working..


Then, I upgraded the database to SQL Server 2022 (as per the documentation, OIM 9.2.1 supports both SQL Server 2019 and 2022).

However, since the upgrade, nothing is working anymore. I get the message:

“Database Agent service is booting right now...” in all the tools (manager etc..)
and no tasks are being processed — all tasks are stuck in JobQueue.net.

I've verified everything: job servers (via JobConfigurator), database IDs, etc., but I couldn't find anything that might indicate the cause of the problem.
I also set the logs to Trace level, but no errors or anomalies appear. done many restarts etc..

Has anyone experienced this kind of issue (upgrading SQL Server to a newer version)?

Any help or guidance would be greatly appreciated.

Thanks in advance,

Parents
  • 0

    Did you find a fix for this?  I've just done the same thing...update SQL 2019 to 2022 and have the same issue. JobService log is full of these messages.  I can compile the db fine...just seems like the db agent is having trouble starting up.

    Thanks

    2025-11-26 08:26:37.9496 INFO (Jobservice ) : Requesting process steps for queue "\OITESTSQL1".
    2025-11-26 08:26:37.9652 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:26:45.0884 INFO (VI.Database.Agent.Startup.DataOrigin caafe98c PID:2728 ) : Waiting until DataOrigin in DialogDatabase was updated.
    2025-11-26 08:26:46.6422 INFO (Jobservice ) : Requesting process steps for queue "\OITESTJOB1".
    2025-11-26 08:26:46.6578 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:26:47.9573 INFO (Jobservice ) : Requesting process steps for queue "\OITESTSQL1".
    2025-11-26 08:26:47.9573 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:26:56.6514 INFO (Jobservice ) : Requesting process steps for queue "\OITESTJOB1".
    2025-11-26 08:26:56.6514 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:26:57.1047 INFO (VI.Database.Agent.Startup.DataOrigin caafe98c PID:2728 ) : Waiting until DataOrigin in DialogDatabase was updated.
    2025-11-26 08:26:57.9662 INFO (Jobservice ) : Requesting process steps for queue "\OITESTSQL1".
    2025-11-26 08:26:57.9662 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:06.6594 INFO (Jobservice ) : Requesting process steps for queue "\OITESTJOB1".
    2025-11-26 08:27:06.6594 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:07.9748 INFO (Jobservice ) : Requesting process steps for queue "\OITESTSQL1".
    2025-11-26 08:27:07.9748 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:09.1176 INFO (VI.Database.Agent.Startup.DataOrigin caafe98c PID:2728 ) : Waiting until DataOrigin in DialogDatabase was updated.
    2025-11-26 08:27:16.6660 INFO (Jobservice ) : Requesting process steps for queue "\OITESTJOB1".
    2025-11-26 08:27:16.6821 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:17.9824 INFO (Jobservice ) : Requesting process steps for queue "\OITESTSQL1".
    2025-11-26 08:27:17.9980 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:18.0918 INFO (Jobservice ) : Requesting process steps for queue "\OITESTJOB2".
    2025-11-26 08:27:18.0918 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:21.1300 INFO (VI.Database.Agent.Startup.DataOrigin caafe98c PID:2728 ) : Waiting until DataOrigin in DialogDatabase was updated.
    2025-11-26 08:27:26.6734 INFO (Jobservice ) : Requesting process steps for queue "\OITESTJOB1".
    2025-11-26 08:27:26.6869 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:27.9896 INFO (Jobservice ) : Requesting process steps for queue "\OITESTSQL1".
    2025-11-26 08:27:27.9896 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:33.1461 INFO (VI.Database.Agent.Startup.DataOrigin caafe98c PID:2728 ) : Waiting until DataOrigin in DialogDatabase was updated.
    2025-11-26 08:27:36.6847 INFO (Jobservice ) : Requesting process steps for queue "\OITESTJOB1".
    2025-11-26 08:27:36.7003 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:38.0000 INFO (Jobservice ) : Requesting process steps for queue "\OITESTSQL1".
    2025-11-26 08:27:38.0156 INFO (Jobservice ) : Last process step request succeeded.

Reply
  • 0

    Did you find a fix for this?  I've just done the same thing...update SQL 2019 to 2022 and have the same issue. JobService log is full of these messages.  I can compile the db fine...just seems like the db agent is having trouble starting up.

    Thanks

    2025-11-26 08:26:37.9496 INFO (Jobservice ) : Requesting process steps for queue "\OITESTSQL1".
    2025-11-26 08:26:37.9652 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:26:45.0884 INFO (VI.Database.Agent.Startup.DataOrigin caafe98c PID:2728 ) : Waiting until DataOrigin in DialogDatabase was updated.
    2025-11-26 08:26:46.6422 INFO (Jobservice ) : Requesting process steps for queue "\OITESTJOB1".
    2025-11-26 08:26:46.6578 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:26:47.9573 INFO (Jobservice ) : Requesting process steps for queue "\OITESTSQL1".
    2025-11-26 08:26:47.9573 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:26:56.6514 INFO (Jobservice ) : Requesting process steps for queue "\OITESTJOB1".
    2025-11-26 08:26:56.6514 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:26:57.1047 INFO (VI.Database.Agent.Startup.DataOrigin caafe98c PID:2728 ) : Waiting until DataOrigin in DialogDatabase was updated.
    2025-11-26 08:26:57.9662 INFO (Jobservice ) : Requesting process steps for queue "\OITESTSQL1".
    2025-11-26 08:26:57.9662 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:06.6594 INFO (Jobservice ) : Requesting process steps for queue "\OITESTJOB1".
    2025-11-26 08:27:06.6594 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:07.9748 INFO (Jobservice ) : Requesting process steps for queue "\OITESTSQL1".
    2025-11-26 08:27:07.9748 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:09.1176 INFO (VI.Database.Agent.Startup.DataOrigin caafe98c PID:2728 ) : Waiting until DataOrigin in DialogDatabase was updated.
    2025-11-26 08:27:16.6660 INFO (Jobservice ) : Requesting process steps for queue "\OITESTJOB1".
    2025-11-26 08:27:16.6821 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:17.9824 INFO (Jobservice ) : Requesting process steps for queue "\OITESTSQL1".
    2025-11-26 08:27:17.9980 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:18.0918 INFO (Jobservice ) : Requesting process steps for queue "\OITESTJOB2".
    2025-11-26 08:27:18.0918 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:21.1300 INFO (VI.Database.Agent.Startup.DataOrigin caafe98c PID:2728 ) : Waiting until DataOrigin in DialogDatabase was updated.
    2025-11-26 08:27:26.6734 INFO (Jobservice ) : Requesting process steps for queue "\OITESTJOB1".
    2025-11-26 08:27:26.6869 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:27.9896 INFO (Jobservice ) : Requesting process steps for queue "\OITESTSQL1".
    2025-11-26 08:27:27.9896 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:33.1461 INFO (VI.Database.Agent.Startup.DataOrigin caafe98c PID:2728 ) : Waiting until DataOrigin in DialogDatabase was updated.
    2025-11-26 08:27:36.6847 INFO (Jobservice ) : Requesting process steps for queue "\OITESTJOB1".
    2025-11-26 08:27:36.7003 INFO (Jobservice ) : Last process step request succeeded.
    2025-11-26 08:27:38.0000 INFO (Jobservice ) : Requesting process steps for queue "\OITESTSQL1".
    2025-11-26 08:27:38.0156 INFO (Jobservice ) : Last process step request succeeded.

Children
No Data