KNOWN ISSUE: IT Analytics Reports only accept dates in US format
| Article:TECH43170 | | | Created: 2009-07-24 | | | Updated: 2009-07-24 | | | Article URL http://www.symantec.com/docs/TECH43170 |
Problem
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
Thank you.