500 Internal Server Error when saving endpoint credentials in vRA 7.x

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:

• 500 Internal Server Error when saving endpoint credentials in vRA 7.x.

 

• You see an error similar to the below in the logfile /var/log/vmware/vcac/Catalina.out:

 

[UTC:2022-07-27 14:09:02,156 Local:2022-07-27 14:09:02,156] vcac: [component="cafe:iaas-proxy" priority="ERROR" thread="tomcat-http--3" tenant="" context="vNc8Qcxd" parent="vNc8Qcxd" token="FqRtc23F"] com.vmware.vcac.iaas.controller.endpointconfiguration.EndpointController.update:123 - Endpoint update failed: HTTP/1.1 500 Internal Server Error : <?xml version="1.0" encoding="utf-8"?><m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><m:code /><m:message xml:lang="en-US">An error occurred while processing this request.</m:message><m:innererror><m:message>8152</m:message><m:type>DynamicOps.Repository.Runtime.Common.RepositorySqlException</m:type><m:stacktrace></m:stacktrace><m:internalexception><m:message>An error occurred while updating the entries. See the inner exception for details.</m:message><m:type>System.Data.UpdateException</m:type><m:stacktrace> at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)&#xD; at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)&#xD; at DynamicOps.Common.Entity.ContextHelpers.EncryptEntitiesAndSaveChanges(ObjectContext entityContext, Func`2 saveFunc, SaveOptions saveOptions)&#xD; at System.Data.Services.Providers.ObjectContextServiceProvider.SaveChanges()&#xD; at System.Data.Services.DataService`1.HandleNonBatchRequest(RequestDescription description)&#xD; at System.Data.Services.DataService`1.HandleRequest()</m:stacktrace><m:internalexception><m:message>String or binary data would be truncated.&#xD;The statement has been terminated.</m:message><m:type>System.Data.SqlClient.SqlException</m:type><m:stacktrace> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)&#xD; at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)&#xD; at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)&#xD; at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)&#xD; at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)&#xD; at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)&#xD; at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)&#xD; at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()&#xD; at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)&#xD; at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)</m:stacktrace></m:internalexception></m:internalexception></m:innererror></m:error>

org.odata4j.exceptions.ServerErrorException: HTTP/1.1 500 Internal Server Error : <?xml version="1.0" encoding="utf-8"?><m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><m:code /><m:message xml:lang="en-US">An error occurred while processing this request.</m:message><m:innererror><m:message>8152</m:message><m:type>DynamicOps.Repository.Runtime.Common.RepositorySqlException</m:type><m:stacktrace></m:stacktrace><m:internalexception><m:message>An error occurred while updating the entries. See the inner exception for details.</m:message><m:type>System.Data.UpdateException</m:type><m:stacktrace> at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)&#xD; at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)&#xD; at DynamicOps.Common.Entity.ContextHelpers.EncryptEntitiesAndSaveChanges(ObjectContext entityContext, Func`2 saveFunc, SaveOptions saveOptions)&#xD; at System.Data.Services.Providers.ObjectContextServiceProvider.SaveChanges()&#xD; at System.Data.Services.DataService`1.HandleNonBatchRequest(RequestDescription description)&#xD; at System.Data.Services.DataService`1.HandleRequest()</m:stacktrace><m:internalexception><m:message>String or binary data would be truncated.&#xD;The statement has been terminated.</m:message><m:type>System.Data.SqlClient.SqlException</m:type><m:stacktrace> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)&#xD; at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)&#xD; at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)&#xD; at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)&#xD; at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)&#xD; at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)&#xD; at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)&#xD; at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()&#xD; at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)&#xD; at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)</m:stacktrace></m:internalexception></m:internalexception></m:innererror></m:error>

 

Environment

VMware vRealize Automation 7.x

Cause

The password field for accounts used for vRealize Automation endpoints has a limitation of 79 characters.

Resolution

Use a password shorter than 79 characters for endpoint accounts in vRA 7.x

Additional Information

Impact/Risks:

Attempts to add an endpoint to vRA 7.x with a user account whose password exceeds 79 characters will fail.