Skip to Content
0

Heterogeneous system copy SQL error -7055 Maxdb

Oct 03, 2017 at 07:31 AM

54

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Prithviraj Rajpurohit Oct 03, 2017 at 10:58 AM
0

Hi Mario,

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

Hope this helps

Regards

Prithviraj

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hallo.

I don't think that it is good for us because my table isn't of a temporary infocube

0

Hi Mario,

Then I guess you need to run report SMIGR_CREATE_DDL to generate SQL statement for these indexes to be created at target DB.

Perform Export again and then start import.

Regards,

Prithviraj

0

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

0
Bartosz Jarkowski Oct 03, 2017 at 07:47 AM
0

Please have a look to following note:

1155785 - SQL error 7055 in heterogeneous system copy

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hallo.

The note is already implemented on my system :
SAPKW70023

Furthermore, source system is Oracle

Thanks

0