Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0031584 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | always | 2015-11-25 18:17 | 2016-02-11 17:46 | |||
| Reporter | ioritzCia | View Status | public | |||||
| Assigned To | ranjith_qualiantech_com | |||||||
| Priority | normal | Resolution | no change required | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 4af994a4bc5b | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| 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 | |||||||
| Tags | SER-QA | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
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 (viewer) 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. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |