tag:blogger.com,1999:blog-4148344860241019504.post2594252808750557671..comments2024-03-26T18:47:12.971+05:30Comments on TechFindings...by Maheshkumar Tiwari: Fetching Data From Multiple Tables Through Dynamically Invoking Stored ProcedureMaheshkumar Tiwarihttp://www.blogger.com/profile/14535330323990019022noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-4148344860241019504.post-54377888706350384792017-11-14T13:00:12.273+05:302017-11-14T13:00:12.273+05:30Hi,
Sorry but question is not clear, can you plea...Hi,<br /><br />Sorry but question is not clear, can you please describe what exactly you want to do?Maheshkumar Tiwarihttps://www.blogger.com/profile/14535330323990019022noreply@blogger.comtag:blogger.com,1999:blog-4148344860241019504.post-35317488509871165782017-11-13T22:26:11.461+05:302017-11-13T22:26:11.461+05:30hi mahesh,
please how to get all fields in table ,...hi mahesh,<br />please how to get all fields in table , when i am working it gets the first field only please tell me how to do.Anonymoushttps://www.blogger.com/profile/11896548152389270992noreply@blogger.comtag:blogger.com,1999:blog-4148344860241019504.post-49447264014366296382015-05-04T12:37:15.443+05:302015-05-04T12:37:15.443+05:30Hi Vinoth,
I am good, thanks. Was away this week...Hi Vinoth, <br /><br />I am good, thanks. Was away this weekend. <br /><br />Have you set Delivery Notification = “Transmitted” , when this property is set to Transmitted it means that your orchestration will receive an exception if the message cannot be send to the destination.Delivery Notification works only when the Retry Count set to 0. When a message cannot be delivered, a DeliveryNotificationException is raised and this exception needs to be handled by the Orchestration (you can just log the error ).<br /> When you handle exception, the flow will continue else orchestration will be suspended.<br /> <br />Maheshkumar Tiwarihttps://www.blogger.com/profile/14535330323990019022noreply@blogger.comtag:blogger.com,1999:blog-4148344860241019504.post-73894531748263638282015-04-29T20:18:04.157+05:302015-04-29T20:18:04.157+05:30Hi Mahesh,
Hope you are doing good,
Actually am r...Hi Mahesh,<br /><br />Hope you are doing good,<br />Actually am recoded and implemented as per your solution. Now am in the process of implementing Exceptions. I tried multiple scenarios.<br /><br />My first loop is looping for number of databases to poll the data from multiple Tables. Second loop is number of Tables loop. In 2nd loop there is Scope and catch block. For the first time, first database is not reachable (for example), Table loop is keep trying to reconnect multiple times even my retry count is 0 for Dynamic send port.<br /><br />What my expectation is, if any one of the Database is not reachable, i have continue poll from the other databases. my code is keep trying the not reachable database but its not moving to next database.<br /><br />Please help me to resolve this.<br /><br />Thanks & regards<br />Vinoth Anonymoushttps://www.blogger.com/profile/09177432066472102144noreply@blogger.comtag:blogger.com,1999:blog-4148344860241019504.post-81535756770311600542015-04-29T19:31:40.387+05:302015-04-29T19:31:40.387+05:30Hi Mahesh,
Hope you are doing good,
Actually am r...Hi Mahesh,<br /><br />Hope you are doing good,<br />Actually am recoded and implemented as per your solution. Now am in the process of implementing Exceptions. I tried multiple scenarios.<br /><br />My first loop is looping for number of databases to poll the data from multiple Tables. Second loop is number of Tables loop. In 2nd loop there is Scope and catch block. For the first time, first database is not reachable (for example), Table loop is keep trying to reconnect multiple times even my retry count is 0 for Dynamic send port.<br /><br />What my expectation is, if any one of the Database is not reachable, i have continue poll from the other databases. my code is keep trying the not reachable database but its not moving to next database.<br /><br />Please help me to resolve this.<br /><br />Thanks & regards<br />Vinoth Anonymoushttps://www.blogger.com/profile/09177432066472102144noreply@blogger.com