Home » Developer & Programmer » Forms » FRM-41214 error
FRM-41214 error [message #318143] Mon, 05 May 2008 21:22 Go to next message
lakshmisaran
Messages: 26
Registered: May 2008
Junior Member
Hi,

In my form i call 6 reports. all 5 r working fine and while running the 6th, FRM-41214 error msg is thrown.

ADD_PARAMETER(PARA_ID,'P_MSG',TEXT_PARAMETER,:msg);
add_parameter(para_id,'p_exn',text_parameter,'TEST1');
add_parameter(para_id,'p_ex1',text_parameter,'TEST1');
add_parameter(para_id,'p_ex2',text_parameter,'TEST1');
add_parameter(para_id,'p_ex3',text_parameter,'TEST1');

set_report_object_property(v_report_id, report_comm_mode, SYNCHRONOUS);
set_report_object_property(v_report_id, REPORT_EXECUTION_MODE, RUNTIME);
set_report_object_property(v_report_id,REPORT_DESTYPE, CACHE);

set_report_object_property(v_report_id, report_server, 'rep_server');

set_report_object_property(v_report_id,report_other,'paramform=NO');

set_report_object_property(v_report_id, report_filename,'g:\invoice.rdf');

v_reportserverjob:=run_report_object(v_report_id, para_id);
v_job_id := substr(v_reportserverjob,length('rep_server')+2,length(v_reportserverjob));

v_rep_status:=report_object_status(v_reportserverjob);

Web.show_document('http://local_machine:8889/reports/rwservlet/getjobid'||v_job_id||'?server=rep_server','_blank');

the code for all others is similar except the parameters and report name.

Anyone could guess on this scenario.

Rgds,
Lakshmi


Re: FRM-41214 error [message #318144 is a reply to message #318143] Mon, 05 May 2008 21:55 Go to previous messageGo to next message
lakshmisaran
Messages: 26
Registered: May 2008
Junior Member
Additionally, when i run directly the report is running successfully

Web.show_document(' http://local_machine.olamnet.com:8889/reports/rwservlet?userid=it/it@xxx&server=rep_server&report=g:\invoice.rdf&paramfor m=no&destype=CACHE&desformat=PDF','_blank');
Re: FRM-41214 error [message #318183 is a reply to message #318144] Tue, 06 May 2008 01:06 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not sure it will help, but nevertheless:
Oracle
FRM-41214: Unable to run report.

Cause: The report server was unable to run the specified report.

Action: Check the Report server and make sure it is up and running.
Re: FRM-41214 error [message #318197 is a reply to message #318183] Tue, 06 May 2008 01:41 Go to previous messageGo to next message
lakshmisaran
Messages: 26
Registered: May 2008
Junior Member
the error is very strange because, when i click other reports on the same form(with similar code as i said)it run but except this fellow.
Re: FRM-41214 error [message #318441 is a reply to message #318143] Tue, 06 May 2008 19:38 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please search this forum for 'run_report_object Web.show_document david'. Look at the older threads and you will find examples like http://www.orafaq.com/forum/m/201560/67467/?srch=run_report_object+Web.show_document+david#msg_201560

David

Upd: Typo

[Updated on: Wed, 07 May 2008 01:11]

Report message to a moderator

asdf [message #318453 is a reply to message #318143] Tue, 06 May 2008 21:42 Go to previous messageGo to next message
lakshmisaran
Messages: 26
Registered: May 2008
Junior Member
hi DJ,

thx for the reply.

I'm doing upgradation work from 6i to 10g. my 5th report is working and found out the problem.

when all other 4 reports are generating why not this guy, so i guessed that problem shud be in report(did by some other guy). they have used a image item where the file path is locating someother drive which is ok for 6i but not ok for 10g.

now got some problem with the last report, tracing the bug... if i couldnt pls help me... will post u the code.

Thx
Lakshmi
Re: asdf [message #318508 is a reply to message #318453] Wed, 07 May 2008 01:16 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
lakshmi,

Please be careful as against which thread your post your replies. You had posted the entry above against a 2006 thread.

David
Re: FRM-41214 error [message #318534 is a reply to message #318143] Wed, 07 May 2008 02:15 Go to previous message
lakshmisaran
Messages: 26
Registered: May 2008
Junior Member
Oh ok.. I'm sorry abt that. I was looking the link u've sent, and replied.

Rgds,
Lakshmi
Previous Topic: Highlighting only some part of text in textbox or placing the cursor at some position in textbox
Next Topic: Web.show_document Visual C++ error
Goto Forum:
  


Current Time: Fri Sep 27 12:20:29 CDT 2024