Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0053435Retail ModulesRetail APIpublic2023-09-12 07:382023-09-12 08:42
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityhave 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
Summary0053435: failed dbconsistency in org.openbravo.api
DescriptionDBConsistency is failing.
Steps To ReproduceSee https://builds.openbravo.com/job/mod-simple/83230/artifact/dbconsistency.log/*view*/ [^]

diff --git a/src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml b/src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
index 9efb387..4273cac 100644
--- a/src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
+++ b/src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
@@ -7672,6 +7672,21 @@
 <!--ACE2C20504CB4EAB9ACF9AD5A42A6C98--> <IDENTIFIES_UNIVOCALLY><![CDATA[N]]></IDENTIFIES_UNIVOCALLY>
 <!--ACE2C20504CB4EAB9ACF9AD5A42A6C98--></OBEI_PROP_MAP_INSTANCE>
 
+<!--ACE953594430466D81D90B06A98C39B6--><OBEI_PROP_MAP_INSTANCE>
+<!--ACE953594430466D81D90B06A98C39B6--> <OBEI_PROP_MAP_INSTANCE_ID><![CDATA[ACE953594430466D81D90B06A98C39B6]]></OBEI_PROP_MAP_INSTANCE_ID>
+<!--ACE953594430466D81D90B06A98C39B6--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--ACE953594430466D81D90B06A98C39B6--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--ACE953594430466D81D90B06A98C39B6--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--ACE953594430466D81D90B06A98C39B6--> <AD_MODULE_ID><![CDATA[2AC92849FE28419B9B012CF841058741]]></AD_MODULE_ID>
+<!--ACE953594430466D81D90B06A98C39B6--> <OBEI_PROPERTY_MAPPING_CLASS_ID><![CDATA[56FE294AE2314727A9313EE50258657E]]></OBEI_PROPERTY_MAPPING_CLASS_ID>
+<!--ACE953594430466D81D90B06A98C39B6--> <OBEI_ENTITY_MAPPING_ID><![CDATA[E5A479790D994DCDA1D4403DE139882D]]></OBEI_ENTITY_MAPPING_ID>
+<!--ACE953594430466D81D90B06A98C39B6--> <SEQNO><![CDATA[420]]></SEQNO>
+<!--ACE953594430466D81D90B06A98C39B6--> <ACCEPT_NULL_VALUES><![CDATA[Y]]></ACCEPT_NULL_VALUES>
+<!--ACE953594430466D81D90B06A98C39B6--> <MAPPING_NAME><![CDATA[transactionMinimumAmt]]></MAPPING_NAME>
+<!--ACE953594430466D81D90B06A98C39B6--> <PROPERTY_PATH><![CDATA[creditminamt]]></PROPERTY_PATH>
+<!--ACE953594430466D81D90B06A98C39B6--> <IDENTIFIES_UNIVOCALLY><![CDATA[N]]></IDENTIFIES_UNIVOCALLY>
+<!--ACE953594430466D81D90B06A98C39B6--></OBEI_PROP_MAP_INSTANCE>
+
 <!--AD3F9F1A152641AFA6DD312B6A8EA726--><OBEI_PROP_MAP_INSTANCE>
 <!--AD3F9F1A152641AFA6DD312B6A8EA726--> <OBEI_PROP_MAP_INSTANCE_ID><![CDATA[AD3F9F1A152641AFA6DD312B6A8EA726]]></OBEI_PROP_MAP_INSTANCE_ID>
 <!--AD3F9F1A152641AFA6DD312B6A8EA726--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -8848,6 +8863,21 @@
 <!--C355C0E686D14BCC964D40CE6AD075BD--> <DESCRIPTION><![CDATA[This field defines the default value for the Via Mail check in Web POS Customer Creation]]></DESCRIPTION>
 <!--C355C0E686D14BCC964D40CE6AD075BD--></OBEI_PROP_MAP_INSTANCE>
 
+<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--><OBEI_PROP_MAP_INSTANCE>
+<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <OBEI_PROP_MAP_INSTANCE_ID><![CDATA[C3E9E427EE9E4ACBAFB1DA211B95E9BF]]></OBEI_PROP_MAP_INSTANCE_ID>
+<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <AD_MODULE_ID><![CDATA[2AC92849FE28419B9B012CF841058741]]></AD_MODULE_ID>
+<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <OBEI_PROPERTY_MAPPING_CLASS_ID><![CDATA[E7530A099A704FBA847DC6EE6FB9CBCE]]></OBEI_PROPERTY_MAPPING_CLASS_ID>
+<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <OBEI_ENTITY_MAPPING_ID><![CDATA[A642108DB1774F6D80BDF8D933FAA569]]></OBEI_ENTITY_MAPPING_ID>
+<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <SEQNO><![CDATA[400]]></SEQNO>
+<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <ACCEPT_NULL_VALUES><![CDATA[Y]]></ACCEPT_NULL_VALUES>
+<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <MAPPING_NAME><![CDATA[transactionMinimumAmt]]></MAPPING_NAME>
+<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <PROPERTY_PATH><![CDATA[creditminamt]]></PROPERTY_PATH>
+<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <IDENTIFIES_UNIVOCALLY><![CDATA[N]]></IDENTIFIES_UNIVOCALLY>
+<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--></OBEI_PROP_MAP_INSTANCE>
+
 <!--C3F27974D0494602A2C194FA7AAC767A--><OBEI_PROP_MAP_INSTANCE>
 <!--C3F27974D0494602A2C194FA7AAC767A--> <OBEI_PROP_MAP_INSTANCE_ID><![CDATA[C3F27974D0494602A2C194FA7AAC767A]]></OBEI_PROP_MAP_INSTANCE_ID>
 <!--C3F27974D0494602A2C194FA7AAC767A--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -11263,34 +11293,4 @@
 <!--FFE5944767D345CC932DD9395D43123A--> <DESCRIPTION><![CDATA[Price shown on the POS as a guide. By defaut it is strikethough in case of difference with the Unit Price]]></DESCRIPTION>
 <!--FFE5944767D345CC932DD9395D43123A--></OBEI_PROP_MAP_INSTANCE>
 
-<!--ACE953594430466D81D90B06A98C39B6--><OBEI_PROP_MAP_INSTANCE>
-<!--ACE953594430466D81D90B06A98C39B6--> <OBEI_PROP_MAP_INSTANCE_ID><![CDATA[ACE953594430466D81D90B06A98C39B6]]></OBEI_PROP_MAP_INSTANCE_ID>
-<!--ACE953594430466D81D90B06A98C39B6--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--ACE953594430466D81D90B06A98C39B6--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--ACE953594430466D81D90B06A98C39B6--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--ACE953594430466D81D90B06A98C39B6--> <AD_MODULE_ID><![CDATA[2AC92849FE28419B9B012CF841058741]]></AD_MODULE_ID>
-<!--ACE953594430466D81D90B06A98C39B6--> <OBEI_PROPERTY_MAPPING_CLASS_ID><![CDATA[56FE294AE2314727A9313EE50258657E]]></OBEI_PROPERTY_MAPPING_CLASS_ID>
-<!--ACE953594430466D81D90B06A98C39B6--> <OBEI_ENTITY_MAPPING_ID><![CDATA[E5A479790D994DCDA1D4403DE139882D]]></OBEI_ENTITY_MAPPING_ID>
-<!--ACE953594430466D81D90B06A98C39B6--> <SEQNO><![CDATA[420]]></SEQNO>
-<!--ACE953594430466D81D90B06A98C39B6--> <ACCEPT_NULL_VALUES><![CDATA[Y]]></ACCEPT_NULL_VALUES>
-<!--ACE953594430466D81D90B06A98C39B6--> <MAPPING_NAME><![CDATA[transactionMinimumAmt]]></MAPPING_NAME>
-<!--ACE953594430466D81D90B06A98C39B6--> <PROPERTY_PATH><![CDATA[creditminamt]]></PROPERTY_PATH>
-<!--ACE953594430466D81D90B06A98C39B6--> <IDENTIFIES_UNIVOCALLY><![CDATA[N]]></IDENTIFIES_UNIVOCALLY>
-<!--ACE953594430466D81D90B06A98C39B6--></OBEI_PROP_MAP_INSTANCE>
-
-<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--><OBEI_PROP_MAP_INSTANCE>
-<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <OBEI_PROP_MAP_INSTANCE_ID><![CDATA[C3E9E427EE9E4ACBAFB1DA211B95E9BF]]></OBEI_PROP_MAP_INSTANCE_ID>
-<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <AD_MODULE_ID><![CDATA[2AC92849FE28419B9B012CF841058741]]></AD_MODULE_ID>
-<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <OBEI_PROPERTY_MAPPING_CLASS_ID><![CDATA[E7530A099A704FBA847DC6EE6FB9CBCE]]></OBEI_PROPERTY_MAPPING_CLASS_ID>
-<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <OBEI_ENTITY_MAPPING_ID><![CDATA[A642108DB1774F6D80BDF8D933FAA569]]></OBEI_ENTITY_MAPPING_ID>
-<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <SEQNO><![CDATA[400]]></SEQNO>
-<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <ACCEPT_NULL_VALUES><![CDATA[Y]]></ACCEPT_NULL_VALUES>
-<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <MAPPING_NAME><![CDATA[transactionMinimumAmt]]></MAPPING_NAME>
-<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <PROPERTY_PATH><![CDATA[creditminamt]]></PROPERTY_PATH>
-<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--> <IDENTIFIES_UNIVOCALLY><![CDATA[N]]></IDENTIFIES_UNIVOCALLY>
-<!--C3E9E427EE9E4ACBAFB1DA211B95E9BF--></OBEI_PROP_MAP_INSTANCE>
-
 </data>
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
caused by feature request 0053098 closed Retail POS2 Minimum amount is configurable with Credit Sales 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-09-12 07:38alostaleNew Issue
2023-09-12 07:38alostaleAssigned To => Triage Platform Conn
2023-09-12 07:38alostaleTriggers an Emergency Pack => No
2023-09-12 07:38alostaleRelationship addedcaused by 0053098
2023-09-12 07:42hgbotNote Added: 0154700
2023-09-12 07:50alostaleSummaryfailed dbconsistency in org.operbravo.api => failed dbconsistency in org.openbravo.api
2023-09-12 08:11hgbotResolutionopen => fixed
2023-09-12 08:11hgbotStatusnew => closed
2023-09-12 08:11hgbotNote Added: 0154702
2023-09-12 08:11hgbotNote Added: 0154703
2023-09-12 08:42alostaleAssigned ToTriage Platform Conn => alostale

Notes
(0154700)
hgbot   
2023-09-12 07:42   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/188 [^]
(0154702)
hgbot   
2023-09-12 08:11   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/merge_requests/188 [^]
(0154703)
hgbot   
2023-09-12 08:11   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.api [^]
Changeset: bc5aa5efe8f8f468057b81d73bc1a9796a68e4e6
Author: Asier Lostalé <asier.lostale@openbravo.com>
Date: 12-09-2023 07:42:05
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.api/-/commit/bc5aa5efe8f8f468057b81d73bc1a9796a68e4e6 [^]

fixes ISSUE-53435: broken dbconsistency

---
M src-db/database/sourcedata/OBEI_PROP_MAP_INSTANCE.xml
---