STMS: Transport control program tp ended with error code 0232

[Former Member]

Dear ERP Gurus,

I just encountered problem with STMS in my PRD system. The import is just stuck up on "tp connecting to database". It won't continue unitl the system gives me this error message:

Transport control program tp ended with error code 0232

Errors: connect failed

The tp System log says:

ERROR: Connect to PRD failed (20090227135454, probably wrong environment)

I have verified that the suggestion in SAP Note 165708 has already been implemented in our DEV, QAS, and PRD instances.

Any idea why I am having this problem? Imports were running fine yesterday. Please help.

Your prompt response is highly appreciated.

Thanks a lot.

Best Regards,

Albert

[Former Member · Accepted solution]

Hi Albert,

First check import monitor and delete all requests from queue, which are still getting imported.

And go to /usr/sap/trans/tmp and mv all those tmp files to other location.

Then kill all OS jobs which are getting execute with tp.

Check all jobs are runnig fine, related to transportation. If not reschedule the same.

Then start importing.

Before doing this just check whether your stms related RFCs are working fine.

I think One of your RFC is getting struck. just try to change ip or hostname accordingly and try.

Regards

Nick Loy

[Former Member · Accepted solution]

thanks nick.

my imports won't proceed any further on the "tp connecting to database". the status of my imports are still on "ready for import".

all my rfcs are okay..i think my problem lies on the database..

i've also checked SAP Notes 556941 and 449270.

best regards,

albert

[Former Member · Accepted solution]

Hai,

Have you tried to generating RFC Destinations from STMS, if not try this in Domain controller and then the systems connected to Domain controller.

Try to upgrade your tp and R3trans.

Regards,

Yoganand.V

[Former Member]

Yes Albert,

You are right. Issue related to database. But why it is happening?

It is happening because tp is not connecing with your database.

At the same time some of your TMS RFCs also should not work.

Just try to import the same from OS level and let us know the result.

Regards

Nick Loy

[manikantan_velayuthan2]

Hi,

In my case it was because the SAPR3 account got locked and once I got it unlocked the issue got fixed.

Thanks,

Mani