Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

"EPMSystemRegistry" failed with exception: "java.sql.SQLRecoverableException: No more data to read f

User_2E55JOct 24 2019 — edited Oct 24 2019

Dear Everybody,

We are actually installing High Availability Hyperion System in Linux where we have a distributed architecture ( Linux Box 1 & 2: Foundation Components, Calc Manager and FDMEE; Linux Box 3 & 4: Planning and Financial Reporting ; Linux Box 5 & 6 : Essbase Server, EAS and APS).OTD is used as load balance. Its our Production System. Two nodes are there for each components as this is HA.

After installation and Configuration, when I am going to start of both nodes of Linux Box 1 and Linux Box 2, ErpIntegrator1 is getting failed for 2nd only. In First node its running fine.

pastedImage_0.png

Node 1 is started before Node 2. Facing the same issue for node 2 if I start node 2 first and node 1 later.

In Node 1 log(erpIntegrator0) , we are facing below error:

####<Oct 24, 2019 12:45:03 PM AST> <Error> <JDBC> <servername> <ErpIntegrator0> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000Mrx9vrHFg42LzqG7yW1Tg0GE0000ks> <1571910303185> <BEA-001112> <Test "select count(*) from SNP_LOC_REP" set up for pool "odiMasterRepository" failed with exception: "java.sql.SQLRecoverableException: No more data to read from socket".>

####<Oct 24, 2019 12:49:03 PM AST> <Error> <JDBC> <servername> <ErpIntegrator0> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000MrxAqTHFg42LzqG7yW1Tg0GE0000l0> <1571910543185> <BEA-001112> <Test "select count(*) from SNP_LOC_REP" set up for pool "odiMasterRepository" failed with exception: "java.sql.SQLRecoverableException: No more data to read from socket".>

####<Oct 24, 2019 12:45:03 PM AST> <Error> <JDBC> <servername> <ErpIntegrator0> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000Mrx9voZFg42LzqG7yW1Tg0GE0000kq> <1571910303013> <BEA-001112> <Test "SELECT 1 FROM HSS_COMPONENT_TYPES WHERE 1 = 0" set up for pool "EPMSystemRegistry" failed with exception: "java.sql.SQLRecoverableException: No more data to read from socket".>

In Node 2 log(erpIntegrator1), we are facing below error:

####<Oct 24, 2019 12:58:47 PM AST> <Error> <HTTP> <servername> <ErpIntegrator1> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <4920eee3e4313625:6fdf3e24:16dfd3339e6:-8000-0000000000000003> <1571911127499> <BEA-101216> <Servlet: "AgentServlet" failed to preload on startup in Web application: "oraclediagent".

ODI-1400: Agent OracleDIAgent start failure: JDBC connection error occurs while connecting to the master repository.

Caused by: java.security.AccessControlException: access denied (oracle.security.jps.service.credstore.CredentialAccessPermission context=SYSTEM,mapName=oracle.odi.credmap,keyName=SUPERVISOR read)

at oracle.odi.runtime.agent.servlet.AgentServlet.startup(AgentServlet.java:411)

at oracle.odi.runtime.agent.servlet.AgentServlet.init(AgentServlet.java:250)

at javax.servlet.GenericServlet.init(GenericServlet.java:242)

at weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:283)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

at weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:64)

at weblogic.servlet.internal.StubLifecycleHelper.createOneInstance(StubLifecycleHelper.java:58)

at weblogic.servlet.internal.StubLifecycleHelper.<init>(StubLifecycleHelper.java:48)

at weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.java:539)

at weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletContext.java:1981)

at weblogic.servlet.internal.WebAppServletContext.loadServletsOnStartup(WebAppServletContext.java:1955)

at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1874)

at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3155)

at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1518)

at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:487)

at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:427)

at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)

at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)

at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:201)

at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:249)

at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:427)

at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)

at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)

at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:28)

at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:672)

at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)

at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)

at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:59)

at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)

at weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)

at weblogic.deploy.internal.targetserver.BasicDeployment.activate(BasicDeployment.java:184)

at weblogic.deploy.internal.targetserver.BasicDeployment.activateFromServerLifecycle(BasicDeployment.java:361)

at weblogic.management.deploy.internal.DeploymentAdapter$1.doActivate(DeploymentAdapter.java:52)

at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:200)

at weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:31)

at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:240)

at weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:170)

at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:124)

at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:181)

at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:97)

at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

Caused By: java.security.AccessControlException: access denied (oracle.security.jps.service.credstore.CredentialAccessPermission context=SYSTEM,mapName=oracle.odi.credmap,keyName=SUPERVISOR read)

Although its running fine in node1 and getting in ADMIN state in node 2.

Please suggest.

Thanks & Regards,

Prit

Comments

Processing