My Oracle Support Banner

Demantra PRE_LOGON ORA-02063 Error In DB_EXCEPTION_LOG (Doc ID 2051282.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Demantra Demand Management - Version 7.3.1.4 and later
Information in this document applies to any platform.

Symptoms

On : 7.3.1.4 version, DM-Gen

Demantra PRE_LOGON Fails

At least weekly but often more frequently at different times of the day the PRE_LOGON procedure shows in the DB_EXCEPTION_LOG with the following error.
I do not see any workflow that has this scheduled so it is unclear what is starting the program and why it is failing.


ERROR
-----------------------
-3135 ORA-03135: connection lost contact
ORA-02063: preceding line from <dblink> Error in PROCEDURE line 19

  dynamic_ddl( 'ALTER SESSION SET nls_date_language = 'AMERICAN'')





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Check DB_EXCEPTION_LOG, notice occurrence of above error messages

 

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
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.