Jira Align Enterprise Insights ETL job fails with error "0x80020009 'The connection string components cannot contain unquoted semicolons'

Summary

Attempting to run Enterprise Insights ETL job fails with error "0x80020009 'The connection string components cannot contain unquoted semicolons'

Environment

Jira Align Self-Hosted

Diagnosis

The following error displays when attempting to run the EI ETL job:

Failed to configure a connection property that has the following path: \Package.Connections[DataWarehouseDest].Properties[Password]. An error occurred while setting the value of property "Password". The error returned is 0x80020009 "The connection string components cannot contain unquoted semicolons. If the value must contain a semicolon, enclose the entire value in quotes. This error occurs when values in the connection string contain unquoted semicolons, such as the InitialCatalog property.".

Cause

The error will occur when either the DW or ETL user account passwords contain a semicolon.

Solution

Passwords for Enterprise Insights accounts (DW and ETL) cannot contain semicolons. The customer must generate a new password that does not contain semicolons.

Semicolons are reserved characters and cannot be used in the password. This is a platform restriction (Microsoft SSIS) and not something that can be circumvented or disabled at the Enterprise Insights product level.