cancel
Showing results for 
Search instead for 
Did you mean: 

No DDL commands found for activation of YCO_REPALVCOLOR

Former Member
0 Kudos

Hi Gurus,

we had a problem with one transport request which got successfully in Dev but failed in QUA environment.

Transport needs to create a table in Qua env, but it is comleted successfully with RC=0. but error found in "Import steps not specific to transport request".

Activate inactive runtime objects 12.07.2011 17:35:38 (8) Ended with errors

ABAP Dictionary Distribution 12.07.2011 17:42:04 (0) Successfully Completed

17:35:26: Retcode 1: error in DDL statement for YCO_REPALVCOLOR - repeat

Error 604-ORA-00604: error occurred at recursive SQL lev when executing ADD-FIELD of

Error in DDL statem when executing ADD-FIELD of

Error YCO_REPALVCOLOR when executing ADD-FIELD of

(dummy, do not translate)

No DDL commands found for activation of YCO_REPALVCOLOR

Could you please help me.

Regards

Sudhar

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Sudhar,

Could you provide import log on QA system?

Compare the table and data element on both QA and test system.

Best regards,

Orkun Gedik

Former Member
0 Kudos

Hi

here is Import log

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

Main import

Transport request : D<SID>K907261

System : Q<SID>

tp path : tp

Version and release: 340.16.63 640

R3trans version 6.13 (release 640 - 17.02.10 - 13:07:00).

unicode enabled version

===============================================

date&time : 12.07.2011 - 17:35:41

control file: /usr/sap/trans/tmp/D<SID>KK907261.Q<SID>

> #pid 2461838 on parva1102546 (Q<SID>adm)

> import

> buffersync=yes

> file='/usr/sap/trans/data/R907261.D<SID>'

> continuation='/usr/sap/trans/data/R907261_#.D<SID>'

> client=510

> csi=yes

> setunicodeflag yes

>

> excluding 'R3TRDDDD','R3TRDOMA','R3TRDTEL','R3TRENQU','R3TRMACO','R3TRMCID','R3TRMCOB','R3TRSHLP','R3TRSQLT','R3TRTABL','R3TRTTYP

R3trans was called as follows: R3trans -w /usr/sap/trans/tmp/D<SID>I907261.Q<SID> /usr/sap/trans/tmp/D<SID>KK907261.Q<SID>

Connected to DBMS = ORACLE dbs_ora_tnsname = 'Q<SID>' SYSTEM = 'Q<SID>'.

0 0

COMMIT (0).

trace at level 1 opened for a given file pointer

================== STEP 1 =====================

date&time : 12.07.2011 - 17:35:41

function : IMPORT

data file : /usr/sap/trans/data/R907261.D<SID>

Continuation: /usr/sap/trans/data/R907261_#.D<SID>

buffersync : YES

client : 510

repeatimport: NO

repeatclimp.: NO

c.s.i. : YES

setunicdflg: YES

l.s.m. : VECTOR

charsetadapt: YES

def. charset: WEUROPEAN

commit : 100000

table cache : 32000000

EXCLUDING : 'R3TRVIEW','R3TRUENO','R3TRTTYP','R3TRTABL','R3TRSQLT','R3TRSHLP','R3TRMCOB','R3TRMCID','R3TRMACO','R3TRENQU','R3TRDT

Data file is compressed with algorithm 'L'.

Export was executed on 12.07.2011 at 17:14:59 by D<SID>adm

640

with R3trans version: 17.02.10 - 13:07:00

Source System = IBM RS/6000 with AIX on DBMS = ORACLE dbs_ora_tnsname = 'D<SID>' SYSTEM = 'D<SID>'.

language vector during export: ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdi(),./:;

language vector during export: ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdi(),./:;& (ISO-ARHECSDEENFRELHUITJADAPLZFNLNOPTSKRUESTRFISVB

lsm during export: VECTOR

trfunction = K (transport to consolidation system)

Used Commandfile D<SID>K907261 (535646/3)

2 E071C entries created

Target client in E070C updated (510)

0 entries for E070 imported (D<SID>K907261).

0 entries for E071 imported (D<SID>K907261 *).

R3TRDTELYY_LINEID was not imported in this step

R3TRTABLYCO_REPALVCOLOR was not imported in this step

D<SID>K907261 touched.

636 636

COMMIT (6559).

6559 bytes read.

Transport overhead 40.1 %.

Data compressed to 9.8 %.

Duration: 0 sec (6559 bytes/sec).

0 0

Summary:

636 bytes modified in database.

[dev trc ,00000] Disconnecting from ALL connections: 26787 0.026787

[dev trc ,00000] Disconnecting from connection 0 ... 70 0.026857

[dev trc ,00000] Close user session (con_hdl=0,svchp=0x111415838,usrhp=0x111475f40)

501 0.027358

[dev trc ,00000] Detaching from DB Server (con_hdl=0,svchp=0x111415838,srvhp=0x111416718)

623 0.027981

[dev trc ,00000] Now connection 0 is disconnected 264 0.028245

[dev trc ,00000] Disconnected from connection 0 58 0.028303

[dev trc ,00000] statistics db_con_commit (com_total=2, com_tx=2)

67 0.028370

[dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0)

144 0.028514

Disconnected from database.

End of Transport (0000).

date&time: 12.07.2011 - 17:35:41

Main import

End date and time : 20110712173541

Ended with return code: ===> 0 <===

Former Member
0 Kudos

Hi,

Go to SE03 and search for the request(s) contain this object, then release it/them.

Another advise is executing the "tp" with "u128" parameter

Additionally, don't forget to check my previous statement;

>> Compare the table and data element on both QA and test system.

Best regards,

Orkun Gedik

Edited by: Orkun Gedik on Jul 14, 2011 1:50 PM