I usually use the series A fish out of water when I want to write something that goes a little bit off-topic on my main blog topic: Enterprise Integration. But this time is different. This was kind of the first thing I thought when I saw this error happen since that didn’t make sense at all.
To contextualize better this reason and blog post, I have been testing the new Logic Apps (Preview) for a while, and if you already try it before, you will know that this new type of Logic Apps runs on top of Azure Function Runtime. This means that now you can run Logic Apps anywhere: in the cloud, on-premises, locally on your laptop, or wherever you need to.
One of the requirements necessary to have the full Logic Apps designer support in VS Code is the Microsoft Azure Storage Emulator 5.10 tool
Microsoft Azure Storage Emulator 5.10 tool – This tool is necessary to have the full Logic Apps designer support in VS Code. This tool will use a local Microsoft SQL Server Express LocalDB instance (you can also use a SQL Server instead) to emulate Azure storage services.
Everything was working properly for the last four months or more, however for no plausible reason today while I was trying to start the Microsoft Azure Storage Emulator I got this error:
Probing SQL Instance: ‘(localdb)MSSQLLocalDB’. Caught exception while probing for SQL endpoint. A network-related or instance-specific error occurred while discovering a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 – Local Database Runtime error occurred. Error occurred during LocalDB instance startup: SQL Server process failed to start. ) Number of SqlErrors Reported: 1 SqlError: System.Data.SqlClient.SqlError: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 – Local Database Runtime error occurred. Error occurred during LocalDB instance startup: SQL Server process failed to start. ) Could not find a LocalDB Installation. Probing SQL Instance: ‘localhostSQLExpress’. Caught exception while probing for SQL endpoint. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) Number of SqlErrors Reported: 1 SqlError: System.Data.SqlClient.SqlError: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) No available SQL Instance was found. One or more initialization actions have failed. Resolve these errors before attempting to run the storage emulator again.
Cause
Again, I can’t find any plausible reason for this to start happend, except the fact that my machine installed some system updates.
Solution
I don’t know if all these steps are necessary or not, I was just simple frustrated about this situation because I need to present this topic in my upcoming sessions this week, so I didn’t test all the hypotheses available properly. Nevertheless, I managed to solve this issue by simply recreating my LocalDb instances and allowing the emulator to recreate his db files.
Here is the steps necessary to perform these tasks:
Get your current LocalDB instance name
<pre class="wp-block-preformatted">
sqllocaldb i
</pre>
Delete the existing LocalDB instance
If you feel more comfortable you can choose to stop the LocalDB instance before you delete
<pre class="wp-block-preformatted">
sqllocaldb d &lt;LocalDB instance>
</pre>
Create your new LocalDB instance with the same name or a different one.
<pre class="wp-block-preformatted">
sqllocaldb c &lt;LocalDB instance>
</pre>
and finally, you need to delete the following Azure Storage Emulator database files to allow the emulator to recreate db files on the first start.
Happy to announce that I will be present and deliver a session at Global Integration Bootcamp 2021. This year we will have a single virtual event instead of several local virtual events. My talk will be about Logic App (Preview)
Logic App (Preview): The new kid on the block
Session Name: Logic App (Preview): The new kid on the block
Abstract: In this session, we will dive into the Public Preview for the new Logic Apps powered by the Azure Functions containerized runtime, letting you run Logic Apps locally, on-premises, or wherever you need to. Showing some of the most important features and explain the differences between the new and the existing Logic App.
My session will be Saturday, February 27 at 1:00 PM UTC+1. Join us and reserve your presence at the Global Integration Bootcamp 2021 virtual event, it is free!
Sessions, sessions, and more sessions this has been my frantic start to the year in terms of contributions to the community, four different presentations delivered in January where Logic Apps was the only common factor:
Logic Apps: Development experiences at Azure User Group Portugal with Pedro Almeida (video not yet available)
How to create robust monitor solutions with PowerShell, Azure Functions and Logic Apps at Azure Lowlands (video not yet available)
and Logic Apps: Anywhere, Everywhere at Microsoft Integrate Conference DACH
Today I’m happy to share with you the slides and the video of this last session are now available online for those who want to see them.
About the session
Session name: Logic App: Anywhere, Everywhere.
Abstract: A walk-thru session on how and where we can or should use Logic Apps and start building fantastic business processes. We will be addressing topics like: what tools should you use: Azure Portal, Visual Studio, or Visual Studio Code. What kind of solutions you can create, cloud integration, hybrid integration, or on-premises integration. Along with some best practices and what are the advantages and drawbacks of each approach.
For any reason, you could not be present at this online event, or if you want to review it again, you can now do it here:
It was a pleasure to deliver a presentation on this event, and most important, by doing that, I was able to raise and give away 1000€ to a non-profit organization.
Finally, the last chapter of this blog post series where we address:
What we need to install to begin developing our stateful and stateless workflows using Azure Logic Apps (Preview) – PART I;
The first approach to what you need to create a new Logic App (Preview) resource and new stateful or stateless workflows through VS Code – PART II;
Today, I will start to explain a different and more powerful way for you to create your Logic Apps (Preview) projects and workflows. Notice that, for this approach, you need to have all the prerequisites installed; otherwise, it will not work correctly or at least certain features like Logic App Designer, debug, or inline code.
If you are like me, a developer used to work with Visual Studio as his primary tool, then you need a little learning curve to start developer using VS Code. It is a different way to developer your solutions.
Create a local project
Before you can create your logic app, the first thing you need to do is to create a local project. This will allow you to manage and deploy your logic app from Visual Studio Code.
To do that, you need to:
In your development environment, create an empty local folder:
in my case, C:VSCODEMy-First-Logic-App-Preview
This folder will be used for our Logic App (Preview) project that you’ll later associate in the Visual Studio Code.
Note: Using the VS Code, there are multiple ways for you to:
Create the local project: you can do it at the Subscription level or the Logic App (Preview) resource level (n the Logic App (Preview) extension);
Create the Logic Apps (Preview) resource in Azure: Directly from the Subscription level on the Logic App (Preview) extension or during the local project deployment;
And even the deployment: once again in the Logic App (Preview) resource level (n the Logic App (Preview) extension) or at the Çocal project level;
I will approach and explain the way I prefer better and which I think is the most ideal.
I am assuming that you have already created the Logic App (Preview) resource in Azure. If not, check to Create a new Logic App (Preview) resource in PART II.
In the Azure pane, from the Logic Apps (Preview) extension, expand your Subscription, select the Logic App (Preview) resource, and click on Create New Project.
This will open the Browse Explorer, select the folder we have created.
C:VSCODEMy-First-Logic-App-Preview
Centered at the top of the VS Code editor window, a wizard will appear asking to select a template for your project’s first workflow, select either Stateful Workflow or Stateless Workflow. We will be using Stateful Workflow.
Provide a workflow name for the workflow you are creating or leave the default nameType Stateful-workflow-example and press Enter
Next, the wizard will ask you if we would like to open your project in a new window or the current one; select Open in current window.
Visual Studio Code reloads and will switch to the Explorer pane, showing you the workflow definition and your new Logic App (Preview) local project, which will include several automatically generated project files. For example:
The project will have a folder with the name that you specify for your workflow – Stateful-workflow-example. Inside this folder, the workflow.json file contains your logic app workflow’s underlying JSON definition.
Also host.json and local.settings.json files;
and so on.
Developing your Logic Apps in VS Code
Now that we have everything we need already created, we can start developing our logic apps locally on VS Code.
To do that, you need to:
Expand the project folder, in my case MY-FIRST-LOGIC-APP-PREVIEW, and then expand your workflow folder, Stateful-workflow-example. Righ-click workflow.json file and select Open in Designer.
From the Enable connectors in Azure list, select Use connectors from Azure, which applies to all managed connectors that are available and deployed in Azure, not just connectors for Azure services.
From the Select subscription list, select your subscription. This will be were the connectores will be created.
And finally, from the Select a resource group for new resources list, select the resource that you created for this project.
After that, the Logic App Designer appears, the Choose an operation prompt appears on the designer and is selected by default, which shows the Add a trigger pane.
Note: If you have .NET Core SDK 5.x, this version might prevent you from opening the logic app’s underlying workflow definition in the designer. Rather than uninstall this version, in your project’s root location, create a global.json file that references the .NET Core runtime 3.x version that you have that’s later than 3.1.201, for example:
Make sure that you explicitly add that global.json file to your project at the root location from inside Visual Studio Code. Otherwise, the designer won’t open.
To check the versions that are installed on your computer, run the following command:
..Users{yourUserName}dotnet --list-sdks
And the rest is basically the same that we are already used to doing it in our “original” Logic Apps, or using the Azure Portal or inside Visual Studio. We need to add a trigger and actions.
On the designer, select the Choose an operation an in the Add a trigger pane, under the Choose an operation search box, make sure that Built-in is selected so that you can select a trigger that runs natively.
In the Choose an operation search box, enter when a http request, and select the built-in Request trigger that’s named When a HTTP request is received.
When the trigger appears on the designer, the trigger’s details pane opens to show the trigger’s properties, settings, and other actions.
This means that you can now define the JSON Schema, method, and all the other properties of this trigger.
Let’s leave the default for now.
Because this is a simple sample, let’s add an HTTP Response to our logic. On the designer, under the trigger that you added, select New step.
On the Add an action pane, under the Choose an operation search box, enter Response, and select the built-in Request action that’s named Response.
To have a more friendly response, set the body property of the Response action to be:
{
"Message": "Welcome to your first Stateful Workflow"
}
Finally, on the designer, select Save.
Now what we need before deploying this is to run and test this workflow locally.
Testing locally our Logic Apps
To do that, we need to:
On the Visual Studio Code toolbar, open the Run menu, and select Start Debugging (F5).
A Terminal window will open so that we can review the debugging session.
Because this workflow is trigger by an HTTP request, we need to find the callback URL for the endpoint on the Request trigger. Usually, we go to the When a HTTP request is received trigger, after we save our Logic App, and on the HTTP POST URL, we would find the callback URL. However, we will not find it locally. Instead, we will find a message saying, “Url not available during authoring in local project. Check the Overview page.”
As the message describes, for us to now the callback URL for the endpoint on the Request trigger we need to:
Reopen the Explorer pane so that you can view your project.
And from the workflow.json file’s inside the workflow folder – Stateful-workflow-example – right-click and select Overview.
There you will find the Workflow Properties like the Callback URL but also the local Run History of that workflow
Copy that URL to Postman or any other tool, and test sending a request to see if you get the desired outcome.
On the Overview page, you will get another entry on the Run History.
How can I add more workflows to my project?
Can I add more workflows to my local project? If so, how can I do it?
Yes, you can. And to do that, you need to:
Switch back to Azure pane and under Logic App (Preview), select your Logic App resource, and select Create Workflow.
A wizard will appear asking to select a template for your workflow, select either Stateful Workflow or Stateless Workflow. We will be using Stateful Workflow.
Provide a workflow name for the workflow you are creating or leave the default name, Type Another-Stateful-workflow-example, and press Enter.
Now, if we switch back again to the Explorer pane, we will notice that we have another workflow added to our local project.
Publish (deploy) to Azure Logic App (Preview) resource
Everything we created above is not created/publish on Azure, they were developed and created locally. Nevertheless, from Visual Studio Code, you can deploy your project and with it all your workflows directly to Azure. If the Logic App (Preview) resource type is not yet created, you can create in Azure during the deployment.
To do that, you need to:
On the Visual Studio Code toolbar, select the Azure icon.
On the Azure: Logic Apps (Preview) pane toolbar, select your Logic App (Preview) resource type, in our case, My-First-Logic-App-Preview, and then select Deploy to Logic App.
The deploy wizard will appear asking to Select subscription from the list.
And then to Select Logic App (Preview) in Azure. We will be selecting the one that we craete previously
If a message appear asking you if you want to continue with the deployment and overwrite any previou depoyment, select Deploy.
This will trigger the deployment process to Azure. Once the deployment is finished, you will be able to see your stateful workflows live in Azure and enabled by default.
Today we will see one of the ways to create a new Logic App (Preview) resource and new stateful or stateless workflows through VS Code. This doesn’t mean that it’s the best way, but later we will address this topic.
Create a new Logic App (Preview) resource
To do that, you need:
Open your VS Code, select the Azure icon.
In the Azure pane, under Azure: Logic Apps (Preview), select Sign in to Azure.
When the Visual Studio Code authentication page appears, sign in with your Azure account.
After you sign in, the Azure pane shows the subscriptions in your Azure account.
Any Logic Apps resources you may have already deployed/released it will not be showing here. You can see any original Logic Apps resources you created using the original extension in the released extension’s Logic Apps section.
In the Logic App (Preview) section, you will only see the new Logic Apps (Preview) resource type within functions runtime.
Note: You cannot create a Logic Apps (Preview) resource type directly from the Azure Portal. The only option at the moment is using Visual Studio Code (and probably scripting).
This is probably the best way, but if you don’t fill comfortable to work in VS Code, the first thing you can do is:
From the Logic Apps (Preview) extension, right-click on your Subscription and select one of the two options:
Create Logic App in Azure…
Create Logic App in Azure… (Advance) – we will be using this one.
Centered at the top of the VS Code editor window, a wizard will appear asking to specify a globally unique name for the logic app, which is the name to use for the Logic App (Preview) resource.
Type My-First-Logic-App-Preview and press Enter.
The second step will ask you to select a hosting plan for your new logic app, either App Service Plan or Premium.
Select App Service Plan.
The next step asks you if you want to create a new App Service plan or select an existing plan.
Select Create new App Service Plan.
Enter the name of the new App Service Plan you are creating or leave the default name
Type My-First-Logic-App-Preview-AS-Plan and press Enter.
And then select a pricing tier for the new App Service plan.
Select the S1 Standard plan (you can choose F1 Free plan).
The next step asks you if you want to create a new resource group for new resources or select an existing resource group.
In this case, select Create new resource group
Enter the name of the new resource group you are creating or leave the default name
Type My-First-Logic-App-Preview-RG and press Enter.
The next step asks you if you want to create a new storage account or select an existing storage account.
In this case, select Create new storage account
Enter the name of the new storage account you are creating or leave the default name
Type myfirstlogicapppreviewsa and press Enter.
The next step asks you if you want to create a new Application Insights resource or select an existing Application Insights resource.
In this case, select Create new Application Insights resource
Enter the name of the new Application Insights resource you are creating or leave the default name
Type My-First-Logic-App-Preview-AppIns and press Enter.
And finally, select a location for the new resources
In our case, West Europe
After that, you will see on the bottom right of VS Code Editor windows a status progress of the resources being created in Azure:
After it is finished, you will be able to see that resources in VS Code:
And the same thru the Azure Portal:
Create a new stateful or stateless workflows
Now that we have our Logic App (Preview) resource created, we can start creating our:
Stateful workflows: Stateful logic apps provide high resiliency if or when outages happen. After services and systems are restored, you can reconstruct the interrupted logic app runs from the saved state and rerun the logic apps to completion. Stateful workflows can continue running for up to a year.
Create stateful logic apps when you need to keep, review, or reference data from previous events. These logic apps keep the input and output for each action and their workflow states in external storage, which makes reviewing the run details and history possible after each run finishes.
or Stateless workflows: Create stateless logic apps when you don’t need to save, review, or reference data from previous events in external storage for later review. These logic apps keep the input and output for each action and their workflow states only in memory, rather than transfer this information to external storage. As a result, stateless logic apps have shorter runs that are usually no longer than 5 minutes, faster performance with quicker response times, higher throughput, and reduced running costs because the run details and history aren’t kept in external storage. However, if or when outages happen, interrupted runs aren’t automatically restored, so the caller needs to manually resubmit interrupted runs. These logic apps can only run synchronously and for easier debugging, you can enable run history, which has some impact on performance.
To do that we can:
Select the Logic App (Preview) resource we created previously, My-First-Logic-App-Preview, and then click on the Create Workflow… button.
Centered at the top of the VS Code editor window, a wizard will once again appear asking to select a template for your workflow, select either Stateful Workflow or Stateless Workflow.
We will be using Stateful Workflow
Provide a workflow name for the workflow you are creating or leave the default name
Type My-First-Stateful-Workflow and press Enter
This will create locally a workflow.json file that contains your logic app workflow’s underlying JSON definition.
Note: the Stateful Workflow is not yet created in Azure.
Since full Logic Apps designer is supported in VS Code in this kind of resource, you may be thinking that now you can switch to Logic Apps designer… Unfortunately, using this creation strategy, you can’t! It will be exactly like the original Logic App extension. Only the code view is supported, and the Designer is read-only.
Does that mean that Logic Apps designer is not supported in VS Code? No, it is, but you need to use a different approach that we will address later in Part III.
You can modify the workflow logic as you want, for example, the bellow code:
Now, to actually create this resource in Azure (in the Logic App (Preview) resource group) you need to:
Select the Logic App (Preview) resource we created previously, My-First-Logic-App-Preview, and then click on the Deploy to Logic App… button.
If it asks if you are sure and if you want to overlap existing resources, select Yes.
The deployment will make take some minutes to finish. After that, you will be able to see it on the Workflow list inside the Logic App (Preview) resource in VS Code:
Once again, the Designer is read-only.
But you can also find the stateful workflow in the Azure Portal, and from there, you will be able to use the new Logic App Designer.
Of course, all the changes you make in the Portal can be synchronized back to VS Code by selecting the Refresh button
In the next blog post, we will explain a different and more powerful way for you to create your Logic Apps (Preview) projects and workflows. Stay tuned!