Non-threaded

Forums » Bugs & Problems » Read Thread

Post reports about problems or bugs in here.
This bug was closed 6/3/2021: all good now

String or Binary data would be truncated?

2 years ago

Every storygame I click on gives the following error message. It says there a problem with Line 41 of the source code. How do I fix this?

 

 

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

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.

Source Error:

 

Line 39:                 }
Line 40: 				State = StoryState.CreateFromStoryId(sid);
Line 41: 				ChooseYourStory.Legacy.LegacyLogger.PlayGame(State.StoryId);
Line 42: 			}
Line 43: 			return;


Source File: c:\Websites\ChooseYourStory\ChooseYourStory.WebApplication\green\Story\Viewer\Default.aspx    Line: 41

Stack Trace:

 

[SqlException (0x80131904): String or binary data would be truncated.
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3317868
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +736
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4061
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +496
   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) +3303
   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) +667
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +535
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +380
   ChooseYourStory.Legacy.LegacyLogger.Log(String eventId, Int32 dataId, String notes) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E131351\Src\ChooseYourStory\Legacy\LegacyLogger.cs:53
   ChooseYourStory.Legacy.LegacyLogger.PlayGame(Int32 GameID) in C:\Users\builds\AppData\Local\Temp\InedoAgent\BuildMaster\192.168.44.60\Temp\_E131351\Src\ChooseYourStory\Legacy\LegacyLogger.cs:14
   ASP.story_viewer_default_aspx.OnLoad(EventArgs e) in c:\Websites\ChooseYourStory\ChooseYourStory.WebApplication\green\Story\Viewer\Default.aspx:41
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785

String or Binary data would be truncated?

2 years ago

I did not mean for this to post twice. x_x

String or Binary data would be truncated?

2 years ago

Yeah it's already been reported, trying to get it fixed as soon as possible.

String or Binary data would be truncated?

2 years ago
Persistence shook the problem off for me. I opened one of my own unpublished games eventually and it straightened out thereafter. Probably coincidental.

String or Binary data would be truncated?

2 years ago
Alex did something about twenty minutes ago, you might've just had good timing.

Can anybody that was still having problems confirm if they're fixed?

The games rating issue is all better now it appears.

String or Binary data would be truncated?

2 years ago

They're fixed for me now. I'm having no issues at the moment.

String or Binary data would be truncated?

2 years ago
Awesome, between you and Nightwatch that seems to confirm it. Thanks for letting us know.