| REP-41213 unable to connect to report server [message #152182] |
Wed, 21 December 2005 09:41  |
ddshah
Messages: 16
Registered: December 2005
|
Junior Member |
|
|
Hello,
reports10g problem!
code seems to be alright - (seperately web.show document is working and generating report)
but here in the code - report_run_object statement is raising the above error and not generating the report
report_id Report_Object;
ReportServerJob VARCHAR2(100);
vc_rep_status VARCHAR2(100);
vjob_id VARCHAR2(100);
repsvr varchar2(50) := 'myrep_serv123';
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,cache);
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 rp_sb_id='||:sb_id);
ReportServerJob:=run_report_object(report_id);
vjob_id := substr(reportserverjob,length(repsvr)+2);
vc_rep_status := REPORT_OBJECT_STATUS(ReportServerJob);
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;
For any Help Thanks a lot.
|
|
|
|
| Re: REP-41213 unable to connect to report server [message #152184 is a reply to message #152182] |
Wed, 21 December 2005 10:04  |
benoitchabot
Messages: 15
Registered: October 2005
Location: Quebec , Canada
|
Junior Member |
|
|
You forgot the while loop
Try with this code .....
report_id Report_Object;
ReportServerJob VARCHAR2(100);
vc_rep_status VARCHAR2(100);
vjob_id VARCHAR2(100);
repsvr varchar2(50) := 'myrep_serv123';
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,cache);
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 rp_sb_id='||:sb_id);
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;
Benoit Chabot
|
|
|
|
|
|
| Re: REP-41213 unable to connect to report server [message #152209 is a reply to message #152184] |
Wed, 21 December 2005 12:32 |
benoitchabot
Messages: 15
Registered: October 2005
Location: Quebec , Canada
|
Junior Member |
|
|
After this code:
ReportServerJob:=run_report_object(report_id);
vjob_id := substr(reportserverjob,length(repsvr)+2);
vc_rep_status := REPORT_OBJECT_STATUS(ReportServerJob);
could you try to see what is the value of the variable vc_rep_status
It should be in ('RUNNING','OPENING_REPORT','ENQUEUED', null)
If it's not, it may be the problem.
|
|
|
|
| Re: REP-41213 unable to connect to report server [message #152212 is a reply to message #152209] |
Wed, 21 December 2005 12:57 |
ddshah
Messages: 16
Registered: December 2005
|
Junior Member |
|
|
I tried again
message('ans='|| vc_rep_status || '?') ;
but it throws answer as 'ans=?' i.e. vc_rep_status is null
FRM-41213 error is appearing only when run_report_object line is getting executed
(note: I have titled REP-41213 it's FRM-41213)
no result so far
Thanks
|
|
|
|
 Re: REP-41213 unable to connect to report server [message #152217 is a reply to message #152212] |
Wed, 21 December 2005 13:15 |
ddshah
Messages: 16
Registered: December 2005
|
Junior Member |
|
|
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;
******* YES YOU WERE RIGHT - IT'S WORKING NOW WITH ABOVE CODE - THANKS A LOT
[Updated on: Thu, 22 December 2005 01:37] Report message to a moderator |
|
|
|
| Re: REP-41213 unable to connect to report server [message #154425 is a reply to message #152182] |
Sun, 08 January 2006 05:24 |
gfbaig
Messages: 11
Registered: January 2006
Location: Islamabad
|
Junior Member |
|
|
Hi everybody
I am feeling problem in calling a report from forms 9i. Forms and reports are running ok separately. When do i call a report from form , it gives me a message as FRM-41213 Unable to conect to to report sever, while report server is running
I am using windows XP can any body have a solution please, I will be thankfull to you
Regards
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
