Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Srw.report_status

lcharbAug 29 2006 — edited Aug 30 2006
I am trying to use the SRW package to call reports from the database. I can run the report ok, but when I try to get back information about the job it errors:

Setup Information:
The package SRW was installed under an account named TESTACCT in a 10.1.0.4 database.

The Reports Server is part of a 10.1.2.0.2 10g Application Server installation on Linux. I have shutoff security by doing the following:
Commented out the "security id" entry and removed the "securityId=" in the "job" elements in the rep_testserver_10gAS.conf file (section 11.3.2 Enabling and Disabling Reports Server Security from the "Oracle® Application Server Reports Services Publishing Reports to the Web 10g Release 2 (10.1.2) B14048-02" document).
Edited the rwservlet.properties by uncommenting and setting the following entires:
DIAGNOSTIC=NO
SINGLESIGNON=NO


Then I edited the rep_testserver_10gAS.conf file, edited the "identifier" entry to be :

<identifier confidential="yes" encrypted="no">scott/tiger=</identifier>

Restarted all processes on this server with EM. Open a web browser with the following URL :http://testserver.bluebunny.com:7777/reports/rwservlet/getserverinfo?server=rep_testserver_10gAS+authid=scott/tiger
Verified that password was now encrypted in rep_testserver_10gAS.conf
(Section 3.4.3 of "Oracle® Application Server Reports Services Publishing Reports to the Web 10g Release 2 (10.1.2) B14048-02" document) Verified that server reported that the Security Mode was Non-secure. Verified that I could call showjobs? with authid=scott/tiger parameter in the URL, I confirmed that without authid=scott/tiger parameter , I received " REP-52262: Diagnostic output is disabled." message. Created a key in the cgicmd.dat file of runm with the following entry:
runm: destype=mail desformat=pdf server=rep_testserver_10gAS userid=scott/tiger@test %
Ran report through browser with :
http://testserver.bluebunny.com:7777/reports/rwservlet?runm+report=Report2.rep+desname="testacct@testmail.com"+from="testacct@testmail.com"
and it created the pdf file and emailed it.

Ran the following PL/SQL block as TESTACCT:
DECLARE

myPlist SRW_PARAMLIST;
myIdent Srw.Job_Ident;
myStatus Srw.Status_Record;
BEGIN

myPlist := SRW_PARAMLIST(SRW_PARAMETER('',''));
Srw.add_parameter(myPlist,'GATEWAY','http://testserver.bluebunny.com:7777/reports/rwservlet?runm');
Srw.add_parameter(myPlist,'REPORT','Report2.rep');
Srw.add_parameter(myPlist,'DESNAME','"testacct@testmail.com"');
Srw.add_parameter(myPlist,'FROM','"testacct@testmail.com"');
Srw.add_parameter(myPlist,'AUTHID','scott/tiger');
myIdent := Srw.run_report(myPlist);

DBMS_OUTPUT.PUT_LINE('Gateway Url :'||myIdent.GATEWAYURL);
DBMS_OUTPUT.PUT_LINE('SERVERNAME :'||myIdent.SERVERNAME);
DBMS_OUTPUT.PUT_LINE('JOBID :'||TO_CHAR(myIdent.JOBID));
DBMS_OUTPUT.PUT_LINE('AUTHID :'||myIdent.AUTHID);

myStatus := Srw.report_status(myIdent);

END;

The pdf file is generated and emailed correctly, but the following error gets generated from the Srw.report_status(myIdent) call:

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00243: element attribute value must be enclosed in quotes
Error at line 4
ORA-06512: at "XDB.DBMS_XMLDOM", line 4180
ORA-06512: at "XDB.DBMS_XMLDOM", line 4205
ORA-06512: at "TESTACCT.SRW", line 186
ORA-06512: at "TESTACCT.SRW", line 257
ORA-06512: at "TESTACCT.SRW", line 860


The DBMS_OUTPUT is:
Gateway Url :http://testserver.bluebunny.com:7777/reports/rwservlet?runm
SERVERNAME :rep_testserver_10gas
JOBID :34
AUTHID :scott/tiger

If I comment out the call to Srw.report_status, I do not get the error.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2006
Added on Aug 29 2006
1 comment
1,193 views