oracle 未执行的特性,讨论ORA-03001: 未执行的特性

最新推荐文章于 2023-06-11 21:27:53 发布

薛加骥

最新推荐文章于 2023-06-11 21:27:53 发布

阅读量2.1k

点赞数

文章标签： oracle 未执行的特性

大家好,我们应用出现下面的问题,提示中对ORA-03001: 未执行的特性陈述不明,现在和大家讨论报错原因,错误原因如下,从昨天我对报错的sql做了比较,在测试库正常,生产库一直有问题,但是问题不知道如何解决.请大家帮助官方描述

ORA-03001 unimplemented feature

Cause: At attempt was made to use a feature that is not currently implemented

Action: Do not attempt to use this feature at this time.

错误详情：

com.star.common.exception.MsrRuntimeException:commquery.waiting.error

atcom.star.sms.richclient.query.surport.CommQueryPageTableFactory.executeWithWaitingDialog(CommQueryPageTableFactory.java:222)

atcom.star.sms.richclient.query.surport.CommQueryPageTableFactory.setDatas(CommQueryPageTableFactory.java:197)

atcom.star.sms.richclient.query.surport.CommQueryShowInfoDisplayer.setData(CommQueryShowInfoDisplayer.java:97)

atcom.star.sms.richclient.query.surport.CommQueryInputInfoEditor.queryData(CommQueryInputInfoEditor.java:241)

atcom.star.sms.richclient.query.surport.CommQueryInputInfoEditor.access$300(CommQueryInputInfoEditor.java:48)

atcom.star.sms.richclient.query.surport.CommQueryInputInfoEditor$2.postExecution(CommQueryInputInfoEditor.java:157)

atorg.springframework.richclient.command.ActionCommand.onPostExecute(ActionCommand.java:215)

atorg.springframework.richclient.command.ActionCommand.execute(ActionCommand.java:189)

atorg.springframework.richclient.command.ActionCommand$1.actionPerformed(ActionCommand.java:123)

atjavax.swing.AbstractButton.fireActionPerformed(Unknown Source)

atjavax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

atjavax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

atjavax.swing.DefaultButtonModel.setPressed(Unknown Source)

atjavax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)

atjava.awt.Component.processMouseEvent(Unknown Source)

atjavax.swing.JComponent.processMouseEvent(Unknown Source)

atjava.awt.Component.processEvent(Unknown Source)

atjava.awt.Container.processEvent(Unknown Source)

atjava.awt.Component.dispatchEventImpl(Unknown Source)

atjava.awt.Container.dispatchEventImpl(Unknown Source)

atjava.awt.Component.dispatchEvent(Unknown Source)

atjava.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

atjava.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

atjava.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

atjava.awt.Container.dispatchEventImpl(Unknown Source)

atjava.awt.Window.dispatchEventImpl(Unknown Source)

atjava.awt.Component.dispatchEvent(Unknown Source)

atjava.awt.EventQueue.dispatchEvent(Unknown Source)

atjava.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)

atjava.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

atjava.awt.EventDispatchThread.pumpEvents(Unknown Source)

atjava.awt.EventDispatchThread.run(Unknown Source)

Caused by

rg.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback;uncategorized SQLException for SQL [SELECT count(*)

from

subscriberaddonen t,

phyresourceen

pr,

resourcecataen

rc,

subscriberen

customeren

instanceen

priceinstanceen

where

rc.resourcecataid_pk = pr.resourcecataid_pk

and pr.resourceid_pk = t.resourceid

and s.subscriberid_pk = t.subscriberid_pk

and c.customerid_pk = s.customerid_pk

and pi.instanceid_pk = t.instanceid_pk

and i.instanceid_pk = t.instanceid_pk

and exists

(select 'a'

from addressen ar

where ar.addressid_pk = c.addressid

start with ar.addressid_pk =

connect by prior ar.addressid_pk = ar.addressid_fk)

and (

is null or pr.resourcetypeid = 2)

and (

is null or

(substr(pr.resourcecodestr, 3, 2) =

? ))

ANDs.OPERAREAID IN ( ? )

and s.OPERAREAID = ?

and pr.resourcecataid_pk =?

and pr.proposetypeid

= ?

AND t.statusid = 1

and i.PRODUCTID

= ?

AND (

isnull or t.createcodestr =

? )

AND (

isnull or

t.startdt>=

? )

AND (

is null or t.startdt<=(to_date(to_char(

? , 'yyyymmdd')||'235959','yyyymmdd hh24miss')))]; SQL state [0A000]; error code [3001];ORA-03001: 未执行的特性

; nested exception isjava.sql.SQLException: ORA-03001: 未执行的特性

atorg.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:97)

atorg.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:258)

atorg.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:493)

atorg.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:528)

atorg.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:561)

atorg.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:579)

atorg.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:584)

atorg.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:614)

atcom.star.sms.dao.utils.SmsJdbcTemplate.queryForObject(SmsJdbcTemplate.java:424)

atcom.star.sms.dao.query.jdbc.GeneralQueryExecuteDaoImp.queryForRowCount(GeneralQueryExecuteDaoImp.java:50)

atcom.star.sms.model.query.core.CountQueryRequest.getQueryResult(CountQueryRequest.java:58)

atcom.star.sms.business.query.GeneralQueryExecuteServiceImp.queryForRowCount(GeneralQueryExecuteServiceImp.java:133)

atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

atjava.lang.reflect.Method.invoke(Method.java:585)

atorg.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)

atorg.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)

atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)

atorg.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)

atorg.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)

atorg.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)

at$Proxy101.queryForRowCount(Unknown Source)

atsun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

atjava.lang.reflect.Method.invoke(Method.java:585)

atorg.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:179)

atorg.springframework.remoting.support.DefaultRemoteInvocationExecutor.invoke(DefaultRemoteInvocationExecutor.java:33)

atorg.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:76)

atorg.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExporter.java:112)

atcom.star.sms.remote.http.HttpInvokerServiceWithHandlerExporter.invokeAndCreateResult(HttpInvokerServiceWithHandlerExporter.java:93)