不能将值 NULL 插入列 'PlanId'，表 'UFTData839214_450714.dbo.EAP_SearchPlanItemGroupInfo_Ext'；列不允许有 Null 值

将值 NULL 插入列 'PlanId'，表 'UFTData839214_450714.dbo.EAP_SearchPlanItemGroupInfo_Ext'；列不允许有 Null 值

【问题描述】

T+账套升级提示如下报错：

UFTData839214_450714升级出错，错误信息：UFTData839214_450714升级脚本出错，错误信息：SQL 脚本: 15.000.000.0138 DATA_DPRD_MP_Rpt_NL-53001 出错：不能将值 NULL 插入列 'PlanId'，表 'UFTData839214_450714.dbo.EAP_SearchPlanItemGroupInfo_Ext'；列不允许有 Null 值。INSERT 失败

【问题解决】

保管好备份数据！！！在数据库执行以下脚本后再升级

GO

DECLARE @detaiRptSearchId int = ( select id from EAP_SearchInfo_Ext where Name = 'MP_ManufactureOrderProcessDetailRpt' )

IF NOT EXISTS(SELECT 1 FROM EAP_SearchPlanInfo_Ext where SearchId = @detaiRptSearchId and IsDefault = 1 and IsSystem = 1 and SearchStyle =2 )

BEGIN

INSERT INTO dbo.EAP_SearchPlanInfo_Ext (SearchName, SearchStyle, IsDefault, IsSystem, PlanName, MaxItemCount, IsDirectSearch, IsPublicPlan, LayoutStyle, LayoutColumnCount, IsShowExpression, Expression, Isdisplay, CreatedTime, EndGrade, TFlag, NoDelete, ExpressionName, SearchId, UserId, IsMenu, IsPublish, IsMobilePlan, IsMBPublish, SourcePlanId, BanDelete, PlanExternalType, IsExternalPublish, Code, Name, idgroupiteminfo)

VALUES ('MP_ManufactureOrderProcessDetailRpt', 2, 1, 1, '系统方案', 15, 0, 1, 2, 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, @detaiRptSearchId, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, 0, NULL, NULL, NULL)

END