How to Unlock the transport que

[MPGraziano]

It seems that we can no longer see all the transports of our QAS import que

we can see them in DEv and Prdn

Please advise

maria

[Former Member · Accepted solution]

Maria,

Somewhat interesting issue - it could be a number of potential issue but the overall answer is that your QA transport buffer file is not being read - either the /usr/sap/trans/buffer directory variable in STMS is defined incorrectly for this system or the buffer file has been removed by accident.

I would additinally open a message with SAP OSS if you cannot restore the file as necessary to have them help you rebuild your queue.

If this answers your questions, please set this thread to answered, if not, please provide your additional requirements so we can address your issues promptly.

[MPGraziano · Accepted solution]

how can I confirm that directory param in stms?

the other option that I was thinking of is that someone accidently locked the que and I am going in circles trying to find where to unlock it

[Former Member · Accepted solution]

Hi,

did you refresh you quality system from production system?

if yes then do following in QAS system 000 client

run tcode SE06 -> check: database copy or database migration -> perform post installation

regards,

kaushal

[MPGraziano · Accepted solution]

As I did that, now it is asking to re-install cts single system, but I need to have it as 3 system (dev, QAS and prdn)

m.

[Former Member · Accepted solution]

Hi,

this steps must be executed after system refresh by system copy.

which system has domain controller?

if your QAS system does not have domain controller then you need to ADD QAS system in domain controller.

reconfigure TMS on QAS system client 000 and add QAS system in domain controller and distributes the configuration from domain controller.

so finally you have three system landscape.

regards,

kaushal

[MPGraziano · Accepted solution]

DEV system is the domain controller

I have added (and can see QAS) in DEV domain controller

But in QAS it still states the stms is inconsistent

on DEV I would think I would need to approve QAS but I cannot?

m

[Former Member · Accepted solution]

Hi,

do following

on DEV system login into 000 client

run STMS

overview -> systems

select QAS and from menu sap systems -> delete

then update the configuration from menu SAP Systems -> update configuration

now login into QAS system 000 client and reconfigure TMS and add it in domain controller.

now again login into DEV system 000 client and update configuration and distribute it

regards,

kaushal

[MPGraziano · Accepted solution]

Thank You, that works well, again, as I did this already a number of times.

My issue still remains that in QAS I can view the import ques for DEV and PRDN but when I look at the import que for QAS it is empty, EVEN after I try to ADD transports it does not display in the the que. I think we have accidently locked it and cannot view anything there. I remember there is an option/functin/menu that will allow me to open the transport ques. Do you remember?

Maria

[former_member524429 · Accepted solution]

The problems may be related to RFC Destinations, through which the the Domain Changes carried out at Domain controller are going to be distributed.

It also requires that, the host name entry of the QAS system must be done in hosts file located at <Dirve>:\WINDOWS\system32\drivers\etc on Host of DEV (which is domain controller, in this case)

Retry the whole procedure as specified by Kaushal, if you want to reconfigure TMS for QAS, again.

then,

"Approve" the QAS System in DEV,000 Client (which is domain controller). and Then, finally, Distribute the Changes.

Also ,check the status info of QAS.

and see the effect.

Tell me if i am wrong.

[Former Member · Accepted solution]

Hi,

in QAS run stms_import from queue menu -> check -> consistency

share the result.

regards,

kaushal

[MPGraziano · Accepted solution]

It was only a database refresh.

Then we do the post refresh configs, including the stms and realiagn with the domain controller

the config file for windows and server names, should not have been touched, in fact we just completed a refresh of DEV and we followed the same procedures except to rebuild the domain and 3sys config.

The problem remains that I cannot add to the que, it seems to read properly from the que when I do a refresh but does not display any transports, even when I try to add thru (extras>>> add)

I can actually see the transports of dev and prdn que, when I am in QAS but nothing in the QAS que.

m.

[MPGraziano · Accepted solution]

the result of the check consistence

all results are checked for datafile and cofiles

except... on QAS there are no files...

[Former Member · Accepted solution]

Hi,

check on OS level at QAS

/usr/sap/trans

check cofiles and data folder is this contain any files.

one more thing

did you find any .LOC file under \usr\sap\trans\buffer in QAS system

if yes delete it.

did you configure transport route after STMS configuration

regards,

kaushal

[MPGraziano · Accepted solution]

At the OS level for SAP there is no directory for usr/sap/trans this exists only in the DEV server at the OS Level

in DEV in usr/sap/trans we have

folder backup

and the following files

ECD

ECN

ECNOLD

ECNSAV

ECNTMP

ECP

ECPOLD

ECPSAV

ECPTMP

ECQ

ECQOLD

ECQSAV

ECQTM

TMS_TEST.ECP

TMS_TEST.ECQ

At OS for QAS system

there is user\sap\ECQ but there is no USR\SAP\TRANS

[MPGraziano · Accepted solution]

Yes I did configured the transport routes In Tranport Routes I see

Configuration Status

ECD (active symbol) System ECD

ECP (active symbol) Prod System

ECQ (active symbol) System ECQ

Transport Routes

-

---

ZECD Transport Layer ECD

--- ECQ System ECQ

-

---

ECP Production Instance

--- SAP

--- ECQ System ECQ

-

---

ECP Prod System

[MPGraziano · Accepted solution]

Donno if anyone has any more suggestions, but I am out of ideas, and now I have QAS sitting without transport route/transports

I'll keep searching ...

But if anyone can advise that would be great!!!!

[Former Member · Accepted solution]

Hi,

provide TP_DOMAIN_SID.PFL where SID is your QAS system SID.

you can find it under \usr\sap\trans\bin

also share the following result.

run stms in DEV system then from menu monitor-> rfc connections

STMS -> overview -> systems

regards,

kaushal

[Former Member · Accepted solution]

hi Maria,

FIle system /usr/sap/trans should be available in QA system. If you can't access it then

you should mount this file system from DEV to QA.

After that check the transport route in QA client 000.

If the route is not correctly, goto Menu SAP system - update configuration.

Check also QA system has the same transport group as DEV/PRD.

Let me know if still problem.

Regards

Ariyanto

[MPGraziano · Accepted solution]

Kaushal

The contents of TP_DOMAIN_ECD. file is below

#TMS:0009:DOMAIN_ECD

#U

#

#----

---

#Caution !

#This file was generated by the Transport Management System.

#Do not change this file using a text editor.

#For further information please see the online documentation of

#transaction STMS.

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

#To do this, log on to the domain controller (system ECD) and call

#Transaction STMS. In the System Overview, you can distribute the TMS

#configuration. This regenerates the file.

#STMS -> Overview -> Systems -> Extras -> Distribute TMS Configuration

#----

---

#

#

TRANSDIR =
m2003063dvm\sapmnt\trans

#

ECD/CTC = 0

ECD/DBHOST = M2003063DVM

ECD/DBNAME = ECD

ECD/DBTYPE = mss

ECD/NBUFFORM = 1

ECD/TP_VERSION = 266

#

ECP/CTC = 0

ECP/DBHOST = M2003066

ECP/DBNAME = ECP

ECP/DBTYPE = mss

ECP/NBUFFORM = 1

ECP/TP_VERSION = 266

#

ECQ/DBHOST = M2003065D

ECQ/DBNAME = ECQ

ECQ/DBTYPE = mss

ECQ/NBUFFORM = 1

ECQ/TP_VERSION = 266

ECQ is the system in question, and it is in this file that resides on the domain controller...

[MPGraziano · Accepted solution]

Thank YOU!!!!

the problem was we did not have the QAS / PRDN system configured in the domain with the correct group.

when I added the domain controller in there I can now add to the QAS tranport que

[Former Member · Accepted solution]

Hi,

following line in TP_DOMAIN_ECD is missing problem with config.

ECQ/CTC = 0

ECQ/DBHOST = M2003065D

ECQ/DBNAME = ECQ

ECQ/DBTYPE = mss

ECQ/NBUFFORM = 1

ECQ/TP_VERSION = 266

check config again save and distribute the settings

regards,

kaushal