[ https://issues.apache.org/jira/browse/OFBIZ-2396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Scott Gray reassigned OFBIZ-2396: --------------------------------- Assignee: Scott Gray > "Manage Picklist" errors out with MS-Sql when there is more than 1 pick list > ---------------------------------------------------------------------------- > > Key: OFBIZ-2396 > URL: https://issues.apache.org/jira/browse/OFBIZ-2396 > Project: OFBiz > Issue Type: Bug > Components: product > Affects Versions: Release Branch 4.0 > Reporter: Brian Sanders > Assignee: Scott Gray > Fix For: Release Branch 4.0 > > Attachments: picklist.patch > > > This may not affect other DBMS', but it definitely affects MS-Sql. Even > though a "workaround" would be to only have 1 picklist at a time, I don't > exactly consider that acceptable. Fortunately, it's an easy fix. It looks > like this issue still lurks in the trunk as well. To sum it up, > getPicklistSingleInfoInline is called for each picklist. In the method there > is an "orderBy" list to which "sequenceId" is added. The first pass works > fine, on the second pass, "sequenceId" is added to the list again and MS-Sql > complains because the column is in the "order by" clause twice. The solution > is to clear the field before-hand. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.