Application Delivery Management
Application Modernization & Connectivity
CyberRes
IT Operations Management
**************************************************
If a failure is encountered while creating the tables, verify that this string is correct
If not, you can modify this string and copy/paste to a command line to run
**************************************************
[12/10/13 22:07:06:213 EST] 0000000d SystemOut O INFO [RBPM] [com.novell.soa.persist.DatabaseSchemaUpdate:analyzeSchema] Checking schema for table SEC_DELPROXY_SRV_CFG....found
[12/10/13 22:07:08:202 EST] 0000000d SystemOut O INFO [RBPM] [com.novell.soa.persist.DatabaseSchemaUpdate:analyzeSchema] Checking schema for table SEC_SYNC_CLEANUP_QUEUE....found
[12/10/13 22:07:10:754 EST] 0000000d SystemOut O ERROR [RBPM] [com.sssw.fw.servlet.EboBootServlet:init] Runtime exception initializing.
com.novell.soa.persist.PersistenceException: liquibase.exception.DatabaseException: Error executing SQL SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,TAG,EXECTYPE FROM DATABASECHANGELOG ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC: ORA-00904: "EXECTYPE": invalid identifier
at com.novell.soa.persist.DatabaseSchemaUpdate.unappliedChangesets(DatabaseSchemaUpdate.java:346)
at com.novell.soa.persist.DatabaseSchemaUpdate.validateDatabaseSchema(DatabaseSchemaUpdate.java:212)
at com.sssw.fw.servlet.EboBootServlet.init(EboBootServlet.java:98)
at com.sssw.portal.servlet.EboPortalBootServlet.init(EboPortalBootServlet.java:59)
at javax.servlet.GenericServlet.init(GenericServlet.java:241)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:359)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.init(ServletWrapperImpl.java:171)
/home/websphere/IBM/WebSphere/Dmgr/java/jre/bin/java -Xms256m -Xmx256m -Dwar.context.name=IDMProv -jar /opt/novell/idm/liquibase.jar --databaseClass=com.novell.soa.persist.OracleUnicodeDatabase --driver=oracle.jdbc.driver.OracleDriver --classpath=/home/websphere/ojdbc6.jar:/opt/novell/idm/IDMProv.war --changeLogFile=DatabaseChangeLog.xml --url="jdbc:oracle:thin:@dbserver.myhost.com:1521:idmprd" --contexts="prov,updatedb" --logLevel=finer --logFile=/opt/novell/idm/db.out --username=idmapp --password=password update
--contexts="prov,updatedb"
--databaseClass=com.novell.soa.persist.OracleUnicodeDatabase
--driver=oracle.jdbc.driver.OracleDriver
--url="jdbc:oracle:thin:@dbserver.myhost.com:1521:idmprd"
INFO 12/1/13 4:22 PM:liquibase: Successfully acquired change log lock
INFO 12/1/13 4:22 PM:liquibase: Reading from DATABASECHANGELOG
INFO 12/1/13 4:22 PM:liquibase: Updating null or out of date checksum on changeSet DbDropForeignKeys.xml::100::IDMRBPM::(Checksum: 3:62ab1433cd27b570f7ea6ad2a0cad894) to correct value
INFO 12/1/13 4:22 PM:liquibase: Updating null or out of date checksum on changeSet DbDropForeignKeys.xml::1900::IDMRBPM::(Checksum: 3:bf06fa9dff29f0496de7cc91cc2c7ecc) to correct value
INFO 12/1/13 4:22 PM:liquibase: Reading from DATABASECHANGELOG
INFO 12/1/13 4:35 PM:liquibase: Marking ChangeSet: DbDropPrimaryKeys.xml::100::IDMRBPM::(Checksum: 3:fe60aab4237791809d4c2caefdec4744) ran despite precondition failure due to onFail='MARK_RAN':
DatabaseChangeLog.xml : Table AFACTIVITY_ORIG does not exist
INFO 12/1/13 4:35 PM:liquibase: Marking ChangeSet: DbDropPrimaryKeys.xml::200::IDMRBPM::(Checksum: 3:af4b4eb1eb37ce75b16edcc8cb39d417) ran despite precondition failure due to onFail='MARK_RAN':
DatabaseChangeLog.xml : Table AFACTIVITYTIMERTASKS_ORIG does not exist
INFO 12/1/13 4:36 PM:liquibase: ChangeSet DbDropPrimaryKeys.xml::1300::IDMRBPM ran successfully in 60183ms
INFO 12/1/13 4:36 PM:liquibase: ChangeSet DbConstraints.xml::3510::IDMRBPM ran successfully in 46ms
INFO 12/1/13 4:36 PM:liquibase: ChangeSet DbConstraints.xml::3710::IDMRBPM ran successfully in 19ms
INFO 12/1/13 4:36 PM:liquibase: Successfully released change log lock
[12/11/13 13:32:28:641 EST] 0000000b SystemOut O INFO [RBPM] [com.novell.soa.persist.DatabaseSchemaUpdate:analyzeSchema] Checking schema for table SEC_SYNC_CLEANUP_QUEUE....missing
[12/11/13 13:32:28:642 EST] 0000000b SystemOut O INFO [RBPM] [com.novell.soa.persist.DatabaseSchemaUpdate:updateSchema] Creating database schema
[12/11/13 13:43:41:287 EST] 00000017 ThreadMonitor W WSVR0605W: Thread "server.startup : 2" (0000000b) has been active for 716122 milliseconds and
may be hung. There is/are 1 thread(s) in total in the server that may be hung.
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:140)
at oracle.net.ns.Packet.receive(Packet.java:283)
[12/11/13 13:51:05:723 EST] 0000000b SystemOut O INFO [RBPM] [com.novell.soa.persist.DatabaseSchemaUpdate:validateDatabaseSchema] All requiredtables found. Schema is valid.
[12/11/13 13:51:05:726 EST] 0000000b SystemOut O INFO [RBPM] [com.sssw.portal.servlet.EboPortalBootServlet:init] Identity Manager Roles Based Provisioning Module Version 4.0.2
[12/11/13 13:51:05:726 EST] 0000000b SystemOut O INFO [RBPM] [com.sssw.portal.servlet.EboPortalBootServlet:init] Patch C
[12/11/13 13:51:05:726 EST] 0000000b SystemOut O INFO [RBPM] [com.sssw.portal.servlet.EboPortalBootServlet:init] Driver Version 2.2
[12/11/13 13:51:05:727 EST] 0000000b SystemOut O INFO [RBPM] [com.sssw.portal.servlet.EboPortalBootServlet:init] Build Revision 39446