Delay In Starting MetaSolv Servers Due To Custom Attributes
(Doc ID 1569882.1)
Last updated on JANUARY 13, 2023
Applies to:
Oracle Communications MetaSolv Solution - Version 6.2.1 and laterInformation in this document applies to any platform.
Symptoms
MetaSolv server takes more than 50 minutes to start up completely with the below errors are logged in appserverlog.xml during this issue.
{CA/ca stands for Custom Attributes}
<log4j:event logger="cmm.JDBCTrace" timestamp="1372455190001" level="ALERT" thread="net-pmssapp1_gateway_Main" dateTime="Fri Jun 28 16:33:10 COT 2013" appServerName="DEF_APPSERVER" machineName="net-pmssapp1" messageID="10000" moduleName="cmm.JDBCTrace" userName="metasolv" className="DEF_CLASS" debugCode="0" productName="cluster-nur">
<log4j:message><![CDATA[User's[ app_api ] queryresults exceeded [ 20000 ] rows:
select cau.ms_bb_id, cau.ca_usage_id, mst.ms_table_nm from asap.ca_usage cau, asap.ms_building_block msbb, asap.ms_table mst where cau.from_eff_dt <= sysdate and (cau.to_eff_dt is null or cau.to_eff_dt > sysdate) And cau.ms_bb_id = msbb.ms_bb_id And msbb.inv_ca_value_table_id = mst.ms_table_id(+) order by cau.ms_bb_id
StackTrace: java.lang.Throwable: -- NO ACTUAL EXCEPTION OCCURRED --
at com.metasolv.jdbc.MSVResultSet.next(MSVResultSet.java:96)
at com.mslv.core.api.internal.ca.queryresult.BbDataResult.populate(BbDataResult.java:58)
at com.mslv.core.api.internal.ca.query.BbDataQuery.getData(BbDataQuery.java:69)
at com.mslv.core.api.internal.ca.cache.factory.BbDataFactory.getData(BbDataFactory.java:42)
at com.mslv.core.api.internal.ca.cache.broker.CacheManager.createCache(CacheManager.java:414)
at com.mslv.core.api.internal.ca.cache.broker.CacheManager.buildCache(CacheManager.java:142)
at com.mslv.core.api.internal.ca.cache.broker.CacheManager.<clinit>(CacheManager.java:104)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.metasolv.system.GenericStartup.init(GenericStartup.java:62)
at com.mslv.webapp.context.listener.MSLVContextListener.contextInitialized(MSLVContextListener.java:39)
at weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:465)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:175)
at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1785)
at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3005)
at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1371)
at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:468)
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:117)
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:635)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:16)
at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:162)
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:51)
at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:196)
at weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:30)
at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:233)
at weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:169)
at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:123)
at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:173)
at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:89)
at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
<log4j:message><![CDATA[User's[ app_api ] queryresults exceeded [ 20000 ] rows:
select cau.ms_bb_id, cau.ca_usage_id, mst.ms_table_nm from asap.ca_usage cau, asap.ms_building_block msbb, asap.ms_table mst where cau.from_eff_dt <= sysdate and (cau.to_eff_dt is null or cau.to_eff_dt > sysdate) And cau.ms_bb_id = msbb.ms_bb_id And msbb.inv_ca_value_table_id = mst.ms_table_id(+) order by cau.ms_bb_id
StackTrace: java.lang.Throwable: -- NO ACTUAL EXCEPTION OCCURRED --
at com.metasolv.jdbc.MSVResultSet.next(MSVResultSet.java:96)
at com.mslv.core.api.internal.ca.queryresult.BbDataResult.populate(BbDataResult.java:58)
at com.mslv.core.api.internal.ca.query.BbDataQuery.getData(BbDataQuery.java:69)
at com.mslv.core.api.internal.ca.cache.factory.BbDataFactory.getData(BbDataFactory.java:42)
at com.mslv.core.api.internal.ca.cache.broker.CacheManager.createCache(CacheManager.java:414)
at com.mslv.core.api.internal.ca.cache.broker.CacheManager.buildCache(CacheManager.java:142)
at com.mslv.core.api.internal.ca.cache.broker.CacheManager.<clinit>(CacheManager.java:104)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.metasolv.system.GenericStartup.init(GenericStartup.java:62)
at com.mslv.webapp.context.listener.MSLVContextListener.contextInitialized(MSLVContextListener.java:39)
at weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:465)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.EventsManager.notifyContextCreatedEvent(EventsManager.java:175)
at weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1785)
at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3005)
at weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1371)
at weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:468)
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
at weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
at weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:117)
at weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:204)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
at weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:60)
at weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
at weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:635)
at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:37)
at weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:212)
at weblogic.application.internal.EarDeployment.activate(EarDeployment.java:16)
at weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:162)
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:51)
at weblogic.management.deploy.internal.DeploymentAdapter.activate(DeploymentAdapter.java:196)
at weblogic.management.deploy.internal.AppTransition$2.transitionApp(AppTransition.java:30)
at weblogic.management.deploy.internal.ConfiguredDeployments.transitionApps(ConfiguredDeployments.java:233)
at weblogic.management.deploy.internal.ConfiguredDeployments.activate(ConfiguredDeployments.java:169)
at weblogic.management.deploy.internal.ConfiguredDeployments.deploy(ConfiguredDeployments.java:123)
at weblogic.management.deploy.internal.DeploymentServerService.resume(DeploymentServerService.java:173)
at weblogic.management.deploy.internal.DeploymentServerService.start(DeploymentServerService.java:89)
at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
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 |
| Cause |
| Solution |
| References |