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

hi !

iam trying install adobe livecycle  jboss.i have  created oracle database suggested in document (created user,database tables...).

when deploy jars created during lcm deploy folder ,i got exception .here snipped of 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 not exist

 

    @ oracle.jdbc.driver.sqlstatemapping.newsqlexception(sqlstatemapping.java:91)
    @ oracle.jdbc.driver.databaseerror.newsqlexception(databaseerror.java:112)
    @ oracle.jdbc.driver.databaseerror.throwsqlexception(databaseerror.java:173)
    @ oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:455)
    @ oracle.jdbc.driver.t4cttioer.processerror(t4cttioer.java:413)
    @ oracle.jdbc.driver.t4c8oall.receive(t4c8oall.java:1030)
    @ oracle.jdbc.driver.t4cstatement.dooall8(t4cstatement.java:183)
    @ oracle.jdbc.driver.t4cstatement.executefordescribe(t4cstatement.java:774)
    @ oracle.jdbc.driver.t4cstatement.executemaybedescribe(t4cstatement.java:849)
    @ oracle.jdbc.driver.oraclestatement.doexecutewithtimeout(oraclestatement.java:1186)
    @ oracle.jdbc.driver.oraclestatement.executequery(oraclestatement.java:1377)
    @ oracle.jdbc.driver.oraclestatementwrapper.executequery(oraclestatementwrapper.java:386)
    @ org.jboss.resource.adapter.jdbc.wrappedstatement.executequery(wrappedstatement.java:171)
    @ org.jboss.ejb.plugins.keygenerator.hilo.hilokeygeneratorfactory.initsequence(hilokeygener atorfactory.java:320)
    @ org.jboss.ejb.plugins.keygenerator.hilo.hilokeygeneratorfactory.startservice(hilokeygener atorfactory.java:281)
    @ org.jboss.system.servicembeansupport.jbossinternalstart(servicembeansupport.java:289)
    @ org.jboss.system.servicembeansupport.jbossinternallifecycle(servicembeansupport.java:245)

 

can suggest problem ?

hi,

 

are using adobe preconfigured jboss or using own copy of jboss?

if using adobe preconfigured jboss make sure have made changes in respective xml files following livecycle documentation.

moreover, make sure have given required roles/privileges oracle user.

also, using livecycle on windows box? if yes, try going partial turnkey installation. configures jboss service user specified database.

 

thanks!

More discussions in LiveCycle installation, configuration, deployment, and administration

adobe