Database Initialization error while installing LC on WebSphere

[Former Community Member]

Hi,

I am trying to install and deploy LC ES2 on WebSphere Application Server. I am following the instructions given in "Installing and Deploying LiveCycle ES2 for WebSphere".

I am stuck at LiveCycle ES2 Database Initialization step while running Adobe LiveCycle Configuration Manager. Can some one help me in resolving this issue. Please find the exception details below.

My OS,DB details are as below:

Windows 2003 Enterprise Edition SP2

32-bit OS

Microsoft SQL server 2005

com.adobe.livecycle.bootstrap.BootstrapException: ALC-TTN-103-000: Bootstrapping request failed on server.  Message from server:

ALC-TTN-011-061: Bootstrapping failed for platform component [Process Engine].  The wrapped exception's
message reads:
com.adobe.idp.um.api.UMException| [com.adobe.idp.um.api.impl.AuthorizationManagerImpl] errorCode:16385 errorCodeHEX:0x4001 message:execute query failure(select distinct
  top 1  * from EDCRELAPPENTITY where upper(EDCRELAPPENTITY.relAppName) like upper(?) escape
'\' )com.adobe.idp.common.errors.exception.IDPException| [com.adobe.idp.storeprovider.jdbc.DBStatement] errorCode:12290 errorCodeHEX:0x3002 message:execute query
failure(select distinct  top 1  * from EDCRELAPPENTITY where upper(EDCRELAPPENTITY.relAppName) like
upper(?) escape '\' ) chainedException:java.sql.SQLException: enlist: caught ExceptionchainedExceptionMessage:enlist
: caught Exception chainedException trace:java.sql.SQLException: enlist: caught Exception
    at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1543)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:777)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2743)
    at com.adobe.idp.storeprovider.jdbc.DBStatement.executeQuery(DBStatement.java:299)
    at com.adobe.idp.storeprovider.jdbc.DBStoreProvider.retrieveAll(DBStoreProvider.java:2053)
    at com.adobe.idp.storeprovider.jdbc.DBStoreProvider.retrieve(DBStoreProvider.java:1762)
    at com.adobe.idp.um.businesslogic.directoryservices.DirectoryServicesManagerBean.findRelApplication(DirectoryServicesManagerBean.java:1921)
[Message truncated - see logs for details.]

Check application server logs for details.
    at com.adobe.livecycle.bootstrap.client.BootstrapRequestClient.analyzeResponse(BootstrapRequestClient.java:152)
    at com.adobe.livecycle.bootstrap.client.BootstrapRequestClient.bootstrap(BootstrapRequestClient.java:63)
    at com.adobe.livecycle.bootstrap.client.BootstrapManager.executeStep(BootstrapManager.java:203)
    at com.adobe.livecycle.lcm.feature.bootstrap.BootstrapTask$ActualTask.<init>(BootstrapTask.java:125)
    at com.adobe.livecycle.lcm.feature.bootstrap.BootstrapTask$1.construct(BootstrapTask.java:58)
    at com.adobe.livecycle.lcm.core.tasks.SwingWorker$2.run(SwingWorker.java:114)
    at java.lang.Thread.run(Thread.java:619)

Thanks & Regards,

Deepthi

[Former Community Member]

This is client side logs.

Can you please post the logs(SystemOut.log/SystemErr.log) generated at the server side.

[Former Community Member]

Hi,

Server log is huge. Please find a bit of  server log below:

LocalTransact E   J2CA0030E: Method enlist caught com.ibm.ws.Transaction.IllegalResourceIn2PCTransactionException: Illegal attempt to enlist multiple 1PC XAResources
at com.ibm.ws.tx.jta.RegisteredResources.enlistResource(RegisteredResources.java:864)
at com.ibm.ws.tx.jta.TransactionImpl.enlistResource(TransactionImpl.java:1718)
at com.ibm.ws.tx.jta.TranManagerSet.enlistOnePhase(TranManagerSet.java:608)
at com.ibm.ejs.j2c.LocalTransactionWrapper.enlist(LocalTransactionWrapper.java:587)
at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:2176)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java:2574)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:712)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2743)
at com.adobe.idp.storeprovider.jdbc.DBStatement.executeQuery(DBStatement.java:299)
at com.adobe.idp.storeprovider.jdbc.DBStoreProvider.retrieveAll(DBStoreProvider.java:2053)
at com.adobe.idp.storeprovider.jdbc.DBStoreProvider.retrieve(DBStoreProvider.java:1762)
at com.adobe.idp.um.businesslogic.directoryservices.DirectoryServicesManagerBean.findRelApplication(DirectoryServicesManagerBean.java:1921)
at com.adobe.idp.um.businesslogic.directoryservices.DirectoryServicesManagerBean.getReliantApplication(DirectoryServicesManagerBean.java:5992)
at com.adobe.idp.um.businesslogic.directoryservices.DirectoryServicesManagerBean.getReliantApplication(DirectoryServicesManagerBean.java:6009)
at com.adobe.idp.um.businesslogic.directoryservices.EJSLocalStatelessDirectoryServicesManagerBean_0dbf3d20.getReliantApplication(Unknown Source)
at com.adobe.idp.um.api.impl.AuthorizationManagerImpl.getReliantApplication(AuthorizationManagerImpl.java:320)
at com.adobe.workflow.initializer.POFWorkflowInitializer.setupWorkflowRoles(POFWorkflowInitializer.java:528)
at com.adobe.workflow.initializer.POFWorkflowInitializer.initializeUserInformation(POFWorkflowInitializer.java:513)
at com.adobe.workflow.initializer.POFWorkflowInitializer.initialize(POFWorkflowInitializer.java:273)
at com.adobe.workflow.initializer.WorkflowInitializerBean.initialize(WorkflowInitializerBean.java:95)
at com.adobe.workflow.initializer.EJSRemoteStatelessadobe_WorkflowInitializerEJB_75bbaaed.initialize(Unknown Source)
at com.adobe.workflow.initializer._WorkflowInitializerRemote_Stub.initialize(_WorkflowInitializerRemote_Stub.java:312)
at com.adobe.workflow.initializer.WorkflowInitializerBean.bootstrap(WorkflowInitializerBean.java:57)
at com.adobe.workflow.initializer.EJSRemoteStatelessadobe_WorkflowInitializerEJB_75bbaaed.bootstrap(Unknown Source)
at com.adobe.workflow.initializer._WorkflowInitializerRemote_Stub.bootstrap(_WorkflowInitializerRemote_Stub.java:267)
at com.adobe.livecycle.bootstrap.bootstrappers.WFBootstrapper.bootstrap(WFBootstrapper.java:53)
at com.adobe.livecycle.bootstrap.framework.ManualBootstrapInvoker.invoke(ManualBootstrapInvoker.java:78)
at com.adobe.livecycle.bootstrap.framework.BootstrapServlet.doGet(BootstrapServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1530)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:829)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:458)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:862)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:178)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:557)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:607)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:984)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1069)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550)
while trying to enlist resources from DataSource IDP_DS with the Transaction Manager for the current transaction, and threw a Exception.
[5/12/10 18:15:11:282 GMT+05:30] 0000001a IDPLoggedExce W com.adobe.idp.common.errors.Logger$LogConsumer run UserM:GENERIC_WARNING: [Thread Hashcode: 1629577505] com.adobe.idp.common.errors.exception.IDPLoggedException| [com.adobe.idp.storeprovider.jdbc.DBStatement] errorCode:12290 errorCodeHEX:0x3002 message:execute query failure(select distinct  top 1  * from EDCRELAPPENTITY where upper(EDCRELAPPENTITY.relAppName) like upper(?) escape '\' ) chainedException:java.sql.SQLException: enlist: caught ExceptionchainedExceptionMessage:enlist: caught Exception chainedException trace:java.sql.SQLException: enlist: caught Exception
at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1543)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:777)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2743)
at com.adobe.idp.storeprovider.jdbc.DBStatement.executeQuery(DBStatement.java:299)
at com.adobe.idp.storeprovider.jdbc.DBStoreProvider.retrieveAll(DBStoreProvider.java:2053)
at com.adobe.idp.storeprovider.jdbc.DBStoreProvider.retrieve(DBStoreProvider.java:1762)
at com.adobe.idp.um.businesslogic.directoryservices.DirectoryServicesManagerBean.findRelApplication(DirectoryServicesManagerBean.java:1921)
at com.adobe.idp.um.businesslogic.directoryservices.DirectoryServicesManagerBean.getReliantApplication(DirectoryServicesManagerBean.java:5992)
at com.adobe.idp.um.businesslogic.directoryservices.DirectoryServicesManagerBean.getReliantApplication(DirectoryServicesManagerBean.java:6009)
at com.adobe.idp.um.businesslogic.directoryservices.EJSLocalStatelessDirectoryServicesManagerBean_0dbf3d20.getReliantApplication(Unknown Source)
at com.adobe.idp.um.api.impl.AuthorizationManagerImpl.getReliantApplication(AuthorizationManagerImpl.java:320)
at com.adobe.workflow.initializer.POFWorkflowInitializer.setupWorkflowRoles(POFWorkflowInitializer.java:528)
at com.adobe.workflow.initializer.POFWorkflowInitializer.initializeUserInformation(POFWorkflowInitializer.java:513)
at com.adobe.workflow.initializer.POFWorkflowInitializer.initialize(POFWorkflowInitializer.java:273)
at com.adobe.workflow.initializer.WorkflowInitializerBean.initialize(WorkflowInitializerBean.java:95)
at com.adobe.workflow.initializer.EJSRemoteStatelessadobe_WorkflowInitializerEJB_75bbaaed.initialize(Unknown Source)
at com.adobe.workflow.initializer._WorkflowInitializerRemote_Stub.initialize(_WorkflowInitializerRemote_Stub.java:312)
at com.adobe.workflow.initializer.WorkflowInitializerBean.bootstrap(WorkflowInitializerBean.java:57)
at com.adobe.workflow.initializer.EJSRemoteStatelessadobe_WorkflowInitializerEJB_75bbaaed.bootstrap(Unknown Source)
at com.adobe.workflow.initializer._WorkflowInitializerRemote_Stub.bootstrap(_WorkflowInitializerRemote_Stub.java:267)
at com.adobe.livecycle.bootstrap.bootstrappers.WFBootstrapper.bootstrap(WFBootstrapper.java:53)
at com.adobe.livecycle.bootstrap.framework.ManualBootstrapInvoker.invoke(ManualBootstrapInvoker.java:78)
at com.adobe.livecycle.bootstrap.framework.BootstrapServlet.doGet(BootstrapServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:718)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1530)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:829)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:458)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:175)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:862)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:178)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:455)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:384)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:557)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:607)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:984)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1069)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1550)
Caused by: javax.resource.ResourceException: enlist: caught Exception
at com.ibm.ejs.j2c.LocalTransactionWrapper.enlist(LocalTransactionWrapper.java:690)
at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:2176)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbManagedConnectionImpl.java:2574)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:712)
... 39 more
Caused by: com.ibm.ws.Transaction.IllegalResourceIn2PCTransactionException: Illegal attempt to enlist multiple 1PC XAResources
at com.ibm.ws.tx.jta.RegisteredResources.enlistResource(RegisteredResources.java:864)
at com.ibm.ws.tx.jta.TransactionImpl.enlistResource(TransactionImpl.java:1718)
at com.ibm.ws.tx.jta.TranManagerSet.enlistOnePhase(TranManagerSet.java:608)
at com.ibm.ejs.j2c.LocalTransactionWrapper.enlist(LocalTransactionWrapper.java:587)
... 42 more

Thanks & Regards,

Deepthi

[JayanKandathil]

It looks like you chose com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelper as the datastore helper class and you shouldn't have.  More here:

http://blogs.adobe.com/livecycle/2007/10/livecycle_for_the_sql_server_2.html