Locked object: Transport of Query Structure does not activate in target sys

[Former Member]

Hello experts,

This problem has been bugging me all day. I recently made a change to an existing query structure (without key figures) with new variables. When I attempt to transport it to our target QA system, the structure refuses to activate to the new version. I see the variables in the system, and I see the modified version existing in table RSZELTXREF, but it wont activate to the version that I created in the dev system. I've used "override originals" and "overwrite local changes" as well.

As a side note, this QA system was recently copied over from production, so i dont know if there if there is an object ownership problem, but TADIR seems to have the correct entries.

Here is the transport log of one of the objects isolated in a test transport:

 Start import R3TRELEMDATFJL1GKX0MFP9SVNQH2U629 ...
   1 entry for TADIR updated  (R3TRELEMDATFJL1GKX0MFP9SVNQH2U629               ).
   0 entries from SMODILOG (ELEMDATFJL1GKX0MFP9SVNQH2U629               %) deleted.
   0 entries from SMODILOG (ELEMDATFJL1GKX0MFP9SVNQH2U629               %) deleted.
   0 entries from SMODISRC (CIELEMDATFJL1GKX0MFP9SVNQH2U629               %) deleted.
   0 entries from SMODISRC (CIELEMDATFJL1GKX0MFP9SVNQH2U629               %) deleted.
   0 entries from SMODISRC (CUELEMDATFJL1GKX0MFP9SVNQH2U629               %) deleted.
   0 entries from SMODISRC (CUELEMDATFJL1GKX0MFP9SVNQH2U629               %) deleted.
   0 entries from SMODISRC (CVELEMDATFJL1GKX0MFP9SVNQH2U629               %) deleted.
   0 entries from SMODISRC (CVELEMDATFJL1GKX0MFP9SVNQH2U629               %) deleted.
   0 entries from SMODISRC (PRELEMDATFJL1GKX0MFP9SVNQH2U629               %) deleted.
   0 entries from SMODISRC (PRELEMDATFJL1GKX0MFP9SVNQH2U629               %) deleted.
   0 entries from SMODISRC (SVELEMDATFJL1GKX0MFP9SVNQH2U629               %) deleted.
   0 entries from SMODISRC (SVELEMDATFJL1GKX0MFP9SVNQH2U629               %) deleted.
   1 entry for RSZELTDIR updated  (DATFJL1GKX0MFP9SVNQH2U629M).
   1 entry for RSZELTTXT updated  (DATFJL1GKX0MFP9SVNQH2U629M*).
   0 entries from RSZCALC (DATFJL1GKX0MFP9SVNQH2U629M%) deleted.
   0 entries from RSZCALC (DATFJL1GKX0MFP9SVNQH2U629M%) deleted.
   0 d /   0 i /   0 u /   3 = 100% ucf RSZELTXREF
   3 entries for RSZELTXREF imported (DATFJL1GKX0MFP9SVNQH2U629M*).
   0 d /   0 i /   0 u /   5 = 100% ucf RSZRANGE
   5 entries for RSZRANGE imported (DATFJL1GKX0MFP9SVNQH2U629M*).
   0 d /   0 i /   0 u /   4 = 100% ucf RSZSELECT
   4 entries for RSZSELECT imported (DATFJL1GKX0MFP9SVNQH2U629M*).
   0 entries from RSZCOMPDIR (DATFJL1GKX0MFP9SVNQH2U629M) deleted.
   0 entries from RSZCHANGES (DATFJL1GKX0MFP9SVNQH2U629M%) deleted.
   0 entries from RSZCHANGES (DATFJL1GKX0MFP9SVNQH2U629M%) deleted.
   0 entries from RSZCOMPIC (DATFJL1GKX0MFP9SVNQH2U629M%) deleted.
   0 entries from RSZCOMPIC (DATFJL1GKX0MFP9SVNQH2U629M%) deleted.
   0 entries from RSZGLOBV (DATFJL1GKX0MFP9SVNQH2U629M) deleted.
   0 entries from RSZELTPRIO (DATFJL1GKX0MFP9SVNQH2U629M%) deleted.
   0 entries from RSZELTPRIO (DATFJL1GKX0MFP9SVNQH2U629M%) deleted.
   1 entry for RSZELTPROP updated  (DATFJL1GKX0MFP9SVNQH2U629M).
   0 entries from RSZELTATTR (DATFJL1GKX0MFP9SVNQH2U629M%) deleted.
   0 entries from RSZELTATTR (DATFJL1GKX0MFP9SVNQH2U629M%) deleted.
   0 entries from RSRREPDIR (DATFJL1GKX0MFP9SVNQH2U629M%) deleted.
   0 entries from RSZCEL (DATFJL1GKX0MFP9SVNQH2U629M) deleted.
 no entries from RSZCOMPEXT (DATFJL1GKX0MFP9SVNQH2U629M*) deleted (table is empty).
 no entries from RSZCOMPEXT (DATFJL1GKX0MFP9SVNQH2U629M*) deleted (table is empty).
 End of import R3TRELEMDATFJL1GKX0MFP9SVNQH2U629
 E071-LOCKFLAGs 000001 - 000001 updated ('2', 1 entries).
 HBDK926679           touched.
   1 tables in P-buffer synchronized.
   0 tables in R-buffer synchronized.

So any ideas would be great. The entire team is stumped.

[Former Member]

We found the problem.

The structure was being locked by a user in the QA system and overnight the M version finally activated after another transport attempt.

The second structure with this problem was only referenced as a local object (even though it had a proper tech name and package assignment) preventing its activation in the QA system. We needed to hack the query tables to make it look like a proper global structure, then re-transported and it activated.