Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0045758
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2021-01-20 10:052021-02-01 08:06
Reporterprakashmurugesan88View Statuspublic 
Assigned Toprakashmurugesan88 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0045758: Build failed in try ret-highvol oracle suites

DescriptionBuild 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 Reproducehttps://cicd.openbravo.com/view/retail-highvol/job/ret-highvol-oracle/9/console [^]
TagsNo 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
Powered by Mantis Bugtracker