Hey Bastian, you might be bitten by the same I was recently since you have this in the log:
com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while switching to database xwiki
Since a few versions, indeed, multi-hosting (aka wiki-farm) is activated by default, so that you can create a database per wiki. This means that the default database name is attempted instead of the one specified in the hibernate.cfg.xml. As Thomas suggested then (http://xwiki.475771.n2.nabble.com/database-name-using-the-standalone-jetty-t...):
You can change it in xwiki.cfg (property xwiki.db).xwiki You should uncomment and write PORTALHILFE there.
And... yes, XWiki will initialize the DB-schema if it finds it empty then offer you upload the default xar. Hope it helps. paul
ruschhauptb <mailto:[email protected]> 8 septembre 2015 10:50 Hello Paul,
thank you for your reply. At the end you find the complete error messages.
At the moment we have an empty database schema named PORTALHILFE. We expected XWIKI to create all tables on the first startup. Is this correct?
Here is our hibernate.cft.xml configuration. Our database schema is called PORTALHILFE, could this be a problem?
<property name="connection.url">jdbc:oracle:thin:@172.17.12.5:1521:etu1db12c</property> <property name="connection.username">PORTALHILFE</property> <property name="connection.password">PORTALHILFE</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property name="connection.SetBigStringTryClob">true</property> <property name="jdbc.batch_size">0</property> <property name="jdbc.use_streams_for_binary">false</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.oracle.hbm.xml"/> <mapping resource="feeds.oracle.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <mapping resource="instance.hbm.xml"/>
Do you know how we can increase the log level?
_________________________________________________________________________
{"level":"ERROR","thread":"XWiki initialization","logger":"org.hibernate.util.JDBCExceptionReporter","context":"etu1appqk01_plis-portalhilfe","zeitstempel":"2015-0904T08:40:47.939Z","nachricht":"ORA-01435: Benutzer ist nicht vorhanden.\n","korrelationsid":"none"} {"level":"ERROR","thread":"XWiki initialization","logger":"com.xpn.xwiki.doc.DefaultDocumentAccessBridge","context":"etu1appqk01_plis-portalhilfe","exception":"com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:AnnotationCode.AnnotationConfig]\n\tat com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:958)\n\tat com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291)\n\tat com.xpn.xwiki.XWiki.getDocument(XWiki.java:1299)\n\tat com.xpn.xwiki.XWiki.getDocument(XWiki.java:1347)\n\tat com.xpn.xwiki.doc.DefaultDocumentAccessBridge.getProperty(DefaultDocumentAccessBridge.java:385)\n\tat org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getPropertyObject(AbstractDocumentConfigurationSource.java:146)\n\tat org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getProperty(AbstractDocumentConfigurationSource.java:135)\n\tat org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getProperty(AbstractDocumentConfigurationSource.java:108)\n\tat org.xwiki.annotation.internal.DefaultAnnotationConfiguration.getAnnotationClassReference(DefaultAnnotationConfiguration.java:121)\n\tat org.xwiki.annotation.internal.AnnotationClassDocumentInitializer.getDocumentReference(AnnotationClassDocumentInitializer.java:67)\n\tat com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:769)\n\tat com.xpn.xwiki.XWiki.initXWiki(XWiki.java:733)\n\tat com.xpn.xwiki.XWiki.initXWiki(XWiki.java:654)\n\tat com.xpn.xwiki.XWiki.<init>(XWiki.java:643)\n\tat com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115)\n\tat org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209)\n\tat org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192)\n\tat java.lang.Thread.run(Thread.java:722)\nCaused by: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while switching to database xwiki\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:739)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:911)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:843)\n\tat com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:830)\n\t... 17 common frames omitted\nCaused by: org.hibernate.QueryTimeoutException: error executing work\n\tat org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124)\n\tat org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)\n\tat org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)\n\tat org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:2001)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.executeSQL(XWikiHibernateBaseStore.java:753)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:719)\n\t... 20 common frames omitted\nCaused by: java.sql.SQLException: ORA-01435: Benutzer ist nicht vorhanden.\n\n\tat oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)\n\tat oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)\n\tat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)\n\tat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)\n\tat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)\n\tat oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)\n\tat oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)\n\tat oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)\n\tat oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)\n\tat oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)\n\tat oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)\n\tat oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)\n\tat org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore$1.execute(XWikiHibernateBaseStore.java:760)\n\tat org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997)\n\t... 22 common frames omitted\n","zeitstempel":"2015-0904T08:40:48.000Z","nachricht":"Failed to get property","korrelationsid":"none"} {"level":"ERROR","thread":"XWiki initialization","logger":"org.hibernate.util.JDBCExceptionReporter","context":"etu1appqk01_plis-portalhilfe","zeitstempel":"2015-0904T08:40:48.004Z","nachricht":"ORA-01435: Benutzer ist nicht vorhanden.\n","korrelationsid":"none"} {"level":"ERROR","thread":"XWiki initialization","logger":"com.xpn.xwiki.internal.XWikiInitializerJob","context":"etu2appqk01_plis-portalhilfe","exception":"com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.XWikiComments]\n\tat com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:958)\n\tat com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291)\n\tat com.xpn.xwiki.XWiki.getDocument(XWiki.java:1299)\n\tat com.xpn.xwiki.XWiki.getDocument(XWiki.java:1347)\n\tat com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:773)\n\tat com.xpn.xwiki.XWiki.initXWiki(XWiki.java:733)\n\tat com.xpn.xwiki.XWiki.initXWiki(XWiki.java:654)\n\tat com.xpn.xwiki.XWiki.<init>(XWiki.java:643)\n\tat com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115)\n\tat org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209)\n\tat org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192)\n\tat java.lang.Thread.run(Thread.java:722)\nCaused by: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while switching to database xwiki\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:739)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:911)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:843)\n\tat com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:830)\n\t... 11 common frames omitted\nCaused by: org.hibernate.QueryTimeoutException: error executing work\n\tat org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124)\n\tat org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)\n\tat org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)\n\tat org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:2001)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.executeSQL(XWikiHibernateBaseStore.java:753)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:719)\n\t... 14 common frames omitted\nCaused by: java.sql.SQLException: ORA-01435: Benutzer ist nicht vorhanden.\n\n\tat oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)\n\tat oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)\n\tat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)\n\tat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)\n\tat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)\n\tat oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)\n\tat oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)\n\tat oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)\n\tat oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)\n\tat oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)\n\tat oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)\n\tat oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)\n\tat org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore$1.execute(XWikiHibernateBaseStore.java:760)\n\tat org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997)\n\t... 16 common frames omitted\n","zeitstempel":"2015-0904T08:40:48.005Z","nachricht":"Exception thrown during job execution","korrelationsid":"none","marker":["xwiki.translation"]}
{"level":"ERROR","thread":"XWiki initialization","logger":"com.xpn.xwiki.internal.XWikiInitializerJob","context":"etu2appqk01_plis-portalhilfe","exception":"com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.XWikiComments]\n\tat com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:958)\n\tat com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:291)\n\tat com.xpn.xwiki.XWiki.getDocument(XWiki.java:1299)\n\tat com.xpn.xwiki.XWiki.getDocument(XWiki.java:1347)\n\tat com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:773)\n\tat com.xpn.xwiki.XWiki.initXWiki(XWiki.java:733)\n\tat com.xpn.xwiki.XWiki.initXWiki(XWiki.java:654)\n\tat com.xpn.xwiki.XWiki.<init>(XWiki.java:643)\n\tat com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:115)\n\tat org.xwiki.job.internal.AbstractJob.runInContext(AbstractJob.java:209)\n\tat org.xwiki.job.internal.AbstractJob.run(AbstractJob.java:192)\n\tat java.lang.Thread.run(Thread.java:722)\nCaused by: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while switching to database xwiki\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:739)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:911)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:843)\n\tat com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:830)\n\t... 11 common frames omitted\nCaused by: org.hibernate.QueryTimeoutException: error executing work\n\tat org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:124)\n\tat org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)\n\tat org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)\n\tat org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:2001)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.executeSQL(XWikiHibernateBaseStore.java:753)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:719)\n\t... 14 common frames omitted\nCaused by: java.sql.SQLException: ORA-01435: Benutzer ist nicht vorhanden.\n\n\tat oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)\n\tat oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)\n\tat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)\n\tat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)\n\tat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)\n\tat oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)\n\tat oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)\n\tat oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)\n\tat oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)\n\tat oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)\n\tat oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)\n\tat oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)\n\tat org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)\n\tat com.xpn.xwiki.store.XWikiHibernateBaseStore$1.execute(XWikiHibernateBaseStore.java:760)\n\tat org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997)\n\t... 16 common frames omitted\n","zeitstempel":"2015-0904T08:40:48.005Z","nachricht":"Exception thrown during job execution","korrelationsid":"none","marker":["xwiki.translation"]}