CRM 9.1 RB_MAIL_READ Process Failing with error: ORA-24324: service handle not initialized (Doc ID 1409030.1)

Last updated on AUGUST 01, 2016

Applies to:

PeopleSoft Enterprise CRM Multichannel Communications - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

CRM 9 Production: RB_MAIL_READ process errors.

Impact: No emails are processing

Sequence: Restart ERMS after the process errored , bounced servers cleared cache
Process still goes to no success

Error:
File: E:\pt85108b-retail\peopletools\src\pssys\gensql.cppSQL error. Stmt #: 902 Error Position: 0 Return: 24324 - ORA-24324: service handle not initialized
Failed SQL stmt:UPDATE PS_AUTO_NUM_TBL SET LAST_AUTO_NBR = LAST_AUTO_NBR + 1 where setid='NONE' and num_type='INTE' and default_beg_seq='Y'

Fatal SQL error occurred. (2,125) FUNCLIB_AUTONUM.LAST_AUTO_NBR.FieldFormula Name:assign_auto_number PCPC:4247 Statement:74

Called from:FUNCLIB_RI.INTERACTION_FUNC.FieldFormula Name:GetNextInteractionID Statement:90

Called from:FUNCLIB_RI.INTERACTION_FUNC.FieldFormula Name:ri_interact_rec_saveprechg Statement:95

Called from:RI_INTERACTION.GBL.RI_INTERACTION.SavePreChange Statement:1

Changes

None

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