[xwiki-notifications] [Issue] Commented: (XWIKI-2009) Error occurs during Oracle database initialization

marek knaze (JIRA) jira at xwiki.org
Tue Jan 15 16:51:40 CET 2008 

    [ http://jira.xwiki.org/jira/browse/XWIKI-2009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_21340 ] 

marek knaze commented on XWIKI-2009:
------------------------------------

The same as the last time:
I am using hibernate 3.2.5ga
ORA-01400: cannot insert NULL into ("XWIKI"."XWIKILARGESTRINGS"."XWL_ID")


16:45:36,588 [http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki] [http-8080-Processor24] ERROR util.JDBCExceptionReporter      - ORA-01400: cannot insert NULL into ("XWIKI"."XWIKILARGESTRINGS"."XWL_ID")
 
16:45:36,588 [http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki] [http-8080-Processor24] ERROR .AbstractFlushingEventListener  - Could not synchronize database state with session 
org.hibernate.exception.ConstraintViolationException: could not insert: [com.xpn.xwiki.objects.LargeStringProperty]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
	at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:701)
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:675)
	at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:323)
	at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97)
	at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:91)
	at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1018)
	at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:991)
	at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:985)
	at com.xpn.xwiki.plugin.packaging.Package.installDocument(Package.java:588)
	at com.xpn.xwiki.plugin.packaging.Package.install(Package.java:525)
	at com.xpn.xwiki.plugin.packaging.PackageAPI.install(PackageAPI.java:197)
	at com.xpn.xwiki.web.ImportAction.render(ImportAction.java:89)
	at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:148)
	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.doPost(ActionServlet.java:432)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	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.coyote.http11.Http11Processor.process(Http11Processor.java:874)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
	at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into ("XWIKI"."XWIKILARGESTRINGS"."XWL_ID")

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2250)
	... 46 more
16:45:36,604 [http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki] [http-8080-Processor24] ERROR packaging.Package               - Failed to save document Stats.Skin 
16:45:37,338 [http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki] [http-8080-Processor24] WARN  util.JDBCExceptionReporter      - SQL Error: 1400, SQLState: 23000 
16:45:37,338 [http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki] [http-8080-Processor24] ERROR util.JDBCExceptionReporter      - ORA-01400: cannot insert NULL into ("XWIKI"."XWIKILARGESTRINGS"."XWL_ID")
 
16:45:37,338 [http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki] [http-8080-Processor24] ERROR .AbstractFlushingEventListener  - Could not synchronize database state with session 
org.hibernate.exception.ConstraintViolationException: could not insert: [com.xpn.xwiki.objects.LargeStringProperty]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
	at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:701)
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:675)
	at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:323)
	at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97)
	at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:91)
	at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1018)
	at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:991)
	at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:985)
	at com.xpn.xwiki.plugin.packaging.Package.installDocument(Package.java:588)
	at com.xpn.xwiki.plugin.packaging.Package.install(Package.java:525)
	at com.xpn.xwiki.plugin.packaging.PackageAPI.install(PackageAPI.java:197)
	at com.xpn.xwiki.web.ImportAction.render(ImportAction.java:89)
	at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:148)
	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.doPost(ActionServlet.java:432)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	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.coyote.http11.Http11Processor.process(Http11Processor.java:874)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
	at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into ("XWIKI"."XWIKILARGESTRINGS"."XWL_ID")

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2250)
	... 46 more
16:45:37,338 [http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki] [http-8080-Processor24] ERROR packaging.Package               - Failed to save document XWiki.SchedulerJobTemplate 
16:45:37,807 [http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki] [http-8080-Processor24] ERROR log.SimpleLog4JLogSystem        - Left side ($request.withversions) of '==' operation has null value. If a reference, it may not be in the context. Operation not possible.  [line 16, column 73] 
16:49:34,055 [http://localhost:8080/xwiki/bin/view/XWiki/Admin] [http-8080-Processor23] WARN  filter.MacroFilter              - MacroFilter: unable to format macro: rss 


> Error occurs during Oracle database initialization
> --------------------------------------------------
>
>                 Key: XWIKI-2009
>                 URL: http://jira.xwiki.org/jira/browse/XWIKI-2009
>             Project: XWiki Platform
>          Issue Type: Bug
>          Components: Storage
>    Affects Versions: 1.2 RC3
>         Environment: Xwiki: xwiki-enterprise-web-1.2-rc-3.war
> DB: Oracle Express 10g
> JDBC driver: Oracle JDBC Driver version - "10.2.0.1.0XE"
> OS: Windows XP
>            Reporter: marek knaze
>         Assigned To: Vincent Massol
>            Priority: Critical
>         Attachments: xwiki.log
>
>
> Oracle error occurs during first time initialization. 
> Failed updating schema while executing query "create sequence xwiki.hibernate_sequence" 
> java.sql.SQLException: ORA-00955: name is already used by an existing object
> 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> 	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> 	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
> 	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
> 	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
> 	at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1615)
> 	at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1580)
> 	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:410)
> please, see attached log file for more details.
> Steps to reproduce:
> 1)create brand new db schema (xwiki)
> 2)copy xwiki-enterprise-web-1.2-rc-3.war into tomcat container
> 3)edit hibernate.cfg.xml (uncomment Oracle DB connection)
> 4)go to http://localhost:8080/xwiki web page
> 5) see xwiki.log file for more error details

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.xwiki.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

More information about the notifications mailing list