end-of-file on communication channel

From: KevinS <SearleK_at_googlemail.com>
Date: Tue, 5 Aug 2008 02:43:51 -0700 (PDT)
Message-ID: <3c321e9d-7330-4bac-a037-a6ec6182aefe@e53g2000hsa.googlegroups.com>

Hello,

The query below (names changed so I don't give away too many company secrets!!) works fine unless you uncomment the line 'AND mp.id = 5010000' when an 'end-of-file on communication channel' error occurs.

SELECT mp.ID AS ID,           mp.a2 AS a2,
       mp.a3 AS a3,
       SUM(nvl(ocp.b1,0)) b1, SUM(nvl(ocp.b2,0)) b2,
       SUM(nvl(ocp.b3,0)) b3, SUM(nvl(ocp.b4,0)) b4,
       SUM(nvl(ocp.b5,0)) b5, SUM(nvl(ocp.b6,0)) b6,
       SUM(nvl(ocp.b7,0)) b7, SUM(nvl(ocp.b8,0)) b8,
       SUM(nvl(ocp.b9,0)) b9, SUM(nvl(ocp.b10,0)) b10,
       MAX(cp.a4) a4
FROM   alpha mp,  alpha cp,
       beta pt,   gamma psp,
       delta ocp
WHERE mp.ive = 1
AND   mp.ate = 0

AND mp.ram = 0
AND mp.ID = pt.prpid
AND psp.prtaskid = pt.pid

AND   cp.ID = psp.prefpid
AND   cp.ive = 1
AND   cp.ID = ocp.ID
AND   ocp.code IN (SELECT code
                   FROM cl
                   WHERE cl.parent_lookup_code = 'A'
                   AND cl.ive = 1)

--AND mp.id = 5010000
GROUP BY mp.ID,

       mp.unique_name,
       mp.NAME;

Searching on google would suggest it's an issue with the database rather than the sql but the DBA's are scratching their heads.

Any suggestions?

Thanks Received on Tue Aug 05 2008 - 04:43:51 CDT