Re: [xwiki-users] "java.sql.BatchUpdateException: No value specified for parameter 4" during 0.9.840 to 1.x database update.

Robin Fernandes wrote:

Hi all,

I'm attempting to migrate a fairly large xwiki instance (5000+ docs, db image >1GB) from 0.9.840 to 1.x. The database schema update fails when I try to access a page for the first time. I get the same problem with both XWiki 1.1.2 and 1.2-rc1.

Full stacktraces from the log file are available here: http://pastebin.com/fbc7639b .

pastebin doesn't work right now... Try rafb: http://rafb.net/paste/

Below is a cut down version:

It would be good to also know the SQL command that fails. I think it is another field that has NOT NULL specified in the database, not XWD_ARCHIVE. See http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Logging to find out how to make the logs show queries. Sergiu