28 Jun
2016
28 Jun
'16
2:22 p.m.
Oh, this looks odd.
The upgrade process first tried to find the name for the primary key; that is the
statement:
select @pkname=i.name from sysindexes i join sysobjects o ON i.id = o.id join sysobjects
pk ON i.name = pk.name AND pk.parent_obj = i.id AND pk.xtype = 'PK' join
sysindexkeys ik on i.id = ik.id AND i.indid = ik.indid join syscolumns c ON ik.id = c.id
AND ik.colid = c.colid where o.name = 'xwikidates'
it then gets a result "PK__xwikidates__6FD49106"
but when it tries to drop this constrain via:
'alter table [dbo].[xwikidates] drop constraint ' + @pkname
it fails with 'PK__xwikidates__6FD49106' is not a constraint. Huh?
Can you try to run that longish SQL Query from an SQL-console or the like, just to see if
that returns the same result?
To proceed the update, maybe it helps to drop the constraint for the primary key of the
'xwikidates' table manually and see what the next error is, probably there are
more PK-constraints with that problem.
(I hope you have backups, otherwise this is very bad advice ;) )
Clemens
First of all thank you for your answer, Clemens.
There a different exceptions in the log-file for executing sql-statements.
Please see http://pastebin.com/BFABwpNz.
All the errors are in relation to the xwikidates table.
Do you have any idea how to fix this?
Thanks again and best regards
Josef
Clemens Klein-Robbenhaar wrote
> It seems a DB migration failed; you can find the error in the log file
> after startup, above of the messages you posted.
>
> It is likely that it is the statistics migration
>
> You can try the SQL statements from here:
> http://jira.xwiki.org/browse/XWIKI-8129
>
> as found in the release notes of 4.3:
>
> http://www.xwiki.org/xwiki/bin/view/ReleaseNotes/ReleaseNotesXWiki43#HGener…
>
> If it is not the statistics, please locate the error from the failed
> migration
> (should be somewhere after the line: "Checking Hibernate mapping and
> updating schema if needed for wiki [xwiki]" )
>
> HTH
> Clemens
>
>
> ----- Ursprüngliche Nachricht -----
> Von: Jhaimerl
> Am: Tuesday, 28.06.2016, 09:59
> An: Xwiki Users
> Betreff: [xwiki-users] Can't Upgrade from XWiki 3.5.1
>
>
>> Hi,
>>
>> I'm trying to upgrade an existing XWiki Instance (V3.5.1). It's running
>> with
>> a MSSQL database.
>>
>> I already tried the following (see referenced links below) and upgrades
>> to
>> different higher versions of XWiki e.g. 4.x, 5.4.x. However I always get
>> this exception http://pastebin.com/yeaFQAtt.
>>
>>
http://xwiki.475771.n2.nabble.com/Another-migration-problem-3-5-to-4-1-3-td…
>> http://lists.xwiki.org/pipermail/users/2012-August/023537.html
>>
http://xwiki.475771.n2.nabble.com/Failed-migration-from-3-0-to-4-3-1-td7583…
>>
>> Does somebody have any hints how to solve this?
>>
>> Many thanks in advance!
>>
>>
>>
>>