Home » Developer & Programmer » Forms » Forms 9i: Trying to run report: FRM-41214  () 1 Vote
Forms 9i: Trying to run report: FRM-41214 [message #138901] Sun, 25 September 2005 06:47 Go to next message
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 #138903 is a reply to message #138901] Sun, 25 September 2005 07:36 Go to previous messageGo to next message
kiran
Messages: 503
Registered: July 2000
Senior Member
Have a look at this otn thread.

--Kiran.
Re: Forms 9i: Trying to run report: FRM-41214 [message #138908 is a reply to message #138903] Sun, 25 September 2005 08:49 Go to previous messageGo to next message
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
Member

I already read that one before posting. our problems are different - the other person's report was actually generating and mine isn't. There wasn't much in that post that I found useful

cheers
adam
Re: Forms 9i: Trying to run report: FRM-41214 [message #138948 is a reply to message #138901] Sun, 25 September 2005 23:30 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Is your OC4J running? Can you run the standard 'test' form and 'test' report?

Pleae search this forum for 'oc4j' and 'test', read them, and then get back to us with your further problems. Basically I expect that you have not configured your 9iDS (developer server) correctly.

David
Re: Forms 9i: Trying to run report: FRM-41214 [message #138957 is a reply to message #138948] Mon, 26 September 2005 00:16 Go to previous messageGo to next message
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 #138959 is a reply to message #138957] Mon, 26 September 2005 00:27 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I did ask questions, which you have not answered, and I did not assume that you are an idiot, if you had looked at other threads these are my standard opening questions.

Unfortunately, you ARE giving me the impression that you are a belligerent ingrate. Answer the questions, be civil, or I will not offer you any assistance.

David
Re: Forms 9i: Trying to run report: FRM-41214 [message #139045 is a reply to message #138901] Mon, 26 September 2005 06:53 Go to previous messageGo to next message
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
Member

To answer your questions: OC4J is running fine. I don't know what these "test" forms are your talking about, but I've made countless forms over the last months without any problem, so I can assume my forms builder is operating correctly. Is there settings that have to be set up correctly to make the report run in the form? I have set up the report service and it must be detecting ok, cos when I change the report service to a different name on the property palette it gives me a different error. Sorry if I was abrupt before, I thought you were implying I didn't know what 0C4J was, that would be a little rough Sad

adam
Re: Forms 9i: Trying to run report: FRM-41214 [message #139213 is a reply to message #139045] Mon, 26 September 2005 18:46 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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 #139293 is a reply to message #139213] Tue, 27 September 2005 04:54 Go to previous messageGo to next message
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
Member

I am using 9i. I am curious about your mention of the registry, as my textbook doesn't mention anything about that... Can you explain exactly what I must do with the registry?

thx
adam
Re: Forms 9i: Trying to run report: FRM-41214 [message #139428 is a reply to message #139293] Wed, 28 September 2005 00:15 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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 #139657 is a reply to message #138901] Thu, 29 September 2005 01:50 Go to previous messageGo to next message
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
Member

Ok, I went into the registry and found FORMS90_PATH, and added C:\Temp\Dev; onto the front of it. But there is nothing for REPORTS90_PATH - anywhere Sad
Looks like I'm going to have to make it myself, can anyone help me here? I know how to make an entry in itself, but I don't know where to put it, or what default entries i may have to insert after my temp dir entry.

thx
adam
Re: Forms 9i: Trying to run report: FRM-41214 [message #139661 is a reply to message #138901] Thu, 29 September 2005 01:55 Go to previous messageGo to next message
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
Member

sokay i found it, no '90' in the key name
trying to see if my report will run now, wish me luck Cool

cheers
adam
Re: Forms 9i: Trying to run report: FRM-41214 [message #139662 is a reply to message #139657] Thu, 29 September 2005 01:57 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Sorry ... I had a typo ... its FORMS90_PATH AND REPORTS_PATH ... I don't know why one has '90' in it and the other does not.

If you have no REPORTS_PATH then I have the feeling that you may not have installed reports into your system. Go to 'start', 'programs', then Oracle and where you have 'Form Builder' there somewhere, do you have 'Report Builder'? If you don't have Report Builder then you probably don't have the reports server either.

Get back to me quickly please.

David
Re: Forms 9i: Trying to run report: FRM-41214 [message #139665 is a reply to message #138901] Thu, 29 September 2005 02:06 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #139670 is a reply to message #139665] Thu, 29 September 2005 02:10 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
As I said the REPORTS90_PATH was a typo ... sorry.

David
Re: Forms 9i: Trying to run report: FRM-41214 [message #139671 is a reply to message #139666] Thu, 29 September 2005 02:15 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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 Go to previous messageGo to next message
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 #139673 is a reply to message #139671] Thu, 29 September 2005 02:19 Go to previous messageGo to next message
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
Member

thanks for your help david Razz

adam
Re: Forms 9i: Trying to run report: FRM-41214 [message #139741 is a reply to message #138901] Thu, 29 September 2005 07:15 Go to previous messageGo to next message
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 #139924 is a reply to message #139741] Fri, 30 September 2005 02:02 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please have a look at http://www.oracle.com/technology/products/forms/pdf/10g/frmwebshowdoc_rep.pdf and http://www.nyoug.org/goin_live.pdf.

David

[Updated on: Fri, 30 September 2005 02:10]

Report message to a moderator

Re: Forms 9i: Trying to run report: FRM-41214 [message #139960 is a reply to message #139924] Fri, 30 September 2005 04:07 Go to previous messageGo to next message
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 #140345 is a reply to message #139960] Mon, 03 October 2005 19:09 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 'SP2' and follow the instructions for changing the 'permissions' that were introduced with XP SP2. I should have asked earlier. I will build a better 9i Forms and Reports FAQ and get it into this forum.

David
Re: Forms 9i: Trying to run report: FRM-41214 [message #140422 is a reply to message #138901] Tue, 04 October 2005 03:18 Go to previous messageGo to next message
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
Member

I searched for SP2 but didn't get any hits Sad
To make matters worse, the technique I used at home doesn't work at college (they have SP2 as well). When clicking the button at college, a new browser window opens but it just chugs forever and can't display the report.
I'll have to check and see if maybe their configuration is different or something, but if it's not I haven't a clue what to do.. Sad

cheers
adam
Re: Forms 9i: Trying to run report: FRM-41214 [message #140583 is a reply to message #140422] Tue, 04 October 2005 18:09 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Sorry ... the search at the top of the page doesn't handle numbers, go to http://www.orafaq.com/about/search, and do a search for SP2 in it. Unfortunately, it is not forum specific. There appears to be a Pentium 4 / Java / Oracle 9 problem. Many of these threads are discussing installation problem, but others discuss permission problems.
I think that you have the latter.
David
Re: Forms 9i: Trying to run report: FRM-41214 [message #307130 is a reply to message #138901] Mon, 17 March 2008 22:41 Go to previous messageGo to next message
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 #307469 is a reply to message #307130] Tue, 18 March 2008 23:48 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I still recommend that you search this forum for 'web.show_document' and seriously consider changing your report call to use this command.

David
Re: Forms 9i: Trying to run report: FRM-41214 [message #312064 is a reply to message #307469] Mon, 07 April 2008 21:36 Go to previous messageGo to next message
ashish.hussain
Messages: 8
Registered: July 2007
Junior Member
Thanks David.

I have resolved the error,by some tweaking with the reports query.

Ashish.
Re: Forms 9i: Trying to run report: FRM-41214 [message #322525 is a reply to message #139213] Sat, 24 May 2008 01:55 Go to previous messageGo to next message
zeeshanamj
Messages: 5
Registered: May 2008
Location: Oman
Junior Member

Hi,

I am a new programmer and facing the same problem. As you said (for the test purpose) that "For reports, go 'Start', 'Programs', 'Oracle Reports 9i', there should be a 'Run a Report on the Web'"

I don't have 'Run a Report on the Web' option, so can you please guide me if I am having installation problem. Please make sure that I don;t have this shortcut but I can run other reports and this problem is coming only with few reports.

Zeeshan
Re: Forms 9i: Trying to run report: FRM-41214 [message #324347 is a reply to message #322525] Mon, 02 June 2008 01:55 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Zeeshan,

Which version of Forms are you running?

David
Re: Forms 9i: Trying to run report: FRM-41214 [message #331632 is a reply to message #324347] Fri, 04 July 2008 04:45 Go to previous messageGo to next message
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 #338736 is a reply to message #331632] Tue, 05 August 2008 19:59 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: Forms 9i: Trying to run report: FRM-41214 [message #340445 is a reply to message #338736] Tue, 12 August 2008 22:58 Go to previous messageGo to next message
zeeshanamj
Messages: 5
Registered: May 2008
Location: Oman
Junior Member

Hi,

No I have not solved the problem. I will be thankful, if u may kindly help me out.

Re: Forms 9i: Trying to run report: FRM-41214 [message #340449 is a reply to message #324347] Tue, 12 August 2008 23:55 Go to previous messageGo to next message
zeeshanamj
Messages: 5
Registered: May 2008
Location: Oman
Junior Member

Sorry for the late reply. I am using Oracle 9i Developer Suite Release 2.

Forms Version is 9.0.2.9.0

Reports version is 9.0.2.0.3

Zeeshan
Re: Forms 9i: Trying to run report: FRM-41214 [message #341429 is a reply to message #340449] Mon, 18 August 2008 19:40 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What messages are you receiving? Can you run a report from the Report Builder? Did you install Reports before or after Forms?

David
Re: Forms 9i: Trying to run report: FRM-41214 [message #342374 is a reply to message #331632] Fri, 22 August 2008 03:23 Go to previous messageGo to next message
linlasj
Messages: 98
Registered: August 2005
Location: Linköping
Member
Hi,
I also get this message, and there is a following message that should explain.

What message du you get?
Re: Forms 9i: Trying to run report: FRM-41214 [message #406762 is a reply to message #342374] Fri, 05 June 2009 12:01 Go to previous messageGo to next message
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.
Re: Forms 9i: Trying to run report: FRM-41214 [message #406767 is a reply to message #406762] Fri, 05 June 2009 13:09 Go to previous message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
it works. i forgot to assign source to one field
Previous Topic: Finding Center of Record and alignment acco
Next Topic: When Check Box Changed
Goto Forum:
  


Current Time: Sun Dec 04 16:26:08 CST 2016

Total time taken to generate the page: 0.13802 seconds