error when rebuilding the index through brtools.

Former Member · ‎02-12-2009

Hi Experts,

We are getting the error (pls check discription as per below) while rebuild the index on our prod server.

Environment :-ECC 5.0 with oracle 9i on WIN 2003 server

Microsoft Windows [Version 5.2.3790]

C:\Documents and Settings\eccadm>brtools

BR0651I BRTOOLS 6.40 (15)

BR0280I BRTOOLS time stamp: 2009-02-12 11.31.46

BR0656I Choice menu 1 - please make a selection

-

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

2

BR0280I BRTOOLS time stamp: 2009-02-12 11.31.50

BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2009-02-12 11.31.50

BR0656I Choice menu 5 - please make a selection

-

Database space management

1 = Extend tablespace

2 - Create tablespace

3 - Drop tablespace

4 - Alter tablespace

5 - Alter data file

6 - Move data file

7 - Additional space functions

8 - Reset input values

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

b

BR0280I BRTOOLS time stamp: 2009-02-12 11.31.57

BR0663I Your choice: 'b'

BR0673I Going back to the previous menu...

BR0280I BRTOOLS time stamp: 2009-02-12 11.31.57

BR0656I Choice menu 1 - please make a selection

-

BR*Tools main menu

1 = Instance management

2 - Space management

3 - Segment management

4 - Backup and database copy

5 - Restore and recovery

6 - Check and verification

7 - Database statistics

8 - Additional functions

9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

3

BR0280I BRTOOLS time stamp: 2009-02-12 11.31.58

BR0663I Your choice: '3'

BR0280I BRTOOLS time stamp: 2009-02-12 11.31.58

BR0656I Choice menu 7 - please make a selection

-

Database segment management

1 = Reorganize tables

2 - Rebuild indexes

3 - Export tables

4 - Import tables

5 - Alter tables

6 - Alter indexes

7 - Additional segment functions

8 - Reset input values

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

2

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.01

BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.01

BR0657I Input menu 92 - please check/enter input values

-

BRSPACE options for rebuild of indexes

1 - BRSPACE profile (profile) ...... [initECC.sap]

2 - Database user/password (user) .. [/]

3 ~ Rebuild action (action) ........ []

4 ~ Tablespace names (tablespace) .. []

5 ~ Index owner (owner) ............ []

6 ~ Table names (table) ............ []

7 ~ Index names (index) ............ []

8 - Confirmation mode (confirm) .... [yes]

9 - Scrolling line count (scroll) .. [20]

10 - Message language (language) .... [E]

11 - BRSPACE command line (command) . [-p initECC.sap -s 20 -l E -f idrebuild]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

7

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.13

BR0663I Your choice: '7'

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.13

BR0681I Enter string value for "index" []:

SAPECC.CEFORMW~0

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.27

BR0683I New value for "index": 'SAPECC.CEFORMW~0'

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.27

BR0657I Input menu 92 - please check/enter input values

-

BRSPACE options for rebuild of indexes

1 - BRSPACE profile (profile) ...... [initECC.sap]

2 - Database user/password (user) .. [/]

3 ~ Rebuild action (action) ........ []

4 ~ Tablespace names (tablespace) .. []

5 ~ Index owner (owner) ............ []

6 ~ Table names (table) ............ []

7 ~ Index names (index) ............ [SAPECC.CEFORMW~0]

8 - Confirmation mode (confirm) .... [yes]

9 - Scrolling line count (scroll) .. [20]

10 - Message language (language) .... [E]

11 - BRSPACE command line (command) . [-p initECC.sap -s 20 -l E -f idrebuild -i

"SAPECC.CEFORMW~0"]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.30

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initECC.sap -s 20 -l E -f idreb

uild -i "SAPECC.CEFORMW~0"'

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.30

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2009-02-12 11.32.32

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

BR1001I BRSPACE 6.40 (15)

BR1002I Start of BRSPACE processing: sdzxheyq.idr 2009-02-12 11.32.32

BR0280I BRSPACE time stamp: 2009-02-12 11.32.34

BR1009I Name of database instance: ECC

BR1010I BRSPACE action ID: sdzxheyq

BR1011I BRSPACE function ID: idr

BR1012I BRSPACE function: idrebuild

BR0280I BRSPACE time stamp: 2009-02-12 11.32.36

BR1039I Selecting information about tables and indexes...

BR0285I This function can take several seconds/minutes - be patient...

BR0280I BRSPACE time stamp: 2009-02-12 11.32.39

BR0814I Number of tables in schema of owner SAPECC: 43103

BR0280I BRSPACE time stamp: 2009-02-12 11.32.42

BR0815I Number of indexes in schema of owner SAPECC: 51463

BR0280I BRSPACE time stamp: 2009-02-12 11.32.42

BR0657I Input menu 356 - please check/enter input values

-

Options for rebuild of indexes: SAPECC.CEFORMW~0 (degree 1)

1 ~ New destination tablespace (newts) . []

2 - Parallel threads (parallel) ........ [1]

3 ~ Index parallel degree (degree) ..... []

4 - SQL command (command) .............. [alter index "SAPECC"."CEFORMW~0" rebu

ild online]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2009-02-12 11.32.49

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2009-02-12 11.32.49

BR1151I Starting online index rebuilding...

BR0280I BRSPACE time stamp: 2009-02-12 11.32.50

BR0301E SQL error -8120 at location BrSqlExecute-1

ORA-08120: Need to create SYS.IND_ONLINE$ table in order to (re)build index

BR1017E Execution of SQL statement 'alter index "SAPECC"."CEFORMW~0" rebuild onl

ine' failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to

repeat the last actionBR0280I BRSPACE time stamp: 2009-02-12 11.32.50

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

Thanks in advance.

Former Member · ‎02-18-2009

Hi Amit,

Try to check this note: 682926

You must repeat the import of the script catcio.sql and check that all other actions from Note 539921 have been executed correctly.

Regards,

Kiran M

Former Member · ‎02-18-2009

Hi Amit,

here u go....

Cause: Alter index Build/Rebuild online require existing of SYS.IND_ONLINE$ table.

Action: User/DBA needs to create sys.ind_online$ table before alter the index /rdbms/admin/catcio.sql contains script to create ind_online$.

You Need to create SYS.IND_ONLINE$ table in order to (re)build index

Thanks

Rhishabh

Former Member · ‎02-12-2009

Dear Amit,

You may need to run script catcio.sql, also please check note: 682926.

Regards,

Sreenivas .Y

error when rebuilding the index through brtools.

Accepted Solutions (0)

Answers (3)

Answers (3)

Re: Not able to see run button on dataflow

Re: Struggling with Filters on Select - Fiori App

Re: Lookup logic in Integration suite

Re: CF Deployment Error: Error getting tenant t0

Re: Encountering a script error on the Crystal Rep...