OraFAQ Forum: Networking and Gateways » ORA-03113: end of file on communication channel

Home » RDBMS Server » Networking and Gateways » ORA-03113: end of file on communication channel

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-03113: end of file on communication channel [message #18159]

Sat, 12 February 2005 18:34

Mack Sundar
Messages: 20
Registered: July 2002

Junior Member

Hi-
I am using Oracle 9i (9.2.0.1) Personal Edition on Windows 2000 Server. I have a query that consistently gives me a "ORA-03113: end of file on communication channel" on all my environments.

SELECT interaction0.date_entered
FROM ( ( ( (interaction interaction0 LEFT OUTER JOIN audit_data audit_data5
ON ((interaction0.interaction_id = audit_data5.related_id)
AND (UPPER(audit_data5.related_tbl_name) = 'INTERACTION')))
LEFT OUTER JOIN individual individual4 ON (interaction0.individual_contact_id = individual4.individual_id))
LEFT OUTER JOIN customer customer3 ON (interaction0.customer_id = customer3.customer_id))
LEFT OUTER JOIN (e_lead e_lead1
LEFT OUTER JOIN customer customer2 ON (e_lead1.customer_id = customer2.customer_id))
ON (interaction0.lead_id = e_lead1.e_lead_id))
WHERE (((interaction0.lead_id = '2BA2EAA0FFFFFF9501FD51F703A5C541')
AND ((((EXISTS (SELECT 1 FROM e_acl_entry myACLEntry
WHERE ((((myACLEntry.everyone_flag = 1) OR (myACLEntry.agent_id = '49365D8DFFFFFF95004605C7200CDA80'))
AND ((myACLEntry.permission_mask > 8) OR ((myACLEntry.permission_mask > 0)
AND (myACLEntry.permission_mask < 8)))) AND (e_lead1.e_lead_id = myACLEntry.bio_instance_id))))
OR (NOT ((customer2.customer_id IS NULL) OR ((customer2.obsolete_flag = 1)
OR (customer2.obsolete_flag IS NULL))))) OR (NOT ((customer3.customer_id IS NULL)
OR ((customer3.obsolete_flag = 1) OR (customer3.obsolete_flag IS NULL)))))
OR (NOT ((individual4.individual_id IS NULL) OR ((individual4.obsolete_flag = 1)
OR (individual4.obsolete_flag IS NULL)))))) AND (interaction0.obsolete_flag = 0))
ORDER BY audit_data5.date_inserted DESC, audit_data5.date_updated DESC, interaction0.interaction_id ASC

Can somebody help me with this problem? Any tips are appreciated.
Thanks,
Mahesh

Report message to a moderator

Re: ORA-03113: end of file on communication channel [message #18186 is a reply to message #18159]

Mon, 14 February 2005 13:28

Edward Stoever
Messages: 58
Registered: August 2002

Member

I cannot be sure that this is the reason, but OR statements do not perform well and NOT statements do not perform well. Combine the two and you are asking for trouble. Try dumbing down the query a bit. Take out the order by and try to simplify it.

Edward

Report message to a moderator

Re: ORA-03113: end of file on communication channel [message #112829 is a reply to message #18159]

Tue, 29 March 2005 10:25

Hoornet
Messages: 4
Registered: March 2005

Junior Member

I have a simmilar problem, but i'm making my sql call from my application.
everything is ok, but when i say: INSERT INTO INVALIDNOST ( OSE_ID, OPE_ID, INV_VPIS, INV_KATEGORIJA, INV_PROCENT_OKVARE, INV_DAT_NAST_OKVARE, INV_DAT_NAST_INVALIDNOSTI, INV_ST_SKLEPA, INV_DAT_SKLEPA, INV_AKTIVNO, INV_FAKTOR, INV_OPIS) VALUES( 7822, 666, SYSDATE, '4', 0, NULL, NULL, '', NULL, -1, 0.000000, '' );

it says:
Description: ORA-03113: end-of-file on communication channel
Source: OraOLEDB

The same sql is easily run through sql plus...

I'm really stuck. Can anyone help?

Report message to a moderator

Previous Topic:	Create database link
Next Topic:	TNS 12574 - TNS lost contact

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 13:57:33 CDT 2024