[mkenney]

Hi there,

I'm trying to run Oracle Forms and Reports from an OTM 5.5 installation, and currently all of the reports get the following error:

REP-50004: No report specified on the command line

For example, if I try to run a canned report using the following steps, I get the above error.

- Transportation Planning and Execution > Reports > Shipment Reports
- Bill of Lading, Run (Online DB)
- Enter a Shipment Number
- Submit

I also get the same error when running other reports, like as an action from one of the other screens.

Any clues on this?

Thanks

[nick.polites]

First step is to check if your "View Scheduled Jobs" Link is working. I have never seen a REP-50004 error before in my 7 1/2 years of dealing with OTM so it is possible that you have an installation issue with Oracle Reports. The next thing I would check is to see if you have properly configured reports. Please post your entries for Oracle Reports configuration from your glog.properties on your app and web server.

[mkenney]

I'll try the View Scheduled Jobs link. Also, here is the section from the glog.properties file about the reports server, which is identical on Web and App servers:

---
## external Oracle Reports Server - optional
report_feature=true
p_reports_server=rep_tmsrpt-dev01.FF.FFBS.NET_FRHome1
#p_reports_server=rep_otmrpt
p_reports_out_dir=d:/otm/rptapache/htdocs
reports_server_fqdn=http://tmsrpt-dev01.FF.FFBS.NET:7778/reports/rwservlet
report_server_url=http://tmsrpt-dev01.FF.FFBS.NET:7778
discoverer_url=
---

[nick.polites]

OK the only thing I see from the config that is incorrect is:
report_server_url=http://tmsrpt-dev01.FF.FFBS.NET:7778

This needs to be actually the reports port for the OTM Reports component, usually 81. You need to install OTM with the reports feature on the server that Oracle Reports resides, otherwise you won't get and schduled reports from within OTM.

Next step would be to check to see if this returns, you want to run this on the same network your servers reside:

http://tmsrpt-dev01.FF.FFBS.NET:7778...BS.NET_FRHome1

If this doesn't return then you have a problem somewhere in your Oracle reports configuration or install. Also be sure that you did not patch Oracle Reports since you installed it (should be 10.1.2.0.2), I have seen that the rwservlet doesn't work on certain patches and it is required for OTM.

After you get this working, you'll need to install the rw.dll file which can be found on the forums. It will fix a formatting bug in the Windows version of Oracle Reports

[mkenney]

I'm still having the issue, but I'm figuring out a little more about the 50004 error. I can re-produce the error directly against the report server using the following URL:

http://tmsrpt-dev01.ff.ffbs.net:7778...-DEV01_FRHome1

It is like the name of the report to run and other parameters were not sent by OTM. This URL will find a report to run and not get the 50004 error for example:

http://tmsrpt-dev01.ff.ffbs.net:7778...desname=D:\OTM

We used an alternate port in the install of Reports, so I believe 7778 is correct for report_server_url, though I could be wrong. Supporting this is the fact that using showjobs I can see the history of all of the attempts to run reports from OTM, and the 50004 errors that are being returned which indicates that the communication is working both ways:

http://tmsrpt-dev01.ff.ffbs.net:7778...rvlet/showjobs
I'm thinking maybe the configuration needs to be changed under: Business Process Automation > Power Data > Document Generation > Reports

This seems to be where Report Parameters are specified.

MK

[mkenney]

The forum seems to be clipping out URLs, so let me re-post without the http:

Re-Produce the 50004 error:
tmsrpt-dev01.ff.ffbs.net:7778/reports/rwservlet?server=rep_TMSRPT-DEV01_FRHome1
Example URL that specifies the report (no 50004 error):
tmsrpt-dev01.ff.ffbs.net:7778/reports/rwservlet?server=rep_TMSRPT-DEV01_FRHome1+report=D:\OTM\glog\reports\bill_of_l ading.rdf+desformat=pdf+destype=file+desname=D:\OT M

Show Jobs link:
tmsrpt-dev01.ff.ffbs.net:7778/reports/rwservlet/showjobs

Nick - The URL from your post was also clipped.

[nick.polites]

If you are running any out of box reports, then you shouldn't need to modify anything in power data.

Please re-read my earlier post and try the steps I mention and respond back.

You may also try running a test report http://tmsrpt-http://dev01.FF.FFBS.NET:7778/repdemo/runJSPIAS.html be sure to include

rep_tmsrpt-dev01.FF.FFBS.NET_FRHome1 as your report server ID. If this errors out, you have an install problem with Oracle Reports.

Does yout view scheduled jobs work with the internal link I sent you?

[mkenney]

The View Scheduled Jobs option does not work for me. It links out to GetReportServlet and never returns.

Nick - I can not read the URL's because the forum is changing them. Could you re-post without the http at the beginning?

[nick.polites]

Sure, in case this happens again you can scroll over it and it should show up in the lower left corner of your browser.

tmsrpt-dev01.ff.ffbs.net:7778/reports/rwservlet/showjobs?server=rep_tmsrpt-dev01.FF.FFBS.NET_FRHome1

If this doesn't return then you either have the port incorrect or the report server name rep_

[mkenney]

Using the URL you sent with the "showjobs" option including the server parameter I get a 51002 error:

Error REP-51002: Bind to Reports Server rep_tmsrpt-dev01.ff.ffbs.net_frhome1 failed
If I remove the server parameter (?server=rep_tmsrpt-dev01.FF.FFBS.NET_FRHome1) I get the list of jobs I previously mentioned:

---
Job ID Job Type Job Name Job Status Job Owner Output Type Output Name Server Name Queued At Started At Finished At 24 report D:\OTM\glog\reports\bill_of_lading.rdf RWUser File D:\OTM rep_tmsrpt-dev01_frhome1 Jun 19, 2008 8:03:05 AM Jun 19, 2008 8:03:24 AM Jun 19, 2008 8:03:33 AM 23 report NoName RWUser undefined rep_tmsrpt-dev01_frhome1 Jun 19, 2008 7:45:51 AM Jun 19, 2008 7:45:51 AM Jun 19, 2008 7:45:51 AM 22 report D:\OTM\glog\reports\WhatsOnOrder.rdf RWUser File D:\OTM rep_tmsrpt-dev01_frhome1 Jun 18, 2008 4:15:38 PM Jun 18, 2008 4:15:38 PM Jun 18, 2008 4:15:38 PM 21 report D:\OTM\glog\reports\WhatsOnOrder.rdf RWUser File D:\OTM rep_tmsrpt-dev01_frhome1 Jun 18, 2008 4:15:02 PM Jun 18, 2008 4:15:02 PM Jun 18, 2008 4:15:02 PM
---