| Author |
Message
|
| why |
 Posted: Tue Jul 02, 2013 8:55 am Post subject: Database Input Node |
 |
|
Novice
Joined: 26 Jun 2013
Posts: 12
|
Version: MB 8
Fix pack 2.
| Code: |
Version: 8.0.0.2
Build id: 8.0.0.2-20130322-1723
|
The properties i have selected at flow level are not reflecting in Bar file config properties. Say i have selected Retry mechanism to Short interval which will disable long retry interval property on node. Later built a bar file newly on this flow and the bar file config properties on database input node still shows Long interval property and with default value. Happened the same while i selected Retry mechanism to Failure which will disable other properties at node but bar file built on it still showing the properties which are disabled.
Here comes my second question, the Retry Threshold property on Database input node, my understanding the flow will retry the many times the value we set in this filed if it errors out while processing in the flow. We have set the Retry threshold to 2(also tried with other values 0 and 3), but on debugging i have seen the flow handling the event only once and on error it terminates (we are doing error handling at catch and failure nodes) . Kindly please let me know how this property works and if my understanding is correct the flow should repeat on the value set on Retry threshold and its not happening.
Appreciate your response.
Last edited by why on Tue Jul 02, 2013 9:34 am; edited 1 time in total |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Tue Jul 02, 2013 9:21 am Post subject: Re: Database Input Node |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| why wrote: |
| Version: MB 8 Fix pack 2. |
Does this mean 8.0.0.2 or 8.0.0.0 ifix 2 ?
Version numbers have four digits. Be specific.
What is your effective level? Use mqisreportbroker to find out. Effective level is not the same as a version number.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| why |
| Posted: Tue Jul 02, 2013 9:40 am Post subject: Re: Database Input Node |
|
|
Novice
Joined: 26 Jun 2013
Posts: 12
|
| lancelotlinc wrote: |
| why wrote: |
| Version: MB 8 Fix pack 2. |
Does this mean 8.0.0.2 or 8.0.0.0 ifix 2 ?
Version numbers have four digits. Be specific.
What is your effective level? Use mqisreportbroker to find out. Effective level is not the same as a version number. |
Sorry i dont have access to broker. This i can get from toolkit.
Version: 8.0.0.2
Build id: 8.0.0.2-20130322-1723 |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Jul 02, 2013 9:56 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| why |
| Posted: Tue Jul 02, 2013 10:47 am Post subject: |
|
|
Novice
Joined: 26 Jun 2013
Posts: 12
|
| @lancelotlinc , i will post the bar file command result shortly. Can you please help me with Retry Threshold property of Database Input node. Thanks. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Jul 02, 2013 11:42 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Retry threshold is the number of times to try the flow transaction again when the Retry mechanism property value is Short retry or Short and long retry.
Let say for example your database trigger criteria fires up your DatabaseInput node. If, during processing, your flow throws an error. What do you want the database input node to do? Do you want it to retry? If so, how many times?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| why |
| Posted: Tue Jul 02, 2013 12:12 pm Post subject: |
|
|
Novice
Joined: 26 Jun 2013
Posts: 12
|
| lancelotlinc wrote: |
Retry threshold is the number of times to try the flow transaction again when the Retry mechanism property value is Short retry or Short and long retry.
Let say for example your database trigger criteria fires up your DatabaseInput node. If, during processing, your flow throws an error. What do you want the database input node to do? Do you want it to retry? If so, how many times? |
Thanks lancelotlinc, yes i also got the same feeling but it was not happening. Say there is a Database Input node and following a compute node ... and error handling at catch terminal. To generate an error scenario i kept the DSN wrong in compute node. The flow behaving like this no matter what property i have set for retry threshold observed from debugger. The flow picks up the database event, errors at compute node comes to input node and goes to catch terminal and terminates the flow and handles other event.
From what i read , if i have kept the Retry threshold to more than 1 the flow should repeat that many times when error and terminate after that many attempts. But i dont see this happening.
Kindly please feel free to correct me, and honestly appreciate your response. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Jul 02, 2013 12:29 pm Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
At the end of your catch logic, you need a throw. Either a node or THROW keyword in your Compute node.
If your catch logic does not notify the input node that there is still a problem, the input node thinks the issue was resolved and does not retry.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| why |
| Posted: Tue Jul 02, 2013 12:45 pm Post subject: |
|
|
Novice
Joined: 26 Jun 2013
Posts: 12
|
| lancelotlinc wrote: |
At the end of your catch logic, you need a throw. Either a node or THROW keyword in your Compute node.
If your catch logic does not notify the input node that there is still a problem, the input node thinks the issue was resolved and does not retry. |
Yes we have throw at catch terminal that brings the control back to db input node, and this scenario the flow is keep on looping for single event and when error flow is in hang state and every time we are restarting the flow. simple fix added Failure count >0 retrun false at compute node for catch terminal allowing the flow not to loop.
So basically you are saying with out trow is must for Retry threshold property, which i havent seen in info center. Again please feel free to correct me and appreciate your response. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Jul 03, 2013 3:51 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| why |
| Posted: Wed Jul 03, 2013 8:13 am Post subject: |
|
|
Novice
Joined: 26 Jun 2013
Posts: 12
|
| Interestingly i am not able to find the sample from my tool kit samples, any tweaks to get that imported to my local, i am using same version. Thanks. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Jul 03, 2013 8:17 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| why |
| Posted: Wed Jul 03, 2013 10:38 am Post subject: |
|
|
Novice
Joined: 26 Jun 2013
Posts: 12
|
| lancelotlinc wrote: |
| Help -> Search -> type "databaseinput sample" -> see results populated in "Local Help" |
Thank you very much, will try and get back to you. |
|
| Back to top |
|
|
| mqceries |
| Posted: Thu Jul 25, 2013 10:57 am Post subject: |
|
|
Acolyte
Joined: 02 Dec 2011
Posts: 70
|
| seems very nice thread,but stopped with out any updates/resolution. We are still in v7, will try to download 8 and check this..seems interesting. Does propogating a property wont work in 8 |
|
| Back to top |
|
|
|
|
