Home » Developer & Programmer » Forms » report problem (application server 10.1.2.0.2, windows 2003 server R2)
report problem [message #389542] Mon, 02 March 2009 10:40 Go to next message
nasir_mughal
Messages: 121
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.

Re: report problem [message #389905 is a reply to message #389542] Wed, 04 March 2009 00:53 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Get rid of the loop and the 'rep_status' test. Just use the 'web.show_document' command.

David
Re: report problem [message #390009 is a reply to message #389905] Wed, 04 March 2009 09:54 Go to previous messageGo to next message
nasir_mughal
Messages: 121
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'hide url'.

David
Re: report problem [message #390697 is a reply to message #390102] Mon, 09 March 2009 05:36 Go to previous messageGo to next message
nasir_mughal
Messages: 121
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.
Re: report problem [message #394190 is a reply to message #390697] Thu, 26 March 2009 00:39 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: report problem [message #394219 is a reply to message #394190] Thu, 26 March 2009 03:48 Go to previous messageGo to next message
nasir_mughal
Messages: 121
Registered: April 2007
Location: Karachi
Senior Member
Not yet. Please guide me.

Thanks.
Re: report problem [message #394274 is a reply to message #390102] Thu, 26 March 2009 06:30 Go to previous message
linlasj
Messages: 98
Registered: August 2005
Location: Linköping
Member
Please note that the hide URL method - using the Java thingy that exists on the internet to hide - does not work in Version 11 of Forms.

[Updated on: Thu, 26 March 2009 06:31]

Report message to a moderator

Previous Topic: Wrong number or type of arugment call in funciton
Next Topic: to call report in form 10g
Goto Forum:
  


Current Time: Sat Dec 10 07:21:30 CST 2016

Total time taken to generate the page: 0.11880 seconds