Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jamie_pattison
Yak Posting Veteran
65 Posts |
 Posted - 2008-09-15 : 05:35:17
|
| On our SQL Reports server i navigate to the reports home page and try to load a report. I keep receiving an error. Looking at the logs this is what it states: Call to RenderFirst( '/Server/Report' )w3wp!processing!1!09/15/2008-10:21:50:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.InvalidCastException: Unable to cast object of type 'System.String' to type 'System.Enum'. at Microsoft.ReportingServices.Diagnostics.EnumParameter.get_Value()If i go to my project to deploy this report it creates the folder and then returns back with an error "An unexpected error occurred in report processing"Does anyone have any recommendation in how to resolve?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-15 : 06:10:14
|
| It seems like you're trying to cast string type value to enum type as suggested by error message in your backend query.Can you spot out where this is happening? |
 |
|
|
jamie_pattison
Yak Posting Veteran
65 Posts |
Posted - 2008-09-15 : 06:28:05
|
quote:
Originally posted by visakh16
It seems like you're trying to cast string type value to enum type as suggested by error message in your backend query.Can you spot out where this is happening?
If i deploy the same reports locally onto my PC then all runs well. I can view and run reports locally. I would agree with your theory IF i could deploy reports from and to the server, but since i cant deploy ANY report to the server im not sure where to start.Thanks |
|
|
|
jamie_pattison
Yak Posting Veteran
65 Posts |
Posted - 2008-09-15 : 07:07:42
|
| I recreated the reports instance and deployed the reports. This was the only way i got it resolved. |
|
|
|
|
|
|
Error loading report