FW: Xwiki Enterprise / Oracle Install problem

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

From: Everitt, Glenn
Sent:   Tuesday, March 11, 2008 10:27 PM
To:     'devs@xwiki.org'
Subject:        Xwiki Enterprise / Oracle Install problem

You have been a big help as I learn how to configure and set up this great product and I hope you can help again. I couldn't find anything in jira that matched this problem or the release notes.

I have installed the xwiki-enterprise-web-1.3.war successfully install on one system using "Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production"

However when I install it on another Redhat 3 system with Tomcat 5.5 / "Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production" I have a problem during database intialization (see xwiki.log snippet below).

The "Failed to load the xwiki.cfg" message - I believe to be an incorrrect message. However, the messages/exceptions further down seem to be a real problem I think this is the important lines:

2008-03-11 14:21:16,557 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] ERROR store.XWikiHibernateBaseStore - Failed updating schema while executing query "update xwikidoc set xwd_translation=0 where xwd_translation is null"

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

This statement looks like it failed to do the update because the table name isn't qualified with the schema name at least that is my guess. I don't know why it doesn't have the schema name. Any help here would be very very appreciated…..

I would also like to know if there is a way to install to a schema named something other than "xwiki". I would to create another schema for xwiki enterprise on the same DBMS at least until I figure out how to use virtual wikis.

Thanks for any help…and Thanks for a great product.

Xwiki.log - sorry this is big

2008-03-11 14:21:10,416 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG xwiki.XWiki - Failed to load the file [/WEB-INF/xwiki.cfg] as a resource using the Servlet Context. Trying to load it as classpath resource...

2008-03-11 14:21:10,418 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG xwiki.XWiki - Failed to load the file [/WEB-INF/xwiki.cfg] using any method.

2008-03-11 14:21:10,535 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Hibernate configuration file: [/WEB-INF/hibernate.cfg.xml]

2008-03-11 14:21:10,541 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO impl.OSCacheService - Initializing OSCacheService

2008-03-11 14:21:10,541 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO impl.OSCacheService - Loading cache properties: oscache.properties

2008-03-11 14:21:10,542 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO impl.OSCacheService - Properties loaded: oscache.properties

2008-03-11 14:21:10,542 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO impl.OSCacheService - Loading cache properties: oscache-local.properties

2008-03-11 14:21:10,542 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO impl.OSCacheService - Properties loaded: oscache-local.properties

2008-03-11 14:21:10,543 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO impl.OSCacheService - Initialized OSCacheService

2008-03-11 14:21:10,560 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO impl.OSCacheService - Created Cache # 1 of size 100 at Tue, 11 Mar 2008 14:21:10 +0000, current count is 1

2008-03-11 14:21:10,560 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO impl.OSCacheService - Created Cache # 2 of size 10000 at Tue, 11 Mar 2008 14:21:10 +0000, current count is 2

2008-03-11 14:21:10,564 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Hibernate configuration file: [/WEB-INF/hibernate.cfg.xml]

2008-03-11 14:21:10,568 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Hibernate configuration file: [/WEB-INF/hibernate.cfg.xml]

2008-03-11 14:21:10,569 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Hibernate configuration file: [/WEB-INF/hibernate.cfg.xml]

2008-03-11 14:21:10,569 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO xwiki.XWiki - Running storage migrations

2008-03-11 14:21:10,762 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [OSCacheService Cache Monitor] INFO impl.OSCacheService - OSCacheCache item count for Cache # 1 = 0 capacity is 100

2008-03-11 14:21:11,243 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.DBCPConnectionProvider - Configure DBCPConnectionProvider

2008-03-11 14:21:11,244 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.DBCPConnectionProvider - Creating a DBCP BasicDataSource with the following DBCP factory properties:

2008-03-11 14:21:11,244 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.DBCPConnectionProvider - -- listing properties --

whenExhaustedAction=1
url=jdbc:oracle:thin:@portaldb.covisint.c...
ps.maxActive=20
maxIdle=5
maxOpenPreparedStatements=20
maxActive=50
driverClassName=oracle.jdbc.driver.OracleDriver
maxWait=30000
username=p8xwiki
poolPreparedStatements=true
connectionProperties=user=XXXXXX;password=XXXXXX;SetBigS...
defaultAutoCommit=false
ps.maxIdle=20
ps.maxWait=120000
password=p8xwiki
ps.whenExhaustedAction=1

2008-03-11 14:21:11,768 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO store.DBCPConnectionProvider - active: 0 (max: 50) idle: 1(max: 5)

2008-03-11 14:21:11,768 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.DBCPConnectionProvider - Configure DBCPConnectionProvider complete

2008-03-11 14:21:11,769 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO store.DBCPConnectionProvider - active: 1 (max: 50) idle: 0(max: 5)

2008-03-11 14:21:11,773 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO store.DBCPConnectionProvider - active: 0 (max: 50) idle: 1(max: 5)

2008-03-11 14:21:13,163 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO store.XWikiHibernateBaseStore - Updating schema update for wiki xwiki ...

2008-03-11 14:21:13,164 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Trying to get session from pool

2008-03-11 14:21:13,192 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Taken session from pool SessionImpl(PersistenceContext[entityKeys=[],collectionKeys=[]];ActionQueue[insertions=[] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]])

2008-03-11 14:21:13,205 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO store.DBCPConnectionProvider - active: 1 (max: 50) idle: 0(max: 5)

2008-03-11 14:21:13,205 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Trying to open transaction

2008-03-11 14:21:13,207 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Opened transaction org.hibernate.transaction.JDBCTransaction@19d9c0d

2008-03-11 14:21:13,859 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Releasing hibernate session SessionImpl(PersistenceContext[entityKeys=[],collectionKeys=[]];ActionQueue[insertions=[] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]])

.
.
.
.
. snip
.
.
.
.
.
.
Schema sql: alter table xwiki.xwikistringclasses add constraint FK300D1FCD99E425B2 foreign key (XWS_ID, XWS_NAME) references xwiki.xwikiclassesprop

2008-03-11 14:21:16,531 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Update Schema sql: alter table xwiki.xwikistrings add constraint FK2780715A3433FD87 foreign key (XWS_ID, XWS_NAME) references xwiki.xwikiproperties

2008-03-11 14:21:16,540 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Update Schema sql: create sequence xwiki.hibernate_sequence

2008-03-11 14:21:16,551 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Update Schema sql: update xwikidoc set xwd_translation=0 where xwd_translation is null

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

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
        at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)
        at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)
        at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:891)
        at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
        at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:453)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:310)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:258)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:519)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1027)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1066)
        at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:62)

at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.<init>(AbstractXWikiMigrationManager.java:68)
at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.<init>(XWikiHibernateMigrationManager.java:49)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at com.xpn.xwiki.XWiki.createClassFromConfig(XWiki.java:827)
        at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:770)
        at com.xpn.xwiki.XWiki.<init>(XWiki.java:721)
        at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:292)
        at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:490)
        at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:118)
        at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
        at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
        at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
        at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
        at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
        at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Thread.java:595)
2008-03-11 14:21:16,565 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore   - Releasing hibernate session SessionImpl(PersistenceContext[entityKeys=[],collectionKeys=[]];ActionQueue[insertions=[] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]])

2008-03-11 14:21:16,565 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Releasing hibernate transaction org.hibernate.transaction.JDBCTransaction@8a6fc

2008-03-11 14:21:16,567 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO store.DBCPConnectionProvider - active: 0 (max: 50) idle: 1(max: 5)

2008-03-11 14:21:16,567 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO store.XWikiHibernateBaseStore - Schema update for wiki xwiki done

2008-03-11 14:21:16,567 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Trying to get session from pool

2008-03-11 14:21:16,567 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Taken session from pool SessionImpl(PersistenceContext[entityKeys=[],collectionKeys=[]];ActionQueue[insertions=[] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]])

2008-03-11 14:21:16,568 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO store.DBCPConnectionProvider - active: 1 (max: 50) idle: 0(max: 5)

2008-03-11 14:21:16,568 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Trying to open transaction

2008-03-11 14:21:16,568 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Opened transaction org.hibernate.transaction.JDBCTransaction@e4d0cd

2008-03-11 14:21:16,593 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] WARN util.JDBCExceptionReporter - SQL Error: 942, SQLState: 42000

2008-03-11 14:21:16,593 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] ERROR util.JDBCExceptionReporter - ORA-00942: table or view does not exist

2008-03-11 14:21:16,594 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] DEBUG store.XWikiHibernateBaseStore - Releasing hibernate session SessionImpl(PersistenceContext[entityKeys=[],collectionKeys=[]];ActionQueue[insertions=[] updates=[] deletions=[] collectionCreations=[] collectionRemovals=[] collectionUpdates=[]])

2008-03-11 14:21:16,595 [http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome] [TP-Processor3] INFO store.DBCPConnectionProvider - active: 0 (max: 50) idle: 1(max: 5)

2008-03-11 14:21:16,604 [] [TP-Processor3] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException

2008-03-11 14:21:16,604 [] [TP-Processor3] ERROR [/xwiki].[action] - Servlet.service() for servlet action threw exception

com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context
Wrapped Exception: Error number 3001 in 3: Cannot load class com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param xwiki.store.migration.manager.class

Wrapped Exception: Error number 0 in 3: Exception while hibernate execute
Wrapped Exception: could not execute query
        at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:302)
        at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:490)
        at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:118)
        at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)