KNOWN ISSUE: IT Analytics Reports only accept dates in US format

Article:TECH43170  |  Created: 2009-07-23  |  Updated: 2009-07-23  |  Article URL http://www.symantec.com/docs/TECH43170
Article Type
Technical Solution


Issue



Reports containing date parameters fail. The forms accept dates in Australian (or non-US) format dd/mm/yy however the report fails and throws the error:

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'PackageServerAvailabilityMonthly'. (rsErrorExecutingCommand)
Execution of the managed stored procedure DateValue failed with the following error: Exception has been thrown by the target of an invocation.Conversion from string "6/22/2008" to type 'Date' is not valid.

Reports identified to incur this issue are:

  • Package Server Availability Daily
  • Package Server Availability Monthly
  • Advertisement Execution Event Summary

Environment



IT Analytics 6.0

Cause



The date format is hardcoded to be in US format

Solution



Symantec is currently investigating this issue.  An update will be made to this article upon completion of investigation.  Those interested are advised to subscribe to this article.

Legacy ID



48259


Article URL http://www.symantec.com/docs/TECH43170


Terms of use for this information are found in Legal Notices