[OLM] Broadcast Schedule event triggers are failing with db connection error (Doc ID 635587.1)

Last updated on OCTOBER 24, 2016

Applies to:

PeopleSoft Enterprise CRM Online Marketing - Version 8.9 to 9 [Release 8.9 to 9]
Information in this document applies to any platform.
SPECIFIC TO:  Enterprise, CRM OLM 8.9 and 9.0

This document was previously published as Customer Connection Solution 200949836




Symptoms

Repeat Broadcast Schedule event triggers are failing with a database connection error.  

Broadcast trigger fails after periods of low or no system activity  with a database connection error.
DES1_Error.log :
ERROR | [2004-09-02 12:38:10.000] | scht11 | DES1 | com.annuncio.scheduler.SchedulerEngine | SCH-00000 | Scheduler general error. | sendRequestsToMcp might have failed due to exception=
    java.lang.NullPointerException

ERROR | [2004-09-02 19:37:10.343] | scht11 | DES1 | com.annuncio.scheduler.SchedulerService | SHD-00002 | Scheduler persistence operation failed. |
    An exception for no reason whatsoever.
SQLState: null
getMessage: Io exception: Connection reset
getErrorCode: 17002
Io exception: Connection reset SELECT PS_RY_SCH_EVENT.RY_EVENT_ID, PS_RY_SCH_EVENT.EVENT_START_DTTM, PS_RY_SCH_EVENT.RY_EVENT_STATUS, PS_RY_SCH_EVENT.RY_EVENT_OP_CODE, PS_RY_SCH_EVENT.RY_PARAM_LIST_ID, PS_RY_SCH_EVENT.DIALOG_ID, PS_RY_SCH_EVENT.REPEAT_SEQ_NUMBER, PS_RY_SCH_EVENT.ROW_LASTMANT_DTTM, PS_RY_SCH_EVENT.RY_SCHEDULER_ID, PS_RY_SCH_EVENT.RY_SCH_DTTM FROM PS_RY_SCH_EVENT WHERE RY_EVENT_STATUS = N'RUNG'
at com.annuncio.jdbc.TransactionJDBC.execute(TransactionJDBC.java:694)
at com.annuncio.jdbc.PersistentSetPeerJDBC.restorePersistentSet(PersistentSetPeerJDBC.java:145)
at com.annuncio.persistence.PersistentSetPeer._restore(PersistentSetPeer.java:113)
at com.annuncio.jdbc.PersistentSetPeerJDBC.restore(PersistentSetPeerJDBC.java:84)
at com.annuncio.persistence.PersistentSet.restore(PersistentSet.java:170)
at com.annuncio.persistence.PersistentSet.restore(PersistentSet.java:164)
at com.annuncio.scheduler.SchedulerService.getRunningEvents(SchedulerService.java:1163)
at com.annuncio.scheduler.SchedulerEngine.restartJobs(SchedulerEngine.java:1048)
at com.annuncio.scheduler.SchedulerEngine.schedulerCheck(SchedulerEngine.java:731)
at com.annuncio.scheduler.SchedulerEngine.execute(SchedulerEngine.java:290)
at com.annuncio.timer.TaskThread.run(TaskThread.java:107)
Caused by: java.sql.SQLException: Io exception: Connection reset
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)
at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3675)
at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:618)
at oracle.jdbc.driver.OracleStatement.open(OracleStatement.java:575)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2803)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:640)
at com.annuncio.jdbc.TransactionJDBC.execute(TransactionJDBC.java:666)
... 10 more

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms