DB Sync error during package deployment: The value's length for key 'password' exceeds it's limit of '128'

(0) Share

Report

Posted on by MarinaAX

730

Hi there,

Used LCS in order to deploy an Application deployable package to the Microsoft based environment. The deployment failed at step #15

"GlobalUpdate script for service model: AOSService on machine: AOS-1":

dbsync.log:

08/10/2017 02:30:06: Bindir: F:\AosService\PackagesLocalDirectory
MetadataDir: F:\AosService\PackagesLocalDirectory
Sql scripts: 

08/10/2017 02:30:06: Caught unexpected exception:
System.ArgumentException: The value's length for key 'password' exceeds it's limit of '128'.
   at System.Data.SqlClient.SqlConnectionString.ValidateValueLength(String value, Int32 limit, String key)
   at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
   at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
   at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
   at System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential)
   at Microsoft.Dynamics.AX.Deployment.Setup.SqlEditionConnectionScan.IsSqlAzure()
   at Microsoft.Dynamics.AX.Deployment.Setup.SetupConfiguration.get_IsAzureSql()
   at Microsoft.Dynamics.AX.Deployment.Setup.Program.Run(SetupConfiguration config)
   at Microsoft.Dynamics.AX.Deployment.Setup.Program.Main(String[] args)
08/10/2017 02:30:06: Call stack:
   at System.Data.SqlClient.SqlConnectionString.ValidateValueLength(String value, Int32 limit, String key)
   at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
   at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
   at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
   at System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential)
   at Microsoft.Dynamics.AX.Deployment.Setup.SqlEditionConnectionScan.IsSqlAzure()
   at Microsoft.Dynamics.AX.Deployment.Setup.SetupConfiguration.get_IsAzureSql()
   at Microsoft.Dynamics.AX.Deployment.Setup.Program.Run(SetupConfiguration config)
   at Microsoft.Dynamics.AX.Deployment.Setup.Program.Main(String[] args)
08/10/2017 03:45:27: Bindir: F:\AosService\PackagesLocalDirectory
MetadataDir: F:\AosService\PackagesLocalDirectory
Sql scripts: 

08/10/2017 03:45:27: Caught unexpected exception:
System.ArgumentException: The value's length for key 'password' exceeds it's limit of '128'.
   at System.Data.SqlClient.SqlConnectionString.ValidateValueLength(String value, Int32 limit, String key)
   at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
   at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
   at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
   at System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential)
   at Microsoft.Dynamics.AX.Deployment.Setup.SqlEditionConnectionScan.IsSqlAzure()
   at Microsoft.Dynamics.AX.Deployment.Setup.SetupConfiguration.get_IsAzureSql()
   at Microsoft.Dynamics.AX.Deployment.Setup.Program.Run(SetupConfiguration config)
   at Microsoft.Dynamics.AX.Deployment.Setup.Program.Main(String[] args)
08/10/2017 03:45:27: Call stack:
   at System.Data.SqlClient.SqlConnectionString.ValidateValueLength(String value, Int32 limit, String key)
   at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
   at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
   at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
   at System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential)
   at Microsoft.Dynamics.AX.Deployment.Setup.SqlEditionConnectionScan.IsSqlAzure()
   at Microsoft.Dynamics.AX.Deployment.Setup.SetupConfiguration.get_IsAzureSql()
   at Microsoft.Dynamics.AX.Deployment.Setup.Program.Run(SetupConfiguration config)
   at Microsoft.Dynamics.AX.Deployment.Setup.Program.Main(String[] args)

Rebooted AOS-1 server and resumed the deployment, but it failed on the same step.
Execution of database synchronization on the AOS-1 succeeded fine.
Subsequent resume of the deployment failed on the same step with the same error message.
Previously I was able to deploy similar packages fine. No changes took place since the last successful package deployment.

Would you be so kind to advise how to troubleshoot that issue?

Many thanks, in advance!!!

Categories:

Finance and Operations

Deployment

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

André Arnaud de Cal... 301,025 Super User 2025 Season 2 on at

Like (2)

Report

Hi MarinaAX,

Are you aware of a customization or vendor solution which contains the 'password'? Was there anything changed on this?

I haven't seen this issue before, so it would be hard to help you out. Possibly you can also create an incident for Microsoft Support.

Was this reply helpful? Yes No
Pranav Gupta 145 on at

Like (0)

Report

Hi,

Facing similar issue.

I have done the Rotate Secrets, after its completion , my client is not working, getting "503 Services unavailable" error every time.

Checked the event log and got this below explanation, I am not sure what does it mean.

Please guide me on this.

AX is shutting down due to an error. Failed to set database connection string. Exception details: Microsoft.Dynamics.AX.InvalidConnectionStringException: Failed to set database connection string. ---> System.ArgumentException: The value's length for key 'password' exceeds it's limit of '128'. at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at Microsoft.Dynamics.AX.TestDatabaseConnectionString(String connectionString) --- End of inner exception stack trace --- at Microsoft.Dynamics.AX.TestDatabaseConnectionString(String connectionString) at Microsoft.Dynamics.AX.AOS.StartupInternal(String[] Arguments)

Best Regards

Pranav

Was this reply helpful? Yes No
MarinaAX 730 on at

Like (0)

Report

Hi Pranav,

In our case the D365 environment on which we experienced the issue was the developer's so we ended up re-building the server.

Was this reply helpful? Yes No
Parker Peng 10 on at

Like (0)

Report

Hi,

Have you fixed the issue? And how?

Regards,

Parker

Was this reply helpful? Yes No
Pranav Gupta 145 on at

Like (0)

Report

Hi Parker,

Actually my DB got corrupt, so I have no option and have to redeploy the VM again.

Also keep in mind that never change the password of the VM manually when the system gives the pop Up of "change your password", always do the "Rotate Secrets" for this.

Was this reply helpful? Yes No
PhucNguyen 35 on at

Like (0)

Report

Hi,

I am also the similar issue.

I deployed a package base on ImportISVLicense template package

(It is get from <PackagesFolder>\bin\CustomDeployablePackage\ImportISVLicense.zip)

The deployment failed at step #3

Executing step: 3

GlobalUpdate script for service model: AOSService on machine: MLAM-260618

Sync AX database

08/31/2018 00:58:12: Caught unexpected exception: System.ArgumentException: The value's length for key 'password' exceeds it's limit of '128'. at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential) at Microsoft.Dynamics.AX.Deployment.DeploymentHelper.SqlEditionConnectionScan.IsSqlAzure() at Microsoft.Dynamics.AX.Deployment.DeploymentHelper.SetupConfiguration.get_IsAzureSql() at Microsoft.Dynamics.AX.Deployment.Setup.Program.Run(SetupConfiguration config) at Microsoft.Dynamics.AX.Deployment.Setup.Program.Main(String[] args) 08/31/2018 00:58:12: Call stack: at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential) at Microsoft.Dynamics.AX.Deployment.DeploymentHelper.SqlEditionConnectionScan.IsSqlAzure() at Microsoft.Dynamics.AX.Deployment.DeploymentHelper.SetupConfiguration.get_IsAzureSql() at Microsoft.Dynamics.AX.Deployment.Setup.Program.Run(SetupConfiguration config) at Microsoft.Dynamics.AX.Deployment.Setup.Program.Main(String[] args)

The step failed

The step: 3 is in failed state, you can use rerunstep command to debug the step explicitly

at Microsoft.Dynamics.AX.AXUpdateInstallerBase.RunbookExecutor.executeRunbookStepList(RunbookData runbookData, List`1 runbookStepList, String updatePackageFilePath, Boolean silent, String stepID, ExecuteStepMode executeStepMode, Boolean versionCheck, Parameters parameters)

at Microsoft.Dynamics.AX.AXUpdateInstallerBase.RunbookExecutor.executeRunbook(RunbookData runbookData, String updatePackageFilePath, Boolean silent, String stepID, ExecuteStepMode executeStepMode, Boolean versionCheck, Parameters parameters)

at Microsoft.Dynamics.AX.AXUpdateInstaller.Program.InstallUpdate(String[] args)

at Microsoft.Dynamics.AX.AXUpdateInstaller.Program.Main(String[] args)

Someone have any idea about this issue?

Thanks in advance,

Phuc

Was this reply helpful? Yes No
Verified answer

IstvanMolnar 27 on at

Like (3)

Report

Hi,

It was happened for me on local hosted VM and it was solved with command which will decrypt the pwd of the sqladmin in the web config file:

C:\AOSService\webroot\bin\Microsoft.Dynamics.AX.Framework.ConfigEncryptor.exe -decrypt C:\AOSService\webroot\web.config

I hope ti helps,

Regards,

Istvan

Was this reply helpful? Yes No
Hichem.Chekebkeb 3,371 on at

Like (0)

Report

Hi MarinaAX,

Did you get an explanation or a fix from MS ?

Was this reply helpful? Yes No