Skip to Content (Press Enter)
UserImage.jpg
Carolina Gutierrez
754Views
7Comments
string or binary data would be truncated when upload a photo
Question
Good morning I am trying to save an image in a table that has a binary field and when I do it from the pc it does not give me an error, but when I do it from the mobile I get the error.
0
0
08 Mar 2019
Copy Link
UserImage.jpg
Carolina Gutierrez

i´m using popup_upload_GetFile


Thanks

0
0
08 Mar 2019
Copy Link
2021-04-09 11-42-43
assif_tiger
 
MVP

Carolina Gutierrez wrote:

Good morning I am trying to save an image in a table that has a binary field and when I do it from the pc it does not give me an error, but when I do it from the mobile I get the error.

Can you share the error, so that folks here can help you.

thanks


0
0
08 Mar 2019
Copy Link
UserImage.jpg
Carolina Gutierrez

Error Detail
Back to Log
Id:
3a3d3456-c39d-4d80-9816-a1daab96176b
Time of Log:
2019-03-08 08:53:02
eSpace:
CheckList
Tenant:
Users
User:
 (1193)
Session Id:
mbz4sucvza1hqwj2ble3yb1o
Server:
E2OIT-DV3N8N
Module:

Message:


String or binary data would be truncated.
The statement has been terminated.


Environment InformationeSpaceVer: 1477 (Id=24811, PubId=25974, CompiledWith=10.0.828.0)
RequestUrl: https://galpenergia-dev.outsystemsenterprise.com/CheckList/Comenzar.aspx?_ts=1552035181132 (Method: POST)
AppDomain: /LM/W3SVC/1/ROOT/CheckList-1380-131964462638750265
FilePath: d:\OutSystems\Platform Server\running\CheckList.1748618165\Comenzar.aspx
ClientIp: 31.221.190.218
Locale: en-US
DateFormat: yyyy-MM-dd
PID: 6168 ('w3wp', Started='3/1/2019 10:58:51 AM', Priv=2278Mb, Virt=11459Mb)
TID: 443
Thread Name:
.NET: 4.0.30319.42000
Stack:
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, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, 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& usedCache, Boolean asyncWrite, Boolean inRetry)
   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 ssCheckList.ExtendedActions.CreateItemPictureTemp(HeContext heContext, RCItemPictureTempRecord inParamSource, Int64& outParamId)
   at ssCheckList.Flows.FlowUIFlowMantenCheck.ScrnComenzar.CommandPruebaPopUpUpload(HeContext heContext)
0
0
08 Mar 2019
Copy Link
UserImage.jpg
Carolina Gutierrez

error string or binary.jpg
0
0
08 Mar 2019
Copy Link
2021-04-09 11-42-43
assif_tiger
 
MVP

That is actually an SQL Server error. It happens when you try to insert/update a record on the database, with some value that is larger than the database field can hold.

For example, if you create an entity Person, and an attribute Name with Length 50 (which is the default), then it can only store texts up to 50 characters in length. If your user tries to insert a larger name, your application will display that error.

The solution is to identify which is the field that has too small of a Length, and then simply increase it.

2
0
08 Mar 2019
Copy Link
2021-03-19 09-32-13
Soren Staun

Yeah, but how to identify it when you cannot see what it's trying to insert, that the trick :-)

0
0
14 Aug 2021
Copy Link
2023-12-27 12-02-31
Duarte Moreira

Hi, 
That error can be caused by the length of the name or by some special characters like "ç" / "ã" / "~".
When uploading the file you can rename it or trim the name to the attribute length. 

Best regards.
(I know this post is old but my answer may help others who come seeking for help in this topic)

0
0
03 Apr 2024
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.