CRM 9.1 RB_MAIL_READ Process Failing with error: ORA-24324: service handle not initialized
(Doc ID 1409030.1)
Last updated on JANUARY 26, 2024
Applies to:
PeopleSoft Enterprise CRM Multichannel Communications - Version 9.1 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |