com.bea.dsp.das.exception.DASException

com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {ld:ViewFolder/physical/VIEW}VIEW:0, line 4, column 1:{bea-err}RDBW0004: [Database]: [SELECT t3.c1, t3.c2, t3.c3 FROM ( SELECT ROWNUM AS c4, t2.c1, t2.c2, t2.c3 FROM ( SELECT t1."DATE" AS c1, t1."ID" AS c2, t1."FK_ID" AS c3 FROM "SCHEMA"."VIEW" t1 ) t2 WHERE (ROWNUM < 501) ) t3]: Error executing SQL query: [BEA][Oracle JDBC Driver][Oracle]ORA-01830: date format picture ends before converting entire input string

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web15

  • , t1."ID" AS c2, t1."FK_ID" AS c3 FROM "SCHEMA"."VIEW" t1 ) t2 WHERE (ROWNUM < 501) ) t3]: Error executing SQL query: [BEA][Oracle JDBC Driver][Oracle]ORA-01830: date format picture ends before converting entire input string
  • via Oracle Community by 666705, 1 year ago
    com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {ld:PhysicalLayer/test/AMT_MAP}AMT_MAP:0, line 4, column 1: {bea-err}RDBW0004: [CBoR]: [SELECT t3.c1, t3.c2, t3.c3 FROM ( SELECT ROW_NUMBER() OVER() AS c4, t2.c1, t2.c2, t2.c3 FROM ( SELECT t1
  • via Oracle Community by 805279, 10 months ago
    com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: ld:Logical/Sample/sampleInfo.ds, line 31, column 1: {bea-err}RDBW0004: [jdbc.abc.efg]: [SELECT f1:get_tname($busIdn) AS c3 FROM "ABC"."sample_table" t1 LEFT OUTER JOIN ( SELECT t2."KEY1" AS
  • Stack trace

    • com.bea.dsp.das.exception.DASException: com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {ld:ViewFolder/physical/VIEW}VIEW:0, line 4, column 1:{bea-err}RDBW0004: [Database]: [SELECT t3.c1, t3.c2, t3.c3 FROM ( SELECT ROWNUM AS c4, t2.c1, t2.c2, t2.c3 FROM ( SELECT t1."DATE" AS c1, t1."ID" AS c2, t1."FK_ID" AS c3 FROM "SCHEMA"."VIEW" t1 ) t2 WHERE (ROWNUM < 501) ) t3]: Error executing SQL query: [BEA][Oracle JDBC Driver][Oracle]ORA-01830: date format picture ends before converting entire input string at com.bea.dsp.das.ejb.EJBClient.invokeOperation(EJBClient.java:160) at com.bea.dsp.das.DataAccessServiceImpl.invokeOperation(DataAccessServiceImpl.java:171) at com.bea.dsp.das.DataAccessServiceImpl.invoke(DataAccessServiceImpl.java:122) at com.bea.dsp.ide.xquery.views.test.QueryExecutor.invokeFunctionOrProcedure(QueryExecutor.java:121) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.getFunctionExecutionResult(XQueryTestView.java:1006) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.executeFunction(XQueryTestView.java:1134) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.widgetSelectedImpl(XQueryTestView.java:1807) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.access$300(XQueryTestView.java:159) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent$3.run(XQueryTestView.java:1535) at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.widgetSelectedBusy(XQueryTestView.java:1538) at com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.widgetSelected(XQueryTestView.java:1500) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968) at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1930) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1894) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:422) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:95) at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.eclipse.core.launcher.Main.invokeFramework(Main.java:339) at org.eclipse.core.launcher.Main.basicRun(Main.java:283) at org.eclipse.core.launcher.Main.run(Main.java:984) at org.eclipse.core.launcher.Main.eclipse_main(Main.java:959) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.m7.installer.util.NitroxMain$1.run(NitroxMain.java:39) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:199) at java.awt.EventQueue.dispatchEvent(EventQueue.java:461) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) Caused by: com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {ld:ViewFolder/physical/VIEW}VIEW:0, line 4, column 1:{bea-err}RDBW0004: [Database]: [SELECT t3.c1, t3.c2, t3.c3 FROM ( SELECT ROWNUM AS c4, t2.c1, t2.c2, t2.c3 FROM ( SELECT t1."DATE" AS c1, t1."ID" AS c2, t1."FK_ID" AS c3 FROM "SCHEMA"."VIEW" t1 ) t2 WHERE (ROWNUM < 501) ) t3]: Error executing SQL query: [BEA][Oracle JDBC Driver][Oracle]ORA-01830: date format picture ends before converting entire input string at com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException.create(RDBWrapperException.java:87) at weblogic.xml.query.exceptions.XQueryException.create(XQueryException.java:128) at weblogic.xml.query.exceptions.XQueryException.create(XQueryException.java:176) at weblogic.xml.query.exceptions.XQueryException.create(XQueryException.java:163) at com.bea.dsp.wrappers.rdb.runtime.DBSession.executeQuery(DBSession.java:113) at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLQueryBase.executeSQL(ExecuteSQLQueryBase.java:19) at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.prepareAndExecuteQuery(ExecuteSQLRuntimeBase.java:170) at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.fetchNext(ExecuteSQLRuntimeBase.java:95) at weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135) at weblogic.xml.query.runtime.core.CountMapIterator.fetchNext(CountMapIterator.java:135) at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114) at weblogic.xml.query.runtime.querycide.QueryAssassin.fetchNext(QueryAssassin.java:54) at weblogic.xml.query.iterators.GenericIterator.peekNext(GenericIterator.java:152) at weblogic.xml.query.runtime.qname.InsertNamespaces.fetchNext(InsertNamespaces.java:161) at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114) at weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:85) at weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135) at weblogic.xml.query.runtime.node.DeflateRec.fetchNext(DeflateRec.java:43) at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114) at com.bea.ld.server.ResultPusher$ChunkyBinxmlChunker.nextChunk(ResultPusher.java:464) at com.bea.ld.server.ResultPusher$AsyncChunkyBinxmlChunker.nextChunk(ResultPusher.java:574) at com.bea.ld.server.ResultPusher$BinxmlChunker.next(ResultPusher.java:342) at com.bea.ld.EJBRequestHandler$1.next(EJBRequestHandler.java:887) at com.bea.ld.ServerBean.maybeStreamResult(ServerBean.java:97) at com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:86) at com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:355) at com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source) at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:550) at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224) at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:440) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147) at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:436) at weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:58) at weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:975) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209) at weblogic.work.ExecuteThread.run(ExecuteThread.java:181) Caused by: java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-01830: date format picture ends before converting entire input string at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source) at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source) at weblogic.jdbc.oracle.OracleImplStatement.fetchNext(Unknown Source) at weblogic.jdbc.oracle.OracleImplStatement.fetchNext2(Unknown Source) at weblogic.jdbc.oracle.OracleImplStatement.execute(Unknown Source) at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source) at weblogic.jdbc.base.BaseStatement.executeInternal(Unknown Source) at weblogic.jdbc.base.BasePreparedStatement.execute(Unknown Source) at weblogic.jdbcx.base.BasePreparedStatementWrapper.execute(Unknown Source) at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:73) at com.bea.dsp.wrappers.rdb.runtime.DBSession.executeQuery(DBSession.java:91) ... 32 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago