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

Oracle Community | 701870 | 7 years ago
  1. 0

    java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-01830: date fo

    Oracle Community | 7 years ago | 701870
    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
  2. 0

    Problem creating physical service using stored procedure.

    Oracle Community | 7 years ago | 761210
    com.bea.dsp.das.exception.DASException: weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_447b134168421dc5:564de77e:12775210007:-7ff2): com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0004: Error executing SQL query: [BEA][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PAG_TES' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  3. 0

    oracle stored procedure with an inout boolean parameter

    Oracle Community | 1 decade ago | 666705
    java.lang.RuntimeException: [BEA][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'P_GET_LIST_OF_ADDRESSES' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Invalid Number Error

    Google Groups | 1 decade ago | Tahir Emre KALAYCI
    java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-01722: invalid number
  6. 0

    P13/Profile data sharing between two WLP instance

    Oracle Community | 7 years ago | 732657
    java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-00001: unique constraint (WLP_USER2.PK_ENT_POLICY) violated

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. weblogic.jdbc.base
      BaseExceptions.getException
      1. weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)
      2. weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)
      2 frames
    3. weblogic.jdbc.oracle
      OracleImplStatement.execute
      1. weblogic.jdbc.oracle.OracleImplStatement.fetchNext(Unknown Source)
      2. weblogic.jdbc.oracle.OracleImplStatement.fetchNext2(Unknown Source)
      3. weblogic.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
      3 frames
    4. weblogic.jdbc.base
      BasePreparedStatement.execute
      1. weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)
      2. weblogic.jdbc.base.BaseStatement.executeInternal(Unknown Source)
      3. weblogic.jdbc.base.BasePreparedStatement.execute(Unknown Source)
      3 frames
    5. weblogic.jdbcx.base
      BasePreparedStatementWrapper.execute
      1. weblogic.jdbcx.base.BasePreparedStatementWrapper.execute(Unknown Source)
      1 frame
    6. weblogic.jdbc.wrapper
      PreparedStatement.execute
      1. weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:73)
      1 frame
    7. com.bea.dsp
      ExecuteSQLRuntimeBase.fetchNext
      1. com.bea.dsp.wrappers.rdb.runtime.DBSession.executeQuery(DBSession.java:91)
      2. com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLQueryBase.executeSQL(ExecuteSQLQueryBase.java:19)
      3. com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.prepareAndExecuteQuery(ExecuteSQLRuntimeBase.java:170)
      4. com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.fetchNext(ExecuteSQLRuntimeBase.java:95)
      4 frames
    8. weblogic.xml.query
      GenericIterator.next
      1. weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135)
      2. weblogic.xml.query.runtime.core.CountMapIterator.fetchNext(CountMapIterator.java:135)
      3. weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114)
      4. weblogic.xml.query.runtime.querycide.QueryAssassin.fetchNext(QueryAssassin.java:54)
      5. weblogic.xml.query.iterators.GenericIterator.peekNext(GenericIterator.java:152)
      6. weblogic.xml.query.runtime.qname.InsertNamespaces.fetchNext(InsertNamespaces.java:161)
      7. weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114)
      8. weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:85)
      9. weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135)
      10. weblogic.xml.query.runtime.node.DeflateRec.fetchNext(DeflateRec.java:43)
      11. weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114)
      11 frames
    9. com.bea.ld
      Server_ydm4ie_EOImpl_WLSkel.invoke
      1. com.bea.ld.server.ResultPusher$ChunkyBinxmlChunker.nextChunk(ResultPusher.java:464)
      2. com.bea.ld.server.ResultPusher$AsyncChunkyBinxmlChunker.nextChunk(ResultPusher.java:574)
      3. com.bea.ld.server.ResultPusher$BinxmlChunker.next(ResultPusher.java:342)
      4. com.bea.ld.EJBRequestHandler$1.next(EJBRequestHandler.java:887)
      5. com.bea.ld.ServerBean.maybeStreamResult(ServerBean.java:97)
      6. com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:86)
      7. com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:355)
      8. com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source)
      8 frames
    10. weblogic.rmi.internal
      BasicServerRef.invoke
      1. weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:550)
      1 frame
    11. weblogic.rmi.cluster
      ClusterableServerRef.invoke
      1. weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224)
      1 frame
    12. weblogic.rmi.internal
      BasicServerRef$1.run
      1. weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:440)
      1 frame
    13. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
      1 frame
    14. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
      1 frame
    15. weblogic.rmi.internal
      BasicServerRef$BasicExecuteRequest.run
      1. weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:436)
      2. weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:58)
      3. weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:975)
      3 frames
    16. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:181)
      2 frames