[
http://mifosforge.jira.com/browse/MIFOS-4647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kalyan Akella resolved MIFOS-4647.
----------------------------------
Resolution: Fixed
This is yet an other example of what happens if someone does unattended changes
on DB and leaves it that way !!!
The table definition for question_choice_tags is corrupted. The unique key
constraint is altered from (choice_id, tag_text) to just (tag_text). To fix
this issue, run the following SQLs in that order:
1. alter table question_choice_tags drop key choice_id;
2. alter table question_choice_tags drop index tag_text;
3. alter table question_choice_tags add unique (choice_id,tag_text);
We did this on the hudson_mifos_f_release schema on the birch box and that
fixed the problem.
We believe the hudson_mifos_gazelle_pseudolocale schema was created basing on a
dump taken from a corrupted index and hence the bug appeared there too. Please
run the above SQLs to fix this on other environments.
> Unhandled exception when adding Smart Select question to existing Question
> group
> --------------------------------------------------------------------------------
>
> Key: MIFOS-4647
> URL: http://mifosforge.jira.com/browse/MIFOS-4647
> Project: mifos
> Issue Type: Bug
> Components: QuestionGroups/Surveys/PPI
> Environment: Test Server (8085)
> Reporter: edcable
> Assignee: Kalyan Akella
> Fix For: Elsie F - Iteration 10, Elsie F
>
> Attachments: stacktrace.txt
>
>
> Steps to Repro:
> When adding an existing Smart Select question to existing Question Group get
> the following error:
> An unhandled error has occurred. Please contact your system administrator.
> See attached stack trace.
> Smart Select Question is called Purpose of Loan. It has 5 answer choices and
> 19 tags amongst those 5 answer choices. When attempting to save edits to
> this existing question I get the same error.
> Steps to Repro:
> 1) Go to Test Server at http:/ci.mifos.org:8085/mifos
> 2) Go to View Question Groups.
> 3) Select View Client Survey.
> 4) Edit Question Group.
> 5) Select "Select from exiting questions." Type in Purpose of Loan. Click Add
> Question.
> 6) Save Question Group - Get Error.
--
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
------------------------------------------------------------------------------
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
Pinpoint memory and threading errors before they happen.
Find and fix more than 250 security defects in the development cycle.
Locate bottlenecks in serial and parallel code that limit performance.
http://p.sf.net/sfu/intel-dev2devfeb
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
