Error While Client Import

[Former Member]

Hello All,

I have done a client Export from production

It has created 3 files.

SP1Ko00015

SP1Kt00015

SP1Kx00015

I copied the files in respctive folders

\usr\sap\co

\usr\sap\data

\usr\sap\log

respectively.

now when i go to stms and click on import queue of dev server it shows all the request in the queue.

I click the half truck for importing them one by one.

it starts importing but afetr few minutes when i refresh it..the first one goes red.and status is request cannot be imported. and the other 2 request are with status import running......and it stays like that indefinitely.

could you please guide me .....

why is this not happenning...and wht should i do to make this export successful.

\Though I have scheduled a fresh export today.

thanks

saurabh

[manu_susankar]

Hi srivastava

Try this sure it will work go to the cofile directry and data directey and change the file permission to 775 (you can also assign 777).This can be done as

chmod 775 KT00015.SP1 do this for all the files...even for data files to just for the datafiles just repace R in place of K (RT00015.SP1...) and try to import.Still if you got the same problem...

change the owner of the files to <SID>adm. this can be done by CHOWN command...

and try to import again.I hope you will never see the error again.

Regards.

S.Manu

[Former Member]

This is a bit late, but I discovered the problem here:

I had a mapped network drive to the sapmnt directory.

For some reason, this would occasionally open the files SAP is using during transport and cause an error.

I would go to the sapmnt directory on the server and manually close the open files and everything worked fine.

Note that when I was using the computer with the mapped network drive this almost never happened, but if I left my computer logged in and was using someone else's PC, then it often happened.

To close the files on a windows server, right-click My Computer --> Manage --> Shared Files --> Open Files. Then right-click the offending files and select close file.

I hope this is helpful.

[Former Member]

I am aatching the error as below.

kindly let me know wht might be the problem.

we are running HP-UX11i.as O.S

This is tp version 340.15.06 (release 640, unicode enabled)

Warning: Parameter DBHOST is no longer used.

Warning: Parameter DBLIBPATH is no longer used.

Warning: Parameter DBNAME is no longer used.

Warning: Parameter DBSWPATH is no longer used.

/usr/sap/trans_SA1/cofiles/KO00017.SP1 for transport: SP1KO00017: Permi

HALT 20060725112712

ERROR: /usr/sap/trans_SA1/cofiles/KO00017.SP1 : cant open

: Permission denied

ERROR: EXIT(16) -> process ID is: 18647

tp returncode summary:

TOOLS: Highest return code of single steps was: 16

ERRORS: Highest tp internal error was: 0212

Output from tools called by tp:

[Former Member]

I got a very similar error when trying to delete imported requests

This is tp version 340.16.03 (release 640)

Warning: Parameter DBHOST is no longer used.

Warning: Parameter DBNAME is no longer used.

kodevqa\sapmnt\trans\tmp\PRDTMP.LOB: Permission denied

HALT 20060801154705

ERROR:
kodevqa\sapmnt\trans\tmp\PRDTMP.LOB : cant open

ERROR: EXIT(16) -> process ID is: 5776

tp returncode summary:

TOOLS: Highest return code of single steps was: 16

ERRORS: Highest tp internal error was: 0212

Output from tools called by tp:

We are running a Dell server with Windows 2003 OS. This morning it worked fine.

[Former Member]

This is because you dont have permission to delete files from mapped drive. Check whether the required permissions are there for sap<sid> and sapservice<sid> for the mount directory. Pls double check the user ids as I am not that familiar with windows

Thanks

prince

[achim_hauck2]

Saurabh,

what tells the import log of the canceled transport request?

kr, achim