My Oracle Support Banner

' WL_JDBC_LLR_POOL.financialclose_datasource commit ' failed error after submitting a task/opening a schedule in FCM (Doc ID 1530029.1)

Last updated on FEBRUARY 05, 2019

Applies to:

Hyperion Financial Close Management - Version 11.1.2.1.000 to 11.1.2.2.350 [Release 11.1]
Information in this document applies to any platform.
This is specific to SQL Server (any version).

Symptoms

When either submitting a task to a open schedule, or opening a new schedule, a BPEL error is thrown in the GUI with the following error thrown in the FCM log:

 

[2013-02-14T16:25:48.313-05:00] [soa_server1] [ERROR] [] [oracle.integration.platform.blocks.soap] [tid: orabpel.invoke.pool-4.thread-10] [userId: admin] [ecid: 0000JnQaKtSDkZQLQat1id1H7LHK000010,1:20804] [APP: soa-infra] [composite_name: FCCTaskExecutionComposite] [component_name: ExecuteTaskSubProcess] [component_instance_id: 110010] Unable to dispatch request to http://<FCM_Application_Server_NAME>:8700/FCC-DataModel-context-root/SOAAMService due to exception[[
oracle.fabric.common.FabricInvocationException: oracle.j2ee.ws.client.jaxws.JRFSOAPFaultException: Client received SOAP Fault from server : NonXAResource 'WL_JDBC_LLR_POOL.financialclose_datasource' commit failed: javax.transaction.SystemException: weblogic.transaction.loggingresource.LoggingResourceException: java.sql.SQLDataException: [FMWGEN][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.
    at oracle.integration.platform.blocks.soap.WebServiceExternalBindingComponent.throwFabricInvocationException(WebServiceExternalBindingComponent.java:495)
    at oracle.integration.platform.blocks.soap.WebServiceExternalBindingComponent.throwFabricInvocationExceptionForSoapFault(WebServiceExternalBindingComponent.java:491)
    at oracle.integration.platform.blocks.soap.WebServiceExternalBindingComponent.processSOAPFault(WebServiceExternalBindingComponent.java:470)
    at oracle.integration.platform.blocks.soap.WebServiceExternalBindingComponent.processOutboundMessage(WebServiceExternalBindingComponent.java:314)
    at oracle.integration.platform.blocks.soap.WebServiceExternalBindingComponent.sendSOAPMessage(WebServiceExternalBindingComponent.java:1026)
    at oracle.integration.platform.blocks.soap.WebServiceExternalBindingComponent.request(WebServiceExternalBindingComponent.java:745)

 

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
References


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