Siebel Business Process & Functionality (MOSC)

MOSC Banner

RCR Workflow Process - SQL errors

edited Sep 25, 2015 1:12AM in Siebel Business Process & Functionality (MOSC) 1 commentAnswered

Hi,

We have RCR workflow scheduled to run daily at 6 am. I have noticed that the workflow has started erroring out almost every day with SQL error:

(oracon.cpp (3273)) SBL-DBC-00108: An error has occurred preparing a Sql statement.

ORA-03113: end-of-file on communication channel Process ID: 24116 Session ID: 363 Serial number: 9017

The same workflow will run fine when invoked manually or if the RCR is for another time during business hours. I suspect that somehow the session that is invoking the workflow gets timed out and loses connection with the database.

Does anyone know which parameter to check?  Nothing has changed on the application side. The DBAs are not siebel DBA so do not know what to check. One of my searches found some parametre called TNS_EXPIRE or something. but, I could not locate more information.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

SBL Business Process Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center