大家好,我们应用出现下面的问题,提示中对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.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
s,
customeren
c,
instanceen
i,
priceinstanceen
pi
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)
atcom.star.sms.remote.RemoteInvokeChain.next(RemoteInvokeChain.java:66)
atcom.star.sms.remote.RemoteInvokeChain.access$000(RemoteInvokeChain.java:29)
atcom.star.sms.remote.RemoteInvokeChain$1.process(RemoteInvokeChain.java:47)
atcom.star.sms.remote.SystemLogInterceptor.invokeAndCreateResult(SystemLogInterceptor.java:77)
atcom.star.sms.remote.RemoteInvokeChain.next(RemoteInvokeChain.java:66)
atcom.star.sms.remote.RemoteInvokeChain.access$000(RemoteInvokeChain.java:29)
atcom.star.sms.remote.RemoteInvokeChain$1.process(RemoteInvokeChain.java:47)
atcom.star.sms.remote.LoginCheckInterceptor.invokeAndCreateResult(LoginCheckInterceptor.java:46)
atcom.star.sms.remote.RemoteInvokeChain.next(RemoteInvokeChain.java:66)
atcom.star.sms.remote.RemoteInvokeChain.access$000(RemoteInvokeChain.java:29)
atcom.star.sms.remote.RemoteInvokeChain$1.process(RemoteInvokeChain.java:47)
atcom.star.sms.remote.SessionManagerInterceptor.invokeAndCreateResult(SessionManagerInterceptor.java:42)
atcom.star.sms.remote.RemoteInvokeChain.next(RemoteInvokeChain.java:66)
atcom.star.sms.remote.RemoteInvokeChain.access$000(RemoteInvokeChain.java:29)
atcom.star.sms.remote.RemoteInvokeChain$1.process(RemoteInvokeChain.java:47)
atcom.star.sms.remote.TerminalCheckInterceptor.invokeAndCreateResult(TerminalCheckInterceptor.java:55)
atcom.star.sms.remote.RemoteInvokeChain.next(RemoteInvokeChain.java:66)
atcom.star.sms.remote.RemoteInvokeChain.invoke(RemoteInvokeChain.java:62)
atcom.star.sms.remote.http.HttpInvokerServiceWithHandlerExporter.handleRequest(HttpInvokerServiceWithHandlerExporter.java:83)
atorg.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
atorg.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:723)
atorg.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:663)
atorg.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:394)
atorg.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:358)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:717)
atjavax.servlet.http.HttpServlet.service(HttpServlet.java:810)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
atorg.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
atorg.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
atorg.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153)
atorg.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
atorg.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
atorg.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
atorg.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
atorg.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
atjava.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException:ORA-03001: 未执行的特性
atoracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
atoracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
atoracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
atoracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
atoracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
atoracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
atoracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
atoracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
atoracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
atorg.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:535)
atorg.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:476)
... 74 more
[本帖最后由 shijian0916 于 2010-11-4 14:10 编辑]