NC65升级NCC 字段缺失 ORA-00904: “T0“.“LISTENERTYPE“: 标识符无效

NC65升级NCC的过程中

报错：sql:select T0.owner,T0.listenertype,T1.sourceid as sourceid,T1.eventtypecode as eventtype,T0.implclassname as implclassname,T0.operindex as operindex,M.devmodule as devmodulecode,T0.localtype as localtype,T0.industrytype as industrytype from pub_eventlistener T0 left outer join pub_eventtype T1 on T0.pk_eventtype =T1.pk_eventtype left join dap_dapsystem  M on M.moduleid=T0.owner where T0.enabled = 'Y' or T0.enabled = 'y' ORA-00904: "T0"."LISTENERTYPE": 标识符无效

问题: 这个报错代表NC65数据库中表pub_eventlistener中没有LISTENERTYPE这一列。

解决办法:根据查看NCC数据库，LISTENERTYPE的数据类型是Char，长度为1。

执行新增列语句： ALTER TABLE PUB_EVENTLISTENER ADD LISTENERTYPE char(1);