Problem Note 54244: SAS® Merchandise Data Integration load fails with "ERROR: ORACLE execute error: ORA-01408: such column list already indexed."
SAS Merchandise Data Integration fails to load on the second attempt of a product load due to pre-existing indexes. After an initial failure, on the second attempt the load might fail again because SAS Merchandise Data Integration does not check for indexes on certain tables.
When you set the update_hierarchy flag set to Y during a hierarchy load, SAS Merchandise Data Integration expects to create indexes on certain tables then drop the indexes after statistics have been gathered. If the first attempt at this load fails before indexes have been dropped, any attempt to reload the data fails and the following error is generated:
MPRINT(DB_INDEX_ADD): execute ( create index ... on maxdata.mplan_working_m_orphans (workplan_id,merch_level,merch_id) ) by mmx_db;
ERROR: ORACLE execute error: ORA-01408: such column list already indexed.
If this issue is encountered, drop the index from the table indicated in the log.
Operating System and Release Information
| SAS System | SAS Merchandise Financial Planning | Microsoft Windows Server 2008 for x64 | 6.1.3 M6 | | | |
| Microsoft Windows Server 2008 R2 | 6.1.3 M6 | 6.6 | | 9.4 TS1M2 |
| Microsoft Windows Server 2003 for x64 | 6.1.3 M6 | | | |
| Linux for x64 | 6.6 | 6.6 | 9.4 TS1M2 | 9.4 TS1M2 |
| 64-bit Enabled AIX | 6.1.3 M6 | 6.6 | | 9.4 TS1M2 |
| 64-bit Enabled Solaris | 6.1.3 M6 | 6.6 | | 9.4 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
If a SAS Merchandise Data Integration load fails, the second attempt might also fail because indexes were not dropped from the first run. SAS Merchandise Data Integration does not check for pre-existing indexes on tables before attempting to create a new one.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2015-03-11 10:59:34 |
| Date Created: | 2014-10-02 10:59:29 |
