Self-Hosted Install Error (Password Length)

[Keith Mangold]

Hello! I am working on the installation of a Self-Hosted instance of Jira Align for a client. 

When executing the: Run deploy-only-[CUSTOMER_NAME].bat, I receive the error as shown below when it is running the _PremiseDeploy10x.ps1 section:

2022-07-19T16:01:17.13 Server:9.9.9.9 Catalog:JiraAlign_ZZZZZZ
2022-07-19T16:01:17.13 Press any key to continue ...
2022-07-19T16:01:24.37 Running database management ...
2022-07-19T16:01:24.39 dbmgmt: C:\ZZZZZZ\Releases\JiraAlign-10.107.4.11\Sources\DbManagement\DbManagement.dll
2022-07-19T16:01:24.39 script: C:\ZZZZZZ\Releases\JiraAlign-10.107.4.11\Sources\DbManagementScripts
2022-07-19T16:01:24.39 DbVersion:10.107.4.20033
2022-07-19T16:01:25.94 Standard output:
2022-07-19T16:01:25.94 [16:01:25 INF] Upgrading AgileCraftServer
2022-07-19T16:01:25.96 [16:01:25 ERR] Upgrade failed due to an unexpected exception:
2022-07-19T16:01:25.96 System.ArgumentException: The value's length for key 'password' exceeds it's limit of '128'.
2022-07-19T16:01:25.96 at System.Data.SqlClient.SqlConnectionString.ValidateValueLength(String value, Int32 limit, String key)

The password is less than 128 characters, but assuming there is some encryption going on which is leading to an expanded value, then leading to this error.

Following the Self-Hosted Guide 10.99.2 for Jira Align 10.107.4.11. 

Any ideas on a resolution?

Thank you!

[Enio Marques Junior]

Hi Keith, that's an interesting error.

How long is the password?

Are there any "=" characters in it?  If so, would be worth a try to generate a new one without such a character and try again.

I think the best way would be to open a ticket with the support team for better troubleshooting.

[Keith Mangold]

Hi Enio,

The password is only 16 characters long; only A-Z a-z and 0-9, no special characters.

After doing some debugging on _PremiseDeploy10x.ps1, it looked like it was getting the wrong password from somewhere, and that password did have an = in it. For the life of me, I can't figure out where it was getting that password though.

I got around it by setting the password variable value manually right above this step and ran it successfully. 

So I am good for now.

Thanks!

Keith

[Enio Marques Junior]

Hey Keith, thanks for the response.

Once the deploy script is executed, the connection string used to connect is placed into the JA_HOME/_Cust/web.config file, maybe that's where it was getting the value from.