Try our conversational search powered by Generative AI!
AI OnAI Off
Arithmetic overflow error converting IDENTITY to data type smallint
The problem was that our RedirectModule uses the table UrlStatusCodeMappings wich ID column has the data type smallint and now we reached the max number of rows (32761) in that table. The solution was to change the data type from smallint to int.
Thanks to k Khan for pointing me in the right direction.
Aug 29, 2017 14:21
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
We can´t move or delete page from pagetree in Episerver 10 update 152.
This is what the log says:
ERROR EPiServer.Cms.Shell.UI.Rest.Internal.ContentStore: Det gick inte att flytta innehållet "Ny sida" till en plats under innehållet "För dig som är student".
System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting IDENTITY to data type smallint.
Arithmetic overflow occurred.
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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at oru.Business.RedirectModule.SimpleSqlUrlMapper.Add301MovedPermanentlyStatus(String oldUrl, String newUrl, Guid pageGuid) in F:\BuildAgent\work\e9a4b72e25b7a8dd\oru\Business\RedirectModule\SimpleSqlUrlMapper.cs:line 66
at oru.Business.RedirectModule.PageEventsMapper.Instance_MovingPage(Object sender, ContentEventArgs e) in F:\BuildAgent\work\e9a4b72e25b7a8dd\oru\Business\RedirectModule\PageEventsMapper.cs:line 73
at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
at EPiServer.Core.Internal.DefaultContentEvents.RaiseCancellableContentEvent(String key, String defaultReason, ContentEventArgs eventArgs)
at EPiServer.Core.Internal.DefaultContentRepository.Move(ContentReference contentLink, ContentReference destinationLink, AccessLevel requiredSourceAccess, AccessLevel requiredDestinationAccess)
at EPiServer.IContentRepositoryExtension.Move(IContentRepository contentRepository, ContentReference contentLink, ContentReference destination)
at EPiServer.Cms.Shell.Service.Internal.ContentService.Move(IContent content, ContentReference destination)
at EPiServer.Cms.Shell.UI.Rest.ContentChangeManager.Move(IContent source, IContent destination, Boolean createAsLocalAsset)
at EPiServer.Cms.Shell.UI.Rest.Internal.ContentStore.MoveContent(IContent source, IContent destination, Boolean createAsLocalAsset, ActionResponse`1 response)
ClientConnectionId:cd108fdf-d8c3-414b-ad1b-5a98bf6ff1bc
Error Number:8115,State:1,Class:1
Has anyone experienced the same thing?