Openbravo Issue Tracking System - Retail Modules | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0031645 | Retail Modules | Mobile Procurement | public | 2015-12-02 14:17 | 2017-02-20 18:44 |
| Reporter | egoitz | ||||
| Assigned To | rqueralta | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0031645: It is not possible to use the character ' on warehouse name | ||||
| Description | When using a name that contains the character ', you can not login on the mobile procurement terminal using the warehouse with that name. | ||||
| Steps To Reproduce | Change the name of the warejhouse used by the dafult by a user for the terminal by adding the charecter ' on the name. When loggin the terminal you get the following error: b17d993 2015-12-02 12:37:48,039 [ajp-bio-127.0.0.1-8009-exec-1] ERROR org.openbravo.mobile.core.process.ProcessHQLQuery - org.openbravo.mobile.procurement.term.Terminal: Error when generating query: null (expecting 'd', found '0' [select pop.id as id, '517C7BAD1822443E945017F6A97FD531' as businessPartner, pop.commercialName as _identifier, pop.searchKey as searchKey, pop.defaultTab as defaultTab, '89303CB25A4B4422B3C921BB4E4C0848' as organization, 'DGO1' as organization$_identifier, '36837D3A6CDA46729E9199228B2316A9' as client, 'RegionWallonne' as client$_identifier, 'B2AAE2BE034C4F6CAC7D3C292D464A30' as warehouse, 'Local d'entreposage DG01' as warehouse$_identifier, '0B06C1B512E742628D23F296DA31CE7D' as priceList, '102' as currency, pop.documentType.id as documentType, COALESCE(false, false) as enableOrderWeightControl, TO_NUMBER('0') as minimumOrderWeight, COALESCE(false, false) as blockUnderWeightOrder, TO_NUMBER('0') as maximumOrderWeight, COALESCE(false, false) as blockOverWeightOrder, 'null' as regionId, '103' as countryId from OBMPR_CONFIGURATION AS pop where ( (pop.client.id in ('36837D3A6CDA46729E9199228B2316A9', '0')) and (pop.organization.id in ('132B6125AFAE40068532AF10F02AE1B5', '0', '133D7D2AA6BD4696ACCFBB94508DBAB0', 'C9BE4470D800486F8D77E3C4AEB27C88', '89303CB25A4B4422B3C921BB4E4C0848')) ) and (pop.active = 'Y') and pop.searchKey = 'DGO1-1']) org.hibernate.QueryException: expecting 'd', found '0' [select pop.id as id, '517C7BAD1822443E945017F6A97FD531' as businessPartner, pop.commercialName as _identifier, pop.searchKey as searchKey, pop.defaultTab as defaultTab, '89303CB25A4B4422B3C921BB4E4C0848' as organization, 'DGO1' as organization$_identifier, '36837D3A6CDA46729E9199228B2316A9' as client, 'RegionWallonne' as client$_identifier, 'B2AAE2BE034C4F6CAC7D3C292D464A30' as warehouse, 'Local d'entreposage DG01' as warehouse$_identifier, '0B06C1B512E742628D23F296DA31CE7D' as priceList, '102' as currency, pop.documentType.id as documentType, COALESCE(false, false) as enableOrderWeightControl, TO_NUMBER('0') as minimumOrderWeight, COALESCE(false, false) as blockUnderWeightOrder, TO_NUMBER('0') as maximumOrderWeight, COALESCE(false, false) as blockOverWeightOrder, 'null' as regionId, '103' as countryId from OBMPR_CONFIGURATION AS pop where ( (pop.client.id in ('36837D3A6CDA46729E9199228B2316A9', '0')) and (pop.organization.id in ('132B6125AFAE40068532AF10F02AE1B5', '0', '133D7D2AA6BD4696ACCFBB94508DBAB0', 'C9BE4470D800486F8D77E3C4AEB27C88', '89303CB25A4B4422B3C921BB4E4C0848')) ) and (pop.active = 'Y') and pop.searchKey = 'DGO1-1'] at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:229) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135) at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770) at org.openbravo.mobile.core.process.ProcessHQLQuery.exec(ProcessHQLQuery.java:114) at org.openbravo.mobile.core.process.SecuredJSONProcess.secureExec(SecuredJSONProcess.java:42) at org.openbravo.mobile.core.process.MobileService.execClassName(MobileService.java:167) | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2015-12-02 14:17 | egoitz | New Issue | |||
| 2015-12-02 14:17 | egoitz | Assigned To | => Retail | ||
| 2015-12-02 14:17 | egoitz | Triggers an Emergency Pack | => No | ||
| 2017-02-20 18:44 | rqueralta | Assigned To | Retail => rqueralta | ||
| There are no notes attached to this issue. |