Skip to Content
0
Former Member
Nov 02, 2006 at 06:40 PM

STMS - Transports not being automatically marked for import into the next

1265 Views

We've recently removed the QA server from our landscape, therefore changing the Transport Route. Transport route was Dev > QA > Delivery group for Q-Prod & Prod. With QA server removed the Trans Route should now be Dev > Q-Prod > Prod.

The problem is that after a released transport request has been imported successfully into Q-Prod, it should automatically be marked for import into Prod, but does not. I am required to manually forward the request (from import queue of Q-Prod)or copy the data & co-files from Dev server, into the Prod trans\bin, then manually add to the Prod Import Queue. (Added complexity is that each system has a different transport directory, which is not on these servers and Subnets.)

My temp work around has Q-Prod and Prod in the same Consolidation Group after Dev, which means the request is forwarded to both Import Queues once it has been released in Dev. (Not desired)

I have already tried deleting & re-adding Prod to the transport domain, and recreating the transport route, as well as creating a delivery group after Q-Prod.

Below are a couple of tests run and results:

Test 1: Transport Route Dev > Consolidation grp (4 Dev clients + Q-Prod) > Prod

1a) Created transport request in Dev and released it. Transport was added to all Dev clients and Q-Prod import queues. (Transport Directory Buffer files for Dev & Q-Prod had the time stamp change, Prod remained un changed) The transport number appeared in the Import Queue of Dev and Q-Prod clients.

1b) Successfully imported the transport into Q-Prod minutes later. (Tran Dir Buffer files for Dev & Q-Prod did not change)

1c) Import did not show up in Prod's Import Queue (Prod's buffer file did not change)

Test 2: Changed Transport Route to Dev > Consolidation grp (Dev clients + Q-Prod + Prod)

2a) Created transport in Dev and Released. Transport was added to all Dev clients, Q-Prod & Prod import queues. (Trans Dir Buffer files for Dev, Q-Prod & Prod time stamp changed)

2b) Deleted transport from the Prod Import Queue (Trans Dir Buffer file for Prod time stamp changed)

2c) Deleted transport from the Q-Prod Import Queue (Trans Dir Buffer file for Q-Prod time stamp did NOT change)

Any ideas out there?

We have R3 4.7 on SQLServer 8 and Windows 2003, but shouldn't matter.