[jira] [Comment Edited] (FINERACT-590) Unable to create client under any office except Head office: Throwing 500 Internal Server Error

["Steve Conrad (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FINERACT-590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16350957#comment-16350957 ] 

Steve Conrad edited comment on FINERACT-590 at 2/3/18 5:07 AM:
---------------------------------------------------------------

The issue is when account number preferences is set to add a prefix (office_name) to the account number, the field is not wide enough to ensure a unique key. For example, if the office_name is over 10 characters (ie. branch-name1), then the 9 digit unique number that is appended will overflow the 20 digit limit on the account_no field.

The solution is to limit the prefix to 10 or fewer characters.


was (Author: conradsp):
The specific error is EntityExistsException. FailedObject: org.apache.fineract.portfolio.client.domain.Client@2bc0472e.

Is there any way to remote debug or connect to the mySQL instance on the staging server? I am unable to replicate on my local instance.

> Unable to create client under any office except Head office: Throwing 500 Internal Server Error
> -----------------------------------------------------------------------------------------------
>
>                 Key: FINERACT-590
>                 URL: https://issues.apache.org/jira/browse/FINERACT-590
>             Project: Apache Fineract
>          Issue Type: Bug
>          Components: Client
>    Affects Versions: 1.0.0
>            Reporter: Santosh Math
>            Assignee: Shaik Nazeer Hussain
>            Priority: Blocker
>              Labels: blocker, p1
>             Fix For: 1.1.0
>
>         Attachments: Screenshot from 2018-01-17 19-54-57.png, Screenshot from 2018-01-17 19-55-52.png
>
>
> Go to https://demo.openmf.org
> Go  to Clients and click on 'Create Client'.
> Provide all necesary or mandatory inputs  and select any office except Head Office.
> >The application is throwing 500:internal server error. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)