Skip to Content

Heterogeneous system copy SQL error -7055 Maxdb

Hallo.

I am executing heterogeneous system copy from oracle to MaxDB of my BI 7.0 system

I executed System Copy with SWPM 1.0 SP21 and it stops one packge with error:

DbSl Trace: EXECUTE on connection 0, rc=-7055 (POS(53) Column(s) already indexed:/BIC/E201365~P)

ERROR : Execute for create index /BIC/E201365~P on /BIC/E201365 failed (dbrc=99).

(SQL error -7055)

error message returned by DbSl:

SQL-Statement: CREATE INDEX "/BIC/E201365~P" ON "/BIC/E201365" ( "KEY_101365P" , "KEY_101365T" , "KEY_ZSD_C03U" , "KEY_1013651" , "KEY_1013652" , "KEY_1013653" , "KEY_1013654" , "KEY_1013655" , "KEY_1013656" , "KEY_1013657" , "KEY_1013658" , "KEY_1013659" , "KEY_101365A" , "KEY_101365B" )

POS(53) Column(s) already indexed:/BIC/E201365~P

Could you help me?

Thanks a lot

Mario

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 03, 2017 at 10:58 AM

    Hi Mario,

    Please check sap note 2142241 - SMIGR_CREATE_DDL: No DDL statement for temporary InfoCube conversion tables

    Hope this helps

    Regards

    Prithviraj

    Add comment
    10|10000 characters needed characters exceeded

    • The problem is that SMIGR_CREATE_DDL doesn't create script for many tables.

      Now I solved using:

      f.m. RSDDS_CHANGERUN_TMPTABLS_DEL

      Instead now, there are many dimension tables:

      .

      .

      .

      /BIC/D100472P /BIC/D100977T /BIC/D100978T /BIC/D100979T /BIC/D101105U /BIC/D101212U /BIC/D101083U /BIC/D101462U

      .

      .

      How could I cleanup them ?

      Thanks a lot

  • Oct 03, 2017 at 07:47 AM

    Please have a look to following note:

    1155785 - SQL error 7055 in heterogeneous system copy

    Add comment
    10|10000 characters needed characters exceeded