Hello,
I'm doing the rbpm migration from 3.7 to 4.0.2. The rbpm is running on a
jboss 5.1.0 EAP (jre 1.6.0_14), Oracle 11g and RHEL 5.8. The migration
runs without any errors, all logs seems to be ok, the problem appears on
the rbpm first startup, it says that schema is invalid with lots of
other errors.
I think that the migration of the DB is not happening. Is there anything
else I can do or check?
I did the same migration in another environment and went well, but with
the default jboss 5.1.0 GA of the rbpm installer.

Here are some of the errors

>
> 2013-03-12 14:18:08,970 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table AF_RESOURCE_REQUEST_STATUS....missing
> 2013-03-12 14:18:09,147 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table AF_ROLE_REQUEST_STATUS....found
> 2013-03-12 14:18:09,324 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table ATTESTATION_ATTESTER....found
> 2013-03-12 14:18:09,497 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table ATTESTATION_ATTRIBUTE....found
> 2013-03-12 14:18:09,673 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table ATTESTATION_QUESTION....found
> 2013-03-12 14:18:09,850 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table ATTESTATION_REPORT....found
> 2013-03-12 14:18:09,976 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table ATTESTATION_REQUEST....found
> 2013-03-12 14:18:10,060 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table ATTESTATION_RESPONSE....found
> 2013-03-12 14:18:10,144 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table ATTESTATION_SURVEY_QUESTION....found
> 2013-03-12 14:18:10,227 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table ATTESTATION_TARGET....found
> 2013-03-12 14:18:10,307 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table AUTHPROPS....found
> 2013-03-12 14:18:10,390 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table DSS_APPLET_BROWSER_TYPES....found
> 2013-03-12 14:18:10,472 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table DSS_APPLET_CFG....found
> 2013-03-12 14:18:10,554 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table DSS_APPLET_CFG_MAP....found
> 2013-03-12 14:18:10,638 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table DSS_BROWSER_TYPE....found
> 2013-03-12 14:18:10,722 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table DSS_CONFIG....found
> 2013-03-12 14:18:10,802 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table DSS_EXT_KEY_USAGE_RESTRICTION....found
> 2013-03-12 14:18:10,882 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table DSS_USR_POLICY_SET....found
> 2013-03-12 14:18:10,968 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table PORTALCATEGORY....found
> 2013-03-12 14:18:11,053 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table PORTALPORTLETHANDLES....found
> 2013-03-12 14:18:11,141 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table PORTALPORTLETSETTINGS....found
> 2013-03-12 14:18:11,230 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table PORTALPRODUCERREGISTRY....found
> 2013-03-12 14:18:11,311 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table PORTALPRODUCERS....found
> 2013-03-12 14:18:11,396 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table PORTALREGISTRY....found
> 2013-03-12 14:18:11,486 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table PROFILEGROUPPREFERENCES....found
> 2013-03-12 14:18:11,575 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table PROFILEUSERPREFERENCES....found
> 2013-03-12 14:18:11,658 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table PROVISIONING_CODE_MAP....found
> 2013-03-12 14:18:11,741 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table PROVISIONING_CODE_MAP_LABEL....found
> 2013-03-12 14:18:11,826 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table PROVISIONING_VIEW_VALUE....found
> 2013-03-12 14:18:11,910 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table PROVISIONING_VIEW_VALUE_LABEL....found
> 2013-03-12 14:18:11,999 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table SECURITYACCESSRIGHTS....found
> 2013-03-12 14:18:12,080 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table SECURITYPERMISSIONMETA....found
> 2013-03-12 14:18:12,170 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table SECURITYPERMISSIONS....found
> 2013-03-12 14:18:12,253 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table SEC_DELPROXY_CFG....found
> 2013-03-12 14:18:12,336 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table SEC_DELPROXY_SRV_CFG....found
> 2013-03-12 14:18:12,418 INFO [STDOUT] (main) INFO [RBPM]
> [com.novell.soa.persist.DatabaseSchemaUpdate:analyz eSchema] Checking
> schema for table SEC_SYNC_CLEANUP_QUEUE....found
> 2013-03-12 14:18:12,432 INFO [STDOUT] (main) ERROR [RBPM]
> [com.sssw.portal.servlet.EboPortalBootServlet:init] Unexpected Runtime
> Exception initializing servlet
> java.lang.RuntimeException:
> com.netiq.common.i18n.LocalizedRuntimeException: Schema is invalid. One
> or more required tables are missing. Check log for messages indicating
> tables that were not found.
> at com.sssw.fw.servlet.EboBootServlet.init(EboBootSer vlet.java:105)
> at
> com.sssw.portal.servlet.EboPortalBootServlet.init( EboPortalBootServlet.java:59)
> at javax.servlet.GenericServlet.init(GenericServlet.j ava:212)
> at
> org.apache.catalina.core.StandardWrapper.loadServl et(StandardWrapper.java:1048)
> at
> org.apache.catalina.core.StandardWrapper.load(Stan dardWrapper.java:950)
>


That table missing I think its normal because on the other environment
was also missing, and the migration went well.

Here is the complete log http://pastebin.com/7pVkECki


--
sbenavidez
------------------------------------------------------------------------
sbenavidez's Profile: https://forums.netiq.com/member.php?userid=560
View this thread: https://forums.netiq.com/showthread.php?t=47070