Jira Align Enterprise Insights ETL job fails with error "0x80020009 'The connection string components cannot contain unquoted semicolons'
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
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.
Was this helpful?