Skip to Content
0
Former Member
Jun 05, 2009 at 10:17 AM

Creation of secondary indexes for table "RSBATCHCTRL_PAR" failed

39 Views

Hi ,

We have installed EHP1 on our BI7.0 system successfully, later we are trying to apply SPS01 for this EHP but we got the follwoing error during TBATG conversion.

2 EGT092 Conversion of table "RSBATCHCTRL_PAR" was restarted

2 EGT241 The conversion is continued at step "6"

2 EGT246 Type of conversion: "T" -> "T"

2 EGT240XBegin step "RSBATCHCTRL_PAR-STEP6":

4 EGT281 sql:

4 ED0314 CREATE

4 ED0314 INDEX [RSBATCHCTRL_PAR~DB] ON [RSBATCHCTRL_PAR]

4 ED0314 ( [JOBNAME] ,

4 ED0314 [JOBCOUNT] ,

4 ED0314 [SERVER] ,

4 ED0314 [HOST] ,

4 ED0314 [WP_NO] ,

4 ED0314 [WP_PID] ,

4 ED0314 [PROCESS_TYPE] )

4 ED0314 WITH ( ONLINE=OFF )

4 ED0314 ON [PRIMARY]

2 ED0314 Line 1: Incorrect syntax near '('.

3 EDA093 "DDL time(___1):" ".........6" milliseconds

2EEGT236 The SQL statement was not executed

2EEDI006 Index " " could not be created completely in the database

2EEGT221 Creation of secondary indexes for table "RSBATCHCTRL_PAR" failed

2EEGT239 Error in step "RSBATCHCTRL_PAR-STEP6"

2 EGT253XTotal time for table "RSBATCHCTRL_PAR": "000:00:00"

2EEGT094 Conversion could not be restarted

2 EGT067 Request for "RSBATCHCTRL_PAR" could not be executed

1 ED0327XProcess..................: "ferrari_12"

1 ED0302X=========================================================================

1 ED0314 DD: Execution of Database Operations

1 ED0302 =========================================================================

1 ED0327 Process..................: "ferrari_12"

1 ED0319 Return code..............: "0"

1 ED0314 Phase 001................: < 1 sec. (Preprocessing of TBATG)

1 ED0314 Phase 002................: < 1 sec. (Partitioning)

1 ED0309 Program runtime..........: "< 1 sec."

1 ED0305 Date, time...............: "03.06.2009", "12:47:21"

1 ED0318 Program end==============================================================

1 ETP166 CONVERSION OF DD OBJECTS (TBATG)

1 ETP110 end date and time : "20090603124721"

1 ETP111 exit code : "8"

1 ETP199 ######################################

System properties:

-


SAP - BI7.0 with EHP1

Database - MSSQL 2000

OS - Windows2003

Please suggest.

Thanks in advance,

Pavan.