Avatar of Swadhin Ray
Swadhin Ray
Flag for United States of America 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:

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 

===========================

Open in new window

Enterprise SoftwareOracle Database

Avatar of undefined
Last Comment
Swadhin Ray

8/22/2022 - Mon
vishal68

Is there a firewall between report server and database server. This error can come due to timeout setting of firewall. Please check the same and increase it. other option can be to set
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.
Swadhin Ray

ASKER
Other reports are running fine but only this report causing issue. Is there anything else I need to check ?
ASKER CERTIFIED SOLUTION
vishal68

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Swadhin Ray

ASKER
Thanks
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck