Openbravo Issue Tracking System - POS2
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047955POS2POSpublic2021-11-02 08:112021-11-02 10:21
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed 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 PackNo
Summary0047955: ORA: can't save print template without module
DescriptionWhen trying to save a print template with as code without module in Oracle, it fails.
Steps To ReproduceIn an Oracle instance:
1. Log in as System Admin
2. Create a new record in POS Print Templates
3. Keep module empty and complete the rest of the fields
4. Save
  -> ERROR: Saving failed. ORA-01403: no data found ORA-06512: at "POS2.OBPOS_PRINT_TEMPLATE_MOD_TRG"

Alternatively execute TemplateValidator tests.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0047413 closed alostale Printing templates as masterdata 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2021-11-02 08:11alostaleNew Issue
2021-11-02 08:11alostaleAssigned To => Retail
2021-11-02 08:11alostaleTriggers an Emergency Pack => No
2021-11-02 08:12alostaleRelationship addedrelated to 0047413
2021-11-02 08:12alostaleAssigned ToRetail => alostale
2021-11-02 10:07hgbotNote Added: 0132778
2021-11-02 10:21hgbotResolutionopen => fixed
2021-11-02 10:21hgbotStatusnew => closed
2021-11-02 10:21hgbotFixed in Version => RR22Q1
2021-11-02 10:21hgbotNote Added: 0132780
2021-11-02 10:21hgbotNote Added: 0132781

Notes
(0132778)
hgbot   
2021-11-02 10:07   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/614 [^]
(0132780)
hgbot   
2021-11-02 10:21   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: 68d9f5e860b3273f820758c05bfc4581e77c7637
Author: Asier Lostalé <asier.lostale@openbravo.com>
Date: 2021-11-02T09:20:59+00:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/68d9f5e860b3273f820758c05bfc4581e77c7637 [^]

fixed BUG-47955: ORA can't save print template without module

Fixes Oracle trigger to properly handle the case of null module.

---
M src-db/database/model/triggers/OBPOS_PRINT_TEMPLATE_MOD_TRG.xml
---
(0132781)
hgbot   
2021-11-02 10:21   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/614 [^]