Oracle Fusion Apps 11.1.9 : Error showing tasklist : SOA server connection information is not available

 

fa_soa_tasklist

 

We implement and host Fusion Applications for our customers (both on our servers or at customer’s servers) and today’s post cover issue encountered in Oracle Fusion Applications when accessing HomePage http://host:10623/homePage  user receives message : Error reported on Worklist: Notification and Approvals

____

Error showing tasklist. Possible reasons could be : 1. SOA server connection information is not available. 2. If it is run in federated mode, the default server may be down

_____

Fusion Application contains multiple Oracle Weblogic Domain, configuration and log file for these domains are usually under/u01/ app/ fa/ instance/domains/[hostname]/  (where /u01/apps/fa is Oracle Fusion Applications base )

As this error is coming on homePage and HomePage is WebLogic Managed Server, under Domain CommonDomain so check logs at

/u01/ app/ fa/ instance/domains/ [hostname]/ CommonDomain/ servers/ HomePageServer_1/ logs/ HomePageServer_1.out

 

In my case error reported in out file

 

_____

<Jun 7, 2015 4:45:44 AM EDT> <Error> <oracle.webservices.jaxws> <BEA-000000> <Error while invoking endpoint “http://hostName:10617/integration/services/TaskQueryService/TaskQueryService” from client; Security Subject: CN_INCENTIVE_COMPENSATION_ADMINISTRATOR_JOB>
<Jun 7, 2015 4:45:44 AM EDT> <Error> <oracle.soa.services.workflow.task> <BEA-000000> <<.> Error in workflow service Web service operation invocation.
Error in workflow service Web service operation invocation. The error is .
Verify that the SOAP connection information for the server is correct.

ORABPEL-30044

Error in workflow service Web service operation invocation.
Error in workflow service Web service operation invocation. The error is .
Verify that the SOAP connection information for the server is correct.

<Jun 7, 2015 4:45:55 AM EDT> <Error> <oracle.soa.services.workflow.worklist> <BEA-000000> <Submission[id=380], Service[FederetedWorklistService], Resource[Financials]: AuthenticationHandler.call() failed for server=Financials because exception was thrown, exception: javax.xml.ws.WebServiceException: Could not determine wsdl ports. , caused by Could not determine wsdl ports. , caused by WSDLException: faultCode=OTHER_ERROR: Failed to read WSDL from http://hostName:10613/integration/services/TaskQueryService/TaskQueryService?WSDL: HTTP connection error code is 503>

<Jun 7, 2015 4:45:55 AM EDT> <Error> <oracle.soa.services.workflow.worklist> <BEA-000000> <Submission[id=379], Service[FederetedWorklistService], Resource[Supply Chain Management]: AuthenticationHandler.call() failed for server=Supply Chain Management because exception was thrown, exception: javax.xml.ws.WebServiceException: Could not determine wsdl ports. , caused by Could not determine wsdl ports. , caused by WSDLException: faultCode=OTHER_ERROR: Failed to read WSDL from http://hostname:10627/integration/ services/TaskQueryService/TaskQueryService?WSDL: HTTP connection error code is 503>

_______

 

Port 10627 is OHS port pointing to Supply Chain Domain (SCMDomain) so look in to log file of SCM Domain at

/u01/ app/ fa/ instance/ domains/ [hostName]/ SCMDomain/ servers/ soa_server1/ logs/ soa_server1.out

Error reported in SOA server log was

_____

<May 28, 2015 10:52:20 PM EDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to STARTING><May 28, 2015 10:53:03 PM EDT> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool “SOALocalTxDataSource”: IO Error: The Network Adapter could not establish the connection.><May 28, 2015 10:53:04 PM EDT> <Error> <Store> <BEA-280072> <JDBC store “AGJMSJDBCStore_auto_1” failed to open table “SCM_FUSION_SOAINFRA.AGJMS_ auto_1_WLStore”.weblogic.jdbc. extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common. ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: The Network Adapter could not establish the connection at weblogic.jdbc.common.internal. JDBCUtil.wrapAndThrow ResourceException (JDBCUtil.java:250)
at weblogic.jdbc.common. internal.RmiDataSource. getPoolConnection(RmiDataSource.java:471)
at weblogic.jdbc.common. internal.RmiDataSource. getConnectionInternal (RmiDataSource.java:553)
at weblogic.jdbc.common. internal.RmiDataSource. getConnection(RmiDataSource.java:513)
at weblogic.jdbc. common.internal. RmiDataSource. getConnection(RmiDataSource.java:506)
Truncated. see log file for complete stacktrace

<May 28, 2015 10:54:35 PM EDT> <Warning> <Management> <BEA-141198> <The undeployment of AGJMSJDBCStore _auto_1 failed.
weblogic.management. UndeploymentException: Deployment weblogic. management. configuration.JDBCStoreMBeanImpl @3fbfbc1([SCMDomain]/ JDBCStores[AGJMSJDBCStore_auto_1]) was never prepared
at 
Truncated. see log file for complete stacktrace
>

<May 28, 2015 10:54:49 PM> <FINEST> <NodeManager> <Waiting for the process to die: 2897>
<May 28, 2015 10:54:49 PM> <INFO> <NodeManager> <Server failed during startup so will not be restarted>
<May 28, 2015 10:54:53 PM> <FINEST> <NodeManager> <runMonitor returned, setting finished=true and notifying waiters>

_____

 

Looking at Admin Console of SCM Domain (Admin port 7811 and user faadmin)

soa_scm_fusionapps

 

 

Note : I restarted SOA managed server from SCM Domain WebLogic Console

Note: I also had to start few other managed servers on following domains that were down.

  • Common Domain : Admin Server Listen Port 7011
  • Financials Domain : Admin Server Listen Port 7411
  • SCM Domain : Admin Server Listen Port 7811
  • Procurement Domain : Admin Server Listen port 8211
  • Projects Domain : Admin Server Listen port 8611
  • CRM Domain : Admin Server Listen port 9011
  • HCM Domain : Admin Server Listen Port 9411

 

HTTP Listener for all the domains in Oracle Fusion Applications

fusion_apps_ports

 

After starting failed managed servers in all Fusion Applications WebLogic Domains, I was able to access HomePage with no errors

 

oracle_fusion_apps_tasklist_fixed

 

 

References

  • Error showing tasklist. Possible reasons could be : 1. SOA server connection information is not available. 2. If it is run in federated mode, the default server may be down. (Doc ID 1563474.1)
  • Starting and Stopping Fusion Applications (Doc ID 1499525.1)
  • Oracle Fusion App Start / Stop Syntax

 

 

Looking for partner to host your Oracle Fusion Application Environment – Request for Demo

Share This Post with Your Friends over Social Media!

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

1 comments
Amitstora says August 11, 2015

Is there any Document available step by step for EBS upgrade from 12.1.3 to 12.2.4?

Reply
Add Your Reply

[i]
[i]
[i]
[i]
[index]
[index]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]
[index]
[index]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]