java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

[chandra100100]

Hi !

Iam trying to install Adobe LiveCycle  to JBoss.I have  created oracle database as suggested in the document (created user,database tables...).

When i deploy jars created during LCM to deploy folder ,i got an exception .Here is a snipped of the server.log

2010-09-07 15:28:10,046 WARN  [org.jboss.system.ServiceController] Problem starting service jboss:service=KeyGeneratorFactory,type=HiLo
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

    at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
    at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:774)
    at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:849)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
    at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:386)
    at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171)
    at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.initSequence(HiLoKeyGeneratorFactory.java:320)
    at org.jboss.ejb.plugins.keygenerator.hilo.HiLoKeyGeneratorFactory.startService(HiLoKeyGeneratorFactory.java:281)
    at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
    at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)

Can anyone suggest where is the problem ?

[Hina_Rastogi]

Hi,

Are you using Adobe Preconfigured JBoss or using your own copy of JBoss?

If you are using Adobe Preconfigured JBoss then make sure you have made changes in the respective XML files following the LiveCycle documentation.

Moreover, make sure you have given required roles/privileges to your Oracle User.

Also, are you using LiveCycle on a Windows box? If yes, then try going for Partial Turnkey installation. It configures JBoss as a service for a user specified database.

Thanks!

[chandra100100]

Hi EveryOne !

I have fixed the problem ,it is the problem in configuring livecycle es2 database for oracle.

Thanks to All.

[Former Community Member]

how do you solve that one?

Please share me.

I follow the creating dabatase by preinstallationg guide . I use that database in WAS 6.1.0.31,LCES2 and Windows 2003 server .it is ok but Windows 2008 ,WAS v7.0.0.9 , i got some issu.

[11/8/10 11:47:18:559 SGT] 00000108 RemoteExcepti E  
CNTR0020E: EJB threw an unexpected (non-declared)
exception during invocation of method "invoke" on bean "BeanId(LiveCycleES2#adobe-ejb-receiver.jar#Invocation, null)".
Exception data: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

[11/8/10 11:52:30:395 SGT] 00000108 LocalExceptio E
   CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "getObjectType" on bean
"BeanId(LiveCycleES2#adobe-pof.jar#adobe_POFDataDictionaryLocalEJB, null)". Exception data: java.sql.SQLSyntaxErrorException:
ORA-00942: table or view does not exist

[11/8/10 11:56:54:233 SGT] 0000001a DSCStartupSer W
com.adobe.idp.dsc.startup.DSCStartupServlet destroy Unable to shutdown DSCManager

[11/8/10 12:20:22:218 SGT] 0000019b
LocalExceptio E   CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method
"doRequiresNew" on bean "BeanId(LiveCycleES2#adobe-dscf.jar#EjbTransactionCMTAdapter, null)".
Exception data: javax.ejb.TransactionRolledbackLocalException:  ; nested exception is: java.sql.SQLSyntaxErrorException:
ORA-00942: table or view does not exist

Regards,

Ei Wah