Home » Developer & Programmer » Forms » Opening Reports 9i from Forms 9i *it was working fine on other laptop*
Opening Reports 9i from Forms 9i *it was working fine on other laptop* [message #261673] Thu, 23 August 2007 05:31 Go to next message
aymanzone
Messages: 9
Registered: December 2006
Junior Member
I'm trying to call a report 9i from forms 9i. It always worked for me and i've not had trouble with 9i. For some reason with the new laptop toshiba *same config as old laptop: windows XP and developer suite 9i* I am unable to open the new form using the same code.

I get an HTTP404 Error not found page. The dialog box that appears when there is an error "FRM:41214: Unable to run form" doesn't even appear. However, I can make it appear if i put wrong settings on purpose. I'm sure the code is right, but don't know what exactly is wrong?

Like I said, I get the HTTP404 Error not found page directly without being prompted for the FRM:41214 dialog box!

Thx! for any feedback.

[Updated on: Thu, 23 August 2007 05:34]

Report message to a moderator

Re: Opening Reports 9i from Forms 9i *it was working fine on other laptop* [message #261682 is a reply to message #261673] Thu, 23 August 2007 05:50 Go to previous messageGo to next message
DRASTANT
Messages: 21
Registered: July 2007
Location: KENYA
Junior Member
helloo aymanzone?? how r u

Please check the path of source directory in your

(report_server_name).conf file it is generally on 14th line
make sure it points to your reports executable
Re: Opening Reports 9i from Forms 9i *it was working fine on other laptop* [message #261690 is a reply to message #261682] Thu, 23 August 2007 06:15 Go to previous messageGo to next message
aymanzone
Messages: 9
Registered: December 2006
Junior Member
Soz, I think I might be a bit new to this

do i compare the web address browswer:http://localhost:8888/reports/rwservlet/getjobid1?server=test1 with what? in this conf document test1.conf?
*my report server is called "test1" btw*



<?xml version = '1.0' encoding = 'ISO-8859-1'?>
<!DOCTYPE server PUBLIC "-//Oracle Corp.//DTD Reports Server Configuration //EN" "file:/C:/OraHome1/reports/dtd/rwserverconf.dtd">
<server>
<!--compatible version="6i"/-->
<cache class="oracle.reports.cache.RWCache">
<property name="cacheSize" value="50"/>
<!--property name="cacheDir" value="your cache directory"/-->
<!--property name="maxCacheFileNumber" value="max number of cache files"/-->
<!--property name="ignoreParameters" value="parameter names to be ignored in constructing cache key, separated by comma ','"/-->
</cache>
<!--Please do not change the id for reports engine.-->
<!--The class specifies below is subclass of _EngineClassImplBase and implements EngineInterface.-->
<engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000">
<!--property name="sourceDir" value="your reports source directory"/-->
<!--property name="tempDir" value="your reports temp directory"/-->
</engine>
<engine id="rwURLEng" class="oracle.reports.urlengine.URLEngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000"/>
<!--security id="rwSec" class="oracle.reports.server.RWSecurity">
<property name="securityUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/>
</security-->
<!--destination destype="oraclePortal" class="oracle.reports.server.DesOraclePortal">
<property name="portalUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/>
</destination-->
<job jobType="report" engineId="rwEng"/>
<job jobType="rwurl" engineId="rwURLEng"/>
<notification id="mailNotify" class="oracle.reports.server.MailNotify">
<property name="succnotefile" value="succnote.txt"/>
<property name="failnotefile" value="failnote.txt"/>
</notification>
<log option="noJob"/>
<!--jobStatusRepository class="oracle.reports.server.JobRepositoryDB">
<property name="repositoryConn" value="repo_db_username/repo_db_password@repo_db_tnsname" confidential="yes" encrypted="no"/>
</jobStatusRepository-->
<!--trace traceOpts="trace_all"/-->
<connection maxConnect="20" idleTimeOut="15">
<orbClient id="RWClient" publicKeyFile="clientpub.key"/>
<cluster publicKeyFile="serverpub.key" privateKeyFile="serverpri.key"/>
</connection>
<queue maxQueueSize="1000"/>
<!--identifier confidential="yes" encrypted="no">scott/tiger</identifier-->
<pluginParam name="mailServer"/>
<!--pluginParam name="proxy" type="file">proxyinfo.xml</pluginParam-->
<pluginParam name="xmlpds" type="file">xmlpds.conf</pluginParam>
<pluginParam name="jdbcpds" type="file">jdbcpds.conf</pluginParam>
<pluginParam name="textpds" type="file">textpds.conf</pluginParam>
</server>


I've never really seen this file Razz...ermm..i'll keeping looking at it until i get an idea, but where do i determine the "report executable" from the "web address generated in the browser"?

thx!

[Updated on: Thu, 23 August 2007 06:28]

Report message to a moderator

Re: Opening Reports 9i from Forms 9i *it was working fine on other laptop* [message #261734 is a reply to message #261690] Thu, 23 August 2007 08:21 Go to previous messageGo to next message
aymanzone
Messages: 9
Registered: December 2006
Junior Member
This doesn't work for me:

WEB.SHOW_DOCUMENT('http://localhost:8888/reports/rwservlet/getjobid' || substr(v_report_job_id, v_server_length +2) || '?server=' || v_rep_server, '_blank');


But the below seems to work!! Problem solved! just neede to change localhost to 127.0.0.1. I've know idea why? ><...but thx!
Is there an online resource that can explains this plz?

WEB.SHOW_DOCUMENT('http://127.0.0.1:8888/reports/rwservlet/getjobid' || substr(v_report_job_id, v_server_length +2) || '?server=' || v_rep_server, '_blank');
Re: Opening Reports 9i from Forms 9i *it was working fine on other laptop* [message #261891 is a reply to message #261734] Thu, 23 August 2007 23:58 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
@aymanzone

Please don't post the same question in multiple threads!

Try "WEB.SHOW_DOCUMENT('/reports/rwservlet?' || substr(v_report_job_id, etc"

David
Re: Opening Reports 9i from Forms 9i *it was working fine on other laptop* [message #262344 is a reply to message #261891] Sun, 26 August 2007 06:08 Go to previous messageGo to next message
aymanzone
Messages: 9
Registered: December 2006
Junior Member
Both

"WEB.SHOW_DOCUMENT('/reports/rwservlet?' || substr(v_report_job_id, etc"

And

WEB.SHOW_DOCUMENT('http://127.0.0.1:8888/reports/rwservlet/getjobid' || substr(v_report_job_id, v_server_length +2) || '?server=' || v_rep_server, '_blank');

Are working. I am curious to know why when using "localhost" it doesn't work? Anyone know why?

Btw david, I didn't post the question on two threads. The intent was to merely help another person who had a similar problem. Hence, replying to his thread.

Re: Opening Reports 9i from Forms 9i *it was working fine on other laptop* [message #262424 is a reply to message #262344] Mon, 27 August 2007 00:35 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Try making the following change in your Internet Explorer settings. Go to Tools > Internet Options > Connection / LAN Settings and set 'Bypass Proxy server for local addresses' to 'checked'.

David

[Updated on: Mon, 27 August 2007 00:35]

Report message to a moderator

Previous Topic: Timer Problem
Next Topic: How To Connect Forms 6i with Micro soft Sql Server via odbc
Goto Forum:
  


Current Time: Sat Dec 10 18:37:17 CST 2016

Total time taken to generate the page: 0.20301 seconds