OTM Reports getting REP-50004 Error

[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]

Re: OTM Reports getting REP-50004 Error

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]

Re: OTM Reports getting REP-50004 Error

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]

Re: OTM Reports getting REP-50004 Error

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/reports/rwservlet/showjobs?server=rep_tmsrpt-dev01.FF.FFBS.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]

Re: OTM Reports getting REP-50004 Error

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/reports/rwservlet?server=rep_TMSRPT-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/reports/rwservlet?server=rep_TMSRPT-DEV01_FRHome1+report=D:\OTM\glog\reports\bill_of_lading.rdf+desformat=pdf+destype=file+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/reports/rwservlet/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]

Re: OTM Reports getting REP-50004 Error

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]

Re: OTM Reports getting REP-50004 Error

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]

Re: OTM Reports getting REP-50004 Error

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]

Re: OTM Reports getting REP-50004 Error

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]

Re: OTM Reports getting REP-50004 Error

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
---

[nick.polites]

Re: OTM Reports getting REP-50004 Error

Do you have the reports server name correct? It should work and you'll need to get it to work in the same format that I sent you otherwise you won't be able to integrate OTM reports with Oracle Reports. Did you patch the instance with anything after you installed Oracle Reports? You need to be sure that it is version 10.1.2.0.2 and nothing else.

[mkenney]

Re: OTM Reports getting REP-50004 Error

If I run the Show Environment command:

tmsrpt-dev01.ff.ffbs.net:7778/reports/rwservlet/showenv
It shows the correct version:

10.1.2.0.2

So I do not think any patches were applied.

Also if I do not fully qualify the name of the server, I can get your link to work:

tmsrpt-dev01.ff.ffbs.net:7778/reports/rwservlet/showjobs?server=rep_tmsrpt-dev01_FRHome1
I changed it from 'rep_tmsrpt-dev01.ff.ffbs.net_FRHome1' to 'rep_tmsrpt-dev01_FRHome1', so I guess the reports server name was not quite correct. The show jobs option shows the list of jobs. The requests from OTM are where it shows Job Name 'NoName', and the others are me manually trying reports:

---
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
20 report D:\OTM\glog\reports\WhatsOnOrder.rdf RWUser File D:\OTM rep_tmsrpt-dev01_frhome1 Jun 18, 2008 4:14:46 PM Jun 18, 2008 4:14:46 PM Jun 18, 2008 4:14:47 PM
19 report D:\OTM\glog\reports\bill_of_lading.rdf RWUser File D:\OTM rep_tmsrpt-dev01_frhome1 Jun 18, 2008 3:59:18 PM Jun 18, 2008 3:59:18 PM Jun 18, 2008 3:59:19 PM
18 report NoName RWUser undefined rep_tmsrpt-dev01_frhome1 Jun 18, 2008 3:58:39 PM Jun 18, 2008 3:58:39 PM Jun 18, 2008 3:58:39 PM
17 report NoName RWUser undefined rep_tmsrpt-dev01_frhome1 Jun 18, 2008 3:58:17 PM Jun 18, 2008 3:58:17 PM Jun 18, 2008 3:58:17 PM
16 report NoName RWUser undefined rep_tmsrpt-dev01_frhome1 Jun 18, 2008 3:55:44 PM Jun 18, 2008 3:55:44 PM Jun 18, 2008 3:55:44 PM
15 report D:\OTM\glog\reports\bill_of_lading.rdf RWUser File D:\OTM rep_tmsrpt-dev01_frhome1 Jun 18, 2008 3:44:07 PM Jun 18, 2008 3:44:07 PM Jun 18, 2008 3:44:10 PM

---

[nick.polites]

Re: OTM Reports getting REP-50004 Error

Ok so you'll need to change that in your glog.properties file and then restart OTM. Then your view scheduled jobs should work. Be sure that you also copied over the templates from your /otm/glog/reports/10g to your /oracle_reports/reports/templates directory as per the admin guide.

[mkenney]

Re: OTM Reports getting REP-50004 Error

OK. I've updated the properties and now the View Scheduled Jobs link works. The p_reports_server property needed to NOT have a fully qualified name, so i removed '.ff.ffbs.net'.

All of the reports still get the 50004 error.

I was able to capture the actual URL that OTM uses to call a report out of the logs, so this will re-produce the 50004 error:

ttp://tmsrpt-dev01.ff.ffbs.net:7778/reports/rwservlet?hide_pass_key&'report=bill_of_lading&'de stype=CACHE&'desformat=PDF&'P_FORMAT=View%20PDF&'P ARAMFORM=NO&'TOLERANCE=0&'SERVER=rep_tmsrpt-dev01_FRHome1&'P_REPORTS_SERVER=rep_tmsrpt-dev01_FRHome1&'P_R

[nick.polites]

Re: OTM Reports getting REP-50004 Error

You have installed the reports component for OTM correct? You have on your report server a /otm/glog/reports directory? Have you tried running the test report from within Oracle Reports?