Skip to Content
0
Former Member
Apr 28, 2009 at 11:15 AM

HTTP XML Data Source authentication error

34 Views

Morning All,

I have just started playing around with using XML as a data source for my CR4Ev2.0.1 reports.

I have managed to create the local inline reports and change their data source loacation with no current

issues.

I am now trying to create the HTTPXML reports using code from Ted's BLOG.

I manage to create a new report, and can open it in design, I can see the data source structure but as

soon as I try browse the data or preview my report I get the following error

Cannot Open file
Server returned HTTP response code: 407 for URL:
http://myserver/httpxml.xml

I had a quick look up the 407 error and it seems to be a Proxy authentication error, we do have a proxy

server setup which requires a username and password.

Before I go through what I have tried I want to confess that for this httpxml.xml file all I did was take my

inline.xml file and rename it and make it avaliable via a URL. So this might be the whole problem but I

am sure this is ok.

So I have tried turning off the proxy server as this URL is local so I dont need to go through the proxy.

If I go to the URL in my browser it works fine and I do not need to enter any proxy details.

Thats the problem with my HTTP XML attempt.

If I use the code as is, from Ted's BLOG, for

Crystal Reports off of HTTP XML data URL

and try use the following 2 URLs

propertyBag.put(
"Http(s) XML URL", "http://resources.businessobjects.com/support/downloads/samples/cr/customer_db/orders.xml");
propertyBag.put(
"Http(s) Schema URL", "http://resources.businessobjects.com/support/downloads/samples/cr/customer_db/orders.xsd");

propertyBag.put(
"Http(s) XML URL", "http://resources.businessobjects.com/support/downloads/samples/cr/customer_db/customer.xml");
propertyBag.put(
"Http(s) Schema URL", "http://resources.businessobjects.com/support/downloads/samples/cr/customer_db/customer.xsd");

But I get the following errors

Exception in thread "main" com.crystaldecisions.sdk.occa.report.lib.ReportSDKLogonException: Logon 
Error: {0}---- Error code:-2147217393 Error code name:dbLogonFailed 
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(Unknown Source)
	........
	at com.crystaldecisions.sdk.occa.report.application.DatabaseController.byte(Unknown
 Source)
	at com.crystaldecisions.sdk.occa.report.application.DatabaseController.addTable(Unknown
 Source)
	at com.businessobjects.samples.CreateHttpXML.main(CreateHttpXML.java:90)
Caused by: com.crystaldecisions.reports.common.LogonFailureException: Logon Error:{0}
	at com.crystaldecisions.reports.queryengine.Connection.br(Unknown Source)
	at com.crystaldecisions.reports.queryengine.Connection.bs(Unknown Source)
	................

Any ideas as to what my issues are or what I am missing.

Thanks in advance.

Darren

Edited by: Darren Jackson on Apr 28, 2009 2:12 PM

Is there any documentation as to what entries I can use in the property bag.

Like is there a ("ProxySet", false) or something along those lines?

Edited by: Darren Jackson on Apr 28, 2009 5:28 PM

I have made a little more head way.

I saved the Orders.xml and Orders.xsd files onto my webserver and editied the code to only worry about

the Orders and ignore the Customer files.

I now create my reports, open them in Eclipse to design them, but when I try preview the data it is now

asking me for a username and password. I have tried all combinations that I can think of for our systems

but none work.

Grrrrrrrrrrrrrrr