Home » Developer & Programmer » Forms » RUN_REPORT_OBJECT is not working, Please Help. (Developer Suite, 10g, XP)
RUN_REPORT_OBJECT is not working, Please Help. [message #343071] Tue, 26 August 2008 03:51 Go to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Hi,

I have
a form c:\testdir\forms\test4.fmb/fmx and
a report c:\testdir\reports\test4.rdf/rep
both created in developer 6i.

I installed developer suite 10g.
I re-compiled both the form and report in developer suite 10g.
To run the report from the form I have written code as below:

DECLARE
Repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
BEGIN
repid := FIND_REPORT_OBJECT('c:\testdir\reports\test4');
v_rep := RUN_REPORT_OBJECT(repid);
END;

While running the above mentioned codes shows error FRM-41219: Can not find report: Invalid ID.

My OC4J is running. I am sure the form and report exist in the specified locations.

It may be mentioned that I also tried to use the form compilation time auto generated code
rp2rro.rp2rro_run_product(reports,:GLOBAL.REPORTDIR||'\test4',SYNCHRONOUS,runtime,filesystem,PL_ID,null);
Whereas global variable :GLOBAL.REPORTDIR:='c:\testdir\reports\';

I had previously copied rp2rro.pll and EnableDisableItem.pll files in forms directory c:\testdir\forms\.


I would be very much gratefull if someone can please help me to run the report in paper layout showing complete trigger.

Kind regards to the answer provider.


G. Hossain
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343077 is a reply to message #343071] Tue, 26 August 2008 04:10 Go to previous messageGo to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

search this forum for web.show_document
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343131 is a reply to message #343071] Tue, 26 August 2008 06:50 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Your problem is with the command Find_report_object. You are not using the good parameter.

In Form Builder 10g, you need to define the report. If you look in the object navigator you will see a new section called Report. In this section create a new report and set the filename to your report. See attached print screen

So when using FIND_REPORT_OBJECT, you will have to use this name instead of the path you actually used

  repid := FIND_REPORT_OBJECT('TEST_REPORT');


Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343137 is a reply to message #343071] Tue, 26 August 2008 07:19 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

My friend,
Lots of thanks for your kind attention. I am trying this.
G. Hossain
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343142 is a reply to message #343131] Tue, 26 August 2008 07:43 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Dear Kaeluan,

I have tried your suggestion that worked well. But, there comes another problem
REP-0110: Unable to open file la.
REP-1070: Error while opening or saving document.

please see attachment.

I have also tried with PREVIEW option in addition to FILE option in report destination.

Please help me.


G. Hossain
  • Attachment: error.JPG
    (Size: 78.85KB, Downloaded 883 times)

[Updated on: Tue, 26 August 2008 08:14]

Report message to a moderator

Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343160 is a reply to message #343071] Tue, 26 August 2008 08:49 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Here is something you may try on your trigger

DECLARE 
    Repid REPORT_OBJECT; 
    v_rep VARCHAR2(100); 
    rep_status VARCHAR2(20); 
BEGIN 
    repid := FIND_REPORT_OBJECT('REPORT5'); 
    set_report_object_property(repid, REPORT_EXECUTION_MODE, BATCH);
    set_report_object_property(repid, REPORT_SERVER, 'rep_synntm172_fr');
    set_report_object_property(repid, REPORT_COMM_MODE, SYNCHRONOUS);
    set_report_object_property(repid, REPORT_DESTYPE, CACHE);
    set_report_object_property(repid, REPORT_DESFORMAT, 'PDF');
    set_report_object_property(repid, REPORT_FILENAME, '\\synntm53\repogi\GAG_RPAC.RDF');

    v_rep := RUN_REPORT_OBJECT(repid);

END;



This allow you to overwrite some setting define in the report object.

REPORT_SERVER parameter = Your report server use to run the report
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343164 is a reply to message #343160] Tue, 26 August 2008 08:53 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Dear Kaeluan,

Many many thanks for your suggestions. I am trying this at once.

1. How can I know what is my report server name?
2. Can I send the report output to preview for print like reports of developer 6i?
3. Would you please see the attached file, why does this happen?

Best Regards for your kind attention.

G. Hossain.
  • Attachment: ERROR3.JPG
    (Size: 79.37KB, Downloaded 682 times)

[Updated on: Tue, 26 August 2008 09:19]

Report message to a moderator

Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343173 is a reply to message #343164] Tue, 26 August 2008 09:21 Go to previous messageGo to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

Try This

declare
  p paramlist;
  rep_id report_object;
begin
  p:=Get_parameter_list('rep');
  if not id_null(p) then
    destroy_parameter_list(p);
  end if;
  p:=Create_parameter_List('rep');
  add_parameter(p,<parameter1>,text_parameter,<Field1>);
  Add_Parameter(p,'MAXIMIZE',TEXT_PARAMETER, 'YES');
  add_parameter(p,'PARAMFORM',text_PARAMETER,'NO'); 
  web.show_document
('/reports/rwservlet?destype=CACHE&desformat=PDF&report=<Path of RDF file>&userid=scott/tiger@orcl&p_internalno=<Field1>');

END;
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343184 is a reply to message #343173] Tue, 26 August 2008 09:58 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Dear Mr. Mudabbir,

Thank you very much for your help. But, it reveals user password.

1. Can I use RUN_REPORT_OBJECT instead?
2. How can I know what my REPORT SERVER name is?
3. Can you please send the solution for the problem shown in attached file?

Kindly answer all the 3 questions.

Best Regards-

Mohd. Golam Hossain.
  • Attachment: ERROR3.JPG
    (Size: 79.37KB, Downloaded 570 times)

[Updated on: Tue, 26 August 2008 10:01]

Report message to a moderator

Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343209 is a reply to message #343071] Tue, 26 August 2008 11:29 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
1- Yes you can use RUN_REPORT_OBJECT

2- if you try to run your report locally using oc4j you need to start a report server to be able to submit job on it. Open a dos command promt and type:

rwserver server=test &

This will start a new instance of report server called test.
To see your job on the report server, open Internet explorer and use a similar url (You will need to change the name of the computer)
http://wmtxpinf061.optimum.inc:8889/reports/rwservlet/showjobs?server=test

Now in your trigger in your Form use code like this
DECLARE 
    Repid REPORT_OBJECT; 
    v_rep VARCHAR2(100); 
    rep_status VARCHAR2(20); 
BEGIN 
    repid := FIND_REPORT_OBJECT('REPORT5'); 
    set_report_object_property(repid, REPORT_EXECUTION_MODE, BATCH);
    set_report_object_property(repid, REPORT_SERVER, 'test');
    set_report_object_property(repid, REPORT_COMM_MODE, SYNCHRONOUS);
    set_report_object_property(repid, REPORT_DESTYPE, CACHE);
    set_report_object_property(repid, REPORT_DESFORMAT, 'PDF');
    set_report_object_property(repid, REPORT_FILENAME, '\\synntm53\repogi\GAG_RPAC.RDF');

    v_rep := RUN_REPORT_OBJECT(repid);
    
    web.show_document('/reports/rwservlet/getjobid'||
                       substr(v_rep,instr(v_rep,'_',-1)+1)||
                       '?server=test');


END;

web.show_document will display your report when completed

3- I am really sorry but i don`t know what is the problem here since it worked fine for me. Your form is running locally or on application server?

[Updated on: Tue, 26 August 2008 12:39]

Report message to a moderator

Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343310 is a reply to message #343209] Tue, 26 August 2008 22:35 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Dear Mr. Kaeluan,

Your all the solutions are great to me.

I can define a report server name as I want. Is there any way to know the existing report server name?

Thanks.

G. Hossain
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343491 is a reply to message #343071] Wed, 27 August 2008 07:20 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
To list all report server on the same network, open a dos window and type

rwdiag -findall

This will list all report server available
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343588 is a reply to message #343491] Wed, 27 August 2008 10:32 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Dear Kaeluan,

I have tried this. It shows error message as follows:

D:\>rwdiag -findall
'rwdiag' is not recognized as an internal or external command,
operable program or batch file.

Please suggest me again.

Best Regards-

G. Hossain


Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343591 is a reply to message #343071] Wed, 27 August 2008 10:45 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Actually rwdiag is a batch file that should be located in your %oracle_home%/bin. i don`t know if it`s part of some specific setting during installation of 10g tools.

Here is the code in the batch file. maybe you can try to create it manually. I hope you have all jar files required by the script installed. You may need to change some path in the file since maybe your installation is not in same directory than mine

@echo off

REM $Header: rwdiag.bat 13-may-2005.03:21:21 sunaraya Exp $
REM
REM rwdiag.bat
REM
REM Copyright (c) 2005, Oracle. All rights reserved.  
REM
REM    NAME
REM      rwdiag.bat - rw diagnostic tool
REM
REM    DESCRIPTION
REM      Script to run the diagnostic tool used to locate servers / monitor packets on the network
REM
REM    NOTES
REM      Usage: rwdiag.bat -find <server name> | -findAll  [-conf <config file>]  [-timeout <timeout in sec>]
REM
REM      Usage: rwdiag.bat -monitor [-log <logfile>]  [-conf <config file>]
REM
REM    MODIFIED   (MM/DD/YY)
REM    sunaraya    05/13/05 - Added rwrun.jar to the classpath for bug 4361664 
REM    sunaraya    04/22/05 - Provided execute permission to the script for bug 4323789 
REM    sunaraya    04/14/05 - sunaraya_bug-4221172
REM    sunaraya    04/14/05 - Creation
REM

set ORA_HOME=C:\Oracle\ora10gds

if "%ORA_HOME%"=="" goto ERROR

set _CLASSPATH=%ORA_HOME%\jlib\zrclient.jar;%ORA_HOME%\reports\jlib\rwrun.jar

%ORA_HOME%\jdk\bin\java -DORACLE_HOME=%ORA_HOME% -classpath %_CLASSPATH% oracle.reports.utility.DiagServerLocator %*
goto END

:ERROR
  echo "ORACLE_HOME is not set"
  echo.
 
:END


Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343739 is a reply to message #343591] Thu, 28 August 2008 00:27 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Dear Mr. Kaeluan,

I am very much grateful to you. How, can I thank you!!!

I wish further boost of your intelect.

Good Luck.


M. G. Hossain.
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343983 is a reply to message #343591] Thu, 28 August 2008 09:30 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Boss,

I created a batch file named rwdiar.bat:
----------------------------------------

@echo off

set ORA_HOME=D:\oracle\OraDev\10G

if "%ORA_HOME%"=="" goto ERROR

set _CLASSPATH=%ORA_HOME%\jlib\zrclient.jar;%ORA_HOME%\reports\jlib\rwrun.jar

%ORA_HOME%\jdk\bin\java -DORACLE_HOME=%ORA_HOME% -classpath %_CLASSPATH% oracle.reports.utility.DiagServerLocator %*
goto END

:ERROR
echo "ORACLE_HOME is not set"
echo.

:END



Then I ran the batch file. The result is as below:
--------------------------------------------------

D:\Documents and Settings\Administrator>cd\

D:\>c:\matadorit\system\rwdiag -findall
Exception in thread "main" java.lang.NoClassDefFoundError: oracle/reports/utility/DiagServerLocator
D:\>


G. Hossain

[Updated on: Thu, 28 August 2008 09:32]

Report message to a moderator

Re: RUN_REPORT_OBJECT is not working, Please Help. [message #344006 is a reply to message #343071] Thu, 28 August 2008 10:15 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
What is your Oracle Version, with all the digit in it (Ex: mine is 10.1.2.0.2)
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #344013 is a reply to message #344006] Thu, 28 August 2008 10:24 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

My oracle version is Database 10g, Developer Suite also 10g.

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 -

[Updated on: Thu, 28 August 2008 10:25]

Report message to a moderator

Re: RUN_REPORT_OBJECT is not working, Please Help. [message #344051 is a reply to message #343071] Thu, 28 August 2008 12:38 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
This is probably why you don`t have the file to run rwdiag. I think this functionnaity was added in Developper Suite 10g only in release 2 (10.1.2)
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #344602 is a reply to message #344051] Sat, 30 August 2008 23:32 Go to previous messageGo to next message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Dear Mr. Kaeluan,

Can You Please give me solution to my 2 other problems:

Problem-1: Forms 10g Window problem:
In developer 6i forms windows are quite good and items of the full window are visible and navigable.

But, in developer 10g forms:
1. TOP SIDE VACANT: some space above the oracle forms window is vacant and un-usable,
2. RIGHT AND BOTTOM SIDE INVISIBLE: some items in the right side and at the bottom are neighter visible nor navigable


Problem-2: Password Problem:
Oracle asks for password each time I want to print report in Deveoper 6i reports with Database 11g.

It would be very helpful for me if you kindly provide me the solutions.

Best regards.


M. G. Hossain.

[Updated on: Sun, 31 August 2008 00:34]

Report message to a moderator

Re: RUN_REPORT_OBJECT is not working, Please Help. [message #345147 is a reply to message #343071] Tue, 02 September 2008 07:18 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Problem #1
1- This look like some reserve space for menu and toolbar because your form don`t seem to have any. I don`t know if it`s possible to remove this space.

2- Look in your file named forsmweb.cfg. This file contain default value to run your application. Search for something like this
  width=650
  height=500

Increase those value and it should fix your problem with invisible field.

Problem #2
Oracle ask you for password when you try to run the report from report builder or when you submit it from forms?
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #345309 is a reply to message #345147] Tue, 02 September 2008 22:53 Go to previous message
m_golam_hossain
Messages: 89
Registered: August 2008
Location: Uttara, Dhaka, Bangladesh
Member

Problem2:
---------
Front End: Oracle Developer 6i (Forms6i and Reports 6i)
Back End : Oracle Database 11g

Yes, when I submit report print request from Developer6i Forms Builder with Oracle Database 11g, it asks for password before previewing report?

Printing Report from Developer 6i+Database 8i Combination is OK, this combination runs the programs very fine does not ask for password. I originally wrote the program in Developer 6i and Database 8i. Now, I need to upgrade them for compatibility with new Hardware and O/S.


Thanks and Regards.


G. Hossain

[Updated on: Tue, 02 September 2008 22:57]

Report message to a moderator

Previous Topic: Hyper terminal
Next Topic: How to get Screen Resolution?
Goto Forum:
  


Current Time: Tue Dec 06 04:47:54 CST 2016

Total time taken to generate the page: 0.11977 seconds