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
