Format of the initialization string does not conform to specification starting at index 0

I was working on Azure Data Factory – Automated deployments (CI/CD) using Azure DevOps and I encountered an error with the message Format of the initialization string does not conform to specification starting at index 0 while running the pipeline.

Format of Initialization string does not confirm to specification

After troubleshooting, I can to know that I was referring to an incorrect Release Variable. Let me explain more about that.

My requirement was to pass Connection String of the SQL Database to Azure Data Factory Pipeline. Instead of hard coding, the connection string, I wanted to configure it in a Release variable as shown below.

Azure Data Factory - Automated deployments CI CD using Azure DevOps - Release Variables
Azure Data Factory – Automated deployments CI CD using Azure DevOps – Release Variables

As shown in the above screenshot, the variable name that holds the SQL Database connection string was DatabaseConnection. However, Instead of using the variable DatabaseConnection, I was referring to something else as shown below.

Override Params

As i was referring to an incorrect variable, I was getting an error with the message Format of the initialization string does not conform to specification starting at index 0. After changing the variable to the appropriate name (SQLConnection), then I can see my pipeline got running successfully. Below is the screenshot that shows the new variables names.

Azure Data Factory - Automated deployments CI CD using Azure DevOps - Release Variables - After Fix
Azure Data Factory – Automated deployments CI CD using Azure DevOps – Release Variables – After Fix

Hope it helps someone who had faced similar issue.

Happy Learning!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s