Swadhin Ray
asked on
Getting errors : ORA-24324 REP-0069 REP-57054 REP-300 for oracle reports
Hello Experts,
I need an urgent help in solving this problem on Oracle reports 10g , my report works perfect on our development environment but when i moved this to stage env I am getting this error:
I need an urgent help in solving this problem on Oracle reports 10g , my report works perfect on our development environment but when i moved this to stage env I am getting this error:
Error Message:-
===========================
ORA-24324: service handle not initialized
==> SELECT /*+ INDEX( V PO_VENDORS_U1 ) */ hou . NAME operating_unit , v . vendor_name c_vendor_name , UPPER ( v . vendor_name ) c_sort_vendor_name , v . segment1 c_vendor_number , vs . vendor_site_code c_vendor_site_code , DECODE ( vs . address_line1
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: service handle not initialized
==> SELECT /*+ INDEX( V PO_VENDORS_U1 ) */ hou . NAME operating_unit , v . vendor_name c_vendor_name , UPPER ( v . vendor_name ) c_sort_vendor_name , v . segment1 c_vendor_number , vs . vendor_site_code c_vendor_site_code , DECODE ( vs . address_line1
===========================
ASKER
Other reports are running fine but only this report causing issue. Is there anything else I need to check ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
the following parameter in sqlnet.ora on the db server.
SQLNET.EXPIRE_TIME= n where n is in minutes. Set n to a value less than the firewall timeout setting
By setting this parameter, the DB server will ping the client every n minutes to check if the client is alive or not. This ping will ensure that the firewall timeout does not kill the connection between report server and database server.