Re: [xwiki-users] Problem Migrating Database from XWiki Ent 3.5.1 to 4.1.3 for MSSQL

2012-08-10 Thread Denis Gervalle
I am adding this follow up, so anyone with an Microsoft SQL server database will get the final outcome of this issue. XWiki devs team does not officially support MS-SQL, however, with the great help provided by Rob, I have been able to add basic support of MS-SQL into the migration

Re: [xwiki-users] Problem Migrating Database from XWiki Ent 3.5.1 to 4.1.3 for MSSQL

2012-08-10 Thread Vincent Massol
That's great, thanks Denis and Rob to get this sorted out! :) -Vincent On Aug 10, 2012, at 12:30 PM, Denis Gervalle wrote: I am adding this follow up, so anyone with an Microsoft SQL server database will get the final outcome of this issue. XWiki devs team does not officially support

Re: [xwiki-users] Problem Migrating Database from XWiki Ent 3.5.1 to 4.1.3 for MSSQL

2012-08-03 Thread Denis Gervalle
Hi, You do not need to enable additional logging if you are using our default configuration. If currently you do not get an info logging saying Running storage schema updates and migrations at some point, and your database is declared Database XXX needs migration(s), it could not be safely used!,

Re: [xwiki-users] Problem Migrating Database from XWiki Ent 3.5.1 to 4.1.3 for MSSQL

2012-08-03 Thread rheim651
Okay, here is an Update: Using the xwiki.cfg file I posted to pastebin, I modified xwiki.store.migration=1 After restarting the server I am still getting the exact same error message in the browser. Looking at the DATABASECHANGELOG from inside the target database, the Liquibase executions get

Re: [xwiki-users] Problem Migrating Database from XWiki Ent 3.5.1 to 4.1.3 for MSSQL

2012-08-03 Thread Denis Gervalle
Hi, At least, you have progressed, you achieved the configuration so that the migration was tried, but has failed. Your diagnosis about what happened seems to me quite right. We drop only FK constraints, and we do not care about any PK constraints, since our supported databases are not affected

Re: [xwiki-users] Problem Migrating Database from XWiki Ent 3.5.1 to 4.1.3 for MSSQL

2012-08-02 Thread rheim651
Here are URLs for some (hopefully) relevant: http://pastebin.com/GiVs68L9 stdout Log http://pastebin.com/dXJqZyhh Catalina Output http://pastebin.com/U4VaVTQw Browser Stack Trace For some additional background, I tried creating an empty database and that appears to work fine with this exact

Re: [xwiki-users] Problem Migrating Database from XWiki Ent 3.5.1 to 4.1.3 for MSSQL

2012-08-02 Thread Denis Gervalle
Hi, I have written most of the migration manager stuffs and the major migration of 4.x, and from what I see, your configuration currently prevent any migrations to be executed. You should carefully investigate your xwiki.cfg file for migration configuration. From what you copy paste, I see twice

Re: [xwiki-users] Problem Migrating Database from XWiki Ent 3.5.1 to 4.1.3 for MSSQL

2012-08-02 Thread Caleb James DeLisle
Check line 142 # xwiki.store.migration=0 That should be uncommented and it should be xwiki.store.migration=1 Thanks, Caleb On 08/02/2012 04:17 PM, rheim651 wrote: Denis, I have reviewed my xwiki.cfg file and revised it according to what you requested ( http://pastebin.com/ACFyDT87 Xwiki

Re: [xwiki-users] Problem Migrating Database from XWiki Ent 3.5.1 to 4.1.3 for MSSQL

2012-07-28 Thread Caleb James DeLisle
Hi, The 4.x migration is large and has turned out to be particularly painful. We are evaluating how to improve it. Do you have any messages regarding the migration in your catalina.out log file? I suspect it is trying to do the migration but failing for some reason. If you can paste any relevant

[xwiki-users] Problem Migrating Database from XWiki Ent 3.5.1 to 4.1.3 for MSSQL

2012-07-27 Thread rheim651
I am attempting to clone an existing XWiki Enterprise 3.5.1 installation to test out how to upgrade to 4.1.3. When attempting to load the main page, I receive the following error: message com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped