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 :
<property
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))))</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">xwiki</property>
<property
name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property
name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property
name="connection.SetBigStringTryClob">true</property>
<property name="jdbc.batch_size">0</property>
<property name="jdbc.use_streams_for_binary">false</property>
<property name="dbcp.ps.maxActive">20</property>
<mapping resource="xwiki.oracle.hbm.xml"/>
<mapping resource="feeds.oracle.hbm.xml"/>
<mapping resource="activitystream.hbm.xml"/>
<mapping resource="instance.hbm.xml"/>
<mapping resource="mailsender.oracle.hbm.xml"/>
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 <mailto:assistance@bfc.nc>
recycle ///Sauvez la planète, n'imprimez que si c'est nécéssaire.///
/---------------------------------------------------------------------------------------------/