OraFAQ Forum: Forms » report problem

Home » Developer & Programmer » Forms » report problem (application server 10.1.2.0.2, windows 2003 server R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

report problem [message #389542]

Mon, 02 March 2009 10:40

nasir_mughal
Messages: 122
Registered: April 2007
Location: Karachi

Senior Member

Hi,

Recently i have change my operating system from Windows XP,SP2 to Window 2003 Server R2. on XP all my reports were running.
Now on Window 2003, Some reports like this when i run them i encounter this error.

FRM-41217 unable to get report job status.

Where as on looking at report server jobs it show report has been finished successfully.

After this error when i try to run report again following error encounters.

FRM-41213 unable to connect to report server repser.

this is the code i am using to call report

Declare
repid      REPORT_OBJECT;
v_rep      VARCHAR2(1000);
rep_status VARCHAR2(20);

P_COND VARCHAR2(1200);
PARAM_ID PARAMLIST;
PARAM_NAME VARCHAR2(15):='acc_due_list2';
	
BEGIN
	
	
P_COND:=' AND A.YEAR=2008'
param_id:=GET_PARAMETER_LIST(param_name);
IF NOT ID_NULL(param_id) THEN
	DESTROY_PARAMETER_LIST(param_id);
END IF;
param_id:=CREATE_PARAMETER_LIST(param_name);

ADD_PARAMETER(param_id,'branch',TEXT_PARAMETER,:PARAMETER.branch_id);
ADD_PARAMETER(param_id,'cond',TEXT_PARAMETER,p_cond);
ADD_PARAMETER(param_id,'PARAMFORM',TEXT_PARAMETER,'NO');

repid:= FIND_REPORT_OBJECT('REPORT2');

SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,ASYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,:PARAMETER.reps);
v_rep := RUN_REPORT_OBJECT(repid,param_id);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status := report_object_status(v_rep);
END LOOP;
 
IF rep_status = 'FINISHED' THEN 

WEB.show_document('/reports/rwservlet/getjobid'|| 
substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=repser','_blank'); 
ELSE 
message('Error when running report'||rep_status); 
END IF; 

END;

Report file attached with form is
acc_due_list.rep

I have set following variables.

In Registry
FORMS_PATH=c:\GemGL
REPORTS_PATH=c:\GemGL

In Default.env file
FORMS_PATH=c:\GemGL

In formsweb.cfg file
Workingdirectory=c:\GemGL

Kindly help me

Thanks in advance.

Report message to a moderator

Re: report problem [message #389905 is a reply to message #389542]

Wed, 04 March 2009 00:53

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Get rid of the loop and the 'rep_status' test. Just use the 'web.show_document' command.

David

Report message to a moderator

Re: report problem [message #390009 is a reply to message #389905]

Wed, 04 March 2009 09:54

nasir_mughal
Messages: 122
Registered: April 2007
Location: Karachi

Senior Member

problem is solved with

WEB.show_document('/reports/rwservlet?server='||:PARAMETER.reps
                                              ||'&report=acc_due_list2.rep'
                                              ||'&desformat=PDF'
                                              ||'&destype=CACHE'
                                              ||'&userid=abc/abc@rd9'
                                              ||'&branch='||:PARAMETER.branch_id
                                              ||'&cond='||p_cond
                                              ||'&paramform=no'
 		        ,'_blank');

but this has exposed connect string and other parameters in URIL, which i dont want. I have configured single sign on, so web.show_document should work like

WEB.show_document('/reports/rwservlet?server='||:PARAMETER.reps
                                              ||'&report=acc_due_list2.rep'
                                              ||'&desformat=PDF'
                                              ||'&destype=CACHE'
                                              ||'&branch='||:PARAMETER.branch_id
                                              ||'&cond='||p_cond
 				              ||'&paramform=no'
 			    ,'_blank');

but when i run report,after being asked to enter single sign in user it gives error "not loged on"

Kindly help me.

[Updated on: Wed, 04 March 2009 10:10]

Report message to a moderator

Re: report problem [message #390102 is a reply to message #390009]

Wed, 04 March 2009 23:37

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Search this forum for 'hide url'.

David

Report message to a moderator

Re: report problem [message #390697 is a reply to message #390102]

Mon, 09 March 2009 05:36

nasir_mughal
Messages: 122
Registered: April 2007
Location: Karachi

Senior Member

Thanks djmartin

I defined this key in my cgicmd.dat file to hide login information from URL.

key1: userid=abc/abc@rd9 report=%* destype=cache desformat=pdf

My question is

1) How can i define a universal key for all users in my database.?
2) Similarly how can i define a universal key for OTHER_PARAMS of all reports.

Thanks in advance.

Report message to a moderator