Transported Queries

[Former Member]

Hi Experts,

I have a problem:

I transported some quereis from BWD to BWT system and they are looking fine in BWT and I cant change them in BWT.

But I can not change the quereis even in BWD .

Can you please suggest something because I am trying to make a copy of the quereis in BWD and then change them as needed instead of recreating everything from scratch.

Thanks

Lakshmi

[Former Member · Accepted solution]

You need to create a open Bex transport request and then can change the query which are transported..

[Former Member · Accepted solution]

If you are getting error as " Locked against external changes"...?

then you have to record changes to BEx objects, by creating an open transportable change request as the transport request for BEx objects or enter a new, targeted transport request in the Administrator Workbench in the transport connection by using the 'BEx' pushbutton (Create Transport Requests for BEx).

Hope this helps..

Regards

Manga(Assign points if it helps!!)

[Former Member · Accepted solution]

Can you please tell me the steps to do this?

[Former Member · Accepted solution]

Go to transport connection in RSA1..You should see a button with BEx truck symbol..click on that..it pop-ups a window for BEx Transport requests..Click on Assign /Delete button it will prompt for creation of new workbench request..create it..It should give you the request number as some thing like BWDK9134*..

Now choose your package (Z*) that your query is saved under..

and you should be fine..

Regards

Manga(Assign points if it helps!!)

[Former Member · Accepted solution]

I did it and its working !!

Thanks

I would like to make sure one thing: Will this affect anything else udner the same Z* package?

[Former Member]

Hi Sri;

The Queries are changeable to all systems. What kind of error are you getting?? give us more details level info..can you able to open the Queries? try to make a copy of the queries doing just save as from the query designer...and see if this works.

BK