com.bea.dsp.das.exception.DASException: 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."AGGREG_VIEW_ID" AS c1, t1."AMT_GRP_CD" AS c2, t1."AMT_QTY_TY_CD" AS c3 FROM "GB3A"."AMT_MAP" t1 ) t2 ) t3 WHERE (t3.c4 < 501)]: Error executing SQL query: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: (;, FROM INTO

Oracle Community | 666705 | 9 years ago
  1. 0

    Error While running a PhysicalLayer Dataservice in DSP3.2

    Oracle Community | 9 years ago | 666705
    com.bea.dsp.das.exception.DASException: 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."AGGREG_VIEW_ID" AS c1, t1."AMT_GRP_CD" AS c2, t1."AMT_QTY_TY_CD" AS c3 FROM "GB3A"."AMT_MAP" t1 ) t2 ) t3 WHERE (t3.c4 < 501)]: Error executing SQL query: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: (;, FROM INTO
  2. 0

    ODSI service using function from oracle database

    Oracle Community | 6 years ago | 805279
    com.bea.dsp.das.exception.DASException: 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 c1, t2."RLN_TYP" AS c2 FROM "ABC"."sample_table1" t2 WHERE ((t2."KEY1_TYP" = 'BUS') AND (t2."KEY2_TYP" = 'ADD') AND (t2."REF_EFF_DTE" <= ?) AND ( t2."REF_CAN_DTE" > ?) AND (t2."RLN_TYP" = 'PRIM')) ) t3 ON (t3.c1 = t1."BUS_IDN") WHERE ((t1."REF_EFF_DTE" <= ?) AND (t1."REF_CAN_DTE" > ?) AND (? = t1."FRM_NUM")) ORDER BY t1."BUS_IDN" ASC, t1."REF_EFF_DTE" ASC]: [2010-10-18T12:52:41.497-06:00, 2010-10-18T12:52:41.497-06:00, 2010-10-18T12:52:41.497-06:00, 2010-10-18T12:52:41.497-06:00, 1106112]: Error executing SQL query: ORA-00904: "GET_TNAME": invalid identifier
  3. 0

    ODSI service using function from oracle database

    Oracle Community | 6 years ago | 805279
    com.bea.dsp.das.exception.DASException: com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: ld:Logical/sampleTest/test.ds, line 18, column 1: {bea-err}RDBW0004: [jdbc.abc.efg]: [SELECT get_tname(t1."BUS_IDN") AS c1 FROM "abc"."Table1" t1 WHERE (? = t1."FNO")]: [1106112]: Error executing SQL query: ORA-00904: "GET_TNAME": invalid identifier
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Optional Parameter in ODSI

    Oracle Community | 6 years ago | 805279
    com.bea.dsp.das.exception.DASException: weblogic.xml.query.exceptions.XQueryDynamicException: {err}XP0021: "": can not cast to {http://www.w3.org/2001/XMLSchema}integer: error: decimal: Invalid decimal value: expected at least one digit
  6. 0

    TYPE003: Runtime Type Mismatch

    Oracle Community | 5 years ago | 583206
    com.bea.dsp.das.exception.DASException: weblogic.xml.query.exceptions.XQueryTypeException: {bea-err}TYPE003: Runtime Type Mismatch

    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. com.bea.dsp.das.exception.DASException

      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."AGGREG_VIEW_ID" AS c1, t1."AMT_GRP_CD" AS c2, t1."AMT_QTY_TY_CD" AS c3 FROM "GB3A"."AMT_MAP" t1 ) t2 ) t3 WHERE (t3.c4 < 501)]: Error executing SQL query: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: (;, FROM INTO

      at com.bea.dsp.das.ejb.EJBClient.invokeOperation()
    2. com.bea.dsp
      XQueryTestViewContent.getFunctionExecutionResult
      1. com.bea.dsp.das.ejb.EJBClient.invokeOperation(EJBClient.java:160)
      2. com.bea.dsp.das.DataAccessServiceImpl.invokeOperation(DataAccessServiceImpl.java:171)
      3. com.bea.dsp.das.DataAccessServiceImpl.invoke(DataAccessServiceImpl.java:122)
      4. com.bea.dsp.ide.xquery.views.test.QueryExecutor.invokeFunctionOrProcedure(QueryExecutor.java:121)
      5. com.bea.dsp.ide.xquery.views.test.XQueryTestViewContent.getFunctionExecutionResult(XQueryTestView.java:1006)
      5 frames