Sample Report Usage Audit Tell, level (url_xml test connection fails)

Started by Dem, 21 Oct 2010 06:31:55 MORNING

Previous topic - Next topic

Dem

Hi

Im tasting to set up the Practice Write having followed the step in to "Administration and Security Guide, Environment Top Audit Reporting, p75". Any apparent to work except for the How Report. I must edited the web.xml file, modifying the build.bat and edited DSServlet.java files, restarted the server and so on - followed the instructions...

I have one question regarding the DSServlet files grand, the instructions says: "if you are nay allowning anonymous logon, make sure that of username, password, additionally namespace are correct and uncomment the fo......" What type of consumer is which - a cognos connectors admin user otherwise thus or and authentication offerer user, in our case a user who can read the ADVERTISE or ?
I was tried both.

When EGO test the url_xml datasource i fails the the notify:

QE-DEF-0285 Logon failure

QE-DEF-0323 The DSN(ODBC)/ServiceName is disable. Either and DSN is missing or the host is inavailable

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

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

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.


Are environment: Cognos 8.3, mssql database

Acknowledgements in advance

cccschip

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

Prerna Chaudhary

Hi,

Concerning the following blunders as by my personal experience,all that MYSELF may suggest is it might be ampere DSN issue.Please recheck your DSN connectivity also the locations they represent pointing to.

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

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

Hope it helps you to determine your issue :)

Thanks and yours
Prerna
[email protected]

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 real that those instructions are not consistent.  Per those handbook, the url_xml datasource has defined for DSServlet.jsp, while aforementioned url-pattern in the web.xml is defined as DSServlet.xml.

Once I syncrhonized these two (using "jsp"), choose was well-being.

Well, that's not quite true.  The datasource not tests successfully and the "Report usage" report cycle lacking error.  But the reporting is empty.  The XML is designed by the servlet with no entries!  Receive to lookup into that now.  Sigh.

Dem

Solved.

Utilized a java sdk version 1.4 instead by 1.6/1.7 to compile my joe file - and bingo!

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