29 Sep
2015
29 Sep
'15
8:17 a.m.
Hi Jody,
Unfortunately we’ve noticed this migration issue with oracle after we released 7.2. Here’s
the issue for it: http://jira.xwiki.org/browse/XWIKI-12625
As you can we fixed it yesterday and we may package it in a 7.2.1 version in the future.
For now, there’s a JAR attached to the issue that you can use to replace yours and it
should work fine.
Sorry for the inconvenience
Thanks
-Vincent
On 29 Sep 2015 at 04:53:28, Jody BURGER (j.burger@bfc.nc(mailto:j.burger@bfc.nc)) wrote:
Hi all,
I'm actually working to migrate our wiki from 6.4.5 to 7.2 as it
implement the feature we were looking for, since the begining of this year !
So as i did before i upgraded the .war manually,
I replaced all config files to match my needs,
i'm working on oracle 11g so my hibernate looks like :
name="connection.url">jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=My_server)
(PORT=My_Port))(ADDRESS=(PROTOCOL=TCP)(HOST=My_server)
(PORT=My_Port))(CONNECT_DATA=(SERVICE_NAME=xwiki)(FAILOVER_MODE=(TYPE =
SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))))
xwiki
xwiki
name="connection.driver_class">oracle.jdbc.driver.OracleDriver
name="dialect">org.hibernate.dialect.Oracle10gDialect
true
0
false
20
i also set the migration parameter in xwiki.cfg
xwiki.store.migration=1
But i can't get through it ... my logs looks like :
2015-09-29 13:28:01,157 [coreLoadExecutor-5-thread-1] WARN
o.a.s.r.ManagedResource - No stored data found for /rest/managed
2015-09-29 13:28:01,453 [main] INFO o.x.s.s.i.EmbeddedSolrInstance -
Started embedded Solr server.
2015-09-29 13:28:01,640 [main] INFO o.x.o.i.s.DefaultOfficeServer -
Open Office instance started.
2015-09-29 13:31:19,030 [XWiki initialization] INFO
.HibernateDataMigrationManager - Storage schema updates and data
migrations are enabled
2015-09-29 13:31:19,420 [XWiki initialization] INFO
.HibernateDataMigrationManager - The following data migration(s) will be
applied for wiki [xwiki] currently in version [72000]:
2015-09-29 13:31:19,435 [XWiki initialization] INFO
.HibernateDataMigrationManager - R72001XWIKI12228 - Make sure
xwikidocument and xwikispace tables are in sync
2015-09-29 13:31:19,435 [XWiki initialization] INFO
.HibernateDataMigrationManager - Checking Hibernate mapping and updating
schema if needed for wiki [xwiki]
2015-09-29 13:31:20,371 [XWiki initialization] INFO
.HibernateDataMigrationManager - Starting data migration
[R72001XWIKI12228] with version [72001] on database [xwiki]
2015-09-29 13:31:20,387 [XWiki initialization] WARN
o.h.u.JDBCExceptionReporter - SQL Error: 904, SQLState: 42000
2015-09-29 13:31:20,387 [XWiki initialization] ERROR
o.h.u.JDBCExceptionReporter - ORA-00904: "TRUE" : identificateur non
valide
2015-09-29 13:31:20,402 [XWiki initialization] ERROR
.HibernateDataMigrationManager - Failed to migrate database [xwiki]...
com.xpn.xwiki.store.migration.DataMigrationException: Data migration
R72001XWIKI12228 failed
[...]
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "TRUE" :
identificateur non valide
[...]
2015-09-29 13:31:20,402 [XWiki initialization] ERROR
.HibernateDataMigrationManager - Main wiki database migration failed, it
is not safe to continue!
2015-09-29 13:31:20,402 [XWiki initialization] ERROR
c.x.x.XWiki - Failed to initialize mandatory document
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while
reading document [xwiki:XWiki.WikiMacroParameterClass]
[...]
Caused by: com.xpn.xwiki.XWikiException: Error number 3301 in 3:
Exception while switching to database xwiki
[...]
I'm so confused ... what did i do wrong ?!
Hope someone can help me to deal with it :)
Best regards,
JB
--
//j.burger(a)bfc.nc
recycle ///Sauvez la planète, n'imprimez que si c'est nécéssaire.///