Demantra BAL error: The Index 'dollar (usd)' must have a table name definition in REAL_VALUES table.
Hi,
I am upgrading demantra from 12.2.3 to 12.2.8 right now and during the BAL import/upgrade I am constantly getting this error at the end:
Validating data for Index 'DOLLAR (USD)'...
Error: The Index 'dollar (usd)' must have a table name definition in REAL_VALUES table.
When I check the table REAL_VALUES then indeed there is no record for the dollar, while for other indexes there is:
select * from real_values;
REAL_VALUE_ID | REAL_VALUE | REAL_TABLE | CALCULATION_TYPE | IS_DEFAULT | APPLICATION_ID |
---|---|---|---|---|---|
0 | Dollar (USD) | 2 | REAL_VALUE:0 | ||
1 | Consumer Price Index | cpi | 1 | REAL_VALUE:1 | |
2 | Euro (EUR) | euro | 2 | REAL_VALUE:2 |