SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS Error


SSRS Error

Author
Message
BU69
BU69
Mr or Mrs. 500
Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)

Group: General Forum Members
Points: 529 Visits: 283
I get the following error in BIDS when trying to open a report:

Deserialization failed: The report definition element 'ConnectionProperties' is empty at line 9, position 8. It is missing a mandatory child element of type 'DataProvider'.
Line 9, position 8. 9 0

The report works fine, it was deployed previously but now I get this error in BIDS and I can't get into it to try and see what it's problem is, it's configured the same way as all my other reports that work fine as well, I don't want to have to recreate the report which I did last time I got this error.

Has anyone come accross this before or does anyone know how to fix it?


Thanks
Jack Corbett
  Jack Corbett
SSC-Forever
SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)

Group: General Forum Members
Points: 44469 Visits: 14925
Have you tried re-downloading the report from the Report Server?

You can also open the RDL in a text editor and manually add the missing attribute.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
BU69
BU69
Mr or Mrs. 500
Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)Mr or Mrs. 500 (529 reputation)

Group: General Forum Members
Points: 529 Visits: 283
Thanks, I looked at the code and it the data collection was slightly different from a report that works so I copied the code and replaced it and it now works.

Thanks
shawn.berry
shawn.berry
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 21
I ran into this problem today. I had an .rdl file in a Visual Studio Project that had a problem with it. This is a development area where no security is needed on the data sources. Since I had a deployed version of it out on the Report Server, I figured I would just edit the report definition there to create a new rdl file, delete the problem file out of my project, then use Reports > Add > Existing Item... in the Solution Explorer to bring a working copy of the report back in.

It seems to work at first, until I made any kind of change to the report in the VS design tab. Then I'd get the error quoted at the top of this thread. What was going on?

I can't speak to why the <Connection String> tag was automatically being inserted into the rdl code, but deleting it AND changing the value of the <rd:SecurityType> tag inside a <Datasource> tag did the trick:

<rd:SecurityType>Value</rd:SecurityType>



"Value" was changed from >Windows< back to >None< . It was all too easy to forget that the security settings on a deployed report get modified and can cause problems when brought back into your development environment.

Hopefully this helps someone else trying to puzzle out this particular error and how to fix it.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search