Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006825Openbravo ERPA. Platformpublic2009-01-09 17:322009-04-25 12:12
Reportershuehner 
Assigned Toalostale 
PriorityhighSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP1 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006825: Clicking on Sales Representative in Sales Invoice fails when field is not empty
DescriptionClicking on the Link next to this field fails with the error message shown: "ERROR: column "salesrep_id" does not exist".

Partial stacktrace:
295129 ERROR ReferencedTablesData - SQL error in query: SELECT C_BPartner_ID AS TABLENAME FROM AD_User WHERE SalesRep_ID = ?Exception:org.postgresql.util.PSQLException: ERROR: column "salesrep_id" does not exist
295130 ERROR HttpSecureAppServlet - Error captured: javax.servlet.ServletException: @CODE=0@ERROR: column "salesrep_id" does not exist
javax.servlet.ServletException: @CODE=0@ERROR: column "salesrep_id" does not exist
    at org.openbravo.erpCommon.utility.ReferencedTablesData.selectKeyId(ReferencedTablesData.java:215)
    at org.openbravo.erpCommon.utility.ReferencedTables.checkParent(ReferencedTables.java:122)

Error does not appear when field is empty.
Error does not appear in 2.40
Steps To ReproduceGo to Sales Invoice
Check that Sales Representative is non-empty
if it is empty, change and save
Click on the link next to Sales Representative
See error message.
Proposed Solution
Additional Information
Tagsmain
Relationships
has duplicate defect 0007904 closed rafaroda External Sales order's sales representative reference link error. 
has duplicate defect 0008491 closed mtaal Cannot navigate to the sales representative from Sales order window 
related to defect 0008762 closed alostale Odd labels appearing non-aligned and without field 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-09 17:32shuehnerNew Issue
2009-01-09 17:32shuehnerAssigned To => rafaroda
2009-01-09 17:32shuehnersf_bug_id0 => 2496053
2009-01-09 17:32shuehnerRegression testing => No
2009-01-09 19:42psarobeStatusnew => scheduled
2009-01-09 19:42psarobefix_in_branch => trunk
2009-02-13 16:12gmauleonAssigned Torafaroda => gmauleon
2009-03-04 08:50rafarodaAssigned Togmauleon => alostale
2009-03-04 08:50rafarodaPrioritynormal => high
2009-03-04 08:50rafarodafix_in_branchpi =>
2009-03-04 08:50rafarodaRelationship addedhas duplicate 0007904
2009-04-20 18:40hgbotCheckin
2009-04-20 18:40hgbotNote Added: 0015449
2009-04-20 18:40hgbotStatusscheduled => resolved
2009-04-20 18:40hgbotResolutionopen => fixed
2009-04-20 18:40hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/80e0f4ddf22880a351c3d4befa122d7856af9591 [^]
2009-04-22 11:23psarobeTag Attached: main
2009-04-22 14:54alostaleRelationship addedhas duplicate 0008491
2009-04-25 12:12psarobeStatusresolved => closed
2009-04-27 09:37alostaleRelationship addedrelated to 0008762

Notes
(0015449)
hgbot   
2009-04-20 18:40   
Repository: erp/devel/pi
Changeset: 80e0f4ddf22880a351c3d4befa122d7856af9591
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Apr 20 18:39:30 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/80e0f4ddf22880a351c3d4befa122d7856af9591 [^]

fixed bug 0006825: Clicking on Sales Representative in Sales Invoice fails when field is not empty

---
M src-wad/src/org/openbravo/wad/WadUtility.java
M src-wad/src/org/openbravo/wad/controls/WADControl.java
M src-wad/src/org/openbravo/wad/controls/WADLabelControl.java
M src-wad/src/org/openbravo/wad/controls/WadControlLabelBuilder.java
---