Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0054631 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [POS2] POS | major | sometimes | 2024-02-08 18:36 | 2024-02-25 14:14 | |||
| Reporter | rafademiguel | View Status | public | |||||
| Assigned To | alainperez | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 24Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| 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 | approved | |||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0054631: POS 2 Module has a hidden dependency over POS 2 Sampledata Module | |||||||
| Description | If you try to install a new environment with POS 2 and without POS 2 Sampledata Module you get this error: [createdatabase] 59527 [main] ERROR org.apache.ddlutils.DatabaseOperationException - Error while executing SQL -- END [createdatabase] ALTER TABLE AD_DATASET_TABLE [createdatabase] ADD CONSTRAINT AD_DATASET_TABLE_AD_DATASET FOREIGN KEY (AD_DATASET_ID) REFERENCES AD_DATASET (AD_DATASET_ID) [createdatabase] org.postgresql.util.PSQLException: ERROR: insert or update on table "ad_dataset_table" violates foreign key constraint "ad_dataset_table_ad_dataset" [createdatabase] Detail: Key (ad_dataset_id)=(312C2628FD8E42A2AE8DB4972C554FE0) is not present in table "ad_dataset". that UUID is from the POS 2 Sampledata Module and if you look for the UUID you will notice is POS2 who is expecting to have this dataset present ./org.openbravo.pos2/src-db/database/sourcedata/AD_DATASET_TABLE.xml:<!--9B8BDF75D7E14F9181AF09DD5A77D827--> <AD_DATASET_ID><![CDATA[312C2628FD8E42A2AE8DB4972C554FE0]]></AD_DATASET_ID> | |||||||
| Steps To Reproduce | install a new environment with POS2 and without POS 2 SampleData Module run install.source | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0160865) hgbot (developer) 2024-02-17 04:58 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2433 [^] |
|
(0160917) hgbot (developer) 2024-02-19 15:07 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/merge_requests/75 [^] |
|
(0160957) hgbot (developer) 2024-02-20 07:38 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^] Changeset: c032826d102573a9234990d3ea38ad13f80fa629 Author: Alain Pérez Balart <alain.perez@doceleguas.com> Date: 20-02-2024 06:38:30 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/c032826d102573a9234990d3ea38ad13f80fa629 [^] Fixed ISSUE-54631: Removed wrong relation of Sampledata dataset --- M src-db/database/sourcedata/AD_DATASET_TABLE.xml --- |
|
(0160958) hgbot (developer) 2024-02-20 07:38 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2433 [^] |
|
(0160959) hgbot (developer) 2024-02-20 07:38 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/merge_requests/75 [^] |
|
(0160960) hgbot (developer) 2024-02-20 07:38 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata [^] Changeset: 8d93a7d5783da2b59a083c377b6945d786e5a2be Author: Alain Pérez Balart <alain.perez@doceleguas.com> Date: 20-02-2024 06:38:32 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2.sampledata/-/commit/8d93a7d5783da2b59a083c377b6945d786e5a2be [^] Fixed ISSUE-54631: Updated dataset with a pending POS2 dataset --- M src-db/database/sourcedata/AD_DATASET_TABLE.xml --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2024-02-08 18:36 | rafademiguel | New Issue | |
| 2024-02-08 18:36 | rafademiguel | Assigned To | => Retail |
| 2024-02-08 18:36 | rafademiguel | OBNetwork customer | => OBPS |
| 2024-02-08 18:36 | rafademiguel | Triggers an Emergency Pack | => No |
| 2024-02-13 09:13 | guillermogil | Assigned To | Retail => alainperez |
| 2024-02-15 09:43 | Mitchunlap | Note Added: 0160783 | |
| 2024-02-15 11:47 | Mitchunlap | Note Edited: 0160783 | View Revisions |
| 2024-02-15 11:47 | Mitchunlap | Note Edited: 0160783 | View Revisions |
| 2024-02-15 11:47 | Mitchunlap | Note Edited: 0160783 | View Revisions |
| 2024-02-16 04:46 | alainperez | Status | new => scheduled |
| 2024-02-16 08:48 | priyam | Note Deleted: 0160783 | |
| 2024-02-17 04:58 | hgbot | Merge Request Status | => open |
| 2024-02-17 04:58 | hgbot | Note Added: 0160865 | |
| 2024-02-19 15:07 | hgbot | Note Added: 0160917 | |
| 2024-02-20 07:37 | hgbot | Merge Request Status | open => approved |
| 2024-02-20 07:38 | hgbot | Resolution | open => fixed |
| 2024-02-20 07:38 | hgbot | Status | scheduled => closed |
| 2024-02-20 07:38 | hgbot | Fixed in Version | => 24Q2 |
| 2024-02-20 07:38 | hgbot | Note Added: 0160957 | |
| 2024-02-20 07:38 | hgbot | Note Added: 0160958 | |
| 2024-02-20 07:38 | hgbot | Note Added: 0160959 | |
| 2024-02-20 07:38 | hgbot | Note Added: 0160960 | |
| 2024-02-25 14:14 | Ivanrtiz | Note Added: 0161217 | |
| 2024-04-10 16:36 | shuehner | Note Deleted: 0161217 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |