[
http://mifosforge.jira.com/browse/MIFOS-4004?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Artur Siekielski resolved MIFOS-4004.
-------------------------------------
Resolution: Fixed
> 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
