Hi,
I work with RBPM 4.0.2 Patch C, Oracle 11g, running on Jboss 5.1.0 EAP
(jre 1.6.0_31) and RHEL 5.8.

i have an error when i start de UserApplication or run any workflow:

> 2013-04-09 17:33:52,112 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking for
> database schema
> 2013-04-09 17:33:52,283 INFO [STDOUT] (main) *ERROR [RBPM]
> [com.sssw.fw.servlet.EboBootServlet:init] Runtime exception
> initializing.
> com.novell.soa.persist.PersistenceException:
> org.hibernate.QueryTimeoutException: could not get table metadata:
> AFACTIVITY*
> at
> com.novell.soa.persist.HibernateUtil.isTableFound( HibernateUtil.java:498)
> at
> com.novell.soa.persist.HibernateUtil.isTableFound( HibernateUtil.java:453)
> at
> com.novell.soa.persist.DatabaseSchemaUpdate.analyz eSchema(DatabaseSchemaUpdate.java:264)
> at
> com.novell.soa.persist.DatabaseSchemaUpdate.valida teDatabaseSchema(DatabaseSchemaUpdate.java:208)
> at
> com.sssw.fw.servlet.EboBootServlet.init(EboBootSer vlet.java:98)
> at
> com.sssw.portal.servlet.EboPortalBootServlet.init( EboPortalBootServlet.java:59)
> at javax.servlet.GenericServlet.init(GenericServlet.j ava:212)
> ...
> at
> org.jboss.system.server.profileservice.repository. MainDeployerAdapter.process(MainDeployerAdapter.ja va:117)
> at
> org.jboss.system.server.profileservice.repository. ProfileDeployAction.install(ProfileDeployAction.ja va:70)
> at
> org.jboss.system.server.profileservice.repository. AbstractProfileAction.install(AbstractProfileActio n.java:53)
> at
> org.jboss.system.server.profileservice.repository. AbstractProfileService.install(AbstractProfileServ ice.java:403)
> at
> org.jboss.dependency.plugins.AbstractControllerCon text.install(AbstractControllerContext.java:348)
> at
> org.jboss.dependency.plugins.AbstractController.in stall(AbstractController.java:1652)
> at
> org.jboss.dependency.plugins.AbstractController.in crementState(AbstractController.java:938)
> at
> org.jboss.dependency.plugins.AbstractController.re solveContexts(AbstractController.java:1082)
> at
> org.jboss.dependency.plugins.AbstractController.re solveContexts(AbstractController.java:988)
> at
> org.jboss.dependency.plugins.AbstractController.in stall(AbstractController.java:778)
> at
> org.jboss.dependency.plugins.AbstractController.in stall(AbstractController.java:543)
> at
> org.jboss.system.server.profileservice.repository. AbstractProfileService.registerProfile(AbstractPro fileService.java:308)
> at
> org.jboss.system.server.profileservice.ProfileServ iceBootstrap.start(ProfileServiceBootstrap.java:25 6)
> at
> org.jboss.bootstrap.AbstractServerImpl.start(Abstr actServerImpl.java:461)
> at org.jboss.Main.boot(Main.java:221)
> at org.jboss.Main$1.run(Main.java:556)
> at java.lang.Thread.run(Thread.java:662)
> CAUSED BY: ORG.HIBERNATE.QUERYTIMEOUTEXCEPTION: COULD NOT GET TABLE
> METADATA: AFACTIVITY
> at
> org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:124)
> at
> org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:66)
> at
> org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:52)
> at
> org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTab leMetadata(DatabaseMetadata.java:128)
> at
> com.novell.soa.persist.HibernateUtil.isTableFound( HibernateUtil.java:480)
> ... 77 more
> CAUSED BY: JAVA.SQL.SQLEXCEPTION: ORA-01502: INDEX
> 'A000529.AFACTIVITY_PKEY' OR PARTITION OF SUCH INDEX IS IN UNUSABLE
> STATE
>
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:112)
> at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:331)
> at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:288)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 743)
> at
> oracle.jdbc.driver.T4CStatement.doOall8(T4CStateme nt.java:207)
> at
> oracle.jdbc.driver.T4CStatement.executeForRows(T4C Statement.java:946)
> at oracle.j
> 2013-04-09 17:33:52,284 INFO [STDOUT] (main)
> dbc.driver.OracleStatement.doExecuteWithTimeout(Or acleStatement.java:1168)
> at
> oracle.jdbc.driver.OracleStatement.executeUpdateIn ternal(OracleStatement.java:1614)
> at
> oracle.jdbc.driver.OracleStatement.executeUpdate(O racleStatement.java:1579)
> at
> oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(Or acleDatabaseMetaData.java:3485)
> at
> org.hibernate.tool.hbm2ddl.TableMetadata.initIndex es(TableMetadata.java:177)
> at
> org.hibernate.tool.hbm2ddl.TableMetadata.<init>(Ta bleMetadata.java:61)
> at
> org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTab leMetadata(DatabaseMetadata.java:113)
> ... 78 more
> 2013-04-09 17:33:52,301 INFO [STDOUT] (main) INFO [RBPM]
> [com.sssw.portal.servlet.EboPortalBootServlet:init] Identity Manager
> Roles Based Provisioning Module Version 4.0.2
> 2013-04-09 17:33:52,302 INFO [STDOUT] (main) INFO [RBPM]
> [com.sssw.portal.servlet.EboPortalBootServlet:init] Patch C
> 2013-04-09 17:33:52,303 INFO [STDOUT] (main) INFO [RBPM]
> [com.sssw.portal.servlet.EboPortalBootServlet:init] Driver Version 2.2
> 2013-04-09 17:33:52,304 INFO [STDOUT] (main) INFO [RBPM]
> [com.sssw.portal.servlet.EboPortalBootServlet:init] Build Revision
> 39446
>


Anybody have any idea about what happens?

Thanks in advance.


--
shinojosa
------------------------------------------------------------------------
shinojosa's Profile: https://forums.netiq.com/member.php?userid=539
View this thread: https://forums.netiq.com/showthread.php?t=47519