2025-10-24 16:06:44.976 ERROR 29034 --- [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] c.o.group.apps.core.aop.ConsolePrintAop : 抛出异常 :
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00904: "FAIL_RULE": invalid identifier
### The error may exist in com/oda/apps/supplyportal/mapper/CoaMaterialParameterMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT ID,UUID,MATERIAL_UUID,PARAMETER_NAME,CHARACTER_SPEC,UNIT,USL,LSL,UCL,LCL,TARGET,SPC_RULE_1,SPC_RULE_2,SPC_RULE_3,SPC_RULE_4,SPC_RULE_5,DESCRIPTION,DEL_FLAG,CREATED_BY,CREATE_TIME,UPDATED_BY,UPDATE_TIME,MATERIAL_NO,CREATED_BY_COMPANY,CREATED_BY_FAB,SPC_RULE_6,SPC_RULE_7,SPC_RULE_8,SPC_RULE_9,FAIL_RULE,KEY_ITEM FROM CERP_COA_MATERIAL_PARAMETER WHERE DEL_FLAG='0' AND (MATERIAL_NO = ? AND CREATED_BY_COMPANY = ? AND CREATED_BY_FAB = ? AND DEL_FLAG = ?)
### Cause: java.sql.SQLSyntaxErrorException: ORA-00904: "FAIL_RULE": invalid identifier
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: "FAIL_RULE": invalid identifier
2025-10-24 16:06:44.985 ERROR 29034 --- [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] c.o.g.a.c.c.e.Error500Controller : 捕获到错误: BadSqlGrammarException:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00904: "FAIL_RULE": invalid identifier
### The error may exist in com/oda/apps/supplyportal/mapper/CoaMaterialParameterMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT ID,UUID,MATERIAL_UUID,PARAMETER_NAME,CHARACTER_SPEC,UNIT,USL,LSL,UCL,LCL,TARGET,SPC_RULE_1,SPC_RULE_2,SPC_RULE_3,SPC_RULE_4,SPC_RULE_5,DESCRIPTION,DEL_FLAG,CREATED_BY,CREATE_TIME,UPDATED_BY,UPDATE_TIME,MATERIAL_NO,CREATED_BY_COMPANY,CREATED_BY_FAB,SPC_RULE_6,SPC_RULE_7,SPC_RULE_8,SPC_RULE_9,FAIL_RULE,KEY_ITEM FROM CERP_COA_MATERIAL_PARAMETER WHERE DEL_FLAG='0' AND (MATERIAL_NO = ? AND CREATED_BY_COMPANY = ? AND CREATED_BY_FAB = ? AND DEL_FLAG = ?)
### Cause: java.sql.SQLSyntaxErrorException: ORA-00904: "FAIL_RULE": invalid identifier
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: "FAIL_RULE": invalid identifier
2025-10-24 16:08:17.005 INFO 29034 --- [MessageBroker-13] o.s.w.s.c.WebSocketMessageBrokerStats : WebSocketSession[0 current WS(0)-HttpStream(0)-HttpPoll(0), 0 total, 0 closed abnormally (0 connect failure, 0 send limit, 0 transport error)], stompSubProtocol[processed CONNECT(0)-CONNECTED(0)-DISCONNECT(0)], stompBrokerRelay[null], inboundChannel[pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0], outboundChannel[pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0], sockJsScheduler[pool size = 16, active threads = 1, queued tasks = 2, completed tasks = 210]
数据库中有这个字段 为什么还报这个错
最新发布
本文详细记录了在使用 Oracle LogMiner 时遇到 capture 进程 abort 掉并出现 ORA-01280 错误的情况，通过启动 capture 进程并观察告警日志来解决问题的过程。
扫一扫
426
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
