I moved my DEV BPM databases (version 10.3) to another server. I took a snapshot of the Production environment and not a direct copy of my previous DEV databases.
I changed the location in Weblogic server (version 10.2) datasources, BPM Admin Center configuration and the Process Administrator settings. The engine and the workspace are started, but PAPIWS is throwing the following error:
********* PAPI Web Services (Version 10.3.1.0.0 Service Pack 1 Build #100513) is starting *********
Checking Java Runtime Enviroment ...Ok
Initializing enviroment...Ok
Initializing PAPI services ...
processDocumentationPath = //opt/bea/bpmwls/user_projects/domains/bpmdev/Fuego-WebLogic-Deployer/fuego_webapp_expanded/07-papiws-wls103-xafdids.ear/papiws.war/processDocumentation/
defaultWorkingDirPath = /opt/bea/bpmwls/user_projects/domains/bpmdev/Fuego-WebLogic-Deployer/fuego_webapp_expanded/07-papiws-wls103-xafdids.ear/papiws.war/WEB-INF/
Creating ProcessService...
fuego.directory.DirectoryRuntimeException: Exception [fuego.directory.exception.InvalidSchemaException: Directory [default] has not been correctly initialized.
Detail:Even though a Directory Service is currently present at the specified location, the expected Oracle entries could not be found. Either the schema has not been created or the existing directory corresponds to a different Oracle version.
].
at fuego.directory.DirectoryRuntimeException.wrapException(DirectoryRuntimeException.java:85)
at fuego.directory.provider.DirectorySessionImpl.getDirectoryPreferences(DirectorySessionImpl.java:623)
at fuego.directory.hybrid.ldap.LDAPDirectoryPreferences.createFromSession(LDAPDirectoryPreferences.java:35)
at fuego.directory.hybrid.generic.GenericLDAPRepository.createRepository(GenericLDAPRepository.java:58)
at fuego.directory.hybrid.generic.GenericLDAPFactory.createRepository(GenericLDAPFactory.java:36)
at fuego.directory.hybrid.ldap.DefaultLDAPHybridFactory.createOrganizationAccessor(DefaultLDAPHybridFactory.java:147)
at fuego.directory.hybrid.generic.GenericLDAPFactory.createOrganizationAccessor(GenericLDAPFactory.java:46)
at fuego.directory.provider.DirectorySessionImpl.<init>(DirectorySessionImpl.java:103)
at fuego.directory.provider.Factory.buildSession(Factory.java:239)
at fuego.directory.hybrid.HybridFactory.buildSession(HybridFactory.java:51)
at fuego.directory.provider.Factory.startSession(Factory.java:403)
at fuego.directory.Directory.startAnonymousSession(Directory.java:214)
at fuego.papi.impl.ProcessServiceFactoryImpl.obtainSchemaId(ProcessServiceFactoryImpl.java:200)
at fuego.papi.impl.ProcessServiceFactoryImpl.create(ProcessServiceFactoryImpl.java:75)
at fuego.papi.impl.ProcessServiceFactoryImpl.create(ProcessServiceFactoryImpl.java:63)
at fuego.papi.ProcessService.create(ProcessService.java:335)
at fuego.papi.webservice.WebServiceManager.configureAndCreateProcessService(WebServiceManager.java:271)
at fuego.papi.webservice.WebServiceManager.initialize(WebServiceManager.java:96)
at fuego.papi.webservice.listener.PapiWsContextListener.initWebServices(PapiWsContextListener.java:133)
at fuego.papi.webservice.listener.PapiWsContextListener.contextInitialized(PapiWsContextListener.java:73)
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:1784)
at weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:2999)
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.operations.AbstractOperation.activate(AbstractOperation.java:569)
at weblogic.deploy.internal.targetserver.operations.ActivateOperation.activateDeployment(ActivateOperation.java:140)
at weblogic.deploy.internal.targetserver.operations.ActivateOperation.doCommit(ActivateOperation.java:106)
at weblogic.deploy.internal.targetserver.operations.StartOperation.doCommit(StartOperation.java:143)
at weblogic.deploy.internal.targetserver.operations.AbstractOperation.commit(AbstractOperation.java:323)
at weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentCommit(DeploymentManager.java:820)
at weblogic.deploy.internal.targetserver.DeploymentManager.activateDeploymentList(DeploymentManager.java:1227)
at weblogic.deploy.internal.targetserver.DeploymentManager.handleCommit(DeploymentManager.java:436)
at weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.commit(DeploymentServiceDispatcher.java:163)
at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:181)
at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.access$100(DeploymentReceiverCallbackDeliverer.java:12)
at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:67)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: fuego.directory.exception.InvalidSchemaException: Directory [default] has not been correctly initialized.
Detail:Even though a Directory Service is currently present at the specified location, the expected Oracle entries could not be found. Either the schema has not been created or the existing directory corresponds to a different Oracle version.
at fuego.directory.provider.jdbc.oracle.OraclePersistenceManager.mapSQLException(OraclePersistenceManager.java:164)
at fuego.directory.provider.jdbc.datadirect.oracle.DataDirectOraclePersistenceManager.mapSQLException(DataDirectOraclePersistenceManager.java:50)
at fuego.directory.provider.jdbc.JDBCServiceAccessor.mapSQLException(JDBCServiceAccessor.java:78)
at fuego.directory.provider.jdbc.JDBCObjectPropertiesAccessor.fetchAllDirectoryProperties(JDBCObjectPropertiesAccessor.java:442)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at fuego.directory.provider.DirectorySessionImpl$AccessorProxy.invoke(DirectorySessionImpl.java:756)
at $Proxy205.fetchAllDirectoryProperties(Unknown Source)
at fuego.directory.provider.jdbc.JDBCDirectoryPreferencesAccessor.loadPreferences(JDBCDirectoryPreferencesAccessor.java:38)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at fuego.directory.provider.DirectorySessionImpl$AccessorProxy.invoke(DirectorySessionImpl.java:756)
at $Proxy207.loadPreferences(Unknown Source)
at fuego.directory.provider.DirectorySessionImpl.getDirectoryPreferences(DirectorySessionImpl.java:619)
... 56 more
Caused by: java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
at weblogic.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
at weblogic.jdbcx.base.BasePreparedStatementWrapper.executeQuery(Unknown Source)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:128)
at fuego.jdbc.FaultTolerantPreparedStatement.executeQuery(FaultTolerantPreparedStatement.java:598)
at fuego.directory.provider.jdbc.JDBCPersistenceManager.executeQuery(JDBCPersistenceManager.java:199)
at fuego.directory.provider.jdbc.JDBCObjectPropertiesAccessor.fetchAllDirectoryProperties(JDBCObjectPropertiesAccessor.java:395)
... 70 more
<Apr 6, 2011 12:04:22 PM EDT> <Warning> <HTTP> <BEA-101162> <User defined listener fuego.papi.webservice.listener.PapiWsContextListener failed: java.lang.RuntimeException: Fatal error initializing PAPI Web Services.
java.lang.RuntimeException: Fatal error initializing PAPI Web Services
at fuego.papi.webservice.listener.PapiWsContextListener.contextInitialized(PapiWsContextListener.java:81)
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)
Truncated. see log file for complete stacktrace
fuego.directory.DirectoryRuntimeException: Exception [fuego.directory.exception.InvalidSchemaException: Directory [default] has not been correctly initialized.
Detail:Even though a Directory Service is currently present at the specified location, the expected Oracle entries could not be found. Either the schema has not been created or the existing directory corresponds to a different Oracle version.
].
at fuego.directory.DirectoryRuntimeException.wrapException(DirectoryRuntimeException.java:85)
at fuego.directory.provider.DirectorySessionImpl.getDirectoryPreferences(DirectorySessionImpl.java:623)
at fuego.directory.hybrid.ldap.LDAPDirectoryPreferences.createFromSession(LDAPDirectoryPreferences.java:35)
at fuego.directory.hybrid.generic.GenericLDAPRepository.createRepository(GenericLDAPRepository.java:58)
at fuego.directory.hybrid.generic.GenericLDAPFactory.createRepository(GenericLDAPFactory.java:36)
Truncated. see log file for complete stacktrace
fuego.directory.exception.InvalidSchemaException: Directory [default] has not been correctly initialized.
Detail:Even though a Directory Service is currently present at the specified location, the expected Oracle entries could not be found. Either the schema has not been created or the existing directory corresponds to a different Oracle version.
at fuego.directory.provider.jdbc.oracle.OraclePersistenceManager.mapSQLException(OraclePersistenceManager.java:164)
at fuego.directory.provider.jdbc.datadirect.oracle.DataDirectOraclePersistenceManager.mapSQLException(DataDirectOraclePersistenceManager.java:50)
at fuego.directory.provider.jdbc.JDBCServiceAccessor.mapSQLException(JDBCServiceAccessor.java:78)
at fuego.directory.provider.jdbc.JDBCObjectPropertiesAccessor.fetchAllDirectoryProperties(JDBCObjectPropertiesAccessor.java:442)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Truncated. see log file for complete stacktrace
java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
at weblogic.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at weblogic.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
Truncated. see log file for complete stacktrace
>
<Apr 6, 2011 12:04:22 PM EDT> <Warning> <HTTP> <BEA-101162> <User defined listener fuego.papi.webservice.discovery.DiscoveryListener failed: java.lang.NullPointerException.
java.lang.NullPointerException
at fuego.papi.webservice.discovery.DiscoveryListener.contextDestroyed(DiscoveryListener.java:110)
at weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:466)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(Unknown Source)
at weblogic.servlet.internal.EventsManager.notifyContextDestroyedEvent(EventsManager.java:194)
Truncated. see log file for complete stacktrace
>
It should be using the XAFDIDS datasource from the Weblogic server which is correct.
Any help would be greatly appreciated.
Thanks,
Shannon