Transport control program tp ended with error code 0212 | URGENT

[Former Member]

Hi All,

We are trying to import requests in our PRD system. As soon as we select the request and try to import it , we get the error "Transport control program tp ended with error code 0212".

This is tp version 305.12.42 (release 46D) for ANY database

/usr/sap/trans/cofiles/K915883.<SID> for transport: <SID>K915883: Permissio

HALT 20070222114323

ERROR: /usr/sap/trans/cofiles/K915883.<SID> : cant open

: Permission denied

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

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:

This is R3trans version 6.05 (release 46D - 18.10.01 - 11:30:00).

R3trans finished (0000).

When i checked the transport tool and rfc destinations, everything was successful.

When i tried to do tp connect -

23> tp connect <SID> pf=/usr/sap/tran/bin/TP_DOMAIN_<SID>.PFL

This is tp version 305.12.42 (release 46D) for ANY database

E-/usr/sap/tran/bin/TP_DOMAIN_<SID>.PFL could not be opened.

EXIT

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0212

tp finished with return code: 212

meaning:

could not access file as supposed (see SLOG for more details)

We are having SAP 4.6C with DB -Oracle and OS HP-UX.

Please let me know whow to rectifiy the issue. The situation here is getting worse.

Regards,

NK

[manu_susankar · Accepted solution]

Hi

There is no other problem it is only due to lacking of permissions on the files. If you could able to do it it definitely imports with out any problem cause it is my personnel experience. Do one thing do it in reverse manner i mean go to DEV system ftp to production system instead of get say put. Try this one if you still face the same problem i suggest to take assistance of Unix team. Some times it may be security issue.

Thanks

S.Manu

[Former Member · Accepted solution]

Hi Manu,

Thank you so much. Finally as per your suggestions, it worked.

Thanks again.

NK

[Former Member]

Hi NK,

664 is correct as long as IP1ADM is part of the group which has access to the cofile.

Do one thing.

In unix find the file permissions cofile files in /usr/trans/cofiles using ls-l command.

Then check for group which has access to the cofile that is causing the error.

ls-l will give you this kind of output

-rw-rw--r -- 1 <owner> <group> <file size> <dates> <cofile>

Now in /etc/group file check for the group value you have got and confirm that all your IP1ADM is part of that group. This you can also check using AL11.

Regards.

Ruchit.

[Former Member]

Hi Ruchit,

This is what i got after doing ls -lt on group

steic25q:root>ls -lt group

-rrr-- 1 bin bin 756 Feb 16 16:06 group

When i went into group, this is what i got -

steic25q:root>more group

root::0:root

other::1:root,hpdb

bin::2:root,bin

sys::3:root,uucp

adm::4:root,adm

daemon::5:root,daemon

mail::6:root

lp::7:root,lp

tty::10:

nuucp::11:nuucp

users::20:root,ip1adm

nogroup:*:-2:

smbnull::201:

dba::103:iq1adm,oraiq1,ip1adm,oraip1,mvbokke

sapsys::101:oraiq1,iq1adm,oraip1,ip1adm

oper::102:oraip1,ip1adm,id1adm,iq1adm,oraiq1,oraid1

xfer::1002:ip1adm,egate,gomesmi,klepeib,bynagav,mccamps

It seems like ip1adm is there, in the group.

[Former Member]

Hi NK,

Sorry I didnot get it. I think you checked file handling permission for the file group.

I wanted you to do the same for the co-file causing error.

Also the /etc/group file specifies which users are in a group. For example the entry

bin::2:root,bin

means that groupname is bin while group id is 2 and the users in the group are root and bin.

Also in the output of ls-l command you need to check for group id and then do a mapping with /etc/group file.

One final thing in case of mutiple application servers check the /etc/group file on the server where transport directory actually resides.

Regards.

Ruchit.

Message was edited by:

Ruchit Khushu

[Former Member]

Hi Naveen,

Try this thing out also. Create transport of copies request in your production system and give target as your development system/client.

Try releasing it and see if co files and data files are getting generated.

Regards.

Ruchit.

[Former Member]

Hi RUchit,

When i checked in group file, i found the entry -

sapsys::101:oraiq1,iq1adm,oraip1,ip1adm

This means that for group sapsys and id 101, ip1adm is there.

But as soon as i do ls -l on the file that has errors, i get -

steic25q:root>ls -l K915901.ID1

-rw-rw-r-- 1 id1adm 105 258 Feb 28 07:12 K915901.ID1

Here you can see that the file which is coming over to PRD system has the user as id1adm and the group as 105. This is the reason why i'm not able to import it to SAP. If i can makse sure that the files that come to PRD , after releasing the requests from DEV, they have the user as ip1adm and group as sapsys. The issue will be resolved if the file will look like -

-rw-rw-r-- 1 ip1adm sapsys 258 Feb 28 07:12 K915901.ID1

How can we achieve this...

[Former Member]

Hi NK,

You are cent percent correct. Ideally the owner has to get changed that also automatically. I am looking for this. One thing though what role is the IQ1 system playing in all this?

Are transport getting imported to it successfully.

Also check your TP parameter profile. If possible resdistirbute the entire configuration of STMS.

regards.

ruchit

Message was edited by:

Ruchit Khushu

[Former Member]

Hello,

As per your group output,

dba::103:iq1adm,oraiq1,ip1adm,oraip1,mvbokke

sapsys::101:oraiq1,iq1adm,oraip1,ip1adm

oper::102:oraip1,ip1adm,id1adm,iq1adm,oraiq1,oraid1

Could you please modify your group file for the dba, sapsys and opr groups as below

DEV server:

dba::103:id1adm,oraid1

sapsys::101:oraid1,id1adm

oper::102:oraid1,id1adm

PRD server:

dba::103:ip1adm,oraip1

sapsys::101:oraip1,ip1adm

oper::102:oraip1,ip1adm

When you do ls -l on dev server you will get the following output

-rw-rw-r-- 1 id1adm sapsys 258 Feb 28 07:12 K915901.ID1

and when you do ls -l on PRD server you will get the following outpu

-rw-rw-r-- 1 ip1adm sapsys 258 Feb 28 07:12 K915901.ID1

Here it going to read your local server group file as accordingly you will get the result for your ls -l command.

One more thing I am not able to understand from the following output

steic25q:root>ls -l K915901.ID1

-rw-rw-r-- 1 id1adm 105 258 Feb 28 07:12 K915901.ID1

why it is coming as group as 105, could you please check your group file on server steic25q.

Cheers,

-Sunil

[Former Member]

Hi Naveen,

I am getting a feeling that your transport profile file is not correct. The group file settings are more or less correct.

Check the transport file again. Cofile and Data file owner has to change from system to system.

Can you please paste its contents please?

Regards.

Ruchit.

[Former Member]

Hi Ruchit, Sorry for the delay. Here is the file you wanted -

steic25q:root>ls

DOMAIN.CFG TPPARAM.bak TP_DOMAIN_ID1.PFL TP_DOMAIN_IQ1.PFL

TMS_TEST.IS1 TPPRAMA0918 TP_DOMAIN_ID1.orig nik.dev_evt

TPPARAM TP_DOMAIN_ID1.BAK TP_DOMAIN_IP1.BAK

steic25q:root>more TP_DOMAIN_ID1.PFL

#TMS:0078:DOMAIN_ID1

#

#----

---

1. Caution !

2. This file was generated by the Transport Management System.

3. Do not change this file using a text editor.

4. For more information, refer to the online documentation of the

5. Transaction STMS.

6. If this file was destroyed, it can be regenerated in the TMS.

7. To do this, log on to the domain controller (system ID1) and call

8. transaction STMS. In the System Overview, you can distribute the TMS

9. configuration. This regenerates the file.

10. STMS -> Overview -> Systems -> Extras -> Distribute TMS configugration

#----

---

#

#

TRANSDIR = /usr/sap/trans

#

DU1/CTC = 1

DU1/DUMMY = 1

DU1/NBUFFORM = 1

DU1/TP_VERSION = 266

#

DU2/CTC = 1

DU2/DUMMY = 1

DU2/NBUFFORM = 1

DU2/TP_VERSION = 266

#

ID1/CTC = 0

ID1/DBHOST = steic24q

ID1/DBLIBPATH = /usr/sap/ID1/SYS/exe/run

ID1/DBNAME = ID1

ID1/DBSWPATH = /oracle/ID1/817_64

ID1/DBTYPE = ora

ID1/NBUFFORM = 1

ID1/TP_VERSION = 266

#

IP1/CTC = 0

IP1/DBHOST = steic25q

IP1/DBLIBPATH = /usr/sap/IP1/SYS/exe/run

IP1/DBNAME = IP1

IP1/DBSWPATH = /oracle/IP1/817_64

IP1/DBTYPE = ora

IP1/NBUFFORM = 1

IP1/TP_VERSION = 266

#

IQ1/CTC = 1

IQ1/DBHOST = cbnysap2

IQ1/DBLIBPATH = /usr/sap/IQ1/SYS/exe/run

IQ1/DBNAME = IQ1

IQ1/DBSWPATH = /oracle/IP1/817_64

IQ1/DBTYPE = ora

IQ1/NBUFFORM = 1

IQ1/TP_VERSION = 266

#

TRN/CTC = 1

TRN/DUMMY = 1

TRN/NBUFFORM = 1

TRN/TP_VERSION = 266

steic25q:root>

[Former Member]

steic25q:root>ls -l K915901.ID1

-rw-rw-r-- 1 id1adm 105 258 Feb 28 07:12 K915901.ID1

why it is coming as group as 105, could you please check your group file on server steic25q. and what is the group ID for sapsys group in steic25q?

Cheers,

-Sunil

[Former Member]

Hi Sunil,

Here is the O/P of my Group file on 25Q -

steic25q:root>more group

root::0:root

other::1:root,hpdb

bin::2:root,bin

sys::3:root,uucp

adm::4:root,adm

daemon::5:root,daemon

mail::6:root

lp::7:root,lp

tty::10:

nuucp::11:nuucp

users::20:root,ip1adm

nogroup:*:-2:

smbnull::201:

dba::103:iq1adm,oraiq1,ip1adm,oraip1,mvbokke

<b>sapsys::101:oraiq1,iq1adm,oraip1,ip1adm</b>oper::102:oraip1,ip1adm,id1adm,iq1adm,oraiq1,oraid1

xfer::1002:ip1adm,egate,gomesmi,klepeib,bynagav,mccamps

egate::1001:ip1adm,bynagari,howellc,krishnc,mccamps,nabeean,gomesmi,klepeib,jabr

iha

fico::1000:ip1adm,bynagari,krishnc,mccamps,nabeean,gomesmi,klepeib,transfer,lock

box,iq1adm,id1adm,bynagav,egate,oraiq1,oraip1,oraid1,jabriha,nawatha

tivoli::200:

unison::40:

lockbox::841:root,maestro,sapsys,unison,bynagav,mccamps

sshd::104:

ntuser::65533:root

uagent::2500:

But i'm sure you will be more interested in the O/P of my DEV server which has the GROUP ID AS 105 !!!! -

steic24q:root>more group

root::0:root

other::1:root,hpdb

bin::2:root,bin

sys::3:root,uucp

adm::4:root,adm,maestro

daemon::5:root,daemon

mail::6:root

lp::7:root,lp

tty::10:

nuucp::11:nuucp

users::20:root,ip1adm

nogroup:*:-2:

smbnull::201:

<b>sapsys::105:ip1adm,id1adm,iq1adm,oraid1</b>

oper::102:oraip1,ip1adm,id1adm,iq1adm,oraiq1,oraid1

dba::103:ip1adm,id1adm,iq1adm

xfer::1002:ip1adm,egate,klepeib,vusteve

egate::1001:ip1adm,howellc,krishnc,mccamps,nabeean,klepeib,jabriha,mlund

fico::1000:ip1adm,egate,krishnc,mccamps,nabeean,klepeib,transfer,lockbox,iq1adm,

id1adm,jabriha,nawatha,mlund,nkharb

tivoli::200:

unison::40:

ntuser::65533:edi,root

lockbox::841:root,maestro,sapsys,unison,mlund

sshd::104:

uagent::2500:

Hope it will give us any clue.

Thanks

[Former Member]

could you please try to match both the GIDs.

server steic25q

dba::103:iq1adm,oraiq1,ip1adm,oraip1,mvbokke

sapsys::101:oraiq1,iq1adm,oraip1,ip1adm

oper::102:oraip1,ip1adm,id1adm,iq1adm,oraiq1,oraid1

Server steic24q

sapsys::105:ip1adm,id1adm,iq1adm,oraid1

oper::102:oraip1,ip1adm,id1adm,iq1adm,oraiq1,oraid1

dba::103:ip1adm,id1adm,iq1adm

Just change the entry sapsys to 105 in /etc/group for server steic25q.

Cheers,

-Sunil

[Former Member]

Hi Sunil,

Thanks for the suggestion. I did change the Group ID to 105 on 25Q, but still the transport requests are coming with user id1adm and not ip1adm -

steic25q:root>ls -l R915907.ID1

-rw-rw-r-- 1 id1adm sapsys 2445 Apr 26 07:05 R915907.ID1

steic25q:root>ls -l R915905.ID1

-rw-rw-r-- 1 id1adm sapsys 2430 Apr 25 11:04 R915905.ID1

steic25q:root>ls -l R905370.ID1

-rwxrwxrwx 1 ip1adm 101 12098 Feb 11 2002 R905370.ID1

If you see here, the old requests came with user ip1adm and group ID 101, but now they are coming as id1adm and group sapsys but not he group ID.

Has it anything to do with the fact that id1adm user is not present in the group file for group sapsys on 25Q ?

server steic25q

sapsys::105:oraiq1,iq1adm,oraip1,ip1adm

Server steic24q

sapsys::105:ip1adm,id1adm,iq1adm,oraid1

[Former Member]

Hi NK,

The attributes will remain the same. I am checking for mount. Is transport directory and its sub directories accessible from all the servers? Please check this . You can use AL11 for this. I was under the impression that transport directory is on your development server.

Secondly I hope that the TP releases is same for all the servers.

Also what the file permission attributes for cofiles actually i mean files with in cofile directory

777 is permission for /usr/sap/trans/cofiles

Check permission for /usr/sap/trans/cofiles/<cofile>? ideally they should be a minmum of 664. Check for the cofile which is causing this error.

Regards.

Ruchit.

[Former Member]

Hi Ruchit,

Thanks for your reply and suggestion. I did check the attributes of the file that is giving error and i found -

Name........... K915901.ID1

Type........... file, regu

Length......... 258

Creator........ id1adm

Last change 02/28/2007 07:12:09

Mode........... 664

Usable......... X

I appreciate your and sunil's efforts and patience.

Please advise.

[Former Member]

Hi NK,

If I am correct (after your correspondence with Sunil) then the transport directory is residing on your production.On which systems did you perform the mounting tests through AL11?

Regards.

Ruchit.

[Former Member]

Hi Ruchit,

The attributes that i sent you earlier are same on both the servers , on PRD as well as on DEV.

[Former Member]

Hi Naveen,

So mount is not an issue in my opinion. File permissions is

Anyways two things:

You said

When i tried to do tp connect -

23> tp connect <SID> pf=/usr/sap/tran/bin/TP_DOMAIN_<SID>.PFL

This is tp version 305.12.42 (release 46D) for ANY database

E-/usr/sap/tran/bin/TP_DOMAIN_<SID>.PFL could not be opened.

EXIT

If this is a copy paste of what you did it will not work since

you have used pf=/usr/sap/tran/bin/TP_DOMAIN_<SID>.PFL instead of pf=/usr/sap/trans/bin/TP_DOMAIN_<SID>.PFL.

You have to use trans and not tran.

Next thing

in all11 go to this path /usr/sap/trans

Click on

cofiles

The select attributes in application menu bar.

This will give file handling permissions in front of mode for cofiles directory.

Since you are not very adept at UNIX may be this approach through SAP will be helpful.

Ideally for things to work the permissions should be 770.

Please check it.

please award points for useful info.

Regards.

Ruchit.

[Former Member]

Hi Ruchit, this is what i got in the attributes for cofiles -

Directory...... /usr/sap/trans

Name........... cofiles

Type........... directory

Length......... 184,320

Creator........ ip1adm

Last change 02/28/2007 07:12:02

Mode........... 777

[Former Member]

Hi NK,

As Sunil pointed oiut all <sid>adms must have access to data files and cofiles. In your case id1adm will be the owner whenever you release the transport.

Check for the mount again. For checking mount login into non development systems (if i am right developement system is the host for transport directory) and go to al11. Check if your able to access the directory /usr/sap/trans and its sub directories. If you are not then there is a mount issue.

Also check for file handling permissions for all the <sid>adm users.

Please award points accordingly,

Regards.

Ruchit.

[Former Member]

Ruchit, thanks for your reply.

I'm able to view files in my Trans directory from my PRD system . This si how it looks like when i double click on any of the files in my cofile sudirectory through AL11 -

ID1 f 0000 20070228071202 steic24q id1adm

IP1 < 0000 20070228071209 steic24q id1adm

ID1 E 0000 20070228071209 steic24q id1adm

Thanks,

NK

[Former Member]

Hi All,

With all your previous replies, we are able to transport the transport requests from DEV to PRD now. But the issue still remains the same.. we are able to transport the requests manually. Automatic transports are not happening. Whenever we release the requests , we have to manually FTP them to Prd in order for them to have the correct permissions. I'll appreciate if someone can help me in resolving this issue so that we can have the Automatic transports running. I tried everything but with no luck. If anyone of you knows how can i make sure that the files will right correct permission in my HP-UX server, i'll be highly obliged.

Appreciate you help.

NK

[Former Member]

When i look at my earlier requests in my DOmain Controller DEV, i see the following -

-rwxrwxrwx 1 ip1adm 101 2346 Mar 22 2001 R900024.ID1

-rwxrwxrwx 1 ip1adm 101 3015 Mar 21 2001 R900022.ID1

-rwxrwxrwx 1 ip1adm 101 2042 Mar 20 2001 R900020.ID1

-rwxrwxrwx 1 ip1adm 101 1283741 Mar 14 2001 RD00050.SAP

-rwxrwxrwx 1 ip1adm 101 8696262 Feb 9 2001 RVSDA71.SAP

-rwxrwxrwx 1 ip1adm 101 10816 Oct 27 2000 RVSDF41.SAP

-rwxrwxrwx 1 ip1adm 101 80727 Apr 21 2000 R000119.TV1

But as soon as i release any new req from DEV, and then when i check in /usr/sap/trans/data or cofiles, i see that they are created for id1adm and not for ip1adm -

steic24q:root>ls -lt R915901.ID1

R915901.ID1 not found

steic24q:root>ls -lt R915901.ID1

-rw-rw-r-- 1 id1adm sapsys 704 Feb 28 07:12 R915901.ID1

I know this is the exact issue, but i'm not able to resolve it. I'm not able to force the system to create the data files and cofiles with the permissions for ip1adm. If i can force the system to give permissions to ip1adm and not to id1adm, it will surely resolve the issue.

Please help me out.

Thanks,

NK

[Former Member]

Hello,

You have 3 system landscape, and you are using same transport directory for all the 3 systems. You should have mounted /usr/sap/trnas from DEV to QAS and PRD server with read/write permissions. When you release the request from your development system it will create from <SID>adm in you case id1adm. If you have given read/write permission while mounting the file system /usr/sap/trans to QAS/PRD then there should not be any problem.

Cheers,

-Sunil

[Former Member]

Hi Sunil,

Thanks a lot for your reply.

Well, it used to be 3 system landscape earlier, but now it is a 2 system landscape. DEV->PRD. QAS is no longer in between.

I just reconfigured the STMS and thought that it should work by default as it was earlier. Do i need to mount /usr/sap/trans from DEV to PRD again ?

I Don't know Unix that much and unfortunately, we don't have any Unix guy here. It will be great if you can help me out in fixing this issue.

Thanks,

NK

[Former Member]

Hello,

If it was successfully in 3 system landscape then it should also possible in 2 system landscape.

Could you please login to your PRD system at OS level. and check command

df -k (list of mounted file system, here you can find whether it is mounted from network or locally.

Cheers,

-Sunil

[Former Member]

HI Sunil,

I did run the command df -k in my PRD and this is what i got -

/sapmnt/IP1 (/dev/vgIP1/lv_sapmnt_IP1) : 5786474 total allocated Kb

5366412 free allocated Kb

420062 used allocated Kb

7 % allocation used

/tmp (/dev/vg00/lvol4 ) : 2045064 total allocated Kb

1016920 free allocated Kb

1028144 used allocated Kb

50 % allocation used

/usr/sap/IP1 (/dev/vgIP1/lv_usr_sap_IP1) : 7704305 total allocated Kb

7463420 free allocated Kb

240885 used allocated Kb

3 % allocation used

/usr/sap/trans (/dev/vgIP1/lv_trans ) : 7066580 total allocated Kb

1521323 free allocated Kb

5545257 used allocated Kb

78 % allocation used

/usr (/dev/vg00/lvol7 ) : 2091488 total allocated Kb

725208 free allocated Kb

1366280 used allocated Kb

Does it tell us that all is well ?

[Former Member]

Hello,

As per your update /usr/sap/trans (/dev/vgIP1/lv_trans ) is mounted as locally. If it is mounted from the network it should look like : <Server_name>:/usr/sap/trans

another clue is if you match the df -k with your DEV and PRD for /usr/sap/trans it should match the output (free size, allocation used)

Cheers,

-Sunil

[Former Member]

Hi Sunil,

I did df -k on my DEV server and this is what i got -

steic24q:root>df -k

/usr/sap/trans (steic25q:/usr/sap/trans) : 7066584 total allocated Kb

1521320 free allocated Kb

5545264 used allocated Kb

78 % allocation used

Any clues?

[Former Member]

Hello,

Which is the server steic25q

in your development server the /usr/sap/trans mounted from steic25q

Cheers,

-Sunil

[Former Member]

Steic25Q is my current PRD system.

[Former Member]

Ok, mean your /usr/sap/trans is mounted from PRD to DEV server

Cheers,

-Sunil

[Former Member]

Yaa sunil, it seems like it is mounted from steic25q to DEV.

[Former Member]

Hello,

Continue with your message ID https://forums.sdn.sap.com/post!reply.jspa?messageID=3108271

You have mounted your PRD /usr/sap/trans to DEV server

when you have created a new transport it is getting created at OS level under /usr/sap/trans/cofiles and /usr/sap/trans/data it means there is no problem with your NFS filesystem /usr/sap/trans. The same transport request you can see on PRD server as this is NFS mounted. The transport will be created as id1adm not ip1adm becuase you are releasing/exporting it from DEV server.

Cheers,

-Sunil

[Former Member]

Hi Sunil,

But i'm still getting the same error -

This is tp version 305.12.42 (release 46D) for ANY database

/usr/sap/trans/cofiles/K915883.<SID> for transport: <SID>K915883: Permissio

HALT 20070222114323

ERROR: /usr/sap/trans/cofiles/K915883.<SID> : cant open

: Permission denied

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

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:

This is R3trans version 6.05 (release 46D - 18.10.01 - 11:30:00).

R3trans finished (0000).

I'm still not able to import the file into my PRD system. The only way i'm able to do so is by manually changing the permissions of data and cofiles on DEV server and then FTP it to PRD system. After this, i'm able to import it into PRD system.

Please suggest.

[Former Member]

Hello N K,

Login as root user and execute:

chmod 777 <cofile_name>

chmod 777 <datafile_name>

Then change the owner of the files to <SID>adm

chown <sid>adm <cofile_name>

chown <sid>adm <datafile_name>

Then login as <sid>adm user and check:

The cofiles & Datafiles will have full permission & <SID>adm will be the owner of those files.

Import it into your target client through STMS

This will solve your problem for sure.

Regards,

Ammey Kesarkar

<i>'Award points for useful info'</i>

[manu_susankar]

Hi

go to <sid>adm (su - sidadm)

From the system on which you want to import do it from there.

I am giving you the SFTP commands both FTP and the SFTP are works same.

First you try with ftp if it does not allow you to login try with sftp.

1. sftp username@<SID>

The authenticity of host 'gld (155.125.30.74)' can't be established.

RSA key fingerprint is 99:f8:00:6c:d8:3d:1b:01:3f:16:99:21:a5:98:c9:c3.

Are you sure you want to continue connecting (yes/no)? yes

it prompts for password .. keen the password (if it is a secured network it also asks the security number RSA pin)

now use the command as follows...

sftp> cd /usr/sap/trans/data

sftp> lcd /usr/sap/trans/data

sftp> get <file name>

do same for the cofiles too as given above

sftp> cd /usr/sap/trans/cofiles

sftp> lcd /usr/sap/trans/cofiles

sftp> get <file name>

once transfer complets

say

sftp> bye

now as usual... try to import it works now.

Cheers.

S.Manu.

[Former Member]

HI Manu,

I appreciate all your help.

But you know what, even i did CHMOD and was able to change the permission through "root" and i tried to import it, it didn't work.

I did the ftp too, but while i said " get K915883.<SID>", it said that you are not the owner. Here are the excerpts.

steic25q:root>chmod 775 K915883.ID1

steic25q:root>ls -lt K915883.ID1

-rwxrwxr-x 1 id1adm 105 808 Feb 21 18:35 K915883.ID1

steic25q:ip1adm 38> ftp steic24q

Connected to steic24q.

220 steic24q FTP server (Version 1.1.214.8 Fri Apr 20 07:27:42 GMT 2001) ready.

Name (steic24q:root): root

331 Password required for root.

Password:

230 User root logged in.

Remote system type is UNIX.

Using binary mode to transfer files.

ftp> cd /usr/sap/trans/cofiles

250 CWD command successful.

ftp> lcd /usr/sap/trans/cofiles

Local directory now /usr/sap/trans/cofiles

ftp> get K915883.ID1

K915883.ID1: Not owner

Can you suggest something, please.

Thanks,

NK

[manu_susankar]

Hi

Try to change from su - <sid>adm if you still face the same problem.Remove the cofile and datafile and do ftp from <sid>adm and chage permissions.Try to import it work.

Cheers...

S.Manu

[Former Member]

Thanks Manu,

I ran CHMOd through <SID>adm, but i got the error that i sent you earlier.

Can you please explain me in detail how to ftp it and how to change the permission, i'm new to HP-UX.

Thanks,

NK

[manu_susankar]

Hi

Change the permission and ownership of the data and cofiles make sure that the files have 755 permission and the owner should be <sid>adm.And do check the utilization of trans directey.Try to reimport once everthing is ok.

Regards....

S.Manu

[Former Member]

Hi Manu,

I tried to change the permission through -

CHMOD 775 K915883.<SID>

I got the error -

chmod 775 K915883.<SID>

chmod: can't change K915883.<SID>: Not owner

Please help.