Table PROJECTS has a indesirable index
Bug #489284 reported by
Sacha Bruttin
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Global Health Observatory |
Fix Committed
|
Undecided
|
Unassigned | ||
Bug Description
There is an index on the column DB_SCHEMA_NAME that is causing problems when we create a new project.
The value of this column is concatenated to the value of the DEFAULT_FACT_TABLE column to define the path to the default fact table of the project in the OLAP Migration Utility.
We don't see any issue removing this index. Please remove it from the table schema.
Revision history for this message
| moores (moores) wrote | #1 |
| Changed in gho: | |
| milestone: | none → data-loader-1.0 |
| Changed in gho: | |
| status: | New → Fix Committed |
To post a comment you must log in.
The GHO application uses this value. It is true that removing this should not affect anything. Just to be clear though, teh value is not the default fact table, it is the default database name. In most cases this can be set to WHO_GHO_PROD, but it would be best if it were in some sort of key-value pair in a config file. For now, let's remove the constraint.