查询上机日志报缺少字段错误处理方法

问题描述：
查询上机日志报错，缺少字段FMETHODDESCRIPTION_L2，错误信息如下：
ORA-00904: "APPLOGS"."FMETHODDESCRIPTION_L2": 标识符无效
. The query sql is:SELECT
解决方案：
步骤 1 ：
执行如下脚本：
IF NOT EXISTS (SELECT * FROM KSQL_USERCOLUMNS WHERE KSQL_COL_NAME = 'FMethodDescription_l1' AND KSQL_COL_TABNAME = 'T_LOG_App')
alter table T_LOG_App add FMethodDescription_l1 NVARCHAR(255);

IF NOT EXISTS (SELECT * FROM KSQL_USERCOLUMNS WHERE KSQL_COL_NAME = 'FMethodDescription_l2' AND KSQL_COL_TABNAME = 'T_LOG_App')
alter table T_LOG_App add FMethodDescription_l2 NVARCHAR(255);

IF NOT EXISTS (SELECT * FROM KSQL_USERCOLUMNS WHERE KSQL_COL_NAME = 'FMethodDescription_l3' AND KSQL_COL_TABNAME = 'T_LOG_App')
alter table T_LOG_App add FMethodDescription_l3 NVARCHAR(255);

IF NOT EXISTS (SELECT * FROM KSQL_USERCOLUMNS WHERE KSQL_COL_NAME = 'FMethodDescription_l1' AND KSQL_COL_TABNAME = 'T_LOG_His')
alter table T_LOG_His add FMethodDescription_l1 NVARCHAR(255);

IF NOT EXISTS (SELECT * FROM KSQL_USERCOLUMNS WHERE KSQL_COL_NAME = 'FMethodDescription_l2' AND KSQL_COL_TABNAME = 'T_LOG_His')
alter table T_LOG_His add FMethodDescription_l2 NV ARCHAR(255);

IF NOT EXISTS (SELECT * FROM KSQL_USERCOLUMNS WHERE KSQL_COL_NAME = 'FMethodDescription_l3' AND KSQL_COL_TABNAME = 'T_LOG_His')
alter table T_LOG_His add FMethodDescription_l3 NVARCHAR(255);

步骤2：
安装补丁PT035176，该补丁同时依赖补丁PT035336、PTM035205需一起安装。