【已解决】业务中心升级到5.0报错(财务、供应链脚本报错
金蝶云社区-云小爱
云小爱
0人赞赏了该文章 819次浏览 未经作者许可,禁止转载编辑于2014年09月16日 09:31:54

业务中心从3.0升级到5.0提示脚本执行报错。报错信息如下所示:
Error: [2014-09-16 00:29:11] 执行脚本[K3CloudV5.0_FIN_DependentData.sql(FIN_DataModel_Public_V5)](HV:0.0010002,CHECK:0.010002,RESULT:False,RUN:0.9861972,ERROR)
---脚本错误Begin---
SQL脚本错误:INSERT INTO T_CB_PROORDERTYPE(FENTRYID,FPROORDERENTRYID,FPROORDERTYPE,FFORMID,FNUMBER,FCREATEORGID,
FUSEORGID,FDOCUMENTSTATUS,FFORBIDSTATUS,FDATE,FMATERIALID,FBOMID,FAUXPROPID,FLOT,
FSEQ,FUNITID,FPRODUCTID,FWORKSHOPID,FCOSTCENTERID)
SELECT FENTRYID,FPROORDERENTRYID,CASE WHEN FFORMID='V_CB_PROORDER' THEN 'PO'
WHEN FFORMID='V_CB_OUTSRCPROORDER' THEN 'OUTSRC'
WHEN FFORMID='V_CB_SALOUTSTOCK' THEN 'TSO'
WHEN FFORMID='V_CB_SALRETURNSTOCK' THEN 'TSR'
ELSE 'SPO' END FPROORDERTYPE,
FFORMID,FNUMBER,FCREATEORGID,
FUSEORGID,FDOCUMENTSTATUS,FFORBIDSTATUS,FDATE,FMATERIALID,FBOMID,FAUXPROPID,FLOT,
FSEQ,FUNITID,FPRODUCTID,FWORKSHOPID,FCOSTCENTERID
FROM V_CB_PROORDERTYPE
WHERE FDOCUMENTSTATUS='C' AND NOT EXISTS(SELECT 1 FROM T_CB_PROORDERTYPE WHERE FENTRYID=V_CB_PROORDERTYPE.FENTRYID)
ORA-01400: cannot insert NULL into ("CLOUDYL93"."T_CB_PROORDERTYPE"."FBOMID")
---脚本错误End---
Error: [2014-09-16 00:29:14] 执行脚本[K3CloudV5.0_SCM_Dependent.sql(SCM_DataModel_Public_V5)](HV:0,CHECK:0.010002,RESULT:False,RUN:0.3110622,ERROR)
---脚本错误Begin---
SQL脚本错误:update T_SP_PICKMTRLDATA AS M set (FEXTAUXUNITID,FEXTAUXUNITQTY)=
(SELECT T.FSECUNITID,T.FSECACTUALQTY FROM T_SP_PICKMTRLDATA T
WHERE M.FEXTAUXUNITID=0 AND M.FEXTAUXUNITQTY=0
AND M.FENTRYID=T.FENTRYID
)
ORA-01407: cannot update ("CLOUDYL93"."T_SP_PICKMTRLDATA"."FEXTAUXUNITID") to NULL
---脚本错误End---