Problem with SQL Statement - List index out of bounds (0)

[jfudickar]

Hi,

when i execute the following VALID select statement

Code: Select all

        SELECT inl.Quelle, inl.Technik, inl.Netzelement, ROUND(AVG(inl.duration_in_sec), 1) Laufzeit_in_Sek, count(1) ANZAHL
          FROM
              (
               SELECT two.orig_login Quelle,
                      DECODE(thc.tech_type, 'JINTERP', 'EWSD', thc.tech_type) Technik,
                      ts.host_clli Netzelement,
                      (SYSDATE - two.start_dts) * 24 * 60 * 60 duration_in_sec
                 FROM tbl_wrk_ord two
                      INNER JOIN tbl_srq ts        ON (two.srq_id    = ts.srq_id   )
                      INNER JOIN tbl_host_clli thc ON (thc.host_clli = ts.host_clli)
                WHERE 1 = 1
                  AND two.wo_stat   = 103
                  AND two.orig_login IN ('TTT', 'PBOX')
              ) inl
         GROUP BY Quelle, Technik, Netzelement

i've got this error: List index out of bounds (0)

If i execute the statement as :

Code: Select all

SELECT  QUELLE WERT_DETAIL_1,
        TECHNIK WERT_DETAIL_2,
        NETZELEMENT WERT_DETAIL_3,
        NULL WERT_DETAIL_4,
        Laufzeit_in_Sek WERT_VALUE_NUMBER_1,
        ANZAHL WERT_VALUE_NUMBER_2,
        NULL WERT_VALUE_NUMBER_3,
        NULL WERT_VALUE_NUMBER_4,
        NULL WERT_VALUE_NUMBER_5,
        NULL WERT_VALUE_VARCHAR2_1,
        NULL WERT_VALUE_VARCHAR2_2,
        NULL WERT_VALUE_VARCHAR2_3,
        NULL WERT_VALUE_VARCHAR2_4,
        NULL WERT_VALUE_VARCHAR2_5,
        NULL WERT_VALUE_DATE_1,
        NULL WERT_VALUE_DATE_2,
        NULL WERT_VALUE_DATE_3,
        NULL WERT_VALUE_DATE_4,
        NULL WERT_VALUE_DATE_5,
        NULL WERT_FLAG 
  FROM ( 
        SELECT inl.Quelle, inl.Technik, inl.Netzelement, ROUND(AVG(inl.duration_in_sec), 1) Laufzeit_in_Sek, count(1) ANZAHL
          FROM
              (
               SELECT two.orig_login Quelle,
                      DECODE(thc.tech_type, 'JINTERP', 'EWSD', thc.tech_type) Technik,
                      ts.host_clli Netzelement,
                      (SYSDATE - two.start_dts) * 24 * 60 * 60 duration_in_sec
                 FROM tbl_wrk_ord two
                      INNER JOIN tbl_srq ts        ON (two.srq_id    = ts.srq_id   )
                      INNER JOIN tbl_host_clli thc ON (thc.host_clli = ts.host_clli)
                WHERE 1 = 1
                  AND two.wo_stat   = 103
                  AND two.orig_login IN ('TTT', 'PBOX')
              ) inl
         GROUP BY Quelle, Technik, Netzelement
       )

everything is fine.

Any Idea?

Greetings
Jens

[Challenger]

We fixed this problem. This fix will be included in the next build of ODAC.

[jfudickar]

Thanks,

is ist possible to receive the fix before?

Greetings
Jens

[Alex]

We plan to release a new ODAC build in a couple of days.