Reporting Failure

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

January 24th, 2011 6:18pm

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.

Free Windows Admin Tool Kit Click here and download it now
December 27th, 2011 8:51am

Hi Michael,

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

Thanks.

April 17th, 2012 12:51pm

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
Free Windows Admin Tool Kit Click here and download it now
April 20th, 2012 1:17pm

Hi Andreas,

thank you for your post. That is the solution.

Danke und Gre aus Bonn

April 24th, 2012 12:01pm

Hi Andreas,

Thanks, now it finally works :-)

best regards

Dirk - DE/Hessen

Free Windows Admin Tool Kit Click here and download it now
February 25th, 2014 4:50pm

Hello. I do not quite understand where I need to change the language? Tell us a little more detail, please.
August 13th, 2014 11:04am

Hi,

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

regards,
Andreas

Free Windows Admin Tool Kit Click here and download it now
August 13th, 2014 12:23pm

Great! Thnx!
August 14th, 2014 3:45am

Moin (north-german for "Hi"),

this soulutionn also works on DPM 2012RU4.

Thank you

Michael

Free Windows Admin Tool Kit Click here and download it now
January 16th, 2015 11:32am

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,

January 16th, 2015 2:24pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics