SPI Proc is not running even after restarted
SummaryFrom the server side the SPI proc is up and running (count was 2) but from admin console it is not up and from database side also not processing any campaigns. When the user restart from server side the service is up at admin console side. Also the count has changed from 2 to 3 after restarted from server. But the client complained that the campaigns are still not started or running at database level.
Customer not able to restart from Admin console as well.
Error MessagesScheduled components not starting due to oracle error “ORA-03114 not connected to ORACLE”
Steps to ReproduceScheduled components to run
Root CauseCMD schema account was locked at database level
Reported issue resolved after unlocking CMD schema account at database level
Published January 5, 2017 - Updated February 21, 2017