[#XWIKI-2009] Error occurs during Oracle database initialization

XWiki Core

Error occurs during Oracle database initialization

Created: 15/Jan/08 13:14 Updated: 30/Jan/08 10:00

Component/s:

Storage

Affects Version/s:

1.2 RC3

Fix Version/s:

1.3 M1

File Attachments:

xwiki.log (22 kB)

Environment:

« Hide

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

Issue Links:

Related

This issue relates to:

~~XWIKI-2010~~ Unable to import the default set of XWiki pages (xwiki-enterprise-wiki-1.2-rc-3.xar) without errors

~~XTCONFRES-2~~ Upgrade Oracle Hibernate Dialect since the current one is now deprecated with Hibernate 3.2.5

keywords:	oracle, hibernate_sequence
Date of First Response:	15/Jan/08 13:28
Resolution Date:	16/Jan/08 13:35

Description

« Hide

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

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

All

Comments

Change History

FishEye

Sort Order:

[ Permlink | « Hide ]

marek knaze added a comment - 15/Jan/08 13:15

complete log file

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 13:28

Hi Marek,

1) Please don't put assignee to issues...
2) This is the same as what is reported in ~~XWIKI-1993~~
3) ~~XWIKI-1993~~ says it's not a serious issue and points to ~~XWIKI-1937~~. However ~~XWIKI-1937~~ appears when you import documents over existing ones so I wonder if it's really the same issue

Could you please verify that the documents that generate this error are correctly imported (by navigating to the pages).

Thanks
-Vincent

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 13:38

Why are you changing the component I set?

[ Permlink | « Hide ]

marek knaze added a comment - 15/Jan/08 13:44

I apologise for that.
I thought, the componet was set by me during issue cratetion.
I really sorry.

[ Permlink | « Hide ]

marek knaze added a comment - 15/Jan/08 13:56

Vincent, you wrote in your comments in the issue http://jira.xwiki.org/jira/browse/XWIKI-1993 that is should be fixed in version XE 1.2RC3, but this error still occurs in this version.

This error occurs after the first request into the clean wiki so there are no imported documents in this time.
So I think, this issue is not caused by documents import.

I am correct?

thank you for help
marek

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 14:04

Issue ~~XWIKI-1993~~ had several issues into one. We fixed the important ones and referred to ~~XWIKI-1937~~ for the other remaining issue (the one you're mentioning).

Now yes you're right this doesn't seem to be the same as ~~XWIKI-1937~~ since this is a first import.

Could you please answer the question I asked above which I'm repeating here:

"Could you please verify that the documents that generate this error are correctly imported (by navigating to the pages)."

Thanks

[ Permlink | « Hide ]

marek knaze added a comment - 15/Jan/08 15:03

Vincent, I do not know, which documents(pages) do you mean.
This error occurs in the clean wiki without any imports. I just created new db schema (xwiki) and then I deployed xwiki into tomcat container.
that all, what I did. After this, I clicked on http://localhost:8080/xwiki and then error occured.

Is this comment useful for you?
If you need more info, please let me know.

thanks

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 15:10

Marek,

I need to know if the errors you got are important or not. If all is working then they are not important. You mentioned several errors when importing some documents. You even listed them. Could you please navigate to those documents and see if they have been imported even though errors were reported?

Thanks
-Vincent

[ Permlink | « Hide ]

marek knaze added a comment - 15/Jan/08 15:19

OK Vincent, here is me report:

Stats.Skin - The requested document could not be found
XWiki.Admin - The requested document could not be found
XWiki.DefaultSkin - The requested document could not be found
XWiki.PhotoAlbumClassTemplate - The requested document could not be found
XWiki.SchedulerJobTemplate - The requested document could not be found
XWiki.WebPreferences - The requested document could not be found
XWiki.XWikiAdminGroup - The requested document could not be found

As you can see these documents were not imported and I think, these errors are important.

Are there any other task which I should to do to help you with this bug?

marek

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 15:31

Ok I was able to get Oracle to run on my Mac.

Indeed even with an empty database, there are errors. Here's what I did:

empty database
run XE
stop XE
run XE again and try going to http://localhost:8080/xwiki/bin/view/Main/

Thus one pb is in the update schema script. There might also be a similar pb in the import.

15:26:47.385 INFO   [main] org.mortbay.util.Container.start(Container.java:74) >09> Started org.mortbay.jetty.Server@2c4768

15:27:00,399 [http://localhost:8080/xwiki/bin/view/Main/] [P1-19] ERROR store.XWikiHibernateBaseStore   - 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:745)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
        at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1623)
        at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1588)
        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)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:271)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:225)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:470)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:914)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:947)
        at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:60)
        at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:140)
        at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102)
        at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:721)
        at com.xpn.xwiki.XWiki.<init>(XWiki.java:672)
        at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
        at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:439)
        at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94)
        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:596)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
        at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
        at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
        at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
        at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
        at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
        at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
        at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
        at org.mortbay.http.HttpServer.service(HttpServer.java:954)
        at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
        at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
        at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
        at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
        at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
        at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
15:27:00,589 [http://localhost:8080/xwiki/bin/view/Main/] [P1-19] INFO  .AbstractXWikiMigrationManager  - No storage migration required since current version is [6431] 
15:27:05,669 [http://localhost:8080/xwiki/bin/view/Main/] [P1-19] ERROR store.XWikiHibernateBaseStore   - 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:745)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
        at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1623)
        at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1588)
        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)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:271)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:225)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:470)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:914)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:947)
        at com.xpn.xwiki.store.XWikiHibernateVersioningStore.loadAllRCSNodeInfo(XWikiHibernateVersioningStore.java:208)
        at com.xpn.xwiki.store.XWikiHibernateVersioningStore.loadXWikiDocArchive(XWikiHibernateVersioningStore.java:125)
        at com.xpn.xwiki.store.XWikiHibernateVersioningStore.getXWikiDocumentArchive(XWikiHibernateVersioningStore.java:110)
        at com.xpn.xwiki.store.XWikiHibernateVersioningStore.updateXWikiDocArchive(XWikiHibernateVersioningStore.java:197)
        at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:254)
        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.scheduler.SchedulerPlugin.prepareJobStubContext(SchedulerPlugin.java:156)
        at com.xpn.xwiki.plugin.scheduler.SchedulerPlugin.scheduleJob(SchedulerPlugin.java:280)
        at com.xpn.xwiki.plugin.scheduler.SchedulerPlugin.restoreExistingJobs(SchedulerPlugin.java:229)
        at com.xpn.xwiki.plugin.scheduler.SchedulerPlugin.init(SchedulerPlugin.java:94)
        at com.xpn.xwiki.plugin.scheduler.SchedulerPlugin.<init>(SchedulerPlugin.java:78)
        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.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:65)
        at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:95)
        at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:799)
        at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:732)
        at com.xpn.xwiki.XWiki.<init>(XWiki.java:672)
        at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:241)
        at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:439)
        at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:94)
        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:596)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
        at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
        at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
        at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
        at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
        at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
        at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
        at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
        at org.mortbay.http.HttpServer.service(HttpServer.java:954)
        at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
        at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
        at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
        at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
        at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
        at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)



15:27:23,820 [http://localhost:8080/xwiki/bin/view/Main/] [P1-19] ERROR store.XWikiHibernateBaseStore   - 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:745)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
        at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1623)
        at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1588)
        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)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:271)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:225)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:470)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:914)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:947)
        at com.xpn.xwiki.store.XWikiHibernateRecycleBinStore.getAllDeletedDocuments(XWikiHibernateRecycleBinStore.java:99)
        at com.xpn.xwiki.XWiki.getDeletedDocuments(XWiki.java:1139)
        at com.xpn.xwiki.api.XWiki.getDeletedDocuments(XWiki.java:131)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:295)
        at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245)
        at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203)
        at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:419)
        at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:73)
        at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:125)
        at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318)
        at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:238)
        at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:152)
        at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1366)
        at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1327)
        at com.xpn.xwiki.api.XWiki.parseTemplate(XWiki.java:607)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:295)
        at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:245)
        at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:203)
        at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:294)
        at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318)
        at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:194)
        at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:170)
        at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:74)
        at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318)
        at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:107)
        at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:318)
        at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:238)
        at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:152)
        at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1366)
        at com.xpn.xwiki.XWiki.parseTemplate(XWiki.java:1327)
        at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:105)
        at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:48)
        at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:155)
        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:596)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
        at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
        at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
        at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
        at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
        at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
        at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
        at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
        at org.mortbay.http.HttpServer.service(HttpServer.java:954)
        at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
        at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
        at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
        at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
        at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
        at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 15:33

forgot to mention that I did this on the 1.2 branch

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 15:34

Seems like this is related to http://opensource.atlassian.com/projects/hibernate/browse/HHH-1651 which is fixed in Hibernate 3.2.1.

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 15:42

Replacing WEB-INF/lib/hibernate-3.1.3jar by http://repo1.maven.org/maven2/org/hibernate/hibernate/3.2.5.ga/hibernate-3.2.5.ga.jar removes the error.

I'll now try importing the XAR.

[ Permlink | « Hide ]

marek knaze added a comment - 15/Jan/08 15:45

Vincent, thanks for help. I tried xwiki with the last hibernate release 3.2.5.GA ant the error you mentioned above (ERROR store.XWikiHibernateBaseStore - Failed updating schema while executing query "create sequence xwiki.hibernate_sequence"
java.sql.SQLException: ORA-00955: name is already used by an existing object ) did not occur.

But import failed again

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
15:41:54,678 http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki [http-8080-Processor23] ERROR packaging.Package - Failed to save document XWiki.SchedulerJobTemplate
15:41:54,772 http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki [http-8080-Processor23] WARN util.JDBCExceptionReporter - SQL Error: 1400, SQLState: 23000
15:41:54,772 http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki [http-8080-Processor23] ERROR util.JDBCExceptionReporter - ORA-01400: cannot insert NULL into ("XWIKI"."XWIKILARGESTRINGS"."XWL_ID")

15:41:54,772 http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki [http-8080-Processor23] 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:619)
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
15:41:54,772 http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki [http-8080-Processor23] ERROR packaging.Package - Failed to save document XWiki.WebPreferences
15:41:54,834 http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki [http-8080-Processor23] WARN util.JDBCExceptionReporter - SQL Error: 1400, SQLState: 23000
15:41:54,834 http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki [http-8080-Processor23] ERROR util.JDBCExceptionReporter - ORA-01400: cannot insert NULL into ("XWIKI"."XWIKILARGESTRINGS"."XWL_ID")

15:41:54,834 http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki [http-8080-Processor23] 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:619)
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
15:41:54,834 http://localhost:8080/xwiki/bin/import/XWiki/Import?editor=import&space=XWiki [http-8080-Processor23] ERROR packaging.Package - Failed to save document XWiki.XWikiAdminGroup

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 15:45

Indeed, importing works perfectly well so at least we have a workaround for Oracle.

Now we need to be sure that all the other DBs work fine with Hibernate 3.2.5ga...

We need to decide whether to upgrade to it now or postpone that to 1.3 and instead document the Oracle workaround for 1.2 in the release notes...

[ Permlink | « Hide ]

marek knaze added a comment - 15/Jan/08 15:51

Vincent, I think you are not right. As you can see in my last comment, imports failed again. Does your imports finished successfully?

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 16:05

As I said above, yes it worked without any error at all.

I even tried reimporting twice and all was fine. The second import does indeed show the problem reported in XWIKIK-1937.

In your case you seem to have a different config somehow. Could you try with this WAR instead:
http://maven.xwiki.org/snapshots/com/xpn/xwiki/products/xwiki-enterprise-web/1.2-SNAPSHOT/xwiki-enterprise-web-1.2-20080115.125833-28.war

I've used version 10.2.0.3 of the oracle client driver and my oracle DB is Oracle Database 10g Express Edition Release 10.2.0.1.0

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 16:06

one question: What XAR are you importing?

[ Permlink | « Hide ]

marek knaze added a comment - 15/Jan/08 16:18

I am importing xwiki-enterprise-wiki-1.2-rc-3.xar file, downloaded from the wiki download page and I am using xwiki-enterprise-web-1.2-rc-3.war also downloaded form the wiki download page.

Now I will try the build you mentioned in your last comment.
marek

[ Permlink | « Hide ]

marek knaze added a comment - 15/Jan/08 16:23

Vincent, I tried the WAR you provided on location http://maven.xwiki.org/snapshots/com/xpn/xwiki/products/xwiki-enterprise-web/1.2-SNAPSHOT/xwiki-enterprise-web-1.2-20080115.125833-28.war but import fails again

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 16:31

This is really strange since we are doing exactly the same thing.

Only difference is with the version of the jdbc driver and mayb with the Oracle version.

Are you removing everything from your DB before trying? Make sure you start with a clean DB just in case this has some impact.

[ Permlink | « Hide ]

marek knaze added a comment - 15/Jan/08 16:33

I am sure, my DB is clean.
Before every deploy I run this DB script:

drop user xwiki cascade;
create user xwiki identified by xwiki;
grant connect to xwiki;
grant resource to xwiki;

just one note: I am using jdk1.6.0_03, do you think this is the issue?

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 16:37

hmmm the error doesn't look related to the JDK but yes I would try with JDK 1.5

BTW I even thought XWiki was not working with 1.6...

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 16:38

Just found this: http://jira.xwiki.org/jira/browse/XWIKI-798
so apparently xwiki runs on 1.6.

If you can test easily it might good to try using 1.5 though. This is what I'm running.

[ Permlink | « Hide ]

marek knaze added a comment - 15/Jan/08 16:47

Vincent, I tried XWiki with jdk150_04 and import fails again, but only for 2 documents

Stats.Skin
XWiki.SchedulerJobTemplate

what do you think about it?

do you have any ideas?

thank for help
marek

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 16:48

What are the errors this time?

[ Permlink | « Hide ]

marek knaze added a comment - 15/Jan/08 16:51

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

[ Permlink | « Hide ]

Vincent Massol added a comment - 15/Jan/08 16:58

Have the 2 documents you mention been created?

Stats.Skin
XWiki.SchedulerJobTemplate

Can you navigate to them?

[ Permlink | « Hide ]

marek knaze added a comment - 15/Jan/08 20:14

Vincent,
I tried to import these 2 documents again and I import Stats.Skin document successfully, but XWiki.SchedulerJobTemplate failed again. So I tried to import just this one (XWiki.SchedulerJobTemplate) document again and (I do not know why) import finished successfully. So, in this time, all documents from xwiki-enterprise-wiki-1.2-rc-3.xar file were imported. I can navigate to the both Stats.Skin
and XWiki.SchedulerJobTemplate documents.

I think it is pretty strange, but it works
Vincent, thank you for your time and help. If you need my co-operation again, please let me know.
Have a nice evening.

[ Permlink | « Hide ]

Vincent Massol added a comment - 16/Jan/08 13:35

Fixed by upgrading to Hibernate 3.2.5ga.

Since this is a potentially breaking change it's has been committed for Core 1.3 only and not in the 1.2 branch.

Thus 1.2 users should manually remove the current hibernate-3.1.3.jar file and replace it with this one: http://repo1.maven.org/maven2/org/hibernate/hibernate/3.2.5.ga/hibernate-3.2.5.ga.jar

Re the other issue Marek had regarding the insert NULL, I don't know what the problem is and I cannot reproduce it. I suggest to open a new issue if it happens again.