regarding client export/import

[former_member182505]

Dear Gurus

i m using ECC6 on windows with MS SQL.

i have a landscape with DEV->QAS->PRD

i want to make a copy of PRD on DEV server.

with the use of client Export/inport.

My query Is?

can we make it directly on DEV.

kindly do the need full.

thanks/warm regards

[Former Member · Accepted solution]

Client export/import is like a type of client copy only where you export the client data from one system and import in another system

Now ideally you should be doing this from production to qa

do you want to do this on dev?why

Rohit

[former_member182505 · Accepted solution]

hi

there not enough space in QAS. thats y?

[Former Member · Accepted solution]

why do you want to client export/import?what is the need

Also I would suggest you create a new client in dev and then export data from production to dev

Also you can free up some space in qa by deleting some unused client

Rohit

[former_member182505 · Accepted solution]

hi

thanks

i have made a new client in DEV and exported from PRD. its exported sucssessfully.

while importing its giving return code 8.

thanks

[Former Member · Accepted solution]

please tell does the error logs say?

then only we can help you

Rohit

[former_member182505 · Accepted solution]

hi

U

Log File:
SAPDEV\sapmnt\trans\log\P01IT00030.D01

3S ######################################

Main import

Transport request : P01KT00030

System : D01

tp path : tp

Version and release: 372.04.04 700

Main import

End date and time : 20090514105856

8O Ended with return code: ===> 8 <===

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

3S3T ######################################

Main import

Transport request : P01KT00030

System : D01

tp path : tp

Version and release: 372.04.04 700

8O Table P05FBN_AC_GROEP is not in nametab

8O Table P05FBN_AFWPL is not in nametab

8O Table P05FBN_AFWPL_IND is not in nametab

8O Table P05FBN_BRON_BST is not in nametab

8O Table P05FBN_BRON_EIG is not in nametab

8O Table P05FBN_BSTGRP is not in nametab

8O Table P05FBN_CATEGORIE is not in nametab

8O Table P05FBN_CMB_CONTR is not in nametab

8O Table P05FBN_DLVR_EIG is not in nametab

8O Table P05FBN_DOELVRT is not in nametab

8O Table P05FBN_DOEL_EIG is not in nametab

8O Table P05FBN_KEUZEMOD is not in nametab

8O Table P05FBN_KMOD_PRGR is not in nametab

8O Table P05FBN_PLTYP_EIG is not in nametab

8O Table P05FBN_VERR is not in nametab

8O Table P05FBN_WZR_PLAN is not in nametab

8O Table P05T_NO_XML_TAG is not in nametab

8O Table T51CE is not in nametab

8O Table T51CET is not in nametab

8O Table T52E_ARFC is not in nametab

8O Table T52E_ARFCT is not in nametab

8O Table T5A7V is not in nametab

8O Table T5A8A is not in nametab

8O Table T5A8B is not in nametab

8O Table T5A8C is not in nametab

8O Table T5A8D is not in nametab

8O Table T5A8E is not in nametab

8O Table T5A8F is not in nametab

8O Table T5A8G is not in nametab

8O Table T5A8H is not in nametab

8O Table T5A8HRAT_CLCP_FT is not in nametab

8O Table T5A8HRAT_CLCP_FV is not in nametab

8O Table T5A8J is not in nametab

8O Table T5APBS16 is not in nametab

8O Table T5APBS17 is not in nametab

8O Table T5APBS18 is not in nametab

8O Table T5APBS19 is not in nametab

8O Table T5APBS20 is not in nametab

8O Table T5APBS21 is not in nametab

8O Table T5B5D is not in nametab

8O Table T5BFP is not in nametab

8O Table T5BFPT is not in nametab

8O Table T5BFT is not in nametab

8O Table T5BVW is not in nametab

8O Table T5BX2 is not in nametab

8O Table T5BX3 is not in nametab

8O Table T5BX4 is not in nametab

8O Table T5C21 is not in nametab

8O Table T5C21T is not in nametab

8O Table T5C22 is not in nametab

8O Table T5C22T is not in nametab

8O Table T5C50 is not in nametab

8O Table T5C51 is not in nametab

8O Table T5C52 is not in nametab

8O Table T5CSK is not in nametab

8O Table T5CSKT is not in nametab

8O Table T5CSL is not in nametab

8O Table T5CSLT is not in nametab

8O Table T5CSM is not in nametab

8O Table T5CSMT is not in nametab

8O Table T5D8AE is not in nametab

8O Table T5D8BE is not in nametab

8O Table T5D8CE is not in nametab

8O Table T5D8DE is not in nametab

8O Table T5DB_SKBER is not in nametab

8O Table T5DPBS0E is not in nametab

8O Table T5DPBS0F is not in nametab

8O Table T5DPBS1D is not in nametab

8O Table T5DPBS1E is not in nametab

8O Table T5DPBS3E is not in nametab

8O Table T5DPBS_VA_UB is not in nametab

8O Table T5DWOG is not in nametab

8O Table T5DWOGT is not in nametab

8O Table T5E4A is not in nametab

8O Table T5E4F is not in nametab

8O Table T5E4G is not in nametab

8O Table T5E4H is not in nametab

8O Table T5E4I is not in nametab

8O Table T5E4J is not in nametab

8O Table T5E4JT is not in nametab

8O Table T5ED1 is not in nametab

8O Table T5ED1T is not in nametab

8O Table T5ED2 is not in nametab

8O Table T5ED2T is not in nametab

8O Table T5ED3 is not in nametab

8O Table T5ED3T is not in nametab

8O Table T5ED4 is not in nametab

8O Table T5ED4T is not in nametab

8O Table T5ED5 is not in nametab

8O Table T5ED5T is not in nametab

8O Table T5ED6 is not in nametab

8O Table T5ED6T is not in nametab

8O Table T5ED7 is not in nametab

8O Table T5ED7T is not in nametab

8O Table T5ED8 is not in nametab

8O Table T5ED8T is not in nametab

8O Table T5ED9 is not in nametab

8O Table T5ED9T is not in nametab

8O Table T5EF1 is not in nametab

8O Table T5EF7 is not in nametab

8O Table T5F1BA is not in nametab

8O Table T5F1BAT is not in nametab

8O Table T5F99FAM is not in nametab

8O Table T5F99FMS is not in nametab

8O Table T5F99FMST is not in nametab

8O Table T5F99M1 is not in nametab

8O Table T5F99M1T is not in nametab

8O Table T5F99M2 is not in nametab

8O Table T5F99M2T is not in nametab

8O Table T5F99M3 is not in nametab

8O Table T5F99M3T is not in nametab

8O Table T5F99M4 is not in nametab

8O Table T5F99M4T is not in nametab

8O Table T5F99M5 is not in nametab

8O Table T5F99MC is not in nametab

8O Table T5F99MCT is not in nametab

8O Table T5FPBS1AF is not in nametab

8O Table T5FPBSD15 is not in nametab

8O Table T5FPBSD16 is not in nametab

8O Table T5ITA4 is not in nametab

8O Table T5ITFC is not in nametab

8O Table T5ITFS is not in nametab

8O Table T5ITO2 is not in nametab

8O Table T5N0E is not in nametab

8O Table T5N0F is not in nametab

8O Table T5N23 is not in nametab

8O Table T5N24 is not in nametab

8O Table T5PPBS2F is not in nametab

8O Table T5PPBS5P is not in nametab

8O Table T5PPBS6G is not in nametab

8O Table T5PPBS6T is not in nametab

8O Table T5PPBS7I is not in nametab

8O Table T5PPBS7O is not in nametab

8O Table T5PPBS7OT is not in nametab

8O Table T5PPBS7P is not in nametab

8O Table T5PPBS7PT is not in nametab

8O Table T5PPBS8A is not in nametab

8O Table T5PPBS8B is not in nametab

8O Table T5PPBS9C is not in nametab

8O Table T5PPBSAB is not in nametab

8O Table T5QTK is not in nametab

8O Table T5QTS is not in nametab

8O Table T5SAC is not in nametab

8O Table T5SAT is not in nametab

8O Table T5SMT is not in nametab

8O Table T5UVET is not in nametab

8O Table T5UVETT is not in nametab

8O Table T5VBF is not in nametab

8O Table T5VOT is not in nametab

8O Table T77TNMFR_TY is not in nametab

8O Table T77TNM_CA is not in nametab

8O Table T77TNM_CG is not in nametab

8O Table T77TNM_CL is not in nametab

8O Table T77TNM_DC is not in nametab

8O Table T77TNM_FC is not in nametab

8O Table T77TNM_IV is not in nametab

8O Table T77TNM_LR is not in nametab

8O Table T799BEFG is not in nametab

8O Table T799BFOR is not in nametab

8O Table T799BMFG is not in nametab

8O Table T799BRNDM is not in nametab

8O Table T799BSFG is not in nametab

8O Table T799BSFT is not in nametab

8O Table T799L40 is not in nametab

8O Table T799L41 is not in nametab

8O Table T7AR08 is not in nametab

8O Table T7AR09 is not in nametab

8O Table T7ARM10 is not in nametab

8O Table T7ARM11 is not in nametab

8O Table T7ARM6 is not in nametab

8O Table T7ARM7 is not in nametab

8O Table T7ARM8 is not in nametab

8O Table T7CN39 is not in nametab

8O Table T7CN39T is not in nametab

8O Table T7DEPBSNV01 is not in nametab

8O Table T7DEPBSNV01T is not in nametab

8O Table T7DEPBSNV02 is not in nametab

8O Table T7DEPBSNV02T is not in nametab

8O Table T7DEPBSNV03 is not in nametab

8O Table T7DEPBSNV03T is not in nametab

8O Table T7DEPBSNV04 is not in nametab

8O Table T7DEPBSNV04T is not in nametab

8O Table T7DEPBSNV05 is not in nametab

8O Table T7DEPBSNV05T is not in nametab

8O Table T7DEPBSNV06 is not in nametab

8O Table T7DEPBSNV06T is not in nametab

8O Table T7DEPBSNV07 is not in nametab

8O Table T7DEPBSNV08 is not in nametab

8O Table T7DEPBSNV0A is not in nametab

8O Table T7DEPBSNV0B is not in nametab

8O Table T7DEPBSNV0C is not in nametab

8O Table T7DEPBSNV0D is not in nametab

8O Table T7DEPBSXXAWE01 is not in nametab

8O Table T7DEPBSXXAWE01T is not in nametab

8O Table T7DEPBSXXAWE0A is not in nametab

8O Table T7DEPBSXXZUS1A is not in nametab

8O Table T7DEPBSXXZUS1AT is not in nametab

8O Table T7DEPBSXXZUS2A is not in nametab

8O Table T7DEPBSXXZUS2AT is not in nametab

8O Table T7DEPBSXXZUS3A is not in nametab

8O Table T7FI09 is not in nametab

8O Table T7FI10 is not in nametab

8O Table T7FI15 is not in nametab

8O Table T7FI16 is not in nametab

8O Table T7FI17 is not in nametab

8O Table T7FIVAC is not in nametab

8O Table T7IEA is not in nametab

8O Table T7INU1 is not in nametab

8O Table T7INU2 is not in nametab

8O Table T7INU3 is not in nametab

8O Table T7INU5 is not in nametab

8O Table T7JPSI_INR_ASN is not in nametab

8O Table T7JPSI_INSURER is not in nametab

8O Table T7JPSI_INSURERT is not in nametab

8O Value of field T7KRC6-JOBTY truncated to '0'

8O Value of field T7KRC6-JOBTY truncated to '0'

8O Value of field T7KRC6-JOBTY truncated to '0'

8O Value of field T7KRC6-JOBTY truncated to '0'

8O Value of field T7KRC6-JOBTY truncated to '0'

8O Value of field T7KRC7-JOBTY truncated to '0'

8O Value of field T7KRC7-JOBTY truncated to '0'

8O Value of field T7KRC7-JOBTY truncated to '0'

8O Value of field T7KRC7-JOBTY truncated to '0'

8O Value of field T7KRC7-JOBTY truncated to '0'

8O Table T7KRST is not in nametab

8O Table T7RU51AV_C is not in nametab

8O Table T7RU9A_GRP is not in nametab

8O Table T7RU9GP is not in nametab

8O Table T7RU9GRP is not in nametab

8O Table T7RU9GRP_T is not in nametab

8O Table T7RU9PAR is not in nametab

8O Table T7RU9PAR_T is not in nametab

8O Table T7RUOC1 is not in nametab

8O Table T7RUOC2 is not in nametab

8O Table T7RUOC2T is not in nametab

8O Table T7RUPACKAGETYPE is not in nametab

8O Table T7RUPACKAGETYPET is not in nametab

8O Table T7RUPFRULE3 is not in nametab

8O Table T7RUSTATUS is not in nametab

8O Table T7RUSTATUST is not in nametab

8O Table T7RUWCS is not in nametab

8O Table T7RU_99F0 is not in nametab

8O Table T7RU_99FF is not in nametab

8O Table T7RU_DEFTXT is not in nametab

8O Table T7RU_DISCEND is not in nametab

8O Table T7RU_MILAGEL is not in nametab

8O Table T7RU_STAT_VAR is not in nametab

8O Table T7RU_STAT_VAR_T is not in nametab

8O Table T7RU_STAT_VFLD is not in nametab

8O Table T7RU_STAT_VFLD_T is not in nametab

8O Table T7UNAAP_ATTRIBS is not in nametab

8O Table T7UNOM_FUNDT is not in nametab

8O Table T7UNOM_FUNDT_T is not in nametab

8O Table T7UNOM_FUND_POS is not in nametab

8O Table T7UNOM_OUTYPE is not in nametab

8O Table T7UNOM_OUTYPE_T is not in nametab

8O Table T7UNOM_POSIT is not in nametab

8O Table T7UNOM_POSIT_T is not in nametab

8O Table T7UNPAD03 is not in nametab

8O Table T7UNPAD_DS is not in nametab

8O Table T7UNPAD_DS0P is not in nametab

8O Table T7UNPAD_DS1P is not in nametab

8O Table T7UNPAD_DSCA is not in nametab

8O Table T7UNPAD_DSCA_T is not in nametab

8O Table T7UNPAD_DSHE is not in nametab

8O Table T7UNPAD_DSLC is not in nametab

8O Table T7UNPAD_DSLC_T is not in nametab

8O Table T7UNPAD_DSME is not in nametab

8O Table T7UNPAD_DSPA is not in nametab

8O Table T7UNPAD_DSRE is not in nametab

8O Table T7UNPAD_DS_T is not in nametab

8O Table T7UNPAD_EG03 is not in nametab

8O Table T7UNPAD_EG05 is not in nametab

8O Table T7UNPAD_EG30 is not in nametab

8O Table T7UNPAD_EGAMT is not in nametab

8O Table T7UNPAD_EGCAQ is not in nametab

8O Table T7UNPAD_EGCAQ_T is not in nametab

8O Table T7UNPAD_EGCL is not in nametab

8O Table T7UNPAD_EGCL_T is not in nametab

8O Table T7UNPAD_EGCOS is not in nametab

8O Table T7UNPAD_EGCOS_T is not in nametab

8O Table T7UNPAD_EGPSH is not in nametab

8O Table T7UNPAD_EGRS is not in nametab

8O Table T7UNPAD_EGRS_T is not in nametab

8O Table T7UNPAD_EGSG is not in nametab

8O Table T7UNPAD_EGSG_T is not in nametab

8O Table T7UNPAD_EGSN is not in nametab

8O Table T7UNPAD_EGST is not in nametab

8O Table T7UNPAD_EGST_T is not in nametab

8O Table T7UNPAD_GA is not in nametab

8O Table T7UNPAD_HSFA is not in nametab

8O Table T7UNPAD_MBFA is not in nametab

8O Table T7UNPAD_NRFA is not in nametab

8O Table T7UNPAD_PFST is not in nametab

8O Table T7UNPAD_PFST_T is not in nametab

8O Table T7UNPAD_PFUN is not in nametab

8O Table T7UNPAD_PFUN_T is not in nametab

8O Table T7UNPAD_PSGR is not in nametab

8O Table T7UNPAD_PSGRT is not in nametab

8O Table T7UNPAD_RSCH is not in nametab

8O Table T7UNPAD_RSCH_T is not in nametab

8O Table T7UNPAD_RSDR is not in nametab

8O Table T7UNPAD_RSDR_T is not in nametab

8O Table T7UNPAD_RSRR is not in nametab

8O Table T7UNPAD_RULESSER is not in nametab

8O Table T7UNPAD_RULES_CT is not in nametab

8O Table T7UNPAD_SLGR is not in nametab

8O Table T7UNPAD_SLGR_T is not in nametab

8O Table T7UNPAD_SLQU is not in nametab

8O Table T7UNPAD_STATUS16 is not in nametab

8O Table T7US_ETA_OVMTH is not in nametab

8O Table T7US_ETA_OVMTH_T is not in nametab

Main import

End date and time : 20090514120713

8O Ended with return code: ===> 8 <===

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

3S ######################################

Main import

Transport request : P01KT00030

System : D01

tp path : tp

Version and release: 372.04.04 700

Main import

End date and time : 20090514152705

8O Ended with return code: ===> 8 <===

[Former Member · Accepted solution]

Sadiq

are your dev and production systems on same support pack level?

If not then you will not be able to import the data in dev

Rohit

[former_member182505 · Accepted solution]

Hi Rohit

i have

basis 14

abap 14

appl 12 with the both system...

kindly tell me what is the latest patch level released by the sap..

thanks

[Former Member · Accepted solution]

Hi

You can check the latest patch from marketplace.

are your all SAP components in dev and prd on same patch level?

If yes I guess there is a problem with the way you exported the client.Which profile did you choose?

Also can you tell what is the procedure that you followed for exporting the client and what is the procedure that you are following for importing the client?

Also how many transport requests were made when you exported the client?

Rohit

[Former Member · Accepted solution]

Please see note 557132

[former_member182505 · Accepted solution]

hi rohit

only HR patch is not matcheing.

there is 2 TR gentated.

thanks

[Former Member · Accepted solution]

Hello Sadiq

I would recommend you to bring HR patches to the same leve and then do client import again

Also generally 3 transport requests are generated depending on the profile used.Can you tell which profile you used

Rohit

[former_member182505 · Accepted solution]

Hi Rohit

I found some more detail abt this...

i think there is some change made in PRD directly and for this reason the tables r not matching with the DEV.

wht u suggested?

Target Client 550

Source Client 200

Copy Type Copy by Transport Req

Transport Request D01K902616

Status Completed w. Dictiona

User SAPADMIN

Start on 22.05.2009 / 17:07:07

Last Entry on 22.05.2009 / 17:07:11

Statistics for this Run

- No. of Tables 0 of

- Lines in Old Objects 0

- Lines in New Objects 0

Warnings and Errors

Table Name Component Package

SHDFVGUICU BC-ABA-TV Table Cross-Client

SHDGUIXT BC-ABA-TV Table Cross-Client

SHDGXTCODE BC-ABA-TV Table Cross-Client

SHDSVCI BC-ABA-TV Table Cross-Client

SHDSVFVCI BC-ABA-TV Table Cross-Client

SHDSVTXCI BC-ABA-TV Table Cross-Client

SHDTTCIU BC-ABA-TV Table Cross-Client

SHDTVCIU BC-ABA-TV Table Cross-Client

SHDTVSVCIU BC-ABA-TV Table Cross-Client

[Former Member · Accepted solution]

Hi Sadiq

that is very much possible but is your production client open for changes because it can happen only if your production is open and if this is the case it is a wrong practice.

Production client should never be open for changes but if this is the case then it might be a valid reason for client export/import failing

Rohit

[former_member182505 · Accepted solution]

Hi Rohit ,

i have selected SAP_ALL profile for that.

thanks

[Former Member · Accepted solution]

Ok...I guess you should have got 3 transport requests for this

Also is your production client open?if yes there are chances that there have been direct modififcation in production and hence your import is failing

Rohit

[former_member182505 · Accepted solution]

hi Rohit

i have the procedure wht i fallowed for the copy . its with screen shots.

how can i send u?

thanks