Forums

Cannot insert the value NULL into column 'ApprovalStatusId', table 'lawsonguru_dnn.dbo.Publish_ItemVersion'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The 'Publish_spInsertItemVersion' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

ModuleId: 911
ModuleDefId: 183
FriendlyName: Manage Content
ModuleControlSource: DesktopModules/EngagePublish/AdminLoader.ascx
AssemblyVersion: 5.2.2
PortalID: 0
PortalName: LawsonGuru.com
UserID: 10
UserName: jhenley
ActiveTabID: 9
ActiveTabName: S3 HR/Payroll
RawURL: /Apps/S3Apps/S3HRPayroll/tabid/9/ctl/AdminContainer/mid/911/adminType/articleEdit/topLevelId/23/parentId/23/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.lawsonguru.com/Apps/S3Apps/S3HRPayroll/tabid/9/ctl/AdminContainer/mid/911/adminType/articleEdit/topLevelId/23/parentId/23/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6 (.NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 7233f0d5-7e7b-4715-8da7-e1e1a34297ac
InnerException: Cannot insert the value NULL into column 'ApprovalStatusId', table 'lawsonguru_dnn.dbo.Publish_ItemVersion'; column does not allow nulls. INSERT fails. The statement has been terminated. The 'Publish_spInsertItemVersion' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.OnError
StackTrace:
Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot insert the value NULL into column 'ApprovalStatusId', table 'lawsonguru_dnn.dbo.Publish_ItemVersion'; column does not allow nulls. INSERT fails. The statement has been terminated. The 'Publish_spInsertItemVersion' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'ApprovalStatusId', table 'lawsonguru_dnn.dbo.Publish_ItemVersion'; column does not allow nulls. INSERT fails. The statement has been terminated. The 'Publish_spInsertItemVersion' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlTransaction transaction, String spName, Object[] parameterValues) at Engage.Dnn.Publish.Data.SqlDataProvider.AddItemVersion(IDbTransaction trans, Int32 itemId, Int32 originalItemVersionId, String name, String description, String startDate, String endDate, Int32 languageId, Int32 authorUserId, String metaKeywords, String metaDescription, String metaTitle, Int32 displayTabId, Boolean disabled, String thumbnail, Guid itemVersionIdentifier, String url, Boolean newWindow, Int32 revisingUserId) at Engage.Dnn.Publish.Item.AddItemVersion(IDbTransaction trans, Int32 itemId, Int32 originalItemVersionId, String name, String description, String startDate, String endDate, Int32 languageId, Int32 authorUserId, String metaKeywords, String metaDescription, String metaTitle, Int32 displayTabId, Boolean disabled, String thumbnail, Guid itemVersionIdentifier, String url, Boolean newWindow, Int32 revisingUserId) at Engage.Dnn.Publish.Item.SaveInfo(IDbTransaction trans, Int32 revisingId) at Engage.Dnn.Publish.Article.Save(Int32 revisingUserId) at Engage.Dnn.Publish.ArticleControls.ArticleEdit.cmdUpdate_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---
Source:
Server Name: LAWGURU

Looking at procedure "Publish_spInsertItemVersion" it is inserting into table "Publish_ItemVersion", but not including the "ApprovalStatusId" column, which is marked as "not null" in the table definition.  Not sure why I've never run into this one before...

I just started having the problem today, but I haven't loaded any new articles in a few months.

I don't even have the approval process turned on. 

1    Edit    editText
2    Waiting for Approval    waitText
3    Approved    approvedtext
4    Archived    archivedText

Turned on approvals, and same error.

Cannot insert the value NULL into column 'ApprovalStatusId', table 'lawsonguru_dnn.dbo.Publish_ItemVersion'; column does not allow nulls. INSERT fails. The statement has been terminated. The 'Publish_spInsertItemVersion' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.