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 for Me (Login required).

Search for additional results

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