Openbravo Issue Tracking System - Retail Modules
View Issue Details
0045758Retail ModulesWeb POSpublic2021-01-20 10:052021-02-01 08:06
prakashmurugesan88 
prakashmurugesan88 
normalmajoralways
closedfixed 
5
 
 
marvintm
No
0045758: Build failed in try ret-highvol oracle suites
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.
https://cicd.openbravo.com/view/retail-highvol/job/ret-highvol-oracle/9/console [^]
No tags attached.
Issue History
2021-01-20 10:05prakashmurugesan88New Issue
2021-01-20 10:05prakashmurugesan88Assigned To => prakashmurugesan88
2021-01-20 10:05prakashmurugesan88Triggers an Emergency Pack => No
2021-01-20 10:06prakashmurugesan88Statusnew => scheduled
2021-01-20 10:08hgbotResolutionopen => fixed
2021-01-20 10:08hgbotStatusscheduled => resolved
2021-01-20 10:08hgbotNote Added: 0125665
2021-02-01 08:06marvintmReview Assigned To => marvintm
2021-02-01 08:06marvintmStatusresolved => closed

Notes
(0125665)
hgbot   
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
---