Skip to Content (Press Enter)
2017-06-14 01-39-55
Amoz Tan
480Views
2Comments
Solved
Hit String or binary data would be truncated when using popup upload
Question
Personal Environment

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)



0
0
19 May 2017
Copy Link
2012-03-16 12-21-09
João Rosado
Staff
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

0
0
19 May 2017
Copy Link
2017-06-14 01-39-55
Amoz Tan

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!!!


0
0
19 May 2017
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.