SSRS 2008 Error – The report definition is not valid

Recently I downloaded a file from one of our production server, did some changes and reviewed it in BIDS and everything looked good. However when I tried to upload the file in the Report Manager got a strange error

The report definition is not valid. Details: ‘.’, hexadecimal value 0x00, is an invalid character. Line 1570, position 10. (rsInvalidReportDefinition)

Since the error message was talking about Report Definition is not valid, checked whether I have corrected the report in appropriate version (we have SSRS 2005, 2008 & R2).

I opened the code behind of the RDL by clicking the “View Code” option in BIDS and looked at the line mentioned in the error message. I was surprised to see few blank spaces after the end of the Report tag and BIDS had highlighted it as an error.

I just simply deleted it, saved and built. Then it worked fine. However I still could not figure out how it was added 😦

Advertisements

About Suresh Kumar D

Hardcore SQL Developer and aspiring Database Architect.
This entry was posted in SSMS. Bookmark the permalink.

One Response to SSRS 2008 Error – The report definition is not valid

  1. Jack Houston says:

    Hi ,
    I am trying to Migrate my reports from Validation Env to Prod using the command line utility rs.exe
    rs.exe -i C:\ssrs_migration.rss -e Mgmt2010 -s https://04.com/ReportServer -v f=”/BA” -v ts=”https://02.com/ReportServer” -v tf=”/BA”
    Everything gets migrated absolutely fine except the DataDriven Subscription for the report
    ERROR: An exception has occurred in data source ‘DataDrivenSubscription’. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot impersonate user for data source ‘SSRSSubscription’. —> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Log on failed.
    Ensure the user name and password are correct. —> System.NullReferenceException: Object reference not set to an instance of an object.
    I manually tested the Data source on the validation environment for the ID & password the test connection is successful and we are using a service account to connect to the SQLServer Datasource.
    Can some one please help me with what i am missing here.
    Thanks,
    Jack

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s