Date conversion problems in VoiceObjects Analyzer

Symptoms

I am using VoiceObjects Analyzer reports containing date filters to analyze Infostore data in a Microsoft SQL Server database. When I execute the reports I get an error message saying there was an error converting character data into date formats.

Resolution

When executing VoiceObjects Analyzer reports, BusinessObjects converts the specified values of date filters into a specific date representation format. This specific format is sent to the database server by the BusinessObjects server.

BusinessObjects requires the language setting of the database server to be English.

If the language setting of the database is not English (e.g. German) the data BusinessObjects writes into the SQL statements is incompatible to the data the database server expects for dates.

• Change the date format setting of the database server.
  Check the database language setting. Change the language setting to English if required. Refer to the documentation of your database system for details on how to do this.
• Restart the BusinessObjects server as described in the BusinessObjects documentation.