SAP Knowledge Base Article - Preview

2186845 - BI 4.1: Promotion Management Service within APS is in 'The service did not start' status after upgrade from BI 4.0

Symptom

  • Unable to access the Version Management Application with the error 'Sorry, Promotion management application is unable to process your request'
  • Selecting 'Override settings' in the Promotion Management application returns the error: com.crystaldecisions.sdk.exception.SDKException$OCAFramework: Unable to find servers in CMS VCDROT-BI404.pgdev.sap.corp:6400 and cluster @VCDROT-BI404.pgdev.sap.corp:6400 with kind pjs and service LCMServiceOCA. All such servers could be down or disabled by the administrator. (FWM 01014)
  • Adaptive Processing Server (APS) in 'Running with Errrors' status in the Central Management Console (CMC)->Servers page.
  • Promotion Management service within the APS shows with 'The service did not start'
  • Error message in the APS logs (traced on High from startup):
    2015 06 26 13:42:39.732|java.sql.SQLException: Failed to create database '\\myshare\pathtoLCM\LCM/LCMOverride', see the next exception for details.
     at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
     at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
     at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
     at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
     at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
     at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source)
     at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
     at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
     at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source)
     at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source)
     at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
     at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source)
     at java.sql.DriverManager.getConnection(DriverManager.java:582)
     at java.sql.DriverManager.getConnection(DriverManager.java:154)
     at com.businessobjects.lcm.db.DataBaseManager.connectDatabase(DataBaseManager.java:172)
     at com.businessobjects.lcm.overrides.LCMOverride.loadDatabase(LCMOverride.java:92)
     at com.businessobjects.lcm.overrides.ConflictManager.loadOverrideDatabase(ConflictManager.java:1907)
     at com.businessobjects.lcm.service.occa2.backend.LCMServiceOCCA2.migrateDerbyDatabase(LCMServiceOCCA2.java:1088)
     at com.businessobjects.lcm.service.occa2.backend.LCMServiceOCCA2.<init>(LCMServiceOCCA2.java:175)
     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
     at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
     at com.businessobjects.framework.servers.platform.deployment.core.BeanComponent.getBeanInternal(BeanComponent.java:528)
     at com.businessobjects.framework.servers.platform.deployment.core.BeanComponent.getBean(BeanComponent.java:323)
     at com.businessobjects.framework.servers.platform.modules.pojo.axis2.ServiceModule.<init>(ServiceModule.java:45)
     at com.businessobjects.framework.servers.platform.modules.pojo.axis2.POJOService.createServiceModule(POJOService.java:366)
     at com.businessobjects.framework.servers.platform.deployment.AbstractPJSService.activateService(AbstractPJSService.java:116)
     at com.businessobjects.framework.servers.platform.deployment.servicebuilder.AbstractServiceBuilder.startService(AbstractServiceBuilder.java:332)
     at com.businessobjects.framework.servers.platform.lifecycle.internal.LifeCycleManager$ServiceController.startSvc(LifeCycleManager.java:226)
     at com.businessobjects.framework.servers.platform.lifecycle.internal.LifeCycleManager$ServiceController.call(LifeCycleManager.java:177)
     at com.businessobjects.framework.servers.platform.lifecycle.internal.LifeCycleManager$ServiceController.call(LifeCycleManager.java:155)
     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
     at java.util.concurrent.FutureTask.run(FutureTask.java:138)
     at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
     at java.lang.Thread.run(Thread.java:763)
    Caused by: java.sql.SQLException: Failed to create database '\\wnash001p01\BUSOB_prod\LCM\LCM/LCMOverride', see the next exception for details.
     at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
     at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
     ... 37 more

     


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform BI 4.1 (SP3+)

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

KBA , BI-BIP-INS , Installation, Updates, Upgrade, Patching , BI-BIP-LCM , Lifecycle Management Console - Promotion mgmt, Version mgmt , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.