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(a)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:10,762
> [
http://coe.portal8.stg.covisint.com/xwiki/bin/view/Main/WebHome]
> [OSCacheService Cache Monitor] INFO impl.OSCacheService -
> OSCacheCache item count for Cache # 2 = 0 capacity is 10000
> 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=[]];Action
> Queue[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=[]];Action
> Queue[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
> 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
> 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.jav
> a:2191)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java
> :2064)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatemen
> t.java:2989)
> at
> oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:
> 891)
> at
> org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingSt
> atement.java:225)
> at
> org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingSt
> atement.java:225)
> at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernat
> eBaseStore.java:453)
> at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernat
> eBaseStore.java:310)
> at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernat
> eBaseStore.java:258)
> at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibern
> ateBaseStore.java:519)
> at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBase
> Store.java:1027)
> at
> com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernate
> BaseStore.java:1066)
> at
> com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager
> .getDBVersion(XWikiHibernateMigrationManager.java:62)
> at
> com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.<init>(Abs
> tractXWikiMigrationManager.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(NativeConstructo
> rAccessorImpl.java:39)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCo
> nstructorAccessorImpl.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(Request
> Processor.java:431)
> at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.jav
> a: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(Appli
> cationFilterChain.java:269)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
> lterChain.java:188)
> at
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEnco
> dingFilter.java:117)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appli
> cationFilterChain.java:215)
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
> lterChain.java:188)
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa
> lve.java:213)
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa
> lve.java:174)
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja
> va:127)
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja
> va:117)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValv
> e.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.jav
> a:703)
> at
> org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocke
> t.java:895)
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPo
> ol.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=[]];Action
> Queue[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=[]];Action
> Queue[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=[]];Action
> Queue[insertions=[] updates=[] deletions=[] collectionCreations=[]
> collectionRemovals=[] collectionUpdates=[]])
> 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 transaction org.hibernate.transaction.JDBCTransaction@e4d0cd
> 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(Request
> Processor.java:431)
>
Everitt, Glenn
Sergiu Dumitriu