1 2 Previous Next 16 Replies Latest reply: Aug 22, 2013 5:56 AM by user11319190 RSS

    Report 11g RUN_REPORT_OBJECT is not working FRM-41214

    user11319190
      Dear all,
      We are not able to run the reports using RUN_REPORT_OBJECT from forms 11g, we have tried our maximum to resolve this issue, unfortunately no proper documentation. Forms working without any issue are able to see the report out puts if I try running the report using internet explorer, but from the forms using RUN_REPORT_OBJECT It is getting failed. I could see two reports servers were running RptSvr_xxxxxx_FrmInst, rep_wls_reports_xxxxxx_frminst both servers queue status page also we can browse, but the reports running using RUN_REPORT_OBJECT is not working, the job queue is not showing these jobs.
      When I use report diagnose it is showing "Exception when retrieving IOR"
      Environment - Fusion Middleware 11.1.1.5.0, Windows 2008 server

      Error : FRM 41214 Unable to run report

      Can anyone through some lights on this issue.

      We areTrying the below code :

      DECLARE
      v_report_id Report_Object;
      vc_ReportServerJob VARCHAR2(100);
      vc_rep_status VARCHAR2(100);
      vjob_id VARCHAR2(100);
      BEGIN
      v_report_id:= FIND_REPORT_OBJECT('CFR007');
      SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT,'PDF');
      SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE);
      SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE,SYNCHRONOUS);
      SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,'RptSvr_xxxxxxx_FrmInst');
      SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER,'paramform=no');
      vc_ReportServerJob:=RUN_REPORT_OBJECT(v_report_id);
      vjob_id := substr(vc_ReportServerJob,instr(vc_ReportServerJob,'_',-1)+1);
      vc_rep_status := REPORT_OBJECT_STATUS(vc_ReportServerJob);
      IF vc_rep_status = 'FINISHED' THEN
      WEB.SHOW_DOCUMENT ('/reports/rwservlet/getjobid'|| vjob_id ||'?server=rptsvr_XXXXXXXX_frminst','_blank');
      ELSE
      message ('Report failed with error message '||vc_rep_status);
      END IF;
      END;

      Thanks & Regards
        • 1. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
          Denis Segard-Oracle
          Hello,

          FRM-41214 means that the request has been received by the Reports Server but an error occurred during the Reports execution .

          To have details about the error , "execute" the URL : http://server:port/reports/rwservlet/showjobs?server=<reports server name>

          The Reports request should appear with a "Red Cross" icon . Click on the "Red Cross" icon to get details about the error.

          Regards
          • 2. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
            user11319190
            Hi denis,

            Thank you verymuch ... after those errors if i try to see the logs using the link "http://server:port/reports/rwservlet/showjobs?server=<reports server name>"
            i am not able to see anything related to those reports.Whterver report i run using run_report_object it is failing with FRM-41214 and am not able to see in the showjobs page. We are actully stuck.


            Best Regards.
            • 4. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
              user11319190
              Hamid,

              We are using Fusion Middleware ,10g application server it is working fine here.

              Best Regards.
              • 5. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
                HamidHelal
                user11319190 wrote:
                Hi denis,

                Thank you verymuch ... after those errors if i try to see the logs using the link "http://server:port/reports/rwservlet/showjobs?server=<reports server name>"
                i am not able to see anything related to those reports.Whterver report i run using run_report_object it is failing with FRM-41214 and am not able to see in the showjobs page. We are actully stuck.


                Best Regards.
                oK. I have few question. Do you calling the report from forms ?
                If yes, after FRM-41214 error thrown, does it through any more error ?
                Like FRM-40735..........ORA- ?

                In both case, check this carefully,
                After going to http://<your_application_server_name>:port/reports/rwservlet/showjobs?server=<reports server name> what is the job status of your calling report ?

                If it shows cross icon click on it and you will see the error.

                Hope this helps

                Hamid
                • 6. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
                  user11319190
                  Dear Hamid,

                  It is not giving me any other error,i can run the rport using direct link for e.g. (http://xxxxxx.xx.co:8888/reports/rwservlet?server=rptsvr_XXXXXX_frminst&report=xxxx.rdf&userid=xxxx/xxxxx@xxxx&desformat=pdf&destype=cache) this is woking fine and i could see the jobstatus in showjobs link.When i use RUN_REPORT_OBJECT from forms is the problem and am getting the above mentioned error.

                  Best regards.

                  Edited by: user11319190 on 07-May-2013 06:08
                  • 7. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
                    HamidHelal
                    user11319190 wrote:
                    Dear Hamid,

                    It is not giving me any other error,i can run the rport using direct link for e.g. (http://xxxxxx.xx.co:8888/reports/rwservlet?server=rptsvr_XXXXXX_frminst&report=xxxx.rdf&userid=xxxx/xxxxx@xxxx&desformat=pdf&destype=cache) this is woking fine and i could see the jobstatus in showjobs link.When i use RUN_REPORT_OBJECT from forms is the problem and am getting the above mentioned error.

                    Best regards.

                    Edited by: user11319190 on 07-May-2013 06:08
                    Can you post your forms code to run the report here ?
                    • 8. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
                      user11319190
                      I have posted it in the begning ,anway i am copying it for you again...

                      DECLARE
                      v_report_id Report_Object;
                      vc_ReportServerJob VARCHAR2(100);
                      vc_rep_status VARCHAR2(100);
                      vjob_id VARCHAR2(100);
                      BEGIN
                      v_report_id:= FIND_REPORT_OBJECT('CFR007');
                      SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT,'PDF');
                      SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE);
                      SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE,SYNCHRONOUS);
                      SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,'RptSvr_xxxxxxx_FrmInst');
                      SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER,'paramform=no');
                      vc_ReportServerJob:=RUN_REPORT_OBJECT(v_report_id); ---- exception is here
                      vjob_id := substr(vc_ReportServerJob,instr(vc_ReportServerJob,'_',-1)+1);
                      vc_rep_status := REPORT_OBJECT_STATUS(vc_ReportServerJob);
                      -----Please not that it is not reaching here......
                      IF vc_rep_status = 'FINISHED' THEN
                      WEB.SHOW_DOCUMENT ('/reports/rwservlet/getjobid'|| vjob_id ||'?server=rptsvr_XXXXXXXX_frminst','_blank');
                      ELSE
                      message ('Report failed with error message '||vc_rep_status);
                      END IF;
                      END;

                      Edited by: user11319190 on 08-May-2013 00:12
                      • 9. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
                        HamidHelal
                        user11319190 wrote:
                        I have posted it in the begning ,anway i am copying it for you again...

                        DECLARE
                        v_report_id Report_Object;
                        vc_ReportServerJob VARCHAR2(100);
                        vc_rep_status VARCHAR2(100);
                        vjob_id VARCHAR2(100);
                        BEGIN
                        v_report_id:= FIND_REPORT_OBJECT('CFR007');
                        SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT,'PDF');
                        SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE);
                        SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE,SYNCHRONOUS);
                        SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,'RptSvr_xxxxxxx_FrmInst');
                        SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER,'paramform=no');
                        vc_ReportServerJob:=RUN_REPORT_OBJECT(v_report_id); ---- exception is here
                        vjob_id := substr(vc_ReportServerJob,instr(vc_ReportServerJob,'_',-1)+1);
                        vc_rep_status := REPORT_OBJECT_STATUS(vc_ReportServerJob);
                        -----Please not that it is not reaching here......
                        IF vc_rep_status = 'FINISHED' THEN
                        WEB.SHOW_DOCUMENT ('/reports/rwservlet/getjobid'|| vjob_id ||'?server=rptsvr_XXXXXXXX_frminst','_blank');
                        ELSE
                        message ('Report failed with error message '||vc_rep_status);
                        END IF;
                        END;

                        Edited by: user11319190 on 08-May-2013 00:12
                        Hmm.. I don't see the report name whom is calling or run. I modified your code, give a try..
                        DECLARE
                          v_report_id Report_Object;
                          vc_ReportServerJob VARCHAR2(100);
                          vc_rep_status VARCHAR2(100);
                          vjob_id VARCHAR2(100);
                        BEGIN
                          v_report_id:= FIND_REPORT_OBJECT('CFR007');
                          SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT,'PDF');
                          SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE);
                          SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE,SYNCHRONOUS);
                             SET_REPORT_OBJECT_PROPERTY(V_REPORT_ID,REPORT_EXECUTION_MODE,BATCH); 
                        /* edit the report name like D:\repname.rep */
                             SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_FILENAME,<write the full path of reports>);
                        
                          SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,'RptSvr_xxxxxxx_FrmInst');
                          SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER,'paramform=no');
                          vc_ReportServerJob:=RUN_REPORT_OBJECT(v_report_id); ---- exception is here
                          VJOB_ID := SUBSTR(VC_REPORTSERVERJOB,INSTR(VC_REPORTSERVERJOB,'_',-1)+1);
                        /* i added loop */
                             WHILE VC_REP_STATUS in ('RUNNING','OPENING_REPORT','ENQUEUED') LOOP  
                               vc_rep_status := REPORT_OBJECT_STATUS(vc_ReportServerJob);  
                             END LOOP;
                        
                          -----Please not that it is not reaching here......
                          IF VC_REP_STATUS = 'FINISHED' THEN
                            WEB.SHOW_DOCUMENT ('/reports/rwservlet/getjobid'|| vjob_id ||'?server=rptsvr_XXXXXXXX_frminst','_blank');
                          ELSE
                            message ('Report failed with error message '||vc_rep_status);
                          END IF;
                        END;
                        Hope this works..
                        • 10. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
                          user11319190
                          Hamid,

                          Same FRM-41214: Unable to run report,Infact i have tried my level best .No use am not able to find the exact error.We can run the report even using rwclient.I am facing this problem only when i use RUN_REPORT_OBJECT from forms,There is no proper document about this.
                          Windows 2008 R2,Fusion Middleware 11.5 combination i hope there is some issue.

                          Not even showing the report status

                          Best Regards.

                          Edited by: user11319190 on 08-May-2013 23:47
                          • 11. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
                            Lars Sjöström
                            There us a goid page in oracle support to solve these issues. It has to do with a number of things. Main reason can be server name, upper or lower. Also the URL used to generate the report can be mimiced in run report objects.
                            • 12. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
                              user11319190
                              Lars,

                              Can you be little more specific,Please give me the Article ID of the support document.

                              Best Regards.
                              • 13. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
                                HamidHelal
                                user11319190 wrote:
                                Hamid,

                                Same FRM-41214: Unable to run report,Infact i have tried my level best .No use am not able to find the exact error.We can run the report even using rwclient.I am facing this problem only when i use RUN_REPORT_OBJECT from forms,There is no proper document about this.
                                Windows 2008 R2,Fusion Middleware 11.5 combination i hope there is some issue.

                                Not even showing the report status

                                Best Regards.

                                Edited by: user11319190 on 08-May-2013 23:47
                                Can you follow this at least for one time How to call a report ?
                                it's also for 11g

                                Hamid
                                • 14. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
                                  user11319190
                                  Dear Hamid,


                                  I followed exactly the same and i got the same result. Do you have any idea why it is not even reflecting in the showjobs queue when we are running the report using run_report_object.Since am getting the FRM-41214 error almost all the document says that FRM-41214 means it is able to connect to the report server , it should show the jobid's in the showjobs page.I could see the JOBID's when i run the test reports using rwservlet also with rwclient ,Unfortunatly not using RUN_REPORT_OBJECT.


                                  Best Regards.

                                  Edited by: user11319190 on 13-May-2013 02:43

                                  Edited by: user11319190 on 13-May-2013 23:35
                                  1 2 Previous Next