Hit String or binary data would be truncated when using popup upload

Hit String or binary data would be truncated when using popup upload

  

Hi 


I have been hitting String or binary data would be truncated. when I was using popup upload widget.


String or binary data would be truncated.
The statement has been terminated.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at OutSystems.HubEdition.DatabaseProvider.SqlServer.ExecutionService.ExecutionService.ExecuteReader(IDbCommand cmd)
   at OutSystems.HubEdition.DatabaseProvider.SqlServer.ExecutionService.ExecutionService.ExecuteScalar(IDbCommand cmd)
   at OutSystems.Internal.Db.Command.ExecuteScalar(String description, Boolean isApplication, Boolean skipLog, Boolean applyTransformationsToParameters)
   at ssAIA.ExtendedActions.CreateDisposalAttachment(HeContext heContext, RCDisposalAttachmentRecord inParamSource, Int64& outParamId)
   at ssAIA.Flows.FlowMainFlow.ScrnDisposalAssetDetail.CommandRefreshDisposalAttachmentTable(HeContext heContext, Boolean inParamResetPagination)



Solution

Hi Amoz,


Check the attributes of your DisposalAttachment entity. There should be Text attribute there that doesn't have enough lenght.

A usual problem In uploads is either the filename or content type. Those can be really large and do not fit in the default 50 chars length.


Regards,

João Rosado

Solution

João Rosado wrote:

Hi Amoz,


Check the attributes of your DisposalAttachment entity. There should be Text attribute there that doesn't have enough lenght.

A usual problem In uploads is either the filename or content type. Those can be really large and do not fit in the default 50 chars length.


Regards,

João Rosado

Yes it resolves my issue. Thanks for your help!!!