This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Aug 22, 2013 3:56 AM by user11319190 RSS

Report 11g RUN_REPORT_OBJECT is not working FRM-41214

user11319190 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.
  • 3. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
    HamidHelal Guru
    Currently Being Moderated
    Follow How to call a report ?


    Hope this helps


    Hamid
  • 4. Re: Report 11g RUN_REPORT_OBJECT is not working FRM-41214
    user11319190 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    larssjostrom Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points