Report Viewer : Unable to generate report

jloosfelt

When I try to view a report using the Tools/Reporting functionnality, I create a database to have a multiple server report.
The "update server history" task works fine. But in the next step Report Viewer shows an error :"Unable to generate report":
An error occured while generating the report. The message returned by SQL server was:
"La conversion d'un type de données CHAR en type DATETIME a donné une valeur hors limite de date et d'heure."

Is it a bug due to the french setttings for SQL Server ?

Thanks for your answer !

Jeremie

Jason Cook

Hi,
It appears that the issue is indeed due to the french settings in SQL Server. The error you mention is easily reproducible in the following scenario:

SET LANGUAGE FRENCH;
SELECT CONVERT(DATETIME, '2006-03-30');
GO
SET LANGUAGE ENGLISH;
SELECT CONVERT(DATETIME, '2006-03-30');

The first generating the error message you mention, the second working correctly. The problem being due to the date format not being recognised correctly in the french language.

I will investigate and see if there is a workaround for this in the meantime and get back to you, and will also raise this to be fixed in the next release of SQL Backup.

Thanks,
Jason