Book Image

Enterprise Integration with Azure Logic Apps

By : Matthew Bennett
Book Image

Enterprise Integration with Azure Logic Apps

By: Matthew Bennett

Overview of this book

Logic Apps are a visual flowchart-like representation of common programming actions, and are a flexible way to create logic without writing a single line of code. Enterprise Integration with Azure Logic Apps is a comprehensive introduction for anyone new to Logic Apps which will boost your learning skills and allow you to create rich, complex, structured, and reusable logic with instant results. You'll begin by discovering how to navigate the Azure portal and understand how your objects can be zoned to a specific environment by using resource groups. Complete with hands-on tutorials, projects, and self-assessment questions, this easy-to-follow guide will teach you the benefits and foundations of Logic App logic design. As you advance, you'll find out how to manage your Azure environment in relation to Logic Apps and how to create elegant and reliable Logic Apps. With useful and practical explanations of how to get the most out of Logic App actions and triggers, you'll be able to ensure that your Logic Apps work efficiently and provide seamless integration for real-world scenarios without having to write code. By the end of this Logic Apps book, you'll be able to create complex and powerful Logic Apps within minutes, integrating large amounts of data on demand, enhancing your systems, and linking applications to improve user experience.
Table of Contents (17 chapters)
1
Section 1: Logic App Fundamentals
7
Section 2: Logic App Design
13
Section 3: Logic App Maintenance and Management

Understanding SQL connection timeouts/bad gateway messages

When working with SQL queries or Insert/Update statements, you will find that the action is reasonably reliable. However, when you are connecting to an on-premises server that is part of the infrastructure, there may be several points of failure, not including the database server itself, which may be busy. Requests will be queued, and other queries may have exclusive access, meaning that your request will have to wait. Once the wait window has elapsed (typically, the default is 2 minutes), the request may retry if you have set the policy to do this, or the action will mark it as a failure.

Connection wait timeout errors

If you are running a complex SQL query or script that takes a long time to process (if the logic app has not heard back within 2 minutes), the logic app may produce an error, along with a timeout message:

Figure 12.15 – Standard gateway timeout message

If you ever experience...