Sample Report Usage Audit Report, difficulty (url_xml test connection fails)

[Dem]

Hi

Im trying to set up the Usage Report having followed the steps in the "Administration and Security Guide, Setting Up Audit Reporting, p75". All seems to work except for the Usage Report. I have edited the web.xml file, modified the build.bat and edited DSServlet.java file, restarted the service and so on - followed the instructions...

I have one question regarding the DSServlet file thou, the instructions says: "if you are not allowning anonymous logon, make sure that the username, password, and namespace are correct and uncomment the fo......" What kind of user is that - a cognos connection admin user or so or an authentication provider user, in our case a user who can read the AD or ?
I had tried both.

When I test the url_xml datasource it fails with the message:

QE-DEF-0285 Logon failure

QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible

QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
testDataSourceConnection

UDA-SQL-0031 Unable to access the "testDataSourceConnection" database

UDA-SQL-0528 The XML parser returned the followning message: "An exception accurred! Type:NetAccessorException, Message:Could not open file: http://ourserver:9300/p2pd/cognos/DSServlet.jsp"

UDA-SQL-0529 XML "http://ourserver:9300//p2pd/cognos/DSServlet.jsp" is not a valid XML document.


Our environment: Cognos 8.3, mssql database

Thanks in advance

[cccschip]

@Dem
I was really hoping someone would have answered your question!  It's exactly mine.  Did you figure this out?

[Prerna Chaudhary]

Hi,

Regarding the following errors as per my personal experience,all that I can suggest is it might be a DSN issue.Please recheck your DSN connections and the locations they are pointing to.

QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible

QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
testDataSourceConnection

Hope it helps you to resolve your issue :)

Thanks and regards
Prerna
pchaudhary@infocepts.com

[cccschip]

I fixed our problem.

I had been following IBM's instructions here:
https://www-304.ibm.com/support/docview.wss?uid=swg21370536&wv=1

Finally realized that those instructions are not consistent.  Per those instructions, the url_xml datasource is defined for DSServlet.jsp, while the url-pattern in the web.xml is defined as DSServlet.xml.

Once I syncrhonized these two (using "jsp"), all was well.

Well, that's not quite true.  The datasource not tests successfully and the "Report usage" report runs without error.  But the report is empty.  The XML is built by the servlet with no entries!  Got to look into that now.  Sigh.

[Dem]

Solved.

Used a java sdk version 1.4 instead of 1.6/1.7 to compile my java file - and voila!

this link is helpful too, clarifying some things.
http://www-01.ibm.com/support/docview.wss?uid=swg21340174