Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Arlan 58 posts 184 karma points
    May 14, 2015 @ 06:55
    Arlan
    0

    Failed to retrieve data for content id

    I have deployed the site from local to remote using Dennis instructions (i also posted on that thread, but wanted to post here as well to get possible quicker response)

    I was going in backoffice, checking/opening  pages and some pages have this error: 

    would that be that database didnt copy 100% form local to remote or files? How would i go about fixing this? thanks

    Received an error from the server

    Failed to retrieve data for content id 3182

    Cannot insert the value NULL into column 'id', table 'maryvanndb1.dbo.cmsPropertyData'; column does not allow nulls. INSERT fails. The statement has been terminated.

    EXCEPTION DETAILS:
    System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'id', table 'maryvanndb1.dbo.cmsPropertyData'; column does not allow nulls. INSERT fails. The statement has been terminated.
    STACKTRACE:
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.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)
       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.ExecuteScalar()
       at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteScalar() in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 299
       at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClassa.<ExecuteScalarWithRetry>b__9()
       at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`
    1 func)
       at
    Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy)
       at
    Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command, RetryPolicy retryPolicy)
       at
    Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteScalarWithRetry(IDbCommand command)
       at
    Umbraco.Core.Persistence.Database.Insert(String tableName, String primaryKeyName, Boolean autoIncrement, Object poco)
       at
    Umbraco.Core.Persistence.Database.Insert(Object poco)
       at
    Umbraco.Core.Persistence.Repositories.VersionableRepositoryBase`2.GetPropertyCollection(Sql docSql, IEnumerable`1 documentDefs)
       at
    Umbraco.Core.Persistence.Repositories.ContentRepository.CreateContentFromDto(DocumentDto dto, Guid versionId, Sql docSql)
       at
    Umbraco.Core.Persistence.Repositories.ContentRepository.PerformGet(Int32 id)
       at
    Umbraco.Core.Persistence.Repositories.RepositoryBase`2.Get(TId id)
       at Umbraco.Core.Services.ContentService.GetById(Int32 id)
       at Umbraco.Web.Editors.ContentController.CheckPermissions(IDictionary`
    2 storage, IUser user, IUserService userService, IContentService contentService, Int32 nodeId, Char[] permissionsToCheck, IContent contentItem)
       at
    Umbraco.Web.WebApi.Filters.EnsureUserPermissionForContentAttribute.OnActionExecuting(HttpActionContext actionContext)
       at
    System.Web.Http.Filters.ActionFilterAttribute.System.Web.Http.Filters.IActionFilter.ExecuteActionFilterAsync(HttpActionContext actionContext, CancellationToken cancellationToken, Func`1 continuation)
  • Arlan 58 posts 184 karma points
    May 14, 2015 @ 06:58
    Arlan
    0

    one more thing, all content is good and visible on visitor side, just in backoffice i get the errors.

  • Mehul Gajjar 48 posts 172 karma points
    May 15, 2015 @ 14:36
    Mehul Gajjar
    0

    Hi Arlan,

    can you please check the media for "My current Page Listing" node , its used some picture or file which has id of 3182,

    its seem that in local you have use any media but its not uploaded in live.

    check your all media reference for same.

    Hope this is help you.

    Regards,

    Mehul Gajjar.

Please Sign in or register to post replies

Write your reply to:

Draft