My Oracle Support Banner

ECM Batch Failed At Task1 (Doc ID 3060109.1)

Last updated on NOVEMBER 26, 2024

Applies to:

Oracle Financial Services Enterprise Case Management - Version 8.0.7 and later
Information in this document applies to any platform.

Symptoms

ECM task is failing and we can see the below error.

Select query fired for the property : AUTH_ALIAS and DB Name : ofsaafbcfccm
lstrQry =SELECT V_AUTH_USERNAME, V_AUTH_STRING FROM AAI_DB_AUTH_ALIAS WHERE V_AUTH_ALIAS = 'ofsaa_fbc_fccm'
[07-11-24 18:44:52 GMT PM][INFO][BACKEND][OFSAA][RUNPROCEDURE] Database Type : ORACLE
[07-11-24 18:44:52 GMT PM][INFO][BACKEND][OFSAA][RUNPROCEDURE] NLS Value : AMERICAN_AMERICA.UTF8
FAILED: create_oci_session() - error attaching to server using OCIServerAttach()...
LIBDB: FAILED: log_on() : OCIERROR: ORA-12154: TNS:could not resolve the connect identifier specified

[07-11-24 18:44:52 GMT PM][SEVERE][BACKEND][OFSAA][RUNPROCEDURE] Could not Connect to the Database from Login Information
FAILED: - error closing the session using OCISessionEnd()...
[07-11-24 18:44:52 GMT PM][INFO][BACKEND][OFSAA][RUNPROCEDURE] After Calling execProc
[07-11-24 18:44:52 GMT PM][SEVERE][BACKEND][OFSAA][RUNPROCEDURE] Stored procedure execution failed

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.