More Group Sites
Education Books
School Rankings
Jobless Net
Better Home
Enviro++
更好教育论坛
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Share
Options
View
Go to last post Go to first unread
hong  
#1 Posted : Sunday, 5 July 2015 7:12:57 PM(UTC)
hong

Rank: Administration

Reputation:

Groups: AcademicCoachingSchool, admin, Administration, BookSeller, CatholicSchool, CoachingAdult, CoachingProfessional, CoachingSports, ExtraCurriculumCoaching, IndependentSchool, Moderator, MusicTeacher, PrivateSchool, PublicSchool, SelectiveSchool, tutor
Joined: 23/11/2008(UTC)
Posts: 523

I tried using report wizard and created a report page using report viewer 8 for SQL Server 2008. It was working. Now I got the following error after compiling the rdc using VS2013
"The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded.".

I think many people experienced the same issue and seeking help on internet. We may need to look at several places to fix the problem:
1. Are you still using SQL Server 2008? Maybe only SQL Server 2008 reporting service is available. You may need to upgrade to SQL Server 2012. Note that the Reporting Services Configuration Manager is located at C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2008\Configuration Tools.

2. Remove the old report references in bin folder
a) Refresh bin folder, delete the old DLLs:
C:\Program Files (x86)\Microsoft Visual Studio 9.0\ReportViewer\Microsoft.ReportViewer.Common.dll
C:\Program Files (x86)\Microsoft Visual Studio 9.0\ReportViewer\Microsoft.ReportViewer.WebForms.dll
b) Install new DLLs report viewer 11 common and ReportViewer.WebForms 11 using NuGet or copy from VS: C:\Program Files (x86)\Microsoft Visual Studio 12.0\ReportViewer\Microsoft.ReportViewer.WebForms.dll
Also you can download and install Microsoft Report Viewer 2012 Runtime redistributable package. You can find the installed DLLs at C:\Windows\assembly\GAC_MSIL or C:\Windows\assembly, e.g.
C:\Windows\assembly\GAC_MSIL\Microsoft.ReportViewer.Common\11.0.0.0__89845dcd8080cc91
C:\Windows\assembly\GAC_MSIL\Microsoft.ReportViewer.WebForms\11.0.0.0__89845dcd8080cc91

3. Add a report viewer onto a web form, try to compile the web app or view the page in a browser. Check web.comfig, scan for report viewer 8.0.0.0 or other older references, comment them out or delete them from web.config, e.g.
Code:
      <buildProviders>
        <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
      </buildProviders>


it should be auto-generated like
Code:
            <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />


More report issues
1. When viewing the report page in a browser, web.config file is auto-updated with a duplicated WebServer config section. This can cause "already defined" errors.
a. duplicated validateIntegratedModeConfiguration tag
b. Config section 'system.webServer/handlers' already defined. Sections must only appear once per config file. See the help topic <location> for exceptions
2. For SQL Server 2008, report wizard always generates rdlc with http://schemas.microsoft...2008/01/reportdefinition although report viewer 11 is used.
This will cause the error: two report viewers 8.0.0.0 and 11.0.0.0 in GAC. Clear the temporary ASP.NET files in C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\root or
D:\Users\brw\AppData\Local\Temporary ASP.NET Files\root. This might mean we need to upgrade SQL server.
Sponsor
Rss Feed  Atom Feed
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.