Home » Developer & Programmer » Reports & Discoverer » report server not running
report server not running [message #165972] Mon, 03 April 2006 16:05 Go to next message
RAY_HT
Messages: 153
Registered: May 2005
Location: Giza
Senior Member

hi all

plz someone help me

i'm using forms and report 10g

i have create form to open report test_rep.rdf in paper layout
i'm using run_report_object built_in

i found file rep_"pcname".conf as server name configuration file

but when i'm using rep_"pcname" as server name in run_report_object built_in

error raised : cannot connect to server rep_"pcname"

also when i trying to insall report server by execute rwserver.exe using command " rwserver -intall <server_name> message " please consult the installation guide"

plz help me it's very urgent

i don't want to use web.show_document
Re: report server not running [message #166012 is a reply to message #165972] Tue, 04 April 2006 01:02 Go to previous messageGo to next message
ahmad_uaf
Messages: 68
Registered: March 2006
Location: Pakistan
Member

Hello,
plz. check the attached Pdf file.
This will help u.
Regards,
Ahmad
Re: report server not running [message #166092 is a reply to message #165972] Tue, 04 April 2006 08:41 Go to previous messageGo to next message
RAY_HT
Messages: 153
Registered: May 2005
Location: Giza
Senior Member

i have this PDF file but
when i do what wrote it dosen't work because of " cannot connect to server name"
Re: report server not running [message #166138 is a reply to message #165972] Tue, 04 April 2006 14:51 Go to previous messageGo to next message
RAY_HT
Messages: 153
Registered: May 2005
Location: Giza
Senior Member

plz some try to open report from form using run_report_object and tell me why it doesn't work

why "cannot connect to server name" error raising
Re: report server not running [message #166167 is a reply to message #166138] Tue, 04 April 2006 23:32 Go to previous messageGo to next message
ahmad_uaf
Messages: 68
Registered: March 2006
Location: Pakistan
Member

hello,
I do this with the following way in the start.....
First Run the Form from where u run the report, if it give the message can't connect to the report server then open the URL

http://Ahmad.amtextile.com:8889/reports/rwservlet
http://Ahmad.amtextile.com:8889/reports/rwservlet/showjobs

Where Ahmad is My computer Name
Amtextile.com is my Domain and 8889 is port#.

This can Intilize the report server if you run the report and make your system as a report server.
Dont' know the exact Logic behid this Dramma.
but My report is Running now when i did this.
If u still any problem then plz. reply me..
Regards,
Ahmad
Re: report server not running [message #166483 is a reply to message #165972] Thu, 06 April 2006 10:05 Go to previous messageGo to next message
RAY_HT
Messages: 153
Registered: May 2005
Location: Giza
Senior Member

i have create from to open report using run_report_object

i attached the form and report .

plz some one tell me what's wrong
Re: report server not running [message #166573 is a reply to message #166483] Fri, 07 April 2006 00:56 Go to previous messageGo to next message
ahmad_uaf
Messages: 68
Registered: March 2006
Location: Pakistan
Member

I check ur Forms & report...
Here is something missing
If you are not connecting to the report server then must run this URL

http://Ahmad.amtextile.com:8889/reports/rwservlet
http://Ahmad.amtextile.com:8889/reports/rwservlet/showjobs


This URL Intialize the report server as run_report_object can't start automatically when you restart the system. but this policy is implemented on server which never shut down.

2ndly you must append some code at the last of your when button pressed...
ur Exact Code will work like this :
-----------------------------

declare
report_id Report_Object;
P_LIST_ID PARAMLIST;
ReportServerJob VARCHAR2(100);
REPORT_STATUS VARCHAR2(100);
-- REPORTSERVERJOB VARCHAR2(100);
JOB_ID VARCHAR2(100);
BEGIN
P_LIST_ID := GET_Parameter_List('PLIST');
report_id:= find_report_object('emp');
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_SERVER,'rep_pchtalaat');

(No need of it coz report has no parameter.Oterwise in report u must define a userparameter name as p_deptno which is then refer from this parameter below)

--SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'p_deptno='||:emp.Deptno||'paramform=no');

ReportServerJob:=run_report_object(report_id);

(if report has parameter then run this statement with parameter llist)
--REPORTSERVERJOB := RUN_REPORT_OBJECT(REPORT_ID,P_LIST_ID);

JOB_ID := SUBSTR(REPORTSERVERJOB,LENGTH('rep_pchtalaat')+2,LENGTH(REPORTSERVERJOB));
REPORT_STATUS := REPORT_OBJECT_STATUS(REPORTSERVERJOB);







IF REPORT_STATUS = 'FINISHED' THEN
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid' || JOB_ID || '?server=' || 'rep_pchtalaat', '_blank');
END IF;



END;
I m sending you this piece of code after checking and this is working.

Regards,
Ahmad
  • Attachment: emp.fmb
    (Size: 48.00KB, Downloaded 428 times)

[Updated on: Fri, 07 April 2006 00:57]

Report message to a moderator

Re: report server not running [message #166821 is a reply to message #165972] Sun, 09 April 2006 11:31 Go to previous messageGo to next message
RAY_HT
Messages: 153
Registered: May 2005
Location: Giza
Senior Member

error " unable to run report" raised

when i'm trying to use URL you have wrote no page displayed
i replaced the name of the server you wrote with my server name "rep_pchtalaat" but nothing displayed and the same error " unable to run report FRM- 41214"
Re: report server not running [message #223803 is a reply to message #165972] Sun, 11 March 2007 13:12 Go to previous message
RAY_HT
Messages: 153
Registered: May 2005
Location: Giza
Senior Member

the problem solved
the attached doc is for "how to use run_report_object"
about server name

i write a query to get "terminal name " for the current session
and create report name " rep_treminal name_oracle home name"

you can also create a new report server as following

1- rename the file rep_hostname.conf to the name you want .
2- execute RWSERVER server ="newname"

the new servername.dat file will created .
Previous Topic: pls help
Next Topic: arabic PDF Report Problem
Goto Forum:
  


Current Time: Sat Dec 10 09:19:55 CST 2016

Total time taken to generate the page: 0.04349 seconds