Oracle Fusion Apps 11.1.9 : Error showing tasklist : SOA server connection information is not available
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)
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
After starting failed managed servers in all Fusion Applications WebLogic Domains, I was able to access HomePage with no errors
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