Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0045758 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Retail Modules] Web POS | major | always | 2021-01-20 10:05 | 2021-02-01 08:06 | |||
Reporter | prakashmurugesan88 | View Status | public | |||||
Assigned To | prakashmurugesan88 | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | ||||
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 | |||||||
Review Assigned To | marvintm | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0045758: Build failed in try ret-highvol oracle suites | |||||||
Description | Build failed in try ret-highvol oracle suites, https://cicd.openbravo.com/view/retail-highvol/job/ret-highvol-oracle/9/console [^] Error: [createdatabase] 43939 [main] WARN org.apache.ddlutils.platform.OracleStandardBatchEvaluator - -- END [createdatabase] CREATE INDEX EM_OBPOS_NAME_TRGM ON M_PRODUCT ((UPPER(NAME))) [createdatabase] 43944 [main] WARN org.apache.ddlutils.platform.OracleStandardBatchEvaluator - SQL Command failed with: ORA-01408: such column list already indexed [createdatabase] [createdatabase] 43944 [main] WARN org.apache.ddlutils.platform.OracleStandardBatchEvaluator - -- END [createdatabase] CREATE INDEX EM_OBPOS_UPC_TRGM ON M_PRODUCT ((UPPER(UPC))) [createdatabase] 43948 [main] WARN org.apache.ddlutils.platform.OracleStandardBatchEvaluator - SQL Command failed with: ORA-01408: such column list already indexed [createdatabase] [createdatabase] 43948 [main] WARN org.apache.ddlutils.platform.OracleStandardBatchEvaluator - -- END [createdatabase] CREATE INDEX EM_OBPOS_VALUE_TRGM ON M_PRODUCT ((UPPER(VALUE))) [createdatabase] 58398 [main] INFO org.apache.ddlutils.platform.OracleStandardBatchEvaluator - Executed 15534 SQL command(s) with 3 error(s) in 29479 ms [createdatabase] 58398 [main] ERROR org.openbravo.ddlutils.task.CreateDatabase - Error creating database [createdatabase] java.lang.Exception: There were serious problems while creating the database. Please review and fix them before continuing with the creation of the database. There are more than one index for the same column. Remove duplicate indexes. | |||||||
Steps To Reproduce | https://cicd.openbravo.com/view/retail-highvol/job/ret-highvol-oracle/9/console [^] | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0125665) hgbot (developer) 2021-01-20 10:08 |
Repository: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.highvolumesconfig [^] Changeset: c96bab0b8f8d53420aa4c470a41aa00aaedb9849 Author: Prakash M <prakash@qualiantech.com> Date: 2021-01-20T14:37:22+05:30 URL: https://gitlab.com/openbravo/ci/modules/org.openbravo.retail.highvolumesconfig/-/commit/c96bab0b8f8d53420aa4c470a41aa00aaedb9849 [^] Fixed BUG-45758: Removed index in M_Product that was included in PosTerminal module * Updated dependency version of PosTerminal, as removed indexes are added in that version --- M src-db/database/model/modifiedTables/M_PRODUCT.xml M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml --- |
Issue History | |||
Date Modified | Username | Field | Change |
2021-01-20 10:05 | prakashmurugesan88 | New Issue | |
2021-01-20 10:05 | prakashmurugesan88 | Assigned To | => prakashmurugesan88 |
2021-01-20 10:05 | prakashmurugesan88 | Triggers an Emergency Pack | => No |
2021-01-20 10:06 | prakashmurugesan88 | Status | new => scheduled |
2021-01-20 10:08 | hgbot | Resolution | open => fixed |
2021-01-20 10:08 | hgbot | Status | scheduled => resolved |
2021-01-20 10:08 | hgbot | Note Added: 0125665 | |
2021-02-01 08:06 | marvintm | Review Assigned To | => marvintm |
2021-02-01 08:06 | marvintm | Status | resolved => closed |
Copyright © 2000 - 2009 MantisBT Group |