EAS8.6 打汽车4S行业补丁PT156253 补丁，执行sql脚失败

错误原因：

执行脚本出现错误，请仔细分析[解决方案]中的错误信息，并试图获取具体的错误原因。

解决方案：

请将如下错误信息提单反馈：

[Execute provider[./sql/PT156253_01.DDL.sql], sql[DECLARE CNT PLS_INTEGER;

BEGIN

SELECT COUNT(*) FCOUNT INTO CNT FROM USER_TAB_COLUMNS WHERE (COLUMN_NAME = 'FGIFTVALUATIONAMOUNT' AND TABLE_NAME = 'T_ATS_ESTIMATECOSTRULE');

IF CNT = 0 THEN

EXECUTE IMMEDIATE 'ALTER TABLE T_ATS_EstimateCostRule ADD (FGiftValuationAmount NUMBER (28, 10))';

END IF;

END;] failed, sqlcode[942] sqlstat[42000],Causedby[ORA-00942: 表或视图不存在

ORA-06512: 在 line 5

],DBType=[Oracle]

Execute provider[./sql/PT156253_02.DML.sql], sql[DECLARE CNT PLS_INTEGER;

BEGIN

SELECT COUNT(*) FCOUNT INTO CNT FROM T_ATS_BizSourceCondItem WHERE fid = 'NGrlhC9BSjiKbyGyarUNeofz9Ic=';

IF CNT = 0 THEN

EXECUTE IMMEDIATE 'INSERT INTO T_ATS_BizSourceCondItem (FID, FBIZSOURCECONDID, FNAME_L1, FNAME_L2, FNAME_L3, FISUSE, FFIELD, FISBENEFIT, FISADDPOINTS, FISSUBPOINTS) VALUES (''NGrlhC9BSjiKbyGyarUNeofz9Ic='', ''VT2q29HgR0ydOiRt+4NtyLYwz1Q='', ''整车销售订单.分录.品牌'', ''整车销售订单.分录.品牌'', ''整车销售订单.分录.品牌'', 1, ''brand'', 0, 1, 0)';

END IF;

END;] failed, sqlcode[6550] sqlstat[65000],Causedby[ORA-06550: 第 3 行, 第 38 列:

PL/SQL: ORA-00942: 表或视图不存在

ORA-06550: 第 3 行, 第 1 列:

PL/SQL: SQL Statement ignored

],DBType=[Oracle]

]

异常堆栈：

com.kingdee.eas.tools.admin.framework.database.exception.DBSQLProviderException: Execute provider[./sql/PT156253_01.DDL.sql], sql[DECLARE CNT PLS_INTEGER;

BEGIN

SELECT COUNT(*) FCOUNT INTO CNT FROM USER_TAB_COLUMNS WHERE (COLUMN_NAME = 'FGIFTVALUATIONAMOUNT' AND TABLE_NAME = 'T_ATS_ESTIMATECOSTRULE');

IF CNT = 0 THEN

EXECUTE IMMEDIATE 'ALTER TABLE T_ATS_EstimateCostRule ADD (FGiftValuationAmount NUMBER (28, 10))';

END IF;

END;] failed, sqlcode[942] sqlstat[42000],Causedby[ORA-00942: 表或视图不存在

ORA-06512: 在 line 5

],DBType=[Oracle]

Execute provider[./sql/PT156253_02.DML.sql], sql[DECLARE CNT PLS_INTEGER;

BEGIN

SELECT COUNT(*) FCOUNT INTO CNT FROM T_ATS_BizSourceCondItem WHERE fid = 'NGrlhC9BSjiKbyGyarUNeofz9Ic=';

IF CNT = 0 THEN

END IF;

END;] failed, sqlcode[6550] sqlstat[65000],Causedby[ORA-06550: 第 3 行, 第 38 列:

PL/SQL: ORA-00942: 表或视图不存在

ORA-06550: 第 3 行, 第 1 列:

PL/SQL: SQL Statement ignored

],DBType=[Oracle]

at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.upgradeEASDatacenter(PatchManagerServiceImpl.java:3309)

at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.recursionInstallPatch(PatchManagerServiceImpl.java:4727)

at com.kingdee.eas.tools.admin.domain.impl.PatchManagerServiceImpl.recursionInstallPatchE(PatchManagerServiceImpl.java:4413)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.kingdee.eas.tools.admin.framework.ssap.dualrpc.SSAPServerRPCHandler.invokeService(SSAPServerRPCHandler.java:46)

at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.processRpcCallMessage(RpcWorker.java:237)

at com.kingdee.eas.tools.admin.framework.dualrpc.core.common.RpcWorker.run(RpcWorker.java:81)

有知道原因的吗

产品问题eas8.6cloud 打行业补丁PT156253 执行sql脚本出错！

产品问题 eas8.6cloud 打行业补丁PT156253 执行sql脚本出错！

恭喜您！

产品问题
eas8.6cloud 打行业补丁PT156253 执行sql脚本出错！