安装程序,把补丁都安装完后,重新建的数据中心,新建之后提示升级,升级完成后说要更新补丁的sql,在执行sql是报错,如下信息
错误原因:
执行脚本出现错误,请仔细分析[解决方案]中的错误信息,并试图获取具体的错误原因。
解决方案:
请将如下错误信息提单反馈:
[Execute provider[C:/Kingdee_sHR/eas/server/deploy/easweb.ear/eas_web.war/addon/attendmanage/data/shr_ats_T_HR_StructureConfig.sql], sql[INSERT INTO T_HR_StructureConfig (FENTITYNAME, FALIAS, FPARENTID, FCLIENTNUMBER, FISMULTIROW, FSUPPORTSINGLEVIEW, FSINGLECONDITION, FSINGLECONDITIONMASKING, FNAME_L1, FNAME_L2, FNAME_L3, FNUMBER, FDESCRIPTION_L1, FDESCRIPTION_L2, FDESCRIPTION_L3, FSIMPLENAME, FCREATORID, FCREATETIME, FLASTUPDATEUSERID, FLASTUPDATETIME, FCONTROLUNITID, FID, FSCHEMEID, FMOLTIALIAS, FISBASEDATA) VALUES ('com.kingdee.eas.hr.ats.app.AttendanceFile', N'考勤档案', NULL, 'attendanceFile', 0, 0, NULL, NULL, NULL, N'考勤档案', NULL, NULL, NULL, NULL, NULL, NULL, '00000000-0000-0000-0000-00000000000013B7DE7F', TO_DATE('2014-08-12 16:04:33', 'YYYY-MM-DD HH24:MI:SS'), '00000000-0000-0000-0000-00000000000013B7DE7F', TO_DATE('2014-09-24 18:06:46', 'YYYY-MM-DD HH24:MI:SS'), 'lHDbB+kPSvqu8bTwCEh3O8znrtQ=', 'F3riaLE3RJK+T5IwEqUIEjk1Eio=', 'hj9uiCTpQK6B0kNy3ARZ8podxk8=', NULL, 0)] failed, sqlcode[904] sqlstat[42000],Causedby[ORA-00904: "FISBASEDATA": 标识符无效
],DBType=[Oracle]
Execute provider[C:/Kingdee_sHR/eas/server/deploy/easweb.ear/eas_web.war/addon/attendmanage/data/T_ATS_AtsQueryConfig.sql], sql[BEGIN
DELETE FROM T_ATS_AtsQueryConfig WHERE (FID IN ('8Rxg5ZKoTI2+yGyABkj4OjUKVsQ=', 'HNuMBTrOStC5TTZBhuLS4DUKVsQ=', 'H8Ij40yvSZ63fawA/sdEXTUKVsQ=', 'dNXVCsQMSMOywlM0b+ojkzUKVsQ=', '46KZBBufQ0GTaus3brRVhzUKVsQ=', '9WYbEzxqRqid75jEec9LRzUKVsQ=', 'hLwfymDOQ2+Q9UJ4Gx59vjUKVsQ='));
INSERT INTO T_ATS_AtsQueryConfig (FTABLENAME, FSTRUCTUREID, FPARENTID, FNUMBER, FSIMPLENAME, FCREATORID, FCREATETIME, FLASTUPDATEUSERID, FLASTUPDATETIME, FCONTROLUNITID, FID, FNAME_L1, FNAME_L2, FNAME_L3, FDESCRIPTION_L1, FDESCRIPTION_L2, FDESCRIPTION_L3) VALUES (NULL, NULL, NULL, N'0001', NULL, '00000000-0000-0000-0000-00000000000013B7DE7F', TO_DATE('2014-08-19 14:50:34', 'YYYY-MM-DD HH24:MI:SS'), '00000000-0000-0000-0000-00000000000013B7DE7F', TO_DATE('2014-08-19 14:51:57', 'YYYY-MM-DD HH24:MI:SS'), 'lHDbB+kPSvqu8bTwCEh3O8znrtQ=', 'H8Ij40yvSZ63fawA/sdEXTUKVsQ=', NULL, N'考勤信息集', NULL, NULL, NULL, NULL);
END;] failed, sqlcode[6550] sqlstat[65000],Causedby[ORA-06550: 第 2 行, 第 13 列:
PL/SQL: ORA-00942: 表或视图不存在
ORA-06550: 第 2 行, 第 1 列:
PL/SQL: SQL Statement ignored
ORA-06550: 第 3 行, 第 13 列:
PL/SQL: ORA-00942: 表或视图不存在
ORA-06550: 第 3 行, 第 1 列:
PL/SQL: SQL Statement ignored
],DBType=[Oracle]
Execute provider[C:/Kingdee_sHR/eas/server/deploy/easweb.ear/eas_web.war/addon/attendmanage/data/T_ATS_AtsQueryConfigFiled.sql], sql[BEGIN
DELETE FROM T_ATS_AtsQueryConfigFiled WHERE (FID IN ('biowBek5Rka7UJgAg7+g6nR9DgQ=', 'emiebnPDRiaYk3dgnDsAxHR9DgQ=', 'BxYoL/I1Swu6xBrLCRY0EnR9DgQ=', 'yv4shDeUR5m6fribMR2zR3R9DgQ=', 'gFyb4eCgR8OTXAxDNC/pO3R9DgQ=', '9XP0kF6ISfe10usp/6aAGnR9DgQ=', 'IArW35mvRwmho8MWTtUf4XR9DgQ=', 'Z3MtgnCrRr6Ej7v9l9YvZHR9DgQ=', 'AHU9CNrOQFGRYNzE8SOSl3R9DgQ=', 'xRSOSTvmSgOzoFu8rVFVRXR9DgQ=', 'swzpaTHwRGKNZ00g47SGHnR9DgQ=', 'HvQ9wSAVR4aKyk1AuTkLbXR9DgQ=', 'sTtvbts4TamLEv8qfrL+mXR9DgQ=', 'ReOxbWdqS/aJlNoNp8n7s3R9DgQ=', 'gb0oZYbMThqzD8QzfHgRL3R9DgQ=', 'vL31ESWbRde5031Xvf7FEnR9DgQ=', 'Ef+2oQ10QR+dO0KB8pGXKnR9DgQ=', 'LkDs99VDRL+EG7vZK3xNKnR9DgQ=', 'bbZtqw+DR9iGGmgyuMvDrXR9DgQ=', 'nmU2R8k8TbSSgrNwxFhADnR9DgQ=', 'D/om0dFfSa6a/PnL6s1n9nR9DgQ=', '8jLdWo3sTxSiqvNt4A3Qx3R9DgQ=', 'uZrA38sHQh69BOPCDxtEknR9DgQ=', 'RCsaZE50SiOBgDSQz5Hj53R9DgQ=', '6y+tIp4hTQqQq5QjSuDFvHR9DgQ=', 'stEkwb00TSa9HDAsVSUwH3R9DgQ=', 'uzDd0P7bSESaGis59MpeXHR9DgQ=', '20A5LJeXQEaHV93F5+t46HR9DgQ=', 'GHaFTqwrR5Ku47F5F1wGL3R9DgQ=', 'XiEeAJVITQCSknYB4lkuk3R9DgQ=', 'Um/k3NQUSk2bkLUSvg9zXXR9DgQ=', 't/NqT2XIRUOIP1bc+NYDYnR9DgQ=', 'hp6xNQ04Qv++b5ctSO53dXR9DgQ=', 'uRx+ju3WTmWQn2AEcuqkbXR9DgQ=', 'wWzN3c2AQy6HWTDqsJ0fA3R9DgQ=', 'kVmLTGO8T8yeo6RTTJyokHR9DgQ=', 'SxH1GhgDSESL20bV08HdT3R9DgQ=', '/tI+aUW/SZ6uIJOTYnidZnR9DgQ=', 'qBn8vs9eSbK+St3IGfubG3R9DgQ=', 'bP6hrUicQOuR8z2bkC9TXXR9DgQ=', 'NtOQbxCGRImpFaQWamFIMnR9DgQ=', 'jqXtORiRTCWLFlB8jvPnp3R9DgQ=', 'ERE0UjmFS1S8OWteqgCCxnR9DgQ=', '1sTYh5CDTLC4VkalFCztNHR9DgQ=', 'IxI1ygldRb6XDSAsLwIEJHR9DgQ=', 'RvouzcWvStKgsd7jSNjm6XR9DgQ=', 'THNJR3EoRXiHzjeZM8yLHHR9DgQ='));
INSERT INTO T_ATS_AtsQueryConfigFiled (FINDEX, FALIAS, FPARENTID, FACTFIELDID, FID) VALUES (2, N'考勤制度名称', 'HNuMBTrOStC5TTZBhuLS4DUKVsQ=', 'mvd4ccDqSV6F/UiA0vRBEW/xHHM=', 'AHU9CNrOQFGRYNzE8SOSl3R9DgQ=');
END;] failed, sqlcode[6550] sqlstat[65000],Causedby[ORA-06550: 第 2 行, 第 13 列:
PL/SQL: ORA-00942: 表或视图不存在
ORA-06550: 第 2 行, 第 1 列:
PL/SQL: SQL Statement ignored
ORA-06550: 第 3 行, 第 13 列:
PL/SQL: ORA-00942: 表或视图不存在
ORA-06550: 第 3 行, 第 1 列:
推荐阅读