This discussion is archived
0 Replies Latest reply: Oct 10, 2013 9: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 Newbie
Currently Being Moderated

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

Legend

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