| Author |
Message
|
| eai143 |
 Posted: Mon Sep 30, 2013 5:49 am Post subject: Getting Esql code from deployed bar |
 |
|
Apprentice
Joined: 16 Aug 2006
Posts: 28
|
Hi All,
Is there any way, to get the esql code from deployed bar file.
We have done changes to a flow and deployed to broker. It is working fine. But later, the workspace got deleted in remote system, and we are not able to get the flows. 
can we get the code from the deployed bar file? |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Mon Sep 30, 2013 5:52 am Post subject: Re: Getting Esql code from deployed bar |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| eai143 wrote: |
Hi All,
Is there any way, to get the esql code from deployed bar file.
We have done changes to a flow and deployed to broker. It is working fine. But later, the workspace got deleted in remote system, and we are not able to get the flows.
can we get the code from the deployed bar file? |
This question has been asked several hundred times in this forum. The answer is no. There is no replacement for source code repository.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| dogorsy |
| Posted: Mon Sep 30, 2013 6:09 am Post subject: Re: Getting Esql code from deployed bar |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
| eai143 wrote: |
Hi All,
Is there any way, to get the esql code from deployed bar file.
We have done changes to a flow and deployed to broker. It is working fine. But later, the workspace got deleted in remote system, and we are not able to get the flows.
can we get the code from the deployed bar file? |
No. Don't you have code respositories, back ups, etc ? |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Sep 30, 2013 6:20 am Post subject: Re: Getting Esql code from deployed bar |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
|
| Back to top |
|
|
| Simbu |
| Posted: Mon Sep 30, 2013 6:24 am Post subject: |
|
|
Master
Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India
|
you can use the below commands to retrieve the content of the deploy flows
| Quote: |
mqsibrowse
mqsireportproperties |
Also check the components under %MQSI_WORKPATH%, there will be folder called ESQL which has the ESQL file(not sure for .cmf). |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Sep 30, 2013 6:32 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Simbu wrote: |
you can use the below commands to retrieve the content of the deploy flows
| Quote: |
mqsibrowse
mqsireportproperties |
Also check the components under %MQSI_WORKPATH%, there will be folder called ESQL which has the ESQL file(not sure for .cmf). |
mqsibrowse: "Use this command only at the request of IBM® service."
mqsireportproperties : only gives you the properties.
Simbu - if you are only providing an incomplete solution, better to not provide any. No, it is not possible to reconstitute a bar file, which is what the OP is asking.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Simbu |
| Posted: Mon Sep 30, 2013 6:52 am Post subject: |
|
|
Master
Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India
|
I just given the ways to get the content of the ESQL file.
| lancelotlinc wrote: |
| mqsibrowse: Use this command only at the request of IBM® service. |
agree with you but still we can use at our own cost.
| Code: |
mqsireportproperties <BrokerName> -e <ExGrpName> -o AllMessageFlows -r > mqsireportproperties.txt |
-o AllMessageFlows will give us the content of the message flows in the EG. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Sep 30, 2013 7:00 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Simbu wrote: |
I just given the ways to get the content of the ESQL file.
| lancelotlinc wrote: |
| mqsibrowse: Use this command only at the request of IBM® service. |
agree with you but still we can use at our own cost.
| Code: |
mqsireportproperties <BrokerName> -e <ExGrpName> -o AllMessageFlows -r > mqsireportproperties.txt |
-o AllMessageFlows will give us the content of the message flows in the EG. |
Still it does not reconstitute the bar. Are you saying that mqsireportproperties does? If there 100 nodes in the message flows of a bar, all connected in different ways, what good is your suggestion to the OP, who needs all the source in order to reconstruct the bar and workspace ?
Why would you recommend this approach rather than using proper source code control repository ?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Simbu |
| Posted: Mon Sep 30, 2013 7:19 am Post subject: |
|
|
Master
Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India
|
I agree that we should use proper source code control repository and not saying that we can retrieve the deployed bar but we can get the content to some extend which will be helpful to regenerate the flow.
Also OP can look at the pattern "Generate Message Flow Pattern " in this forum to regenerate the flow(only .msgflow). |
|
| Back to top |
|
|
| wbisantosh |
| Posted: Tue May 20, 2014 12:56 pm Post subject: |
|
|
Apprentice
Joined: 12 Nov 2012
Posts: 47
|
Sorry to Re-open an old post.
I am in the similar situation, trying to find the artifacts I can. I know they cannot be completely retrieved.Its annoying that the Implementing Vendor has left us without providing the Source Code. But,the thought of getting ESQL is little Amusing.
The Developer must have selected "Compile and in-line Resources" as the ESQL folder(inside the %MQSI_WORKPATH%) seem to be empty
The Issue is with the "Application"
When I run the command
| Code: |
| mqsireportproperties <BrokerName> -e <ExGrpName> -o AllMessageFlows -r > mqsireportproperties.txt |
It is giving me the ESQL for the Messageflows under the Execution Group only but not the one's in an Application.
Per Say, If I have a EG -EG1 And I deployed Messaflow - MF1(Independent Resource) and Application - App1->App.MF1(Messageflow Name). I am able to retrieve the ESL for MF1 but not the App.MF1
Is there any flag I am missing out in the command ?
Environment-
WMB v8(FP3)
zLinux
Thanks
Santosh |
|
| Back to top |
|
|
| Simbu |
| Posted: Tue May 20, 2014 5:56 pm Post subject: |
|
|
Master
Joined: 17 Jun 2011
Posts: 289
Location: Tamil Nadu, India
|
| Check the components under %MQSI_WORKPATH%, there will be a folder named ESQL somewhere in the path which has the ESQL file of the application. |
|
| Back to top |
|
|
| wbisantosh |
| Posted: Tue May 20, 2014 7:55 pm Post subject: |
|
|
Apprentice
Joined: 12 Nov 2012
Posts: 47
|
Thanks for the Reply.
You are correct! But, when "Compile and in-line Resources" is checked while building the BAR file, the ESQL directory is being EMPTY. Is it because the Message Flow get complied and there will be no .esql file in the CMF to place it in the Directory ?
Is this possible with WMB v8 ?
Thanks
Santosh |
|
| Back to top |
|
|
| vishnurajnr |
| Posted: Tue May 20, 2014 8:55 pm Post subject: |
|
|
Centurion
Joined: 08 Aug 2011
Posts: 134
Location: Trivandrum
|
| Quote: |
| mqsireportproperties <BrokerName> -e <ExGrpName> -o AllMessageFlows -r > mqsireportproperties.txt |
This command will give you the deployed ESQL details only when it was deployed using the option "Compile and in-line Resources". If the message flow application was build using that option, then you might be able to retrieve the ESQLs in the message flow app also.
Else (When compiled without the option 'Compile and in-line Resources'), it will just give the details of message flow only. |
|
| Back to top |
|
|
| wbisantosh |
| Posted: Tue May 20, 2014 10:07 pm Post subject: |
|
|
Apprentice
Joined: 12 Nov 2012
Posts: 47
|
Awesome 
It Worked
Thanks for the Clarity. Appreciate it  |
|
| Back to top |
|
|
|
|
