Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0031584 | Retail Modules | Web POS | public | 2015-11-25 18:17 | 2016-02-11 17:46 |
|
| Reporter | ioritzCia | |
| Assigned To | ranjith_qualiantech_com | |
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | no change required | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | marvintm |
| OBNetwork customer | No |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0031584: [SERQA 438] The obpos_print_template table should be included in the Client Definition dataset |
| Description | The 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 Reproduce | For 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
|
| Proposed Solution | |
| Additional Information | |
| Tags | SER-QA |
| Relationships | |
| Attached Files | |
|
| 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 | OBNetwork customer | => Yes |
| 2015-11-25 18:17 | ioritzCia | Triggers an Emergency Pack | => No |
| 2015-11-26 11:51 | ioritzCia | OBNetwork customer | Yes => 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 |
|
Notes |
|
|
(0083300)
|
|
hgbot
|
|
2016-01-14 13:59
|
|
|
|
|
(0083301)
|
|
hgbot
|
|
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
|
|
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
|
|
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
---
|
|
|
|
|
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. |
|