My Oracle Support Banner

Central Coding Impact Analysis Fails With Error: An Error Occurred Communicating with the Database (Doc ID 2423946.1)

Last updated on JANUARY 02, 2025

Applies to:

Oracle Life Sciences Central Coding - Version 1.0.0 and later
Information in this document applies to any platform.

Symptoms

 Impact Analysis fails with the below Central Coding user interface error

An error occurred communicating with the database. Please contact your system administrator to troubleshoot the problem.

 

 

Central Coding Server Stack:

Server Event Log Error (Kibana )

General Information
*********************************************
Additional Info:
UniqueIdentifier: 42530476
ApplicationName: JobService-Central Coding Job Scheduler prod
PlatformVersion: 1.5.3073.0
CompanyName: Phase Forward Incorporated
Manifest Version: 3.1.4958.0
MachineName:
CreatedDateTime: 7/12/2018 11:48:49 AM
AppDomainName: PhaseForward.Platform.JobScheduler.exe
AppDomainVersion: 4.0.30319.34209
ThreadId: 6
ThreadIdentityName:
WindowsIdentityName: NT AUTHORITY\NETWORK SERVICE
UniqueIdentifier: 42529967
ExceptionId: PhaseForward.Platform.Storage.Exceptions.DBProviders.Messages.ErrorRestoringCulturalParameters
Data: System.Collections.ListDictionaryInternal
TargetSite: Void CloseConnection()
HelpLink:
Source: PhaseForward.Platform.AppServer
HResult: -2146232832

StackTrace Information
*********************************************
at PhaseForward.Platform.Storage.DBProvider.CloseConnection()
at PhaseForward.Platform.Storage.DBProvider.Fill(IDbCommand selectCommand, DataTable data)
at PhaseForward.CCA.RequestEngine.RequestManagement.ResponseManager.GetResponseDataSet(Guid requestId)

4) Exception Information
*********************************************
Exception Type: System.InvalidOperationException
Message: The transaction associated with the connection has completed but not yet disposed. Dispose the transaction to execute SQL statements on this connection
Data: System.Collections.ListDictionaryInternal
TargetSite: Void ValidateTransactionContext(Boolean ByRef)
HelpLink:
Source: Oracle.DataAccess
HResult: -2146233079

StackTrace Information
*********************************************
at Oracle.DataAccess.Client.OracleCommand.ValidateTransactionContext(Boolean& bTxnValidationFailed)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at PhaseForward.Platform.Storage.Providers.ODPGlobalizationManager.AlterSession(IDbConnection conn, String sort, String comp)
at PhaseForward.Platform.Storage.DBProvider.CloseConnection()

 

 

Changes

 

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

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