Hi Clemens, tried your advice and checked the installation folder for duplicate jar-files. Couldn't find any. I also used jwhich.jar for that purpose without any results. Also I repeated the whole process with different versions of XWiki (4.0, 4.2).
Still I'm faced by the checksum errors you already mentioned around line 310. Any ideas or hints whatelse I could try? Many thanks and best regards Josef Clemens Klein-Robbenhaar wrote > Hi Josef, > > there are a lot of messages saying that one component wants to overwrite > another component with the same name, class and priority. > > This usually happens if two XWiki version are unpacked on top of each > other, so the WEB-INF/lib contains the *.jar for both versions. > This might cause a lot of other problems, too > > Can you please check if you have some "duplicate" jars in your WEB-INF/lib > directory e.g. both a xwiki-platform-component-script-4.2.jar and a > xwiki-platform-component-script-7.4.jar or the like? > > The actual problem then is around line 310 (next DB upgrade issue) - if > there are duplicate jars, hopefully this can be sorted out by repairing > the installation. > Otherwise we have to think about it again what might fix the issue this > time. > > hope this helps > Clemens > > > Jhaimerl wrote on Monday, 04.07.2016, 16:16 >> Hi Clemens, >> >> first of thanks again. I followed your advice and executed the longish >> sql >> statement - didn't work. >> I then removed the relationships between tables and changed the datatype >> of >> the id columns to BIGINT manually by following the exceptions in the log. >> >> So I finally got through that part of the migration. Now I'm stuck with a >> new type of error, please see line 162 here http://pastebin.com/YLzwvxmh. >> >> Has somebody ever seen this? >> >> Thank you and best regards >> Josef >> >> >> Clemens Klein-Robbenhaar wrote >>> 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#HGeneralNotes >>>>> >>>>> 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-td7580726.html#a7580809 >>>>>> 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-td7583304.html >>>>>> >>>>>> Does somebody have any hints how to solve this? >>>>>> >>>>>> Many thanks in advance! >>>>>> >>>>>> >>>>>> >>>>>> > > _______________________________________________ > users mailing list > users@ > http://lists.xwiki.org/mailman/listinfo/users -- View this message in context: http://xwiki.475771.n2.nabble.com/Can-t-Upgrade-from-XWiki-3-5-1-tp7600118p7600419.html Sent from the XWiki- Users mailing list archive at Nabble.com. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
