Error while transport request from DEV to PRD

[Former Member]

Dear Sir,

I am getting error while transporting request from DEV to PRD

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

How to solve this error.

[former_member199290]

Hi:

Please check below similar discussions:

regarding Return code from tp:  &nbsp... | SCN

https://scn.sap.com/thread/933569

[former_member185239]

Dear Atul,

Follow the below steps :

- Run the Transaction STMS->Overview->system.

- Double click on the system for which you are facing the error.

- Goto the transport tool and check the dbtype value is maintained or not.

if the value is not maintained then maintain the value over there.

If the above setting is correctly maintained , then Run the command

R3trans -d and paste the trans.log file.

Also check the environment variable dbms/type in instance profile.

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi Atul,

I believe you are facing this error while releasing the transport from DEV, please correct me if I am wrong.

You can get more details on the error in the log on the request.

Please provide the details in the log so that we could assist you further.

Regards,

Pradeep

[Former Member]

Hi Atul,

Please check the another discussion below in SCN, may be useful

[former_member189797]

Hello Atul,

Please execute "R3trans -d" as sidadm and attach the trans.log .

BR,
Gaurav

[Former Member]

Hello Atul,

Please check whether environment variable dbms_type=mss is set or not.

Regards

Anand

[Former Member]

Anand,

may I ask why you are thinking that dbms_type should be set to mss in this case?

In none of our system it is mss, nevertheless transports are working well.

[Former Member]

Hello Josef,

I could give you detailed explanation, but the following SAP note will give you better understanding.

1966797 - Errors: connect failed due to DbSL load lib failure

Regards

Anand

[Former Member]

Hello Anand,

yes, I know, this link will come up when you do a SAP notes search with these keywords:

tp ended with return code 0249

This proves that your searching skills are better than the OP's.

SAP note 1966797 is telling us that dbms_type has to be set correctly; it doesn't tell us that it has to be set to mss, imho.

I for my part don't dare to guess which setting for dbms_type will be correct in the OP's case.

Jist wondering how you can know.

regards

[Former Member]

Josef,

(As per my understanding)

R3trans does not read R/3 Parameters from profile,

R/3 parameters are read by SIDADM on OS level. but when you want to use R3trans from SAP application.SAP application has to know environment variable.

It depends on SIDADM to interact with R3trans. That is the reason you have to specifically mention dbms_type.

You are right about dbms_type=mss. Its specific to SQL DB. But i haven't came across issue with other Database. Where this parameter was critical.

The screenshots was helpful as it points where you are able to release task but not the transport.

Most of the time the first suggestions for any queries would be on the broader level.Until unless all the logs and full details are provided.

You are experienced enough and i hope you understand.

Regards

Anand