Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0056270 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [POS2] POS | major | always | 2024-08-17 09:51 | 2024-08-19 11:15 | |||
| Reporter | sreehari | View Status | public | |||||
| Assigned To | sreehari | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Regression level | Pre packaging ( pi ) | |||||||
| Regression date | 2024-08-16 | |||||||
| Regression introduced in release | pi | |||||||
| Regression introduced by commit | https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2732/diffs#d3700544a6538284c53af61d2572f89af485c63c_35_47 [^] | |||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0056270: The Sales Representation saved as null in shipment and invoice lines throws FK exception | |||||||
| Description | When completing a order with more than 1 line the Sales Representative for the lines are set as null as per the regression commit. Which then causes the FK exception in m_inoutline & c_invoiceline for Salesrep_ID=null | |||||||
| Steps To Reproduce | 1.Complete a order with more than 1 lines 2.Error while importing is created | |||||||
| Proposed Solution | Add null checks before setting the salesRep in m_inoutline & c_invoiceline - since when we have no sales rep in general we wont be setting the sales rep and still the column value is null - since we set the salesRep_id value to be null it is set as "null" which throws exception with Foreign Key mismatch | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  Screenshot 2024-08-17 at 1.21.16 PM.png [^] (297,114 bytes) 2024-08-17 09:51 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0168207) hgbot (developer) 2024-08-19 10:54 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1650 [^] |
|
(0168208) hgbot (developer) 2024-08-19 11:15 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^] Changeset: 058b916136baef7adde9662beeed1896dd4b95ef Author: Sreehari Venkataraman <sreehari.venkataraman.ext@openbravo.com> Date: 17-08-2024 13:23:59 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/058b916136baef7adde9662beeed1896dd4b95ef [^] Fixes ISSUE-56270: Added null checks before setting salesRepresentative --- M src/org/openbravo/retail/posterminal/utility/InvoiceUtils.java M src/org/openbravo/retail/posterminal/utility/ShipmentUtils.java --- |
|
(0168209) hgbot (developer) 2024-08-19 11:15 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1650 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2024-08-17 09:51 | sreehari | New Issue | |
| 2024-08-17 09:51 | sreehari | Assigned To | => sreehari |
| 2024-08-17 09:51 | sreehari | File Added: Screenshot 2024-08-17 at 1.21.16 PM.png | |
| 2024-08-17 09:51 | sreehari | Regression level | => Pre packaging ( pi ) |
| 2024-08-17 09:51 | sreehari | Regression date | => 2024-08-16 |
| 2024-08-17 09:51 | sreehari | Regression introduced in release | => pi |
| 2024-08-17 09:51 | sreehari | Regression introduced by commit | => https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2732/diffs#d3700544a6538284c53af61d2572f89af485c63c_35_47 [^] |
| 2024-08-17 09:51 | sreehari | Triggers an Emergency Pack | => No |
| 2024-08-17 09:52 | sreehari | Relationship added | caused by 0055749 |
| 2024-08-17 09:52 | sreehari | Status | new => scheduled |
| 2024-08-19 10:54 | hgbot | Note Added: 0168207 | |
| 2024-08-19 11:15 | hgbot | Resolution | open => fixed |
| 2024-08-19 11:15 | hgbot | Status | scheduled => closed |
| 2024-08-19 11:15 | hgbot | Fixed in Version | => RR24Q4 |
| 2024-08-19 11:15 | hgbot | Note Added: 0168208 | |
| 2024-08-19 11:15 | hgbot | Note Added: 0168209 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |