My Oracle Support Banner

Shipping-Transportation Carrier Synchronization Fails with WshSendLocRefDataToOtm}refDat aUnExpError" has been Thrown (Doc ID 988144.1)

Last updated on JUNE 18, 2020

Applies to:

Oracle Shipping Execution - Version 12.1 to 12.1 [Release 12.1]
Oracle Transportation Management - Version 6.2.0 and later
Information in this document applies to any platform.
WSHTMCAR: SHIPPING TRANSPORTATION CARRIERS SYNCHRONIZATIONXML:
WSHJARBUILD.XML - xml file used to deploy BPEL processes for OTM/EBS Integration
Executable:B49T0700 - Process OTM Records




Symptoms


When attempting to run the Shipping Transportation Carrier Synchronization Interface program, the following initial error occurs:


ERROR
________

InvokeRefDataPL
2009/12/08 10:42:53 Faulted while invoking operation "process" on provider "WshGetRefDataPL". More...
http://xmlns.oracle.com/apps/wsh/outbound/ref/WshSendLocRefDataToOtm}refDataUnExpError" has been thrown. More...
</sequence>
<scope>
</sequence>
2009/12/08 10:42:53 "BPELFault" has not been caught by a catch block.
2009/12/08 10:42:53 There is a system exception while performing the BPEL instance, the reason is "faultName:
http://xmlns.oracle.com/apps/wsh/outbound/ref/WshSendLocRefDataToOtm}refDataUnExpError} messageType:
 http://xmlns.oracle.com/apps/wsh/outbound/ref/WshSendLocRefDataToOtm}WshLoc
 RefErrorMessage} parts: {{payload= }} ". Please check the error log file for more infromation. Please try to use bpel fault handlers to catch the faults
in your bpel process. If this is a system exception, please report this to your system administrator. Administrator could perform manual recovery of the instance from last non-idempotent activity or dehydration point. less
 com.oracle.bpel.client.BPELFault: faultName:
http://xmlns.oracle.com/apps/wsh/outbound/ref/WshSendLocRefDataToOtm}refDataUnExpError}
messageType:


STEPS
-----------------------

The issue can be reproduced at will with the following steps:
1. Order Management Super User Responsibility
2. Create a new freight carrier
3. Shipping--Interfaces-Run
5. Select Shipping-Transportation Carrier Synchronization program and run


Changes

If you are performing the configuration steps to set up and test Oracle Transportation Management (OTM) integration with Oracle Shipping Execution (WSH) E-Business Suite in Release 12.1.1, but are experiencing errors preventing the specific needed BPEL processes from invoking interface data between OTM and WSH,  then please review the following notes to ensure each step is carried out and verify all settings.

In order to get the needed debug log files for your test case when faced with an error like the one reported here, then you need to take the following steps:

1. Login to the BPEL Console http://hostname:port/BPELConsole

2. Click On the Configuration tab.

3. Click On the Logging tab.

4. For now set "Change All" to the value of "DEBUG " as it will set the log for all above parameters to Debug .

5. Login into the SOA environment, ie; through the back end .

6. Go to this folder $SOA_HOME/opmn/logs for eg (
/slot/ems1111/oracle/product/10.1.3.1/OracleAS_1/opmn/logs).

7. mv default_group~oc4j_soa~default_group~1.log
default_group~oc4j_soa~default_group~1_old.log

8. vi default_group~oc4j_soa~default_group~1.log

9. Now Restart the SOA.

10. After the test case is completed,  please collect this file and upload to your SR in order for support to troubleshoot.  $SOA_HOME/opmn/logs/default_group~oc4j_soa~default_group~1.log

11. Please follow steps 1-9 with the only change being to set log Change All to the value of "INFO"
(Note: This step is necessary, otherwise if not changed it will consume a lot of your environment memory.)

_____________________________________________________________________________________________________________________________________________________________________


When reviewing the default_group_logs this is where you can see that there are additional errors that pinpoint more as to why the process is not being invoked. These need to be investigated  and verified within your configuration settings:
Could not invoke operation 'WshGenLocRefData' against the 'Database Adapter' due to:
ORABPEL-00001
java.util.MissingResourceException
java.util.MissingResourceException
beginning of the log file says, "
OraBPEL run-time system failed to start due to exception:
Domain descriptor not found.
The process domain descriptor file "/u00/product/oracle/OracleAS/10.1.3/bpel/domains/KFCRP1.orig/config/domain.xml" was not found in the directory "/u00/product/oracle/OracleAS/10.1.3/bpel/domains/KFCRP1.orig".

Domain.XML File also shows the following confirming that it cannot find a domain:
09/12/21 14:36:11 Warning: config-property named driverClassName specified in oc4j-ra.xml does not exist in ra.xml
09/12/21 14:36:11 Warning: config-property named connectionString specified in oc4j-ra.xml does not exist in ra.xml
09/12/21 14:36:11 Warning: config-property named userName specified in oc4j-ra.xml does not exist in ra.xml
09/12/21 14:36:11 Warning: config-property named password specified in oc4j-ra.xml does not exist in ra.xml
09/12/21 14:36:11 Warning: config-property named minConnections specified in oc4j-ra.xml does not exist in ra.xml
09/12/21 14:36:11 Warning: config-property named maxConnections specified in oc4j-ra.xml does not exist in ra.xml
09/12/21 14:36:11 Warning: config-property named minReadConnections specified in oc4j-ra.xml does not exist in ra.xml
09/12/21 14:36:11 Warning: config-property named maxReadConnections specified in oc4j-ra.xml does not exist in ra.xml
09/12/21 14:36:11 Warning: config-property named usesExternalConnectionPooling specified in oc4j-ra.xml does not exist in ra.xml
09/12/21 14:36:11 Warning: config-property named usesExternalTransactionController specified in oc4j-ra.xml does not exist in ra.xml
09/12/21 14:36:11 Warning: config-property named tableQualifier specified in oc4j-ra.xml does not exist in ra.xml
09/12/21 14:36:14 log4j:WARN No appenders could be found for logger (wsif).
09/12/21 14:36:14 log4j:WARN Please initialize the log4j system properly.
<2009-12-21 14:36:15,326> <INFO> <collaxa> <ServerManager::__init>
In order to troubleshoot issue of the domain not being found, you would need to perform the following steps to acquire further debugging files in order narrow down what the specific underlying cause is:
  • Provide the ''default.collaxa.cube.ws" logger under BPEL Console by using the following navigation path:
    1. Login to BPEL console
    2. Manage BPEL Domain
    3. Logging Tab
    4.  Make changes
    5. Apply
  • What affect does the following ORABPEL-11001 file adapter error have on the polling for the database adapter ORABPEL-00001 error?
    <2009-12-21 14:36:37,602> <INFO> <KFCRP1.collaxa.cube.activation> <File Adapter::Inbound> Poller raising Alert for exception : ORABPEL-11001
    Invalid Input Directory.
From an SOA Application knowledge point when setting up these types of configurations,  ensure that the following conditions are satisfied for the input directory :
  •  It exists and is a directory (not a file) that is readable (file read permissions).
  •  If activation parameter "DeleteFile" is set to "true" then the directory should also have granted write permissions.
  •  If using a logical name, then ensure that the mapping from logical name<->physical directory is correctly specified in the deployment descriptor.

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.