I am trying to transport my templates from DEV to QA and PROD.
From transaction RSA1, I can add my template, and that adds all the underlying elements, like the query it appears. I am asked to assign the transport to a transport request, which I do, then release the transport through transaction SE09.
The transport is then pulled into QA and eventually PROD, but I get an error when opening the templates in QA, as it says the query doesn't exist. If I then open Query Designer, I can confirm that the query doesn't exist.
I have tried adding a single template to the transport request, and made sure all the items have the "transport" checkbox selected, and this doesn't work either.
Please, I am desperate to get these things through, so would appreciate any advice.