| Forms 9i: Trying to run report: FRM-41214 [message #138901] |
Sun, 25 September 2005 06:47  |
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
|
Member |
|
|
I'm trying to run a report within Forms 9i
(using Guide to Oracle 9i (Thomson Course Technology) , p656-666)
I continue to get the error: FRM-41214 Unable to run report
There is no more information, and the RUN_REPORT_OBJECT is returning localrepserver_0
How on earth am I supposed to debug this with no information? Is there any other oracle error more obscure than this?
Can anyone help?
thx
adam
|
|
|
|
|
|
|
|
|
|
| Re: Forms 9i: Trying to run report: FRM-41214 [message #138957 is a reply to message #138948] |
Mon, 26 September 2005 00:16  |
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
|
Member |
|
|
My developer is working just fine thank you for the last 6 months. It's only running the report from the form that has a problem. I can say for sure that the report is not generating at all. Perhaps you should ask some questions before assuming someone is an idiot!
|
|
|
|
|
|
|
|
| Re: Forms 9i: Trying to run report: FRM-41214 [message #139213 is a reply to message #139045] |
Mon, 26 September 2005 18:46 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
The following is my standard response to people who have just started with the 9i DS:
Please search your oracle directory for 'test', there should be a test.fmb file and a test.rdf file. To run the 'test' example, go 'Start', 'Programs', 'Oracle Forms 9i', there should be a 'Run a Form on the Web' - do you have it? If no, do you have 6i installed on your PC? Yes or no - I'll give reasons later, maybe.
For reports, go 'Start', 'Programs', 'Oracle Reports 9i', there should be a 'Run a Report on the Web', select it, if you don't have a userid 'scott/tiger' defined in your default database then change the 'Userid' to your userid and password.
For those that have been working with forms for a while: Me thinks that you may not have placed your report development directory in the REPORTS_PATH of the register. Make sure that you DO NOT delete any of the existing entries in the register entry. Also make sure that you have no spaces in the directory name, and that there is at least one file (aaa.txt is good enough) in each directory that exists in the register entry. (Some users have placed two or three directories in their list, in anticipation of working on other projects, but because one of these directories had not been created or was empty the form or report would not run.)
David
|
|
|
|
|
|
| Re: Forms 9i: Trying to run report: FRM-41214 [message #139428 is a reply to message #139293] |
Wed, 28 September 2005 00:15 |
|
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Basic stuff, please excuse 'Notes' English - you have installed Oracle Forms and Reports - they are in directories in your <oracle_home> directory, you DO NOT want to do your work in these directories because when you upgrade your Forms and Reports you MAY lose your work. You create a work directory 'C:\work', you need to let Oracle about it. Use regedit (rgedit32, whatever), find the FORMS90_PATH (search this forum for other threads that talk about it), and 'c:\work' to the BEGINNING of this list of directory names, do the same for REPORTS_PATH (search this forum again), if you have custom graphic images which we roughly call icons, you need to have them as '.ico' files for them to appear in your Forms Builder and as '.gif' files to appear in your 9iDS. This icon directory is placed in the new UI_ICON entry. There is another entry for 10g but I can't remember it at the moment.
Now to get them to appear in your 9iDS your need to edit the <oracle_home>\forms90\java\oracle\forms\registry\Registry.dat and change 'default.icons.iconpath=' to 'default.icons.iconpath=icons/' (please note location of SLASH, 'icons' can be 'xxx' if you wish). Now edit <oracle_home>\j2ee\Oracle9iDS\application-deployments\forms\forms90web\orion-web.xml, duplicate one of the 'virtual-directory virtual-path' lines and make it read as below:| Quote: |
<virtual-directory virtual-path="/icons" real-path="<myicondirectory>\gif" />
|
again note the position of the SLASH and I have two subdirectories for my icons - \gif for the '.gif' files and \ico for the '.ico' files.
When you get around to running your application through 9iAS you will have to add similar lines to the AS configuration files.
If these constructs do NOT appear in your textbook, then I suggest you download the 9i Forms installation guide from OTN.
David
[Updated on: Thu, 29 September 2005 01:53] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Forms 9i: Trying to run report: FRM-41214 [message #139665 is a reply to message #138901] |
Thu, 29 September 2005 02:06 |
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
|
Member |
|
|
ok, now the report is actually generating, but the web.show_document command isn't doing anything. the htm file is appearing, and the .gif file for its picture, but its not showing. I changed the FORMS90_PATH, and the REPORTS_PATH, but there was no REPORTS90_PATH there.... any ideas?
thx
adam
|
|
|
|
| Re: Forms 9i: Trying to run report: FRM-41214 [message #139666 is a reply to message #138901] |
Thu, 29 September 2005 02:08 |
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
|
Member |
|
|
here is my code for the button trigger:
DECLARE
rep_result VARCHAR2(30);
BEGIN
SET_REPORT_OBJECT_PROPERTY('INVENTORY_REPORT', REPORT_FILENAME, :GLOBAL.project_path || 'Inventory.rdf');
SET_REPORT_OBJECT_PROPERTY('INVENTORY_REPORT', REPORT_DESNAME, :GLOBAL.project_path || 'Inventory.htm');
rep_result := RUN_REPORT_OBJECT('INVENTORY_REPORT');
MESSAGE('Rep result: ' || rep_result);
WEB.SHOW_DOCUMENT('file:///' || :GLOBAL.project_path || 'Inventory.htm', '_blank');
END;
cheers
adam
|
|
|
|
|
|
| Re: Forms 9i: Trying to run report: FRM-41214 [message #139671 is a reply to message #139666] |
Thu, 29 September 2005 02:15 |
|
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I have to go. Search this forum for 'WEB.SHOW_DOCUMENT' also do the same on the Oracle Website, or OTN or google. There will be a full example there.
@others - Can someone else please put up a nicely working, WEB.SHOW_DOCUMENT example, with parameters.
David
[Updated on: Thu, 29 September 2005 02:17] Report message to a moderator |
|
|
|
| Re: Forms 9i: Trying to run report: FRM-41214 [message #139672 is a reply to message #139670] |
Thu, 29 September 2005 02:16 |
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
|
Member |
|
|
yeah i saw that post when doing my last reply - it's ok that part of things i think is sorted now. One step away from success: just need to find out why WEB.SHOW_DOCUMENT doesn't do anything - it used to give me an error when the report wasn't generating cos there was no file for it - now i get nothing at all from it. I'm pretty sure i'm not filtering error messages out. I posted code for my button a short time ago. Any help appreciated
adam
|
|
|
|
|
|
| Re: Forms 9i: Trying to run report: FRM-41214 [message #139741 is a reply to message #138901] |
Thu, 29 September 2005 07:15 |
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
|
Member |
|
|
Hi David, if you return sometime soon...
I have now got the report generating, thanks to fixing the registry.
The problem now is that WEB.SHOW_DOCUMENT is not doing anything at all. I even tried making a new button and tried to display a quick 4 line htm file i made myself, and it can't even do that. No display, no error, no nothing. If I give an incorrect file or pathname it will show an error, but does nothing when the info is correct.
Thx for your help fixing the registry, hopefully you or someone else can help me get show_document working.
thx
adam
|
|
|
|
|
|
| Re: Forms 9i: Trying to run report: FRM-41214 [message #139960 is a reply to message #139924] |
Fri, 30 September 2005 04:07 |
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
|
Member |
|
|
i've managed to get the report to display using the http:// method instead of the file:/// method. My file:/// code works on my friends comp (very similar setup to mine except he has SP1 and I have SP2), so I think maybe SP2 is the culprit. There was nothing wrong with my code in the first place. I'll stick to the http:// method since we have SP2 at college as well.
cheers
adam
|
|
|
|
|
|
|
|
|
|
| Re: Forms 9i: Trying to run report: FRM-41214 [message #307130 is a reply to message #138901] |
Mon, 17 March 2008 22:41 |
ashish.hussain
Messages: 8
Registered: July 2007
|
Junior Member |
|
|
Hi,
We had an application that was on 9i Forms/ Windows and which we recently migrated to 10g Forms/Linux. There are a number of reports being called in the appl, but only some are throwing "FRM-41214 - Unable to run report" error.
run_report_object is being used to call the reports and its the same for all the reports, as they are all being called from the same form.
I would appreciate very much if you could throw some light on what the issue might be.
David,
As you suggested to use web.show_document instead of run_report_object, we would not be able to do that.
The reports are being called with a parameter list like v_rep := run_report_object(repid, paramlist1);
then checking on the status for successful completion of the above command, web.show_document is used to display the report.
But, the "FRM-41214 - Unable to run report" error is prompted instead.
Would anyone know what the problem might be ?
Many thanks.
Ashish.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Forms 9i: Trying to run report: FRM-41214 [message #331632 is a reply to message #324347] |
Fri, 04 July 2008 04:45 |
rcyan
Messages: 1
Registered: July 2008
|
Junior Member |
|
|
Hi,
I am also getting the same error, on Forms 10g. What difference does it make if I also have 6i installed on my PC and if these are migrated forms and reports. We are in the process of migrating forms 6 to 10g.
Appreciate any help.
Thanks,
rcyan
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Forms 9i: Trying to run report: FRM-41214 [message #406762 is a reply to message #342374] |
Fri, 05 June 2009 12:01 |
nastyjillu
Messages: 211
Registered: February 2009
|
Senior Member |
|
|
Hi,
i have an issue. my report runs fine in report builder. but when i try to run it from form, it say
REPORT TERMINATED WITH ERROR.
this happens when i make some changes in the report query. if i dont make changes and run the report from from, then it works fine.
why is this?? how doest it works in report builder and not in form builder??
and the query is coorect.it works in toad.
|
|
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
