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
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  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

    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