Highlighted

Error Deploying Persistant JMS Store

_mmcatam_

16-10-2008

new to Livecycle. Going through the install steps, on page 46 of the deploy to a webloigc cluster. I create and targeted my JDBC data source. We are using oralce 10g.<br /><br />When I then go to try and create my JMS persistent store, on activate I get the following exception. I believe I have configured everything else correctly, according to the docs:<br /><br />####<Oct 15, 2008 9:04:28 AM PDT> <Info> <JDBC> <pdf-dev1> <pdf101a-m1> <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <weblogic> <> <> <1224086668200> <BEA-001128> <Connection for pool "IDP_DS" closed.> <br />####<Oct 15, 2008 9:04:28 AM PDT> <Error> <Store> <pdf-dev1> <pdf101a-m1> <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <weblogic> <> <> <1224086668215> <BEA-280072> <JDBC store "IDPJDBCStore_pdf101a-m1" failed to open table "pdf101a-m1WLStore".<br />weblogic.store.io.jdbc.JDBCStoreException: [Store:280065][Store:280068]JDBC store failed to initialize. It did not find its database table and failed trying to create a new empty table using the commands in file "/weblogic/store/io/jdbc/ddl/oracle.ddl". (server="pdf101a-m1" store="IDPJDBCStore_pdf101a-m1" table="pdf101a-m1WLStore"):(Linked Cause, "java.sql.SQLException: ORA-00922: missing or invalid option<br />")<br /> at weblogic.store.io.jdbc.JDBCStoreIO.createTable(JDBCStoreIO.java:605)<br /> at weblogic.store.io.jdbc.JDBCStoreIO.open(JDBCStoreIO.java:351)<br /> at weblogic.store.internal.PersistentStoreImpl.recoverStoreConnections(PersistentStoreImpl.java:327)<br /> at weblogic.store.internal.PersistentStoreImpl.open(PersistentStoreImpl.java:318)<br /> at weblogic.store.admin.AdminHandler.activate(AdminHandler.java:135)<br /> at weblogic.store.admin.JDBCAdminHandler.activate(JDBCAdminHandler.java:64)<br /> at weblogic.management.utils.GenericManagedService.activateDeployment(GenericManagedService.java:237)<br /> at weblogic.management.utils.GenericServiceManager.activateDeployment(GenericServiceManager.java:131)<br /> at weblogic.management.internal.DeploymentHandlerHome.invokeHandlers(DeploymentHandlerHome.java:590)<br /> at weblogic.management.internal.DeploymentHandlerHome.access$400(DeploymentHandlerHome.java:63)<br /> at weblogic.management.internal.DeploymentHandlerHome$1.activateUpdate(DeploymentHandlerHome.java:173)<br /> at weblogic.descriptor.internal.DescriptorImpl$Update.activate(DescriptorImpl.java:481)<br /> at weblogic.descriptor.internal.DescriptorImpl.activateUpdate(DescriptorImpl.java:220)<br /> at weblogic.management.provider.internal.RuntimeAccessDeploymentReceiverService$1.run(RuntimeAccessDeploymentReceiverService.java:361)<br /> at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)<br /> at weblogic.security.service.SecurityManager.runAs(Unknown Source)<br /> at weblogic.management.provider.internal.RuntimeAccessDeploymentReceiverService.commit(RuntimeAccessDeploymentReceiverService.java:356)<br /> at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:181)<br /> at weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.commit(DeploymentReceiverCallbackDeliverer.java:63)<br /> at weblogic.deploy.service.internal.statemachines.targetserver.AwaitingCommit.callDeploymentReceivers(AwaitingCommit.java:223)<br /> at weblogic.deploy.service.internal.statemachines.targetserver.AwaitingCommit.handleCommit(AwaitingCommit.java:125)<br /> at weblogic.deploy.service.internal.statemachines.targetserver.AwaitingCommit.receivedCommit(AwaitingCommit.java:44)<br /> at weblogic.deploy.service.internal.transport.CommonMessageReceiver.receiveRequestCommitMsg(CommonMessageReceiver.java:466)<br /> at weblogic.deploy.service.internal.transport.CommonMessageReceiver$3.run(CommonMessageReceiver.java:720)<br /> at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:464)<br /> at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)<br /> at weblogic.work.ExecuteThread.run(ExecuteThread