One problem I had was the schema name I was using was "xwiki" however the user name I was using was "p8xwiki". I guess they need to be the same so that the default schema name can be determined from the user name. I am using an Oracle database so I didn't expect this requirement. I had also tried to use "p8xiki" as the schema name and the user name and add this entry <property name="default_schema">p8xwiki</property> into the hibernate.cfg.xml file to tell it to use a p8xwiki as the default schema but I didn't get this to work. I also had to use the newest jdbc driver I could find for Oracle in the ojdbc14.jar manifest file it lists: Specification-Version: Oracle JDBC Driver version - "10.2.0.4.0" and this version worked but this version didn't Specification-Version: "Oracle JDBC Driver version - 9.0.2.0.0" Glenn Everitt Everitt, Glenn wrote:

...

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: '[email protected]' 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)

_______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs

-- View this message in context: http://www.nabble.com/FW%3A-Xwiki-Enterprise---Oracle-Install-problem-tp1599... Sent from the XWiki- Dev mailing list archive at Nabble.com.