0 Replies Latest reply: Oct 10, 2013 11:55 PM by 5a58a664-d73c-476c-bcc8-5b3a5f030e88 RSS

    SRW doen't work after Database upgrading from 10g to 11g

    5a58a664-d73c-476c-bcc8-5b3a5f030e88

      Hi everyone,  I met a problem with oracle report service.Hope anyone can help me with this...  We use report service stand-alone(still 9i...),it worked well with 10g database&10g Application Server, using SRW package.This week, we upgraded database to 11g, didn't change any program code or application configuration.I run a test programs as below(it was ok in 10g):

       

      Test codes:

      myPlist SRW_PARAMLIST;

      myIdent SRW.JOB_IDENT;

      r_stat srw.Status_Record;

      BEGIN

      UTL_HTTP.set_transfer_timeout(900);

      SRW.Start_Debugging;

      myPlist := SRW_PARAMLIST(SRW_PARAMETER('',''));

      SRW.ADD_PARAMETER(myPlist,'GATEWAY','http://domainname/reports/rwservlet');

      SRW.ADD_PARAMETER(myPlist,'REPORT','data_compare.rdf');

      SRW.ADD_PARAMETER(myPlist,'SERVER','rep_t01');

      SRW.ADD_PARAMETER(myPlist,'USERID',' not shown here');

      SRW.ADD_PARAMETER(myPlist,'DESTYPE','FILE');

      SRW.ADD_PARAMETER(myPlist,'DESFORMAT','PDF');

      SRW.ADD_PARAMETER(myPlist,'DESNAME','/apps/app/lreports/Compare_at_112011.pdf');

      SRW.ADD_PARAMETER(myPlist,'Param1','TEST');

      SRW.ADD_PARAMETER(myPlist,'Param2','294');

      myIdent := SRW.RUN_REPORT(myPlist);

      r_stat := SRW.report_status(myIdent,myPlist);

      dbms_output.put_line('Report Status Text:'||r_stat.StatusText);

       

      got an error in"SRW.report_status":

      ORA-31011:XML parsing failed

      ORA-19202: Error occurred in XML processing

      LPX-00225: end-element tag "PRE" does not match start-element tag "br"

      Error at line1

      ORA-06512: at "XDB.DBMS_XMLPARSER", line 157

      ORA-06512: at "SRW", line314

      ORA-06512: at "SRW", line875

       

      I debugged in SRW, got the XML text return from Report Server as below:

      <?xml version = '1.0' encoding = 'ISO-8859-1' standalone = 'yes'?>

      <serverQueues>

        <error code="50003" component="REP" message="Bad command line: authid=RWUser/ jobname=data_compare.rdf desname=/apps/app/Compare_at_112011.pdf desformat=PDF server=rep_t01 expiredays=0 report=data_compare.rdf param1=TEST statusformat=xml destype=FILE Param2=294  userid= 'not shown here' SERVER_NAME=&quot;test&quot; SERVER_PORT=80 SCRIPT_NAME=&quot;/rwservlet&quot; SERVER_PROTOCOL=&quot;HTTP/1.1&quot; REMOTE_ADDR=&quot;'DB IP, not show here'&quot; REMOTE_HOST=&quot;DB IP, not show here'&quot;"/>

      </serverQueues>

       

      I tried typing URL in the Browser to run reports, it's OK.

      Does anyone konw what the problem is ?

       

      Thanks!!!