描述:现在进行cloud系统从3.0升级到6.0,升级方案为,先用V5.0的安装包将3个应用服务器分别升级到5.0,然后用V6.0的安装包升级到6.0;
再升级管理中心;最后升级数据中心;在升级数据中心时,升级oracle的数据中心后有报错;
环境:
cloud版本: 3.0
应用服务器3台:windows server 2012,
管理中心在其中一台应用服务器上
数据库服务器2台:Linux Server release 6.3, oracle 版本 11.2.0.3
:windows server 2012,sql server 2012
升级步骤:
(1)3台应用服务器,先用v5.0、v6.0安装包依次升级到5.0、6.0;——正常
(2)管理中心升级 ——正常
(3)sql数据库的数据中心升级 ——正常
(4)oracle数据库的数据中心升级 ——报错
报错日志如下:
Error: [2016-01-16 17:30:25] 元数据文件执行失败:C:\Program Files (x86)\Kingdee\K3Cloud\ManageSite\CommonFileServer\PackageCollection\9BA697B5-9790-4882-9EC8-D6F62CC347B3\package\BusinessObjectCollection\QM_WorkshopQuaStatisticRpt.dym
ORA-31061: XDB error: XML event error
ORA-19202: Error occurred in XML processing
In line 633 of orastream:
LPX-00217: invalid character 7938196 (U+792094)
Error: [2016-01-16 17:42:45] 执行脚本[K3CloudV6.0_FIN_FA_Data.sql(FIN_DataModel_Public_V6)](HV:0,CHECK:0.0050205,RESULT:False,RUN:0.2605217,ERROR)
---脚本错误Begin---
SQL脚本错误:UPDATE T_FA_BORROWDETAIL SET FOLDPOSITIONID=(SELECT TOP 1 FUSEDEPTID FROM T_FA_ALLOCATION WHERE FALLOID=FID)
ORA-01407: cannot update ("LAKALA01"."T_FA_BORROWDETAIL"."FOLDPOSITIONID") to NULL
---脚本错误End---
Error: [2016-01-16 17:45:37] 执行脚本[K3CloudV6.0_SCM_SALData.sql(SCM_DataModel_Public_V6)](HV:0.001001,CHECK:0.0030012,RESULT:False,RUN:78.3014087,ERROR)
---脚本错误Begin---
SQL脚本错误:MERGE INTO T_SAL_RETURNSTOCKENTRY_R LT USING (
SELECT distinct T2.FENTRYID,T3.FSUPPLIERID FROM T_SAL_RETURNSTOCKFIN T1
INNER JOIN T_SAL_RETURNSTOCKENTRY T2 ON T1.FID = T2.FID
INNER JOIN T_BD_SUPPLIER T3 ON T3.FUSEORGID = T1.FSETTLEORGID AND T3.FCORRESPONDORGID = T2.FOWNERID
WHERE T2.FOWNERID <> 0
) TT ON (LT.FENTRYID = TT.FENTRYID)
WHEN MATCHED THEN UPDATE SET LT.FEOWNERSUPPLIERID = TT.FSUPPLIERID
ORA-00600: internal error code, arguments: [13013], [5001], [87400], [20997103], [92], [20997103], [17], [], [], [], [], []
SQL脚本错误:MERGE INTO T_SAL_RETURNSTOCKENTRY_R LT USING (
SELECT distinct T2.FENTRYID,T3.FCUSTID FROM T_SAL_RETURNSTOCKFIN T1
INNER JOIN T_SAL_RETURNSTOCKENTRY T2 ON T1.FID = T2.FID
INNER JOIN T_BD_CUSTOMER T3 ON T3.FUSEORGID = T2.FOWNERID AND T3.FCORRESPONDORGID = T1.FSETTLEORGID
WHERE T1.FSETTLEORGID <> 0
) TT ON (LT.FENTRYID = TT.FENTRYID)
WHEN MATCHED THEN UPDATE SET LT.FESETTLECUSTOMERID = TT.FCUSTID
ORA-00600: internal error code, arguments: [13013], [5001], [87400], [20997103], [92], [20997103], [17], [], [], [], [], []
---脚本错误End---
Error: [2016-01-16 17:46:51] 执行脚本[K3CloudV6.0_BETA_CRM_PreData.sql(CRM_DataModel_Public_V6)](HV:0,CHECK:0.0020032,RESULT:False,RUN:0.0459866,ERROR)
---脚本错误Begin---
SQL脚本错误:EXEC P_ALTERPK 'PK_CRM_OPPORTUNITY_LK', 'T_CRM_ACTIVITY_LK', '', '1'
ORA-02443: Cannot drop constraint - nonexistent constraint
ORA-06512: at "LAKALA01.P_ALTERPK", line 33
ORA-06512: at line 1
SQL脚本错误:EXEC P_ALTERPK 'PK_CRM_OPPORTUNITY_LK', 'T_CRM_CONTRACTENTRY_LK', '', '1'
ORA-06535: statement string in EXECUTE IMMEDIATE is NULL or 0 length
ORA-06512: at "LAKALA01.P_ALTERPK", line 33
ORA-06512: at line 1
SQL脚本错误:EXEC P_ALTERPK 'PK_CRM_OPPORTUNITYROLE', 'T_CRM_OPPEXPENSE', '', '1'
ORA-06535: statement string in EXECUTE IMMEDIATE is NULL or 0 length
ORA-06512: at "LAKALA01.P_ALTERPK", line 33
ORA-06512: at line 1
---脚本错误End---
请问这个报错有什么影响,该如何处理
有什么疑问,请随时与我联系qq:1969523032 电话:18507172080
推荐阅读