url_xml in Auditing

[ghostraider]

Hi everyone, I have set up Auditing on our Dev and Prod servers and i am able to run all the reports provided in the package. However, when i test the 'url_xml' subject in Database View i am getting an error.

UDA-SQL-0528 The XML parser returned the following message: "An exception occurred! Type:NetAccessorException, Message:The host/address 'prodserver' could not be resolved".
UDA-SQL-0196 The table or view "url_xml" was not found in the dictionary.

But i when test 'url_xml' in Data Source it tests successfully. Can someone suggest as to what is wrong?

Thanks!!

[CognosPolzovatel]

"However, when i test the 'url_xml' subject in Database View i am getting an error."
By Database View, do you mean, when testing url_xml outside of Cognos, via a database connection client?

Usually, the UDA-SQL-0528 error refers to an XML data source created against an XML file w/ a path valid to the server. The path, however, should also be valid on the remote FM computer. See KB 1013383.3. It suggests changing the XML datasource to use a UNC path. I'm not sure, however, if this describes your scenario.