Hi,

the reporting Feature of our DPM 2010 installation doesn´t work. Every time we want to generate a report (Recovery Point Status - generate report) we get an Faiulre Message:

Fehler beim Clientrendering.

Fehler bei der Berichtsverarbeitung. (rsProcessingAborted)

Fehler beim Ausführen der Abfrage für das DataSet1-Dataset. (rsErrorExecutingCommand)

Bei der Konvertierung eines nvarchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.

 

Translation:

 

Error rendering client. Error in report processing. (RsProcessingAborted) Error running query for the DataSet1 dataset. (RsErrorExecutingCommand) When converting a nvarchar data type to a datetime data type of the value is out of range.

Thanks for your help!

Greetings from Germany

Michael

I see this is a very old post.

Hopefully the issue you reported here was already taken care of.

Let me know if this is the case.

Hi Michael,

I've the same problem. What was the solution to the problem?

Thanks.

Hi,

I also had this problem. I updated the DPM Server in my lab environment from 2010 to 2012 and moved the database from the local machine (SQL 2008 English) to a remote SQL Server (SQL 2008 R2 German). After that I encountered the same problem, but only when creating the RecoveryPointStatus Report.

I changed the language default language of the user that connects to the database. In my case it was a group ([SQLSERVER\DPMDBReader$[DPMSERVER]). The default language was German. I changed it to English. Not it seems to work.

Hope this helps.

King Regards,
Andreas

• Proposed as answer by Reza_Zad Tuesday, April 24, 2012 9:01 AM

Hi Andreas,

thank you for your post. That is the solution.

Danke und Gre aus Bonn

Hi Andreas,

Thanks, now it finally works :-)

best regards

Dirk - DE/Hessen

Hello. I do not quite understand where I need to change the language? Tell us a little more detail, please.

Hi,

in the user or group properties on the "general" tab. SQL Server Management Studio -> Security -> Logins.

regards,
Andreas

• Proposed as answer by Andrey Vertexx Thursday, August 14, 2014 12:45 AM
• Marked as answer by Robert HedblomMVP, Moderator Thursday, August 14, 2014 8:10 AM

Great! Thnx!

Moin (north-german for "Hi"),

this soulutionn also works on DPM 2012RU4.

Thank you

Michael

Worked for me, too!

DPM 2012 R2 UR4 (german versions)
All reports are working now :-)

Perhaps this is helpful, too ->

https://social.technet.microsoft.com/Forums/en-US/9cf885c2-93e7-4f5f-82ae-b4c9bd7f28b3/permission-required-to-see-dpm-reports?forum=dataprotectionmanager

Thanks,