Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033503Retail ModulesWeb POSpublic2016-07-20 08:292016-08-17 07:21
Reportersimbu94 
Assigned Toranjith_qualiantech_com 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomigueldejuana
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033503: Error Loading POS Terminal If default Business Partner's max(businessPartnerLocationId) is inactive.
DescriptionError Loading POS Terminal If default Business Partner's max(businessPartnerLocationId) is inactive.


Error getting Business Partner information
The Business Partner information is missing in local database. Click Reload to refresh the page. If the problem persists please contact your System Administrator.
Steps To Reproduce1. Login to POS Terminal VBS-1 (default Customer: VBS Customer)
2. Create 2 New Locations for default Business Partner
3. execute query in database (Make sure you are not updating default business partner location)

update c_bpartner_location set isactive='N' where c_bpartner_location_id =(select max(c_bpartner_location_id) from c_bpartner_location where c_bpartner_id='ABD91C9D3BC94175B876FBBE9CACA008') --VBS Customer

4. Clear cache and Login to POS. you see the POPUP error
Proposed SolutionBusiness Partner sub query is missing active check. Attached Patch for solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespatch BPError.patch (2,418) 2016-07-21 11:12
https://issues.openbravo.com/file_download.php?file_id=9643&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-07-20 08:29simbu94New Issue
2016-07-20 08:29simbu94Assigned To => Retail
2016-07-20 08:29simbu94Triggers an Emergency Pack => No
2016-07-20 08:29simbu94File Added: BPError.patch
2016-07-20 15:11simbu94File Deleted: BPError.patch
2016-07-21 11:12simbu94File Added: BPError.patch
2016-07-21 11:23marvintmStatusnew => acknowledged
2016-07-22 13:58simbu94SummaryError Loading POS Terminal If default Business Partner Location is inactive. => Error Loading POS Terminal If default Business Partner's max(businessPartnerLocationId) is inactive.
2016-07-22 13:58simbu94Description Updatedbug_revision_view_page.php?rev_id=12738#r12738
2016-07-25 11:19ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2016-07-25 11:19ranjith_qualiantech_comStatusacknowledged => scheduled
2016-07-26 11:27hgbotCheckin
2016-07-26 11:27hgbotNote Added: 0088664
2016-07-26 11:27hgbotStatusscheduled => resolved
2016-07-26 11:27hgbotResolutionopen => fixed
2016-07-26 11:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c2604fffb961a739c71d60e062ca9a3aa570c3ac [^]
2016-08-17 07:21migueldejuanaReview Assigned To => migueldejuana
2016-08-17 07:21migueldejuanaNote Added: 0089162
2016-08-17 07:21migueldejuanaStatusresolved => closed

Notes
(0088664)
hgbot   
2016-07-26 11:27   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: c2604fffb961a739c71d60e062ca9a3aa570c3ac
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Tue Jul 26 14:33:34 2016 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/c2604fffb961a739c71d60e062ca9a3aa570c3ac [^]

Fixes issue 33503 : BusinessPartner should be loaded if max(businessPartnerLocationId) is active

- Condition added in order to load the BusinessPartner with max(BusinessPartnerLocation) should be active

---
M src/org/openbravo/retail/posterminal/master/BusinessPartner.java
---
(0089162)
migueldejuana   
2016-08-17 07:21   
tested and reviewed