[
http://mifosforge.jira.com/browse/MIFOS-4004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=61053#action_61053
]
Mifos Hudson Jira Plugin User commented on MIFOS-4004:
------------------------------------------------------
Integrated in !http://ci.mifos.org/hudson/images/16x16/blue.gif! [head-1.7.x
#121|http://ci.mifos.org/hudson/job/head-1.7.x/121/]
MIFOS-4004: workaround for not working db upgrade.
Artur Siekielski :
[8e26646cfd5e5053a3edaac3742154fa21215bcc|http://mifos.git.sourceforge.net/git/gitweb.cgi?p=mifos/head&a=commit&h=8e26646cfd5e5053a3edaac3742154fa21215bcc]
Files :
*
application/src/main/java/org/mifos/application/master/persistence/Upgrade1286195484.java
*
application/src/main/java/org/mifos/application/master/persistence/Upgrade1285177663.java
> Database upgrade from 1.6.1 to Leila E fails with the SQLGrammerException in
> upgrade 1285177663
> -----------------------------------------------------------------------------------------------
>
> Key: MIFOS-4004
> URL: http://mifosforge.jira.com/browse/MIFOS-4004
> Project: mifos
> Issue Type: Bug
> Affects Versions: Release E
> Reporter: Jakub Sławiński
> Assignee: Artur Siekielski
> Priority: Critical
> Fix For: Release E - Iteration 10, Release E
>
>
> Database upgrade from 1.6.1 to Leila E fails with the SQLGrammerException in
> upgrade 1285177663. This error is caused by changes introduced in upgrade
> 1286195484 (new column in customer_address_detail). It seems that we cannot
> have schema changes of entities used in Java upgrades (schema changes cannot
> be introduced after the Java upgrade).
> The easiest workaround is to move schema upgrade before Java upgrade.
> applying upgrade with timestamp: 1285177663
> Time to execute the query 38 . Got 6 accounts.
> Using parameters:
> OutputIntervalForBatchJobs: 1000
> BatchSizeForBatchJobs: 100
> RecordCommittingSizeForBatchJobs: 500
> 6 accounts to process, results output every 1000 accounts
> 2010-10-25/11:26:36.613/CEST ERROR, org.hibernate.util.JDBCExceptionReporter,
> ?, ?, ?, Unknown column 'customerad1_.phone_number_stripped' in 'field list'
> account 12 exception could not load an entity:
> [org.mifos.customers.business.CustomerBO#9]
> 2010-10-25/11:26:36.659/CEST ERROR, org.mifos.framework.persistence.Upgrade,
> ?, ?, ?, Unable to generate schedules for account with ID 12
> org.hibernate.exception.SQLGrammarException: could not load an entity:
> [org.mifos.customers.business.CustomerBO#9]
> at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
> at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
> at org.hibernate.loader.Loader.loadEntity(Loader.java:1937)
> ...
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown
> column 'customerad1_.phone_number_stripped' in 'field list'
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
