Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0031584
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2015-11-25 18:172016-02-11 17:46
ReporterioritzCiaView Statuspublic 
Assigned Toranjith_qualiantech_com 
PrioritynormalResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision4af994a4bc5b
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0031584: [SERQA 438] The obpos_print_template table should be included in the Client Definition dataset

DescriptionThe em_obpos_invoice_template_id column of the ad_org table references the obpos_print_template table.

The problem is that the ad_org table is included in the Client Definition dataset, but the obpos_print_template table is not. This will cause referencial integrity problems when importing a sample data that containes not null values in the em_obpos_invoice_template_id column of the ad_org table.
Steps To ReproduceFor any client:
- Add values to some rows in the em_obpos_invoice_template_id column of the ad_org table.
- export the sample data for that client:
ant export.sample.data -Dclient="YourClient" -Dmodule=org.openbravo
  this will generate a XML file for the ad_org that contains values for its em_obpos_invoice_template_id column, but it will not generate a XML file for the obpos_print_template table
- Import the sample data for that client, for instance by executing ant install.source. There will be referencial integrity problemes like these:

[java] 49497 WARN - SQL Command failed with: ERROR: insert or update on table "ad_org" violates foreign key constraint "em_obpos_org_invoicetemp"
     [java] Detail: Key (em_obpos_invoice_template_id)=(9C65D4A30C7E4842B65E071E127060CF) is not present in table "obpos_print_template".
     [java] 49499 WARN - -- END

TagsSER-QA
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0083300)
hgbot (developer)
2016-01-14 13:59

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 4af994a4bc5b2929c9dff51ec51b3b7b317b843b
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Thu Jan 14 18:29:04 2016 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/4af994a4bc5b2929c9dff51ec51b3b7b317b843b [^]

Fixes issue 31584 : Adding obpos_print_template table in Client definition dataset

---
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0083301)
hgbot (developer)
2016-01-14 14:00

 Repository: tools/automation/pi-mobile
Changeset: afc83636783659f8c12e3a1c9c423cdbcc354b65
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Thu Jan 14 18:29:01 2016 +0530
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/afc83636783659f8c12e3a1c9c423cdbcc354b65 [^]

Verifies issue 31584: Added automated test 'I31584_POSPrintTableIncludedInDataset'

---
A src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I31584_POSPrintTableIncludedInDataset.java
---
(0084129)
hgbot (developer)
2016-02-11 17:41

 Repository: tools/automation/pi-mobile
Changeset: a5cf84ffd521338ff1be428cba1fa55a9dcf9803
Author: Antonio Moreno Perez <antonio.moreno <at> openbravo.com>
Date: Thu Feb 11 17:41:23 2016 +0100
URL: http://code.openbravo.com/tools/automation/pi-mobile/rev/a5cf84ffd521338ff1be428cba1fa55a9dcf9803 [^]

Related to issue 31584. Removed automated test because it's not necessary.

---
R src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/system/I31584_POSPrintTableIncludedInDataset.java
---
(0084130)
hgbot (developer)
2016-02-11 17:44

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: d0134cc6d84bc6ce8c203b12b81aec2258f91c72
Author: Antonio Moreno Perez <antonio.moreno <at> openbravo.com>
Date: Thu Feb 11 17:44:21 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/d0134cc6d84bc6ce8c203b12b81aec2258f91c72 [^]

Related to issue 31584. Removed OBPOS_PRINT_TEMPLATE table from Client Definition dataset because this table is already included in the Application Dictionary, which is the right dataset for it.

---
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
---
(0084131)
marvintm (manager)
2016-02-11 17:46

 Finally this issue doesn't need to be fixed. The reason is that the table OBPOS_PRINT_TEMPLATE is already included in the dataset AD, and this is correct due to the fact that this table contains source information (in this case, printing template definitions) which should be exported to the sourcedata information of modules.

It is therefore not needed to export this information into the Client definition.

- Issue History
Date Modified Username Field Change
2015-11-25 18:17 ioritzCia New Issue
2015-11-25 18:17 ioritzCia Assigned To => Retail
2015-11-25 18:17 ioritzCia Triggers an Emergency Pack => No
2015-12-01 11:47 agete Tag Attached: SER-QA
2015-12-01 11:47 agete Summary The obpos_print_template table should be included in the Client Definition dataset => [SERQA 438]The obpos_print_template table should be included in the Client Definition dataset
2015-12-01 13:03 agete Summary [SERQA 438]The obpos_print_template table should be included in the Client Definition dataset => [SERQA 438] The obpos_print_template table should be included in the Client Definition dataset
2015-12-01 14:31 Orekaria Status new => acknowledged
2016-01-13 14:28 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2016-01-13 14:28 ranjith_qualiantech_com Status acknowledged => scheduled
2016-01-14 13:59 hgbot Checkin
2016-01-14 13:59 hgbot Note Added: 0083300
2016-01-14 13:59 hgbot Status scheduled => resolved
2016-01-14 13:59 hgbot Resolution open => fixed
2016-01-14 13:59 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/4af994a4bc5b2929c9dff51ec51b3b7b317b843b [^]
2016-01-14 14:00 hgbot Checkin
2016-01-14 14:00 hgbot Note Added: 0083301
2016-02-05 13:20 marvintm Review Assigned To => marvintm
2016-02-05 13:20 marvintm Status resolved => closed
2016-02-05 13:20 marvintm Fixed in Version => RR16Q2
2016-02-11 17:41 hgbot Checkin
2016-02-11 17:41 hgbot Note Added: 0084129
2016-02-11 17:44 hgbot Checkin
2016-02-11 17:44 hgbot Note Added: 0084130
2016-02-11 17:45 marvintm Status closed => new
2016-02-11 17:45 marvintm Resolution fixed => open
2016-02-11 17:45 marvintm Fixed in Version RR16Q2 =>
2016-02-11 17:46 marvintm Note Added: 0084131
2016-02-11 17:46 marvintm Status new => closed
2016-02-11 17:46 marvintm Resolution open => no change required

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker