Announcement

Collapse
No announcement yet.

OTM Reports getting REP-50004 Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • OTM Reports getting REP-50004 Error

    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

  • #2
    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.
    If my post was helpful please click on the Thanks! button

    MavenWire Hosting Admin
    15 years of OTM experience

    Comment


    • #3
      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=
      ---

      Comment


      • #4
        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...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
        If my post was helpful please click on the Thanks! button

        MavenWire Hosting Admin
        15 years of OTM experience

        Comment


        • #5
          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...-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

          Comment


          • #6
            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.

            Comment


            • #7
              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?
              If my post was helpful please click on the Thanks! button

              MavenWire Hosting Admin
              15 years of OTM experience

              Comment


              • #8
                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?

                Comment


                • #9
                  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_
                  If my post was helpful please click on the Thanks! button

                  MavenWire Hosting Admin
                  15 years of OTM experience

                  Comment


                  • #10
                    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
                    ---

                    Comment


                    • #11
                      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.
                      If my post was helpful please click on the Thanks! button

                      MavenWire Hosting Admin
                      15 years of OTM experience

                      Comment


                      • #12
                        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

                        ---

                        Comment


                        • #13
                          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.
                          If my post was helpful please click on the Thanks! button

                          MavenWire Hosting Admin
                          15 years of OTM experience

                          Comment


                          • #14
                            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

                            Comment


                            • #15
                              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?
                              If my post was helpful please click on the Thanks! button

                              MavenWire Hosting Admin
                              15 years of OTM experience

                              Comment

                              Working...
                              X