Home » Developer & Programmer » Forms » FRM- 41213: Unable to connect to the report server error
FRM- 41213: Unable to connect to the report server error [message #149117] Wed, 30 November 2005 02:25 Go to next message
bijayad
Messages: 11
Registered: August 2005
Junior Member
Hi,

I am trying to integrate report within forms 9i. So, I have written following syntax:

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,
'rep_hp11');
where 'rep_hp11' is the report server name created in the folder /Reports/conf/rep_hp11.conf.

But I am getting following error:
FRM- 41213: Unable to connect to the report server rep_hp11.

How to resolve this error.Please help me.
Regards,
Bijaya
Re: FRM- 41213: Unable to connect to the report server error [message #149128 is a reply to message #149117] Wed, 30 November 2005 04:01 Go to previous messageGo to next message
manjuvasu
Messages: 22
Registered: May 2005
Junior Member
Try this first

In your browser, give as http://hostname/reports/conf/showjobs

then call u'r report from form.

bye
Re: FRM- 41213: Unable to connect to the report server error [message #149160 is a reply to message #149128] Wed, 30 November 2005 06:57 Go to previous messageGo to next message
bijayad
Messages: 11
Registered: August 2005
Junior Member
Hi,
I am unable to browse this side. Give me alternate solution. Can you tell me how to pass 3 parameters from form 9i to report 9i.

Thanks.
Bijaya
Re: FRM- 41213: Unable to connect to the report server error [message #149260 is a reply to message #149160] Wed, 30 November 2005 21:06 Go to previous messageGo to next message
manjuvasu
Messages: 22
Registered: May 2005
Junior Member
u try this http://hostname/reports/rwservlet/showjobs

to pass parameters from form use add_parameter built-in.

bye.
Re: FRM- 41213: Unable to connect to the report server error [message #150051 is a reply to message #149160] Tue, 06 December 2005 01:47 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: FRM- 41213: Unable to connect to the report server error [message #152173 is a reply to message #150051] Wed, 21 December 2005 08:25 Go to previous messageGo to next message
ddshah
Messages: 16
Registered: December 2005
Junior Member
Hello David,

I have similar problem

receiving error FRM-41213 ( able to run web.show_document but unable to run run_report_object) also how to pass multiple user parameters in reports 10g

Can you guide please.

Thanks
icon14.gif  Re: FRM- 41213: Unable to connect to the report server error [message #152229 is a reply to message #149117] Wed, 21 December 2005 15:32 Go to previous messageGo to next message
ddshah
Messages: 16
Registered: December 2005
Junior Member
My code is working - source given in message #152217
Re: FRM- 41213: Unable to connect to the report server error [message #152720 is a reply to message #152229] Mon, 26 December 2005 19:24 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Would you put the full link into your reply please. '152217' isn't doing it for me.

David
icon7.gif  Re: FRM- 41213: Unable to connect to the report server error [message #153086 is a reply to message #149117] Wed, 28 December 2005 23:59 Go to previous messageGo to next message
ddshah
Messages: 16
Registered: December 2005
Junior Member
Hello David,


the link is as follows:
http://www.orafaq.com/forum/t/56738/80375/


I am pasting the source code itself.

declare
report_id Report_Object;
ReportServerJob VARCHAR2(100);
vc_rep_status VARCHAR2(100);
vjob_id VARCHAR2(100);
repsvr varchar2(21) := 'rep_MYSERV';

BEGIN

report_id:= find_report_object('REPORT1');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,file);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESNAME,'rpout1.html');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,'HTMLCSS');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,repsvr);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER, 'paramform=no');

ReportServerJob:=run_report_object(report_id);
vjob_id := substr(reportserverjob,length(repsvr)+2);
vc_rep_status := REPORT_OBJECT_STATUS(ReportServerJob);

WHILE vc_rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED', null)
LOOP
vc_rep_status:=REPORT_OBJECT_STATUS(ReportServerJob);
END LOOP;

IF vc_rep_status='FINISHED' THEN
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'|| vjob_id ||'?server='||repsvr,'_blank');
ELSE
message ('Report failed with error message '|| vc_rep_status);
END IF;
END;

FRM-41213 ERROR STOPPED AFTER I USED THE ABOVE CODE.

Hope you'll find this OK.


[Updated on: Thu, 29 December 2005 00:31]

Report message to a moderator

Re: FRM- 41213: Unable to connect to the report server error [message #153492 is a reply to message #153086] Mon, 02 January 2006 22:08 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at http://www.orafaq.com/forum/t/52330/67693/. Does it help?

Also look at http://www.orafaq.com/forum/m/145719/67467/?srch=%2Freports%2Frwservlet%3F#msg_145719

David
Re: FRM- 41213: Unable to connect to the report server error [message #318145 is a reply to message #150051] Mon, 05 May 2008 22:07 Go to previous messageGo to next message
datbom
Messages: 1
Registered: May 2008
Junior Member

I meet the same error and i have tried all solution you discus but it has been not running and still found that error. Please, help me Sad
Re: FRM- 41213: Unable to connect to the report server error [message #318438 is a reply to message #318145] Tue, 06 May 2008 19:24 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What is the error that you are receiving? Is this a new installation? What version of Forms are you running?

David
Re: FRM- 41213: Unable to connect to the report server error [message #411564 is a reply to message #149117] Sun, 05 July 2009 07:22 Go to previous message
Sarah Aman
Messages: 80
Registered: July 2009
Member

use 10G v-9.0 u will not get the error



Sarah
Previous Topic: Change colour
Next Topic: move cursor (next item) to a text item lower in sequence (merged 3)
Goto Forum:
  


Current Time: Sat Dec 03 04:06:29 CST 2016

Total time taken to generate the page: 0.24389 seconds