Monday 20 August 2012

Test call of transport control program (tp) ended with return code 0232



Today I was releasing the transport request at that time I was able to release the child request but parent request was giving the error like " Test call of transport control program (tp) ended with return code 0232"


This error is coming because of SAPSR3 user is expired in database.

SAP has suggested a note (1519872 - SAP Database User Profile SAPUPROF)  for this & now from Oracle 11G onwards we have to change the password of SAPSR3 user in every 6 months.

Change the password through BRTOOLS to update the same in SAPUSER table as well.

To avoid the change of password every 6 months download the profile script attached with the above note.

Run the script as per note & check the below command in sqlplus prompt to confirm the expiry date of users.

SQL > select USERNAME, ACCOUNT_STATUS, EXPIRY_DATE from dba_users;



Cheers.... :)



1 comment:

  1. i have this problem code 0232 but i use sql server 2005, can you pls help?

    ReplyDelete