on 07-14-2011 11:15 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 <===
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
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.