Home » Developer & Programmer » Reports & Discoverer » Error While running report
Error While running report [message #539482] Mon, 16 January 2012 05:49 Go to next message
aallan
Messages: 150
Registered: October 2011
Senior Member
Dears;
when i tried to run report i got this error message:

My code at the button:
DECLARE
	v_rep_id		REPORT_OBJECT;
	v_repjob		VARCHAR2(100);
	v_job_id		VARCHAR2(100);
	v_rep_status		VARCHAR2(100);	
	v_reportsrvr		VARCHAR2(50) := 'rep_server';
	v_runformat		vARCHAR2(50) := 'pdf';

 BEGIN	
	v_rep_id := FIND_REPORT_OBJECT('TEST_sys');
	SET_REPORT_OBJECT_PROPERTY(v_rep_id, REPORT_COMM_MODE, SYNCHRONOUS);
	SET_REPORT_OBJECT_PROPERTY(v_rep_id, REPORT_DESTYPE, CACHE);
	
	SET_REPORT_OBJECT_PROPERTY(v_rep_id, REPORT_SERVER, v_reportsrvr);
	SET_REPORT_OBJECT_PROPERTY(v_rep_id, REPORT_DESFORMAT, v_runformat);	
	
	SET_REPORT_OBJECT_PROPERTY(v_rep_id, REPORT_OTHER, 'paramform=no');	
	
	SET_REPORT_OBJECT_PROPERTY(v_rep_id, REPORT_FILENAME, 'TEST_sys.rdf');
	
	v_repjob := RUN_REPORT_OBJECT(v_rep_id);
	v_job_id := SUBSTR(v_repjob, LENGTH(v_reportsrvr) + 2, LENGTH(v_repjob) );
	v_rep_status := REPORT_OBJECT_STATUS(v_repjob);
	
	IF v_rep_status = 'FINISHED' THEN
		--WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid' || v_job_id ||'?server=' || v_reportsrvr || '', '_blank');
Web.Show_Document ('http://aljawal.sale-co.com:8889/reports/rwservlet/getjobid'||Substr(v_job_id,Instr(v_job_id,'_',-1)+1)||'?'||'server=rep_server&paramform=NO','_blank');
	ELSE
			message('Report failed with error message ');

	END IF;
END;


and i put the path in the report path and form path
and in env file !!!

report located in server and i run the report from client machine.
i run report server.
report saved in this path \\10.1.2.13\d\Sys_Dev\Reports

please help ??
/forum/fa/9719/0/


  • Attachment: 1.PNG
    (Size: 2.83KB, Downloaded 2584 times)

[Updated on: Mon, 16 January 2012 05:53]

Report message to a moderator

Re: Error While running report [message #539615 is a reply to message #539482] Tue, 17 January 2012 06:41 Go to previous messageGo to next message
aallan
Messages: 150
Registered: October 2011
Senior Member
Dears;
i solved the previous problem.
but i faced another, and it is:

I have 2 enviroments:
1- Test.
2- Live (Production).
i have 2 env files (saledev (Test), Default(production)) one for test enviroment and the other for production enviroment.
in formsweb.cfg i configered:
[Saledev] and [Salelive]
and put the env file for each one.
when i tried to delete for example the report located in live system folder and tried to print it, its printed out. and there is a problem because it shouldn't print.
also when i tried to delete the report from test enviroment and tried to print the report it printed out, when i delete it from both enviroments it gave me an error that it deosn't find the report.

# $Id: formsweb.cfg 15-apr-2005.13:17:30 pkuhn Exp $
# formsweb.cfg defines parameter values used by the FormsServlet (frmservlet)
# This section defines the Default settings.  Any of them may be overridden in the
# following Named Configuration sections.  If they are not overridden, then the
# values here will be used.
# The default settings comprise two types of parameters: System parameters,
# which cannot be overridden in the URL, and User Parameters, which can.
# Parameters which are not marked as System parameters are User parameters.
# SYSTEM PARAMETERS
# -----------------
# These have fixed names and give information required by the Forms
# Servlet in order to function.  They cannot be specified in the URL query
# string.  But they can be overridden in a named configuration (see below).
# Some parameters specify file names: if the full path is not given,
# they are assumed to be in the same directory as this file.  If a path
# is given, then it should be a physical path, not a URL.
# USER PARAMETERS
# ---------------
# These match variables (e.g. %form%) in the baseHTML file. Their values
# may be overridden by specifying them in the URL query string
# (e.g. "http://myhost.mydomain.com/forms/frmservlet?form=myform&width=700")
# or by overriding them in a specific, named configuration (see below)
[default]
# System parameter: default base HTML file
baseHTML=base.htm
# System parameter: base HTML file for use with JInitiator client
baseHTMLjinitiator=basejini.htm
# System parameter: base HTML file for use with Sun's Java Plug-In
baseHTMLjpi=basejpi.htm
# System parameter: delimiter for parameters in the base HTML files
HTMLdelimiter=%
# System parameter: working directory for Forms runtime processes
# WorkingDirectory defaults to <oracle_home>/forms if unset.
workingDirectory=
# System parameter: file setting environment variables for the Forms runtime processes
envFile=default.env

# Forms runtime argument: whether to escape certain special characters
# in values extracted from the URL for other runtime arguments
escapeparams=true
# Forms runtime argument: which form module to run
form=test.fmx
# Forms runtime argument: database connection details
userid=
# Forms runtime argument: whether to run in debug mode
debug=no
# Forms runtime argument: host for debugging
host=
# Forms runtime argument: port for debugging
port=
# Other Forms runtime arguments: grouped together as one parameter.
# These settings support running and debugging a form from the Builder:
otherparams=buffer_records=%buffer% debug_messages=%debug_messages% array=%array% obr=%obr% query_only=%query_only% quiet=%quiet% render=%render% record=%record% tracegroup=%tracegroup% log=%log% term=%term%
# Sub argument for otherparams
buffer=no 
# Sub argument for otherparams
debug_messages=no
# Sub argument for otherparams
array=no
# Sub argument for otherparams
obr=no
# Sub argument for otherparams
query_only=no
# Sub argument for otherparams
quiet=yes
# Sub argument for otherparams
render=no
# Sub argument for otherparams
record=
# Sub argument for otherparams
tracegroup=
# Sub argument for otherparams
log=
# Sub argument for otherparams
term=

# HTML page title
pageTitle=Oracle Application Server Forms Services
# HTML attributes for the BODY tag
HTMLbodyAttrs=
# HTML to add before the form
HTMLbeforeForm=
# HTML to add after the form
HTMLafterForm=

# Forms applet parameter: URL path to Forms ListenerServlet
serverURL=/forms/lservlet
# Forms applet parameter
codebase=/forms/java
# Forms applet parameter
imageBase=DocumentBase
# Forms applet parameter
width=750
# Forms applet parameter
height=600
# Forms applet parameter
separateFrame=false
# Forms applet parameter
splashScreen=
# Forms applet parameter
background=
# Forms applet parameter
lookAndFeel=Oracle
# Forms applet parameter
colorScheme=teal
# Forms applet parameter
logo=
# Forms applet parameter
restrictedURLparams=HTMLbodyAttrs,HTMLbeforeForm,pageTitle,HTMLafterForm,log,allow_debug,allowNewConnections
# Forms applet parameter
formsMessageListener=
# Forms applet parameter
recordFileName=
# Forms applet parameter
serverApp=default
# Forms applet archive setting for JInitiator
archive_jini=frmall_jinit.jar
# Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)
archive=frmall.jar
# Number of times client should retry if a network failure occurs.  You should
# only change this after reading the documentation.
networkRetries=0

# Page displayed to Netscape users to allow them to download Oracle JInitiator.
# Oracle JInitiator is used with Windows clients.
# If you create your own page, you should set this parameter to point to it.
jinit_download_page=/forms/jinitiator/us/jinit_download.htm
# Parameter related to the version of JInitiator
jinit_classid=clsid:CAFECAFE-0013-0001-0022-ABCDEFABCDEF
# Parameter related to the version of JInitiator
jinit_exename=jinit.exe#Version=1,3,1,22
# Parameter related to the version of JInitiator
jinit_mimetype=application/x-jinit-applet;version=1.3.1.22

# Page displayed to users to allow them to download Sun's Java Plugin.
# Sun's Java Plugin is typically used for non-Windows clients.
# (NOTE: you should check this page and possibly change the settings)
jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_06/index.html
# Parameter related to the version of the Java Plugin
jpi_classid=clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA
# Parameter related to the version of the Java Plugin
jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_4_2-windows-i586.cab#Version=1,4,2,06
# Parameter related to the version of the Java Plugin
jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06
# EM config parameter
# Set this to "1" to enable Enterprise Manager to track Forms processes
em_mode=0

# Single Sign-On OID configuration parameter
oid_formsid=%OID_FORMSID%
# Single Sign-On OID configuration parameter
oracle_home=D:\DevSuiteHome_1
# Single Sign-On OID configuration parameter
formsid_group_dn=%GROUP_DN%
# Single Sign-On OID configuration parameter: indicates whether we allow
# dynamic resource creation if the resource is not yet created in the OID.
ssoDynamicResourceCreate=true
# Single Sign-On parameter: URL to redirect to if ssoDynamicResourceCreate=false
ssoErrorUrl=
# Single Sign-On parameter: Cancel URL for the dynamic resource creation DAS page.
ssoCancelUrl=
# Single Sign-On parameter: indicates whether the url is protected in which
# case mod_osso will be given control for authentication or continue in
# the FormsServlet if not. It is false by default. Set it to true in an
# application-specific section to enable Single Sign-On for that application.
ssoMode=false
# The parameter allow_debug determines whether debugging is permitted.
# Administrators should set allow_debug to "true" if servlet
# debugging is required, or to provide access to the Forms Trace Xlate utility. 
# Otherwise these activities will not be allowed (for security reasons).
allow_debug=false
# Parameter which determines whether new Forms sessions are allowed. 
# This is also read by the Forms EM Overview page to show the 
# current Forms status.
allowNewConnections=true

# EndUserMonitoring 

# EndUserMonitoringEnabled parameter
# Indicates whether EUM/Chronos integration is enabled
EndUserMonitoringEnabled=

# EndUserMonitoringURL 
# indicates where to record EUM/Chronos data
EndUserMonitoringURL=

# Example Named Configuration Section
# Example 1: configuration to run forms in a separate browser window with
# "generic" look and feel (include "config=sepwin" in the URL)
# You may define your own specific, named configurations (sets of parameters)
# by adding special sections as illustrated in the following examples.
# Note that you need only specify the parameters you want to change.  The
# default values (defined above) will be used for all other parameters.
# Use of a specific configuration can be requested by including the text
# "config=<your_config_name>" in the query string of the URL used to run
# a form.  For example, to use the sepwin configuration, your could issue
# a URL like "http://myhost.mydomain.com/forms/frmservlet?config=sepwin".
[sepwin]
separateFrame=True
lookandfeel=Generic

# Example Named Configuration Section
# Example 2: configuration forcing use of the Java Plugin in all cases (even if 
# the client browser is on Windows)
[jpi]
baseHTMLJInitiator=basejpi.htm

# Example Named Configuration Section
# Example 3: configuration running the Forms ListenerServlet in debug mode
# (debug messages will be written to the servlet engine's log file). 
[debug]
serverURL=/forms/lservlet/debug

# Sample configuration for deploying WebUtil. Note that WebUtil is shipped with
# DS but not AS and is also available for download from OTN.
[webutil]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=frmall_jinit.jar
archive=frmall.jar
lookAndFeel=oracle

[Saledev]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
form=Sale_Log.fmx
userid=sale/sale@saledev
width=100%
height=100%
separateFrame=True
splashScreen=no
background= 
lookAndFeel=Oracle
colorScheme=blue
logo=no
codebase=/forms/java
imageBase=CodeBase
archive_jini=frmall_jinit.jar,icons.jar, mail.jar, activation.jar and SendMail.jar 
archive=frmall.jar, icons.jar, laf_902.jar, laf_1012.jar, laf_10123.jar, laf_11112.jar, dynamicmenu.jar, Calculator.jar
baseHTMLJInitiator=basejpi.htm
jpi_mimetype=application/x-java-applet;version=1.6
jpi_classid=clsid:CAFEEFAC-0016-0000-0021-ABCDEFFEDCBA
envFile=saledev.env

[Salelive]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
form=Sale_Log.fmx
userid=sale/sale@salelive
width=100%
height=100%
separateFrame=True
splashScreen=no
background= 
lookAndFeel=Oracle
colorScheme=blue
logo=no
codebase=/forms/java
imageBase=CodeBase
archive_jini=frmall_jinit.jar,icons.jar, mail.jar, activation.jar and SendMail.jar 
archive=frmall.jar, icons.jar, laf_902.jar, laf_1012.jar, laf_10123.jar, laf_11112.jar, dynamicmenu.jar, Calculator.jar
baseHTMLJInitiator=basejpi.htm
jpi_mimetype=application/x-java-applet;version=1.6
jpi_classid=clsid:CAFEEFAC-0016-0000-0021-ABCDEFFEDCBA
envFile=default.env


# $Id: default.env 14-apr-2005.13:22:43 pkuhn Exp $
# default.env - default Forms environment file, Windows version
#
# This file is used to set the Forms runtime environment parameters.  
# If a parameter is not defined here, the value in the Windows registry 
# will be used. If no value is found in the registry, the value used will
# be that defined in the environment in which the servlet engine (OC4J 
# or JServ) was started.
#
# NOTES
# 1/ The Forms installation process should replace all occurrences of
#    <percent>FORMS_ORACLE_HOME<percent> with the correct ORACLE_HOME 
#    setting, and all occurrences of <percent>O_JDK_HOME<percent> with
#    the location of the JDK (usually $ORACLE_HOME/jdk).  
#    Please make these changes manually if not.
# 2/ Some of the variables below may need to be changed to suite your needs.
#    Please refer to the Forms documentation for details.
#
ORACLE_HOME=D:\DevSuiteHome_1

  #
  # Search path for Forms applications (.fmx files, PL/SQL libraries)
  # If you need to include more than one directory, they should be semi-colon
  # separated (e.g. c:\test\dir1;c:\test\dir2)
  #
  FORMS_PATH=D:\DevSuiteHome_1\forms;D:\DevSuiteHome_1\forms\webutil;D:\Sys_Dev\Forms;D:\Sys_Dev\General

  # webutil config file path
  WEBUTIL_CONFIG=D:\DevSuiteHome_1\forms\server\webutil.cfg

  # Disable/remove this variable if end-users need access to the query-where
  # functionality which potentially allows them to enter arbitrary SQL 
  # statements when in enter-query mode.
  FORMS_RESTRICT_ENTER_QUERY=TRUE

  #
  # The PATH setting is required in order to pick up the JVM (jvm.dll). 
  # The Forms runtime executable and dll's are assumed to be in 
  # D:\DevSuiteHome_1\bin if they are not in the PATH.
  # In addition, if you are running Graphics applications, you will need
  # to append the following to the path (where <Graphics Oracle Home> should
  # be replaced with the actual location of your Graphics 6i oracle_home):
  #
  # ;<Graphics Oracle Home>\bin;<Graphics Oracle Home>\jdk\bin
  # 

  PATH=D:\DevSuiteHome_1\jdk\bin;D:\DevSuiteHome_1\jdk\jre\bin\classic;D:\DevSuiteHome_1\jdk\jre\bin;D:\DevSuiteHome_1\jlib;D:\DevSuiteHome_1\jre\1.4.2\bin\client;D:\DevSuiteHome_1\jre\1.4.2\bin;D:\DevSuiteHome_1\jdk\jre\bin\client
  #
  # Settings for Graphics
  # -------------------------------
  # NOTE: These settings are only needed if Graphics applications 
  # are called from Forms applications. In addition, you will need to
  # modify the PATH variable above as described above.
  #

    #
    # Please uncomment the following and put the correct 6i 
    # oracle_home value to use Graphics applications.
    #
    #ORACLE_GRAPHICS6I_HOME=<your Graphics 6i oracle_home here>

    #
    # Search path for Graphics applications
    #
    #GRAPHICS60_PATH=

  #
  # Settings for Forms tracing and logging
  # -----------------------------------------------
  # Note: This entry has to be uncommented to enable tracing and
  # logging.

    #FORMS_TRACE_PATH=<FORMS_ORACLE_HOME>\forms\server
  

  #
  # System settings
  # ---------------
  # You should not normally need to modify these settings
  #
  FORMS=D:\DevSuiteHome_1\forms

  #
  # Java class path 
  #   This is required for the Forms debugger
  #   You can append your own Java code here)
  # frmsrv.jar, repository.jar and ldapjclnt10.jar are required for
  # the password expiry feature to work(#2213140).
  #
  CLASSPATH=D:\DevSuiteHome_1\j2ee\OC4J_BI_Forms\applications\formsapp\formsweb\WEB-INF\lib\frmsrv.jar;D:\DevSuiteHome_1\jlib\repository.jar;D:\DevSuiteHome_1\jlib\ldapjclnt10.jar;D:\DevSuiteHome_1\jlib\debugger.jar;D:\DevSuiteHome_1\jlib\ewt3.jar;D:\DevSuiteHome_1\jlib\share.jar;D:\DevSuiteHome_1\jlib\utj.jar;D:\DevSuiteHome_1\jlib\zrclient.jar;D:\DevSuiteHome_1\reports\jlib\rwrun.jar;D:\DevSuiteHome_1\forms\java\frmwebutil.jar;D:\DevSuiteHome_1\forms\java\icons.jar;D:\DevSuiteHome_1\jlib\zrclient.jar;D:\DevSuiteHome_1\reports\jlib\rwrun.jar;D:\DevSuiteHome_1\forms\java\jacob.jar;D:\DevSuiteHome_1\forms\java\frmall.jar;D:\DevSuiteHome_1\jdk\jre\lib\rt.jar;D:\DevSuiteHome_1\jlib\zrclient.jar;D:\DevSuiteHome_1\reports\jlib\rwrun.jar
#local=sale
FORMS_PATH=C:\WINDOWS\Fonts;D:\Sys_Dev\GENERAL;D:\Sys_Dev\forms;D:\Sys_Dev\GENERAL\icons
REPORTS_PATH=C:\WINDOWS\Fonts;D:\Sys_Dev\GENERAL;D:\Sys_Dev\Reports

FORMS_MMAP=TRUE


# $Id: default.env 14-apr-2005.13:22:43 pkuhn Exp $
# default.env - default Forms environment file, Windows version
#
# This file is used to set the Forms runtime environment parameters.  
# If a parameter is not defined here, the value in the Windows registry 
# will be used. If no value is found in the registry, the value used will
# be that defined in the environment in which the servlet engine (OC4J 
# or JServ) was started.
#
# NOTES
# 1/ The Forms installation process should replace all occurrences of
#    <percent>FORMS_ORACLE_HOME<percent> with the correct ORACLE_HOME 
#    setting, and all occurrences of <percent>O_JDK_HOME<percent> with
#    the location of the JDK (usually $ORACLE_HOME/jdk).  
#    Please make these changes manually if not.
# 2/ Some of the variables below may need to be changed to suite your needs.
#    Please refer to the Forms documentation for details.
#
ORACLE_HOME=D:\DevSuiteHome_1

  #
  # Search path for Forms applications (.fmx files, PL/SQL libraries)
  # If you need to include more than one directory, they should be semi-colon
  # separated (e.g. c:\test\dir1;c:\test\dir2)
  #
  FORMS_PATH=D:\DevSuiteHome_1\forms;D:\DevSuiteHome_1\forms\webutil;D:\Sys\Forms;D:\Sys\General

  # webutil config file path
  WEBUTIL_CONFIG=D:\DevSuiteHome_1\forms\server\webutil.cfg

  # Disable/remove this variable if end-users need access to the query-where
  # functionality which potentially allows them to enter arbitrary SQL 
  # statements when in enter-query mode.
  FORMS_RESTRICT_ENTER_QUERY=TRUE

  #
  # The PATH setting is required in order to pick up the JVM (jvm.dll). 
  # The Forms runtime executable and dll's are assumed to be in 
  # D:\DevSuiteHome_1\bin if they are not in the PATH.
  # In addition, if you are running Graphics applications, you will need
  # to append the following to the path (where <Graphics Oracle Home> should
  # be replaced with the actual location of your Graphics 6i oracle_home):
  #
  # ;<Graphics Oracle Home>\bin;<Graphics Oracle Home>\jdk\bin
  # 

  PATH=D:\DevSuiteHome_1\jdk\bin;D:\DevSuiteHome_1\jdk\jre\bin\classic;D:\DevSuiteHome_1\jdk\jre\bin;D:\DevSuiteHome_1\jlib;D:\DevSuiteHome_1\jre\1.4.2\bin\client;D:\DevSuiteHome_1\jre\1.4.2\bin;D:\DevSuiteHome_1\jdk\jre\bin\client
  #
  # Settings for Graphics
  # -------------------------------
  # NOTE: These settings are only needed if Graphics applications 
  # are called from Forms applications. In addition, you will need to
  # modify the PATH variable above as described above.
  #

    #
    # Please uncomment the following and put the correct 6i 
    # oracle_home value to use Graphics applications.
    #
    #ORACLE_GRAPHICS6I_HOME=<your Graphics 6i oracle_home here>

    #
    # Search path for Graphics applications
    #
    #GRAPHICS60_PATH=

  #
  # Settings for Forms tracing and logging
  # -----------------------------------------------
  # Note: This entry has to be uncommented to enable tracing and
  # logging.

    #FORMS_TRACE_PATH=<FORMS_ORACLE_HOME>\forms\server
  

  #
  # System settings
  # ---------------
  # You should not normally need to modify these settings
  #
  FORMS=D:\DevSuiteHome_1\forms

  #
  # Java class path 
  #   This is required for the Forms debugger
  #   You can append your own Java code here)
  # frmsrv.jar, repository.jar and ldapjclnt10.jar are required for
  # the password expiry feature to work(#2213140).
  #
  CLASSPATH=D:\DevSuiteHome_1\j2ee\OC4J_BI_Forms\applications\formsapp\formsweb\WEB-INF\lib\frmsrv.jar;D:\DevSuiteHome_1\jlib\repository.jar;D:\DevSuiteHome_1\jlib\ldapjclnt10.jar;D:\DevSuiteHome_1\jlib\debugger.jar;D:\DevSuiteHome_1\jlib\ewt3.jar;D:\DevSuiteHome_1\jlib\share.jar;D:\DevSuiteHome_1\jlib\utj.jar;D:\DevSuiteHome_1\jlib\zrclient.jar;D:\DevSuiteHome_1\reports\jlib\rwrun.jar;D:\DevSuiteHome_1\forms\java\frmwebutil.jar;D:\DevSuiteHome_1\forms\java\icons.jar;D:\DevSuiteHome_1\jlib\zrclient.jar;D:\DevSuiteHome_1\reports\jlib\rwrun.jar;D:\DevSuiteHome_1\forms\java\jacob.jar;D:\DevSuiteHome_1\forms\java\frmall.jar;D:\DevSuiteHome_1\jdk\jre\lib\rt.jar
#local=sale
FORMS_PATH=C:\WINDOWS\Fonts;D:\Sys\GENERAL;D:\Sys\forms;D:\Sys\GENERAL\icons
REPORTS_PATH=C:\WINDOWS\Fonts;D:\Sys\GENERAL;D:\Sys\Reports

FORMS_MMAP=TRUE


also i write the reports folders path in the reports_path in the registry:

D:\Sys_Dev\Reports;D:\Sys\Reports

Sys_Dev is a test enviroment folder.
Sys Is Production.
D drive on the server.

Code to run report:
Declare
V_Rep_Id Report_Object;
V_Repjob Varchar2(100);
V_Job_Id Varchar2(100);
V_Rep_Status Varchar2(100); 
V_Reportsrvr Varchar2(50) := 'rep_server';
V_Runformat Varchar2(50) := 'pdf';
Begin 
V_Rep_Id := Find_Report_Object('EMPSTATUS');
Set_Report_Object_Property(V_Rep_Id, Report_Comm_Mode, Synchronous);
Set_Report_Object_Property(V_Rep_Id, Report_Destype, Cache);

Set_Report_Object_Property(V_Rep_Id, Report_Server, V_Reportsrvr);
Set_Report_Object_Property(V_Rep_Id, Report_Desformat, V_Runformat); 

--Set_Report_Object_Property(V_Rep_Id, Report_Other, 'paramform=no');
Set_Report_Object_Property(V_Rep_Id, Report_Other, 'User_Id=' || :Global.User ||' paramform=no'); 

Set_Report_Object_Property(V_Rep_Id, Report_Filename, 'EMPSTATUS.rdf');

V_Repjob := Run_Report_Object(V_Rep_Id);
V_Job_Id := Substr(V_Repjob, Length(V_Reportsrvr) + 2, Length(V_Repjob) );
V_Rep_Status := Report_Object_Status(V_Repjob);

If V_Rep_Status = 'FINISHED' Then
Web.Show_Document('/reports/rwservlet/getjobid' || V_Job_Id ||'?server=' || V_Reportsrvr || '', '_blank');
Else
Message('Report failed with error message ');
End If;
End;

Please Help !!
  • Attachment: EMPSTATS.fmb
    (Size: 212.00KB, Downloaded 1304 times)

[Updated on: Tue, 17 January 2012 06:46]

Report message to a moderator

Re: Error While running report [message #539701 is a reply to message #539615] Wed, 18 January 2012 03:02 Go to previous messageGo to next message
aallan
Messages: 150
Registered: October 2011
Senior Member
up !!
Re: Error While running report [message #539842 is a reply to message #539701] Wed, 18 January 2012 16:27 Go to previous messageGo to next message
aallan
Messages: 150
Registered: October 2011
Senior Member
Please, i need help...!!!
Re: Error While running report [message #539854 is a reply to message #539842] Wed, 18 January 2012 23:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Keep your lines of code in 80 character width: no more than 80 characters on each line.
I can't read lines that spread over 10 screen width.

Regards
Michel
Re: Error While running report [message #539972 is a reply to message #539854] Thu, 19 January 2012 10:13 Go to previous messageGo to next message
aallan
Messages: 150
Registered: October 2011
Senior Member
thanks, no need to read it.
Re: Error While running report [message #539980 is a reply to message #539972] Thu, 19 January 2012 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks to allow me to not read it.

Regards
Michel
Re: Error While running report [message #540385 is a reply to message #539980] Mon, 23 January 2012 03:36 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Did you also define your report path in Registry.
Please read this post.
http://www.orafaq.com/forum/m/500552/81953/#msg_500552


Regards,
Irfan
Re: Error While running report [message #540439 is a reply to message #540385] Mon, 23 January 2012 10:36 Go to previous message
aallan
Messages: 150
Registered: October 2011
Senior Member
ranamirfan wrote on Mon, 23 January 2012 03:36
Did you also define your report path in Registry.
Please read this post.
http://www.orafaq.com/forum/m/500552/81953/#msg_500552


Regards,
Irfan


dear irfan,
yes, in defined the report path in the registry
and please look to my second thread, its another problem i didnt solved it.

[Updated on: Mon, 23 January 2012 10:39]

Report message to a moderator

Previous Topic: GP Percentage in Total
Next Topic: Report are not running
Goto Forum:
  


Current Time: Thu Mar 28 11:13:39 CDT 2024