Error ORA-01502 In Upgrep - Step Import Repositories (Doc ID 2189245.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 16.0 [IP2016] and later
Information in this document applies to any platform.

Symptoms

When attempting to run upgrep from 15.4 to IP16 the following error occurs.

ERROR
-----------------------
SQLError Statement 0 0000000257eb01b4:0 2016-09-28 14:25:02 SQL Statement:
insert into SIEBEL.S_APLT_BRSSCRPT (APPLET_ID,
COMMENTS,
CONFLICT_ID,
CREATED,
CREATED_BY,
DB_LAST_UPD,
DB_LAST_UPD_SRC,
HIGH_INTERACT_FLG,
INACTIVE_FLG,
LAST_UPD,
LAST_UPD_BY,
MODIFICATION_NUM,
NAME,
PROCEDURE_NAME,
REPOSITORY_ID,
ROW_ID,
SCRIPT,
SSE_FLG,
SST_FLG,
SSV_FLG,
USER_AGENT_CD) values (?, ?, ?, ?, ?, current_date, 'repimexp', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

DBCLog DBCLogError 1 0000000257eb01b4:0 2016-09-28 14:25:02 [tp][ODBC Oracle driver][Oracle]ORA-01502: index 'SIEBEL.S_APLT_BRSSCRPT_P1' or partition of such index is in unusable state

SQLDBUtilityLog SQLDBUtilityLog 3 0000000257eb01b4:0 2016-09-28 14:25:02

SQLDBUtilityLog SQLDBUtilityLog 3 0000000257eb01b4:0 2016-09-28 14:25:02 S1000: [tp][ODBC Oracle driver][Oracle]ORA-01502: index 'SIEBEL.S_APLT_BRSSCRPT_P1' or partition of such index is in unusable state


STEPS
-----------------------
1. install 16.5
2. run upgrep
3. error occurs on the logs

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms