Ora-03113 error when running report

[kinhell]

ORA-03113: end-of-file on communication channel

I have a cognos catalog with 1 view and 1 table. When I join them on a common field it works. If I then add an outer join on the view it works. But when I add a join line which is eg CCN='FSG01' then it falls over with the ORA-03113 End of file communications channel. I've tried various scenarios and it only crashes when there is and outer join on a view and the join definition contains a 'something = string' statement.


The oracle trace shows
select T1."CCN_PL01H" "c1", T1."INVOICE_NO_PL01H" "c2", T2."PLINVOICENO" "c3",T2."PLRCDDATE" "c4"from "INVOICE_VIEW" T1 LEFT OUTER JOIN "PL01H" T2 on T1."CCN_PL01H"=T2."CCN" and T1."INVOICE_NO_PL01H"=T2."PLINVOICENO" and T1."CCN_PL01H"='FSG01'
*
Error at line 0
ORA-03113: end-of-file on communication channel
This was generated by impromptu. Any idea where the error in this could be??

 

[blom0344]

ORA-03113: end-of-file on communication channel

is one of the most 'generic' failure messages. It usually indicates a connection issue like a time-out.

Did you check the SQL generated with a common query-tool or SQL-Plus? Does the query complete outside impromptu?

Ties Blom