Deploying To Report Manager Error

I have created a report using SSRS 2005.  It uses a stored procedure.  It executes beautifully when I'm in reporting services.  But, when I deploy it to Report Manager, this is the error I am getting.


An error has occurred during report processing.
Query execution failed for data set 'DataSource1'.
An MDX Statement was expected. An MDX expression was specified.

I have 3 parameters in this report.  Start Date, End Date & Region.  Region is a drop down that contains 2 options. This is a string field being passed into the procedure.  Start and end dates are just basic date fields. 

I am not using a cube to get my data.

I have deployed to the Report Manager before and have been successful.

 

Thanks!



ADVERTISEMENT

Reporting Services Keeping Format When Deploying To The Report Manager

Hi,

I am trying to place text boxes in the header of a matrix in order to give each row group(i.e.  each drill-down area in my matrix a header). This can be done in Reporting Services 2005.

However when I deploy this report to the corresponding url(Report Manager) it seems to be losing its formatting and not displaying correctly.  The textboxes placed in the matrix header seem to go all over the place.

I do get a warning when I deploy the report ->

 [rsOverlappingReportItems]. Some renderers do not support overlapping report items.

How can this be rectified?

View Replies View Related

Deploying A Report Services Application To The Local Host; Error:A Connection Could Not Be Made To The Report Server

 I installed SQL reporting services 2005 and  successfully configured reporting services.After designing the report using Bussiness Intelligence Studio, i tried to deploy my reporting services application to the localhost , I got the below mentioned error :  

TITLE: Microsoft Report Designer
------------------------------

A connection could not be made to the report server http://localhost/ReportServer.

------------------------------
ADDITIONAL INFORMATION:

The attempt to connect to the report server failed.  Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

------------------------------

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)

 Can anybody provide a solution for this issue....

Thanks in advance

Nirupa

View Replies View Related

Report Definition Error When Deploying Report To RS 2000 In VS .NET 2003

Using MS SQL 200 SP4 with Reporting Services 2000 SP2 on Win 2003 Server SP1

Visual Studio .NET 2003 on different PC (Win XP SP2)

No problem creating reports or building solutions.
Problems develop when deploying report to Report Server.

Here is the Output:

------ Build started: Project: From CD, Configuration: Debug ------

Build complete -- 0 errors, 0 warnings



------ Deploy started: Project: From CD, Configuration: Debug ------

Deploying to http://<server name>/ReportServer?%2f2nd
Deploying data source '/2nd/AdventureWorks2000'.
Deploying report 'Vendor Purchase Orders'.
The report definition is not valid.  Details: Could not find schema
information for the element
'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:Report'.
Deploy complete -- 1 errors, 0 warnings



---------------------- Done ----------------------

    Build: 1 succeeded, 0 failed, 0 skipped
    Deploy: 0 succeeded, 1 failed, 0 skipped

These are my first attempts using report services. In a previous deployment
attempts it created the folder (named 2nd), but in another attempt (saving it
to the existing folder) I got the same result as you see above (I have also
tried with a new folder but no luck). This above output is from my last
attempt.

The Build error Task List states:

The Report Definition is not valid. Details: Could not find schema
information for the element
'http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition:report'.

The shema URL as above returns HTTP 404.
If I remove :report, I receive the page for Report Definition Language
Schema May 2004

Looking at the .rdl code the schema URL is as above without :report.

As you can imagine with a limited skill set in this area I am quite
confused. I have been doing alot of research but found nothing to help (or
that I understand will help) so far.

If anyone can help me get through this I would appreciate it.

Bill

View Replies View Related

Error When Deploying A Report

I hope someone can help.  I'm new to reporting services 2005, and I'm currently going through Microsoft's tutorial.

 

I can build a report no problem.  But when it comes to deploying the report to a web page, the following message appears:

 

------ Build started: Project: Reporting Services Tutorial, Configuration: Production ------
Build complete -- 0 errors, 0 warnings
------ Deploy started: Project: Reporting Services Tutorial, Configuration: Production ------
Deploying to http://localhost/reportserver
Error  : Response is not well-formed XML.
Deploy complete -- 1 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

 

This "reponse is not well-formed XML" error also occurs when I try to expand any of the folders from a "reporting services" server type in management studio.

 

Any ideas would be greatly appreciated!

 

Cheers

 

Richard Powell

 

View Replies View Related

Error Deploying Report Model

I'm trying to deploy a report model and I keep getting an error. The
error is the following: "The Permissions Granted to user xxx are insufficient
for performing this operation". I'm new to this world and need someone to give me very simple instructions on how to fix this. Do I fix this in "Control Panel" or right within SQL. Please help.
thx

View Replies View Related

Error Deploying Report Model

I am trying to follow the step by step here

http://msdn2.microsoft.com/en-us/library/ms167048.aspx

to deploy a report model for the adventureworks DB. I get to the last step which is to right click the project and click deploy and I get these two errors.

 

Error 1 The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. c:documents and settingscharles.zackmy documentssql server management studioprojectsadvworksmodeltutorialadvworksmodeltutorialAdvWorksModelTutorial.ds 0 0 


Error 2 The operation you are attempting requires a secure connection (HTTPS). c:documents and settingscharles.zackmy documentssql server management studioprojectsadvworksmodeltutorialadvworksmodeltutorialAdvWorksModelTutorial.smdl 0 0 


Any suggestions are greatly appreciated.

 

Chuck

View Replies View Related

Error Deploying Report With DataSource SSIS

 

Hello Everyone,
 
I make a report to consume a SSIS package, actually I use SSIS to load a datasheet on my Sql Server database, then i expose the aggregate values in a datareader destination. Every work fine in Visual Studio.  But when i deploy my report and my Shared Data Source,  and I try to run the report i get the next message:

An error has occurred during report processing.

No se puede crear una conexión al origen de datos 'ETLSource'.

The package failed to validate.
 I dont Understand why, because when i work in BIDS the work perfect,  Actually i'm using sql server authentication in my package connection to avoid the mistakes about report credentials.
 
That is the code of the ETLSource.
<?xml version="1.0" encoding="utf-8"?>
<RptDataSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Name>ETLSource</Name>
  <DataSourceID>c238d65d-a0f3-48da-ae23-323d6ba13bb0</DataSourceID>
  <ConnectionProperties>
    <Extension>SSIS</Extension>
    <ConnectString>-f "C:TempValidaCambioEfec.dtsx"</ConnectString>
  </ConnectionProperties>
</RptDataSource>
 
Also I have SSIS and SSRS in the same machine.  And I'm using the same domain Account to run SSIS, SSRS and Reports site.
 
 
Thank you for help me
 
 
Julian Castiblanco P
Bogotá, Colombia
 

View Replies View Related

Error When Deploying Report Builder Model

I get the following error when I try to deploy a report builder model. The SQL Server 2005 "Reporting Services" are installed and running on the local machine. 

TITLE: Microsoft Semantic Model Designer
------------------------------

A connection could not be made to the report server http://localhost/ReportServer.

------------------------------
ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
    <head>
        <title>
            SQL Server Reporting Services
        </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.2047.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content="   at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load()
   at Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName)
   at Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location)
   at Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation)
   at Microsoft.ReportingServices.Library.Global.get_ConfigurationManager()
   at Microsoft.ReportingServices.WebServer.Global.StartApp()
   at Microsoft.ReportingServices.WebServer.Global.Application_BeginRequest(Object sender, EventArgs e)" />
<style>
            BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
            H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
            LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
            .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
            A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
            A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
            A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
            A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

        </style>
    </head><body bgcolor="white">
        <h1>
            Reporting Services Error<hr width="100%" size="1" color="silver" />
        </h1><ul>
            <li>The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) </li><ul>
                <li>Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesReportServerRSReportServer.config' is denied.</li>
            </ul>
        </ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
    </body>
</html>
--. (Microsoft.ReportingServices.SemanticQueryDesign)

------------------------------
BUTTONS:

OK
------------------------------

View Replies View Related

Error Deploying Large Report Model

 


Hi ,

I am trying to deploy the report model which is more than  4 mb size. I am getting following error:

Error     2          There was an exception running the extensions specified in the config file. ---> Maximum request length exceeded.

i changed the web.config on the server side:
as following:
<!--
            <httpRuntime
                executionTimeout = "600"  [in Seconds][number]
                maxRequestLength = "102400" [number]
                requestLengthDiskThreshold = "80" [number]
                useFullyQualifiedRedirectUrl = "false" [true|false]
                minFreeThreads = "8" [number]
                minLocalRequestFreeThreads = "4" [number]
                appRequestQueueLimit = "5000" [number]
                enableKernelOutputCache = "true" [true|false]
                enableVersionHeader = "true" [true|false]
                apartmentThreading = "false" [true|false]
                requireRootedSaveAsPath = "true" [true|false]
                enable = "true" [true|false]
                sendCacheControlHeader = "true" [true|false]
                shutdownTimeout = "90"  [in Seconds][number]
                delayNotificationTimeout = "5"  [in Seconds][number]
                waitChangeNotification = "0" [number]
                maxWaitChangeNotification = "0" [number]
                enableHeaderChecking = "true" [true|false]
            />
        -->
        <httpRuntime executionTimeout="600" maxRequestLength="102400" requestLengthDiskThreshold="80" useFullyQualifiedRedirectUrl="false" minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="5000" enableKernelOutputCache="true" enableVersionHeader="true" requireRootedSaveAsPath="true" enable="true" shutdownTimeout="90" delayNotificationTimeout="5" waitChangeNotification="0" maxWaitChangeNotification="0" enableHeaderChecking="true" sendCacheControlHeader="true" apartmentThreading="false" />
    
But still gets same error: what else i ahve to change.

Please help!!

Thanks

View Replies View Related

Proxy Authentication Error While Deploying The Report On The Same Server

Hello Experts,

I have a Report Server when i try to deploy my report on the same server and if i use the Fully Qualified Domain Name in my report path i get the below Error

TargetServerURL : http://jptoclq901.corpusers.net/ReportServer

Error : The request failed with HTTP Status 407 : Proxy Authentication Required (Microsoft.ReportingServices.Designer)

 

but if i use the TargetServerURL as http://localhost/ReportServer, things do work fine. but company requirement is to use complete path.

 

Is this a limitation or some way out, any Idea???

 

Thanks in advance for the help

 

/Soni

 

 

View Replies View Related

Error While Loading Code Module When Deploying A Report

I have a custom assembly that I wrote.  I placed it in the GAC and the report runs fine locally.  I placed it on the server in the GAC and it kicks out the following error when deploying:

Error while loading code module: €˜SSRSReporting, Version=1.0.1.0, Culture=neutral, PublicKeyToken=de4c010eaf2f2fe8€™. Details: Could not load file or assembly 'SSRSReporting, Version=1.0.1.0, Culture=neutral, PublicKeyToken=de4c010eaf2f2fe8' or one of its dependencies. The system cannot find the file specified.   ....

If I put the file in the /bin directory on the server there is no issues and it works fine.  I need to to deploy to the GAC though.  I restarted IIS and the RS services.    I still have the same issue.

View Replies View Related

Deploying Report Via Visual Studio To Sharepoint - Error

Hi guys

I seem to be having a bit of trouble deploying my reports from my Reporting Services Project in Visual Studio to my Sharpoint server.

 

Both the reporting server and sharepoint are installed on the same server.

 

The settings within my reporting server are as follows (where report is the site name):

    TrargetDataSourceFolder - https://server/Report/Shared Documents/DataSources

    TrargetReportFolder - https://server/Report/Shared Documents

    TrargetServerURL - https://server/Report

 

I have not yet changed over all my reports to use fully qualified urls yet. As we have multiple domains in which the reports need to go through before they hit the production server and i haven't yet decided how i am going to handle the issues of the reports requiring fully qualified addresses (if someone has a way i would love to know).

 

I was getting the following error when i tried to deploy the projects but i delete all extensions from the blocked file types and that error went away. I can only guess that there was a file type it didn't like.

Error - "The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators."

 

When i deleted all the file extensions i now get the following error.

Error - "File Not Found."

 

Just wondering if anyone has had any success with visual studio and sharepoint deployment or run into this problem.

Thanks

Anthony
 

View Replies View Related

.net Security Assembly Returns Results Of An MDX Query To A Report Viewed In Report Manager - EnvironmentPermissions Error

Hi,
 
I've got a Security assembly implemented in .net 2.0, which returns the results of an MDX query to a report viewed in Report Manager.
 
This is the error:
 Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed
 
If I cut out the code that asserts the need for unlimited FileIOPermissions, then the error changes to:
 
Unable to retrieve security descriptor for this frame
 
So I can't get away with just asserting less permissions. I assume that this is something to do with using MDX in this way.
 

Clearly the permissions on the assembly are inadequate, so I tried updating the rssrvpolicy.config file:
 
<configuration>
    <mscorlib>
        <security>
            <policy>
                <PolicyLevel version="1">
                    <SecurityClasses>
                        <SecurityClass Name="AllMembershipCondition" Description="System.Security.Policy.AllMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="AspNetHostingPermission" Description="System.Web.AspNetHostingPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="DnsPermission" Description="System.Net.DnsPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="EnvironmentPermission" Description="System.Security.Permissions.EnvironmentPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="FileIOPermission" Description="System.Security.Permissions.FileIOPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="FirstMatchCodeGroup" Description="System.Security.Policy.FirstMatchCodeGroup, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="IsolatedStorageFilePermission" Description="System.Security.Permissions.IsolatedStorageFilePermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="NamedPermissionSet" Description="System.Security.NamedPermissionSet"/>
                        <SecurityClass Name="PrintingPermission" Description="System.Drawing.Printing.PrintingPermission, System.Drawing, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
                        <SecurityClass Name="ReflectionPermission" Description="System.Security.Permissions.ReflectionPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="RegistryPermission" Description="System.Security.Permissions.RegistryPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SecurityPermission" Description="System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SocketPermission" Description="System.Net.SocketPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="SqlClientPermission" Description="System.Data.SqlClient.SqlClientPermission, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="StrongNameMembershipCondition" Description="System.Security.Policy.StrongNameMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="UnionCodeGroup" Description="System.Security.Policy.UnionCodeGroup, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="UrlMembershipCondition" Description="System.Security.Policy.UrlMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="WebPermission" Description="System.Net.WebPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                        <SecurityClass Name="ZoneMembershipCondition" Description="System.Security.Policy.ZoneMembershipCondition, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
                    </SecurityClasses>
                    <NamedPermissionSets>
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Unrestricted="true"
                                Name="FullTrust"
                                Description="Allows full access to all resources"
                        />
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Name="Nothing"
                                Description="Denies all resources, including the right to execute"
                        />
                        <PermissionSet
                                class="NamedPermissionSet"
                                version="1"
                                Name="Execution">
                            <IPermission
                                    class="SecurityPermission"
                                    version="1"
                                    Flags="Execution"
                            />
                        </PermissionSet>
   <PermissionSet class="DirectoryServicesPermissionSet"
    version="1"
    Name="DSPermissionSet"
    Description="A special permission set that grants browse access to DirectoryServices">
    <IPermission class="DirectoryServicesPermission"
     version="1"
     Browse=""/>
    <IPermission class="SecurityPermission"
         version="1"
         Flags="Assertion, Execution"/>
   </PermissionSet>
                    </NamedPermissionSets>
                    <CodeGroup
                            class="FirstMatchCodeGroup"
                            version="1"
                            PermissionSetName="Nothing">
                        <IMembershipCondition
                                class="AllMembershipCondition"
                                version="1"
                        />
                        <CodeGroup
                                class="UnionCodeGroup"
                                version="1"
                                PermissionSetName="Execution"
                                Name="Report_Expressions_Default_Permissions"
                                Description="This code group grants default permissions for code in report expressions and Code element. ">
                            <IMembershipCondition
                                    class="StrongNameMembershipCondition"
                                    version="1"
                                    PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100512C8E872E28569E733BCB123794DAB55111A0570B3B3D4DE3794153DEA5EFB7C3FEA9F2D8236CFF320C4FD0EAD5F677880BF6C181F296C751C5F6E65B04D3834C02F792FEE0FE452915D44AFE74A0C27E0D8E4B8D04EC52A8E281E01FF47E7D694E6C7275A09AFCBFD8CC82705A06B20FD6EF61EBBA6873E29C8C0F2CAEDDA2"
                            />
   </CodeGroup>
                        <CodeGroup
                                class="FirstMatchCodeGroup"
                                version="1"
                                PermissionSetName="Execution"
                                Description="This code group grants MyComputer code Execution permission. ">
                         <IMembershipCondition
                                    class="ZoneMembershipCondition"
                                    version="1"
                                    Zone="MyComputer" />
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Microsoft_Strong_Name"
                                    Description="This code group grants code signed with the Microsoft strong name full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="002400000480000094000000060200000024000052534131000400000100010007D1FA57C4AED9F0A32E84AA0FAEFD0DE9E8FD6AEC8F87FB03766C834C99921EB23BE79AD9D5DCC1DD9AD236132102900B723CF980957FC4E177108FC607774F29E8320E92EA05ECE4E821C0A5EFE8F1645C4C0C93C1AB99285D622CAA652C1DFAD63D745D6F2DE5F17E5EAF0FC4963D261C8A12436518206DC093344D5AD293"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Ecma_Strong_Name"
                                    Description="This code group grants code signed with the ECMA strong name full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="00000000000000000400000000000000"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="Report_Server_Strong_Name"
                                    Description="This code group grants Report Server code full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100272736AD6E5F9586BAC2D531EABC3ACC666C2F8EC879FA94F8F7B0327D2FF2ED523448F83C3D5C5DD2DFC7BC99C5286B2C125117BF5CBE242B9D41750732B2BDFFE649C6EFB8E5526D526FDD130095ECDB7BF210809C6CDAD8824FAA9AC0310AC3CBA2AA0523567B2DFA7FE250B30FACBD62D4EC99B94AC47C7D3B28F1F6E4C8"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust">
                                <IMembershipCondition
                                        class="UrlMembershipCondition"
                                        version="1"
                                        Url="$CodeGen$/*"
                                />
                            </CodeGroup>
                            <CodeGroup
                                    class="UnionCodeGroup"
                                    version="1"
                                    PermissionSetName="FullTrust"
                                    Name="SharePoint_Server_Strong_Name"
                                    Description="This code group grants SharePoint Server code full trust. ">
                                <IMembershipCondition
                                        class="StrongNameMembershipCondition"
                                        version="1"
                                        PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000100AFD4A0E7724151D5DD52CB23A30DED7C0091CC01CFE94B2BCD85B3F4EEE3C4D8F6417BFF763763A996D6B2DFC1E7C29BCFB8299779DF8785CDE2C168CEEE480E570725F2468E782A9C2401302CF6DC17E119118ED2011937BAE9698357AD21E8B6DFB40475D16E87EB03C744A5D32899A0DBC596A6B2CFA1E509BE5FBD09FACF"
                                />
                            </CodeGroup>
       <CodeGroup class="UnionCodeGroup"
        version="1"
                                   PermissionSetName="FullTrust"
                                   Name="MyCompany.MIS.Security"
                                   Description="A special code group for my custom assembly.">
       <IMembershipCondition class="StrongNameMembershipCondition" version="1"
        PublicKeyBlob="00240000048000009400000006020000002400005253413100040000010001003F099786BD0BDCD36FF941A6EC9E6612103F15D0D34DF124FF4792C237EF88E88C23C3BAD09A57FAD1C3364003C4C27E7EFA206520286982563134566247AFCFFFDCA1B91B9AA0EBAEA81F20A3BB6769037D882DFB38F9D7FFE2F19B8975C18CED382BC2BB911C7D4B8484B39EE3AC651530A1DDD21DCE50A24EEED613CF8DBA"
                      Name="MyCompany.MIS.Security" AssemblyVersion="3.0.0.4"/>
          </CodeGroup>
                    </CodeGroup>
                </PolicyLevel>
            </policy>
        </security>
    </mscorlib>
</configuration>
 

I've added 'Full Trust' to my specific assembly. The new clause there was generated using caspol.exe so I think it should be correct. However, this made no difference at all to the error!

 
However, if I upgrade Report_Expressions_Default_Permissions (see above) to Full Trust, the problem is 'solved'. Unfortunately giving Full Trust to any and all Report Expressions is not an option.
 
Can anyone help?
 
Dr. Bunsen
 

View Replies View Related

Error When Deleting Report In Report Manager And SQL Management Studio

I am getting a rsInternalError when I try to delete a report in Report Manager and SQL Management Studio.  I am able to deploy, move (as long as the report doesn't exist at the destination) and upload but not delete.
 
This is the error dump:
 
<Header>
  <Product>Microsoft SQL Server Reporting Services Version 9.00.3050.00</Product>
  <Locale>en-US</Locale>
  <TimeZone>Central Daylight Time</TimeZone>
  <Path>C:Program FilesMicrosoft SQL ServerMSSQL.10Reporting ServicesLogFilesReportServer__09_19_2007_00_02_45.log</Path>
  <SystemName>HLTHS2</SystemName>
  <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
  <OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!5!9/19/2007-00:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-00:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-00:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-00:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-00:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-00:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-01:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-01:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-02:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-02:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-02:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-03:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-03:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-03:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-04:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-04:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-05:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-05:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-05:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-05:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-05:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-05:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:02:48:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-06:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-07:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-07:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-07:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-09:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!09/19/2007-09:07:20:: Call to GetItemTypeAction(/Test).
w3wp!library!1!09/19/2007-09:07:21:: Call to CreateFolderAction(Test, /).
w3wp!library!7!09/19/2007-09:07:21:: Call to GetItemTypeAction(/Data Sources).
w3wp!library!7!09/19/2007-09:07:21:: Call to GetItemTypeAction(/Data Sources/Warehouse).
w3wp!library!5!09/19/2007-09:07:22:: Call to GetItemTypeAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:07:25:: Call to CreateReportAction(Invoice Balance, /Test, True).
w3wp!library!7!09/19/2007-09:07:29:: Call to SetItemDataSourcesAction(/Test/Invoice Balance).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetPermissionsAction(/).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetSystemPermissionsAction().
w3wp!library!5!09/19/2007-09:08:25:: Call to ListChildrenAction(/, False).
w3wp!library!5!09/19/2007-09:08:25:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:08:25:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:08:29:: Call to GetPermissionsAction(/Test).
w3wp!library!1!09/19/2007-09:08:29:: Call to GetPropertiesAction(/Test, PathBased).
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:08:29:: Call to ListChildrenAction(/Test, False).
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPropertiesAction().
w3wp!library!6!9/19/2007-09:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!09/19/2007-09:15:04:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:04:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:04:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:04:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:15:05:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!1!09/19/2007-09:15:05:: Call to ListEventsAction().
w3wp!library!1!09/19/2007-09:15:08:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:13:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:14:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/19/2007-09:15:14:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:14:: Call to GetReportParametersAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:14:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:15:14:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/Test, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/Test, False).
w3wp!library!5!09/19/2007-09:15:14:: Call to GetItemDataSourcesAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:15:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:18:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!1!09/19/2007-09:15:18:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:15:18:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!7!09/19/2007-09:15:18:: Call to GetReportParametersAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:18:: Call to GetSystemPermissionsAction().
w3wp!library!5!09/19/2007-09:15:18:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!5!09/19/2007-09:15:18:: Call to DeleteItemAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:19:: a ASSERT: Assertion failed!   Call stack:
 Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow() 
 Microsoft.ReportingServices.Library.RSSoapAction`1.Execute() 
 Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String Item) 
 Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String Item) 
 System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) 
 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) 
 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) 
 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) 
 System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values) 
 System.Web.Services.Protocols.WebServiceHandler.Invoke() 
 System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest() 
 System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context) 
 System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 
 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 
 System.Web.HttpApplication+ApplicationStepManager.ResumeSteps(Exception error) 
 System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) 
 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) 
 System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) 
 System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) 
w3wp!library!5!09/19/2007-09:15:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component library;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

 
 
The error in the event log is:
 
EventType sql90exception, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4 reportingservicesnativeclient.ni.dll, P5 2005.90.3042.0, P6 45cd6edb, P7 0, P8 00005253, P9 00000000, P10 NIL.

 
Thanks in advance!
 
Lori

View Replies View Related

Report Manager Error

I have seen this issue in other posts, but I've never seen a way to fix it.

When I try to access the Report Manager, I get the following:

 
Server Error in '/Reports' Application.


Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.

Source Error:





An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.





WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLMSoftwareMicrosoftFusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLMSoftwareMicrosoftFusion!EnableLog].

Stack Trace:





[FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211
System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141
System.Reflection.Assembly.Load(String assemblyString) +25
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32

[ConfigurationErrorsException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596
System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +70
System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177
System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +180
System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) +3446629
System.Web.Compilation.BuildManager.CompileGlobalAsax() +51
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +462

[HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +57
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +612
System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +456

[HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426855
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +149





Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

I am using SSE2005 SP2

What can I do to fix this?  This is a production server that is very precisely configured, so I can't just format and reinstall everything (this would take DAYS)

Please please help!!!  : )

View Replies View Related

Error In Access Report Manager

I am able to access report server and view the reports on my machine but when i access

the report manager it gives error

"The attempt to connect to the report server failed.  Check your connection information and that the report server is a compatible version"

 

View Replies View Related

Report Manager - Subscription Error

 

Hello All,
 
I have created few reports and deployed the reports ot Report Server. When i tried to create new subscription(to schedule the report) for the report, i am getting the below error:
 
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help




For more information about this error navigate to the report server on the local server machine, or enable remote errors
 
Please let me know the solution in this regard.
 
Thanks,
SR.

View Replies View Related

Processing Error In Report Manager

Hi,
 
I'm trying to generate a report i'd deployed on the webserver. However, I keep getting the following error msg, even after i've created a shared data source.







An error has occurred during report processing.




Cannot create a connection to data source 'RC_Cube'.

For more information about this error navigate to the report server on the local server machine, or enable remote errors








 
Al

View Replies View Related

Cannot Edit Report Security In Report Manager Or SQL Server Manager!!!

Please help!  I recently installed SSRS and it has been working well for the last couple of weeks.  Now, I cannot access the security controls for any reports in either Report Manager or SQL Server Management Studio.  Right-clicking on the Home directory brings up an error window that says "Cannot show requested dialog." and gives an rsInternalError reference.
 
I've searched everything related to the error msg that I'm getting and cannot find any reference to this issue.  If anyone has any suggestions, I'd really appreciate them.
 
Thanks in advance!
 
- Mike

View Replies View Related

Error When Creating Schedule In Report Manager

Hello,
 
Scenario:
I am trying to set up a shared schedule in report manager after successfully deploying the reports to my server. I have set up the linked reports and AD permissions, however when I want to either set up a shared schedule, or an individual schedule I encounter the error below.  
 
System details:
Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86)   Feb 13 2007 23:02:48   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) 
 
Report Manager Error:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) The specified @category_id ('100') does not exist.
 
The error log does not contain any infor regarding this error, and I've searched for this error extensively in Google as well as microsoft.com, however can't seem to find a resolution for it.
 
I have also tried to create the schedule in SQL Server Management Studio. The complete error message is as follows:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) (Report Services SOAP Proxy Source)
Additional information:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) (ReportingServicesLibrary)
The specified @category_id ('100') does not exist. () (.Net SqlClient Data Provider)
 
Please could you send me any further info about how to solve this problem and resolve the error.
 
Thank you
Sune de Vos

 
 
 

View Replies View Related

Data #ERROR In Report Manager But Not Designer

Hi,

 

I'm running a report using MDX. In preview, the report displays correctly, but after deploying to Report Manager, where there were once numbers there is now '#Error'. The string fields display correctly, its just the numeric ones that are not working.

 

Any help is much appreciated.

 

Cheers,

 

Ali

View Replies View Related

Error While Executing Reports From Report Manager

Hi..

I have deployed reports on to the report server. When I try to open the reports from report server, I get the error," Value does not fall within the expected range." This error message appears as soon as  I click on any report on the report manager.

I am not able to find the cause of the error.

Does anybody have any suggestions?

Thanks ,

Viva

View Replies View Related

Reg: Error While Browsing Report Server In IIS Manager

 
Reporting Services Error



The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)



SQL Server Reporting Services


 
While browsing ReportServer I am getting the above error please help me on this regard.
 
 
 
Thanks in advance,
Archana Devi P

View Replies View Related

Login Prompt When Deploying Solution/report To Report Server

 

Hi there,
 
I've seen some similar posts to this one, however none with an answer and I'm wondering if anyone has actually figured out what causes this issue. I'm running SQL Server 2005 Reporting Services.
 
I'm attempting to implement a folder structure for the report server, therefore am creating individual solutions in Visual Studio for each folder. At the top level i.e http://servername/reportserver/ I am able to deploy reports no problem.
 
However creating a folder at the next level in the tree and then deploying to that level such as http://servername/reportserver/ManagementReports causes a Reporting Services Login prompt to appear. No matter what user credentials I enter they are not accepted. I have full administrator rights the server, the site and the folders in question.
 
Has anyone else experienced this? Does anyone have any suggestions?
 
Thanks
Matt

View Replies View Related

Problem Deploying Custom Report Item. Items Shows In Preview Screen In VS, But Not In Server Deployed Report

I have developed a custom report item that works fine in design and preview mode while in Visual Studio. I cannot get it to show up on my deployed reports. Here's what I have done so far:

1. Deployed the report using Visual Studio

2. updated the rsreportserver.config file with the following entry:

    <ReportItems>
      <ReportItem Name="PedigreeChart" Type="Uabr.Rap.PedigreeChart.PedigreeChartRenderer, Uabr.Rap.PedigreeChart" />
    </ReportItems>

3. Updated the rssrvpolicy.config file with the following entry.

                          <CodeGroup
                    class="UnionCodeGroup"
                    version="1"
                    PermissionSetName="FullTrust"
                    Description="This code group grants Uabr.Rap.PedigreeChart.dll FUllTrust permission. ">
                            <IMembershipCondition
                                class="UrlMembershipCondition"
                                version="1"
                                Url="C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerinUabr.Rap.PedigreeChart.dll" />
                          </CodeGroup>

I've also tried using the StrongNameMembershipCondition with no better results.

4. The dll and its dependencies are copied to the bin directory of the report server.

5. When I load a report with this custom report item on it, the report loads fine with no errors or warnings in the log file (even with verbose tracing). The area where the custom item should be is just white. It's almost like Reporting Services isn't registering the item correctly.

This is particularly frustrating because the report works fine in Visual Studio - apparently I configured that correctly. Any suggestions would be greatly appreciated. I'm stumped.

View Replies View Related

Invalid Namespace Error While Login Report Manager

I am using Custom Security Extension DLL for implementing Forms Authentication in Reporting Service 2005. While Login I am getting an "Invalid Namespace" error. After debugging it, i found below lines in the AuthenticationUtilities.cs page of the Custom DLL which is giving error.

const string WmiNamespace = @"\localhost
ootMicrosoftSqlServerReportingServicesv8";
const string WmiRSClass = @"MSReportServerReportManager_ConfigurationSetting";

scope = new ManagementScope(WmiNamespace);

// Connect to the Reporting Services namespace.
scope.Connect(); //This is the line where the error is coming. It is trying to conenct WMI provider

Can anyone help me in figuring out What is wrong with the WmiNamespace ???????


Thanks,
Akash


 

View Replies View Related

Accessing SSAS Cube From Report Manager Error

Hey Forum Community

I seem to have a problem creating a model for my AS cube through Report Manager.

I have set up the data source as follows:

Name:  Gates Aust Business Intelligence

Connection Type:  MS SQL Server Analysis Services

Connection String:  Data Source=MANT4003;initial catalog="GAPL Sales Analysis"

Connect Using: Windows Interegrated Security

This part works, but when i go to generate the model, i get the following error in the browser:

"









Cannot create a connection to data source ''. (rsErrorOpeningConnection) Get Online Help




For more information about this error navigate to the report server on the local server machine, or enable remote errors

In the reporting services log file i have the following errors:

w3wp!library!7!07/03/2006-10:51:40:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.DataSourceOpenException: Cannot create a connection to data source ''., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.DataSourceOpenException: Cannot create a connection to data source ''. ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The connection either timed out or was lost. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- End of inner exception stack trace ---
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
   at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
   at Microsoft.AnalysisServices.AdomdClient.DimeRecord..ctor(Stream stream)
   at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
   at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetDataType()
   --- End of inner exception stack trace ---
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest()
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.CreateSession(ListDictionary properties, Boolean sendNamespaceCompatibility)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.CreateSession(Boolean sendNamespaceCompatibility)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
   at Microsoft.ReportingServices.Library.RSService.OpenDataSourceConnection(DataSourceInfo dataSourceInfo, CreateDataExtensionInstance createDataExtensionInstanceFunction, Boolean isUnattendedExecution, Boolean unwrapConnection, IntPtr clientToken, IDbConnection& unwrappedConnection)
   --- End of inner exception stack trace ---
w3wp!library!1!07/03/2006-10:51:59:: i INFO: Call to GetPermissions:/
w3wp!library!1!07/03/2006-10:53:02:: i INFO: Call to GetPermissions:/

 

I have tried searching the forums and cannot find anything really helpful.  I have had one cube setup and a model generated before and all was workin, but i had to delete it and i recreated the SSAS cube from scratch. 

My user account has admin rights on the cube and also on the servers.

Server is Windows 2003

Client is Windows XP.

Any one got anythoughts on this or how i can determine what is wrong.?

Many Thanks


Scotty

View Replies View Related

Error Message When Clicked The New Subscription In Report Manager

Hi all,


When I try above, I was shown the below:

Subscriptions cannot be created because the credentials used to run the report are not stored, the link is no longer valid.

How do I resolve this?

Regards,
Farouk Yew Abdullah

View Replies View Related

Reporting Services: Report Manager Does Not Load (server Error)

Hello Everyone,
 
I have installed SQL Server 2005 with Reporting Services on Windows Server 2003.  I can run through reporting services configuration and completed all the required steps to initialize it.  I can access the reports through //localhost/reportserver and I can also access the reports through Microsoft CRM.  But I cannot access the Report Manager (//localhost/reports).  I get this Error:
Server Error in '/Reports' Application.


Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.

Source Error:





An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.





WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLMSoftwareMicrosoftFusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLMSoftwareMicrosoftFusion!EnableLog].

Stack Trace:





[FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211
System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141
System.Reflection.Assembly.Load(String assemblyString) +25
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32

[ConfigurationErrorsException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596
System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +70
System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177
System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +180
System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) +3561465
System.Web.Compilation.BuildManager.CompileGlobalAsax() +51
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +462

[HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +57
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +612
System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +521

[HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3540923
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +69
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +275











Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
 
Any ideas?  I have done some searching, but could not find any viable solutions.  Please Help
 
Regards,
Ray

View Replies View Related

HTTP Status 401: Access Denied Error In Report Manager

This didn't use to happen but now it does.

 

When I go into Report Manager, http://localhost/reports, and try running a report it is giving me this error message:

 

The request failed with HTTP status 401: Access Denied

 

But if I go directly to the Report Server, http://localhost/reportserver, and try running a report there then everything is fine.

 

Does anyone know why it is doing this all of a sudden? I did change the Reports app in ISS to allow anonymous access but have since changed it back, and it still gives this error.

View Replies View Related

Error While Connecting To Reporting Services Engine &&amp; Report Manager

Hi,
 
I am getting an error:
 
1. While connecting to the Reporting Services Engine (Using SQL Server Management Server). The error message is given below. Report Server is working fine, I am able to browse the reports from the report server.
 
------------------------------------------------------------------------------------------------------------------------------------------------------------
TITLE: Connect to Server
------------------------------
Cannot connect to BTP8NMB03.
------------------------------
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<HTML dir="ltr">
<HEAD><meta name="GENERATOR" content="Microsoft SharePoint" /><meta name="progid" content="SharePoint.WebPartPage.Document" /><meta HTTP-EQUIV="Content-Type" content="text/html; charset=utf-8" /><meta HTTP-EQUIV="Expires" content="0" /><meta name="ROBOTS" content="NOHTMLINDEX" /><title>
 
 Error
</title><link rel="stylesheet" type="text/css" href="/_layouts/1033/styles/core.css?rev=5msmprmeONfN6lJ3wtbAlA%3D%3D"/>
<script type="text/javascript" language="javascript" src="/_layouts/1033/init.js?rev=VhAxGc3rkK79RM90tibDzw%3D%3D"></script>
<script type="text/javascript" language="javascript" src="/_layouts/1033/core.js?rev=F8pbQQxa4zefcW%2BW9E5g8w%3D%3D"></script>
 <meta name="Robots" content="NOINDEX " />
 <meta name="SharePointError" content=""/>
</HEAD>
<BODY scroll="yes" onload="javascript:if (typeof(_spBodyOnLoadWrapper) != 'undefined') _spBodyOnLoadWrapper();">
  <form name="aspnetForm" method="post" action="../_layouts/error.aspx" id="aspnetForm" onsubmit="return _spFormOnSubmitWrapper();">
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUKLTU2NjkxODU3M2RkLuL1ujv9xB7yocvKanNE0G4cIn0=" />
  <TABLE class="ms-main" CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%" HEIGHT="100%">
 <tr><td>
    <table CELLPADDING=0 CELLSPACING=0 BORDER=0 WIDTH="100%">
  <tr>
   <td colspan=4 class="ms-globalbreadcrumb" align="right">
      <a href="javascript:TopHelpButtonClick('NavBarHelpHome')" id="ctl00_PlaceHolderGlobalNavigation_TopHelpLink" AccessKey="6" title="Help (new window)"><img src="/_layouts/images/helpicon.gif" align="absmiddle" border="0" alt="Help (new window)" /></a>
   </td>
  </tr>
    </table>
   </td></tr>
 <tr>
  <td class="ms-globalTitleArea">
   <table width=100% cellpadding=0 cellspacing=0 border=0>
    <tr>
  <td id="GlobalTitleAreaImage" class="ms-titleimagearea"><img id="onetidHeadbnnr0" src="/_layouts/images/titlegraphic.gif"  alt="" /></td>
  <td class="ms-sitetitle" width=100%>
   
   
  </td>
  <td style="padding-top:8px;" valign=top>
   
   
  </td>
    </tr>
   </table>
  </td>
 </tr>
 <TR>
  <TD id="onetIdTopNavBarContainer" WIDTH=100% class="ms-bannerContainer">
  
  
  </TD>
 </TR>
 
  

 
 
 <TR height="100%"><TD><TABLE width="100%" height="100%" cellspacing="0" cellpadding="0">
 <tr>
  <td class="ms-titlearealeft" id="TitleAreaImageCell" valign="middle" nowrap><div style="height:100%" class="ms-titleareaframe"></div></td>
  <td class="ms-titleareaframe" id="TitleAreaFrameClass">
  
  <table cellpadding=0 height=100% width=100% cellspacing=0>
   <tr><td class="ms-areaseparatorleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=1 alt=""></td></tr>
  </table>
  
  </td>
  <td valign=top  id="onetidPageTitleAreaFrame" class='ms-areaseparator' nowrap width="100%">
   <table id="onetidPageTitleAreaTable" cellpadding=0 cellspacing=0 width=100% border="0">
    <tr>
  <td valign="top" class="ms-titlearea">
  
    <a href="http://btp8nmb03" id="ctl00_PlaceHolderTitleBreadcrumb_idSimpleGoBackToHome">Go back to site</a>
  
  </td>
    </tr>
    <tr>
  <td height=100% valign=top ID=onetidPageTitle class="ms-pagetitle">
    <h2 class="ms-pagetitle">
   
 Error
    </h2>
  </td>
    </tr>
   </table>
  </td>
  <td class="ms-titlearearight">
  
  
<div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
 </tr>
 <TR>
   <TD class="ms-leftareacell" valign=top height=100% id="LeftNavigationAreaCell">
    <table class=ms-nav width=100% height=100% cellpadding=0 cellspacing=0>
  <tr>
   <td>
    <TABLE height="100%" class=ms-navframe CELLPADDING=0 CELLSPACING=0 border="0">
     <tr valign="top">
   <td width="4px"><IMG SRC="/_layouts/images/blank.gif" width=4 height=1 alt=""></td>
   <td valign="top" width="100%">
    
    
    
    
     
    
    
   </td>
     </tr>
     <tr><td colspan=2><IMG SRC="/_layouts/images/blank.gif" width=138 height=1 alt=""></td></tr>
    </TABLE>
   </td>
   <td></td>
  </tr>
    </table>
   </TD>
   <td>
<div class='ms-areaseparatorleft'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
   <td class='ms-formareaframe' valign="top">
  <TABLE width="100%" border="0" cellspacing="0" cellpadding="0" class="ms-propertysheet">
   <TR valign="top"  >
   <TD class="ms-descriptiontext" width="100%">
    
   </TD>
      <TD ID=onetidYPadding width="10px"><IMG SRC="/_layouts/images/blank.gif" width=10 height=1 alt=""></TD>
    </TR>
    <TR >
   <TD ID=onetidMainBodyPadding height="8px"><IMG SRC="/_layouts/images/blank.gif" width=1 height=8 alt=""></TD>
    </TR>
    <tr>
    <td valign="top" height="100%">
      <A name="mainContent"></A>
    
 <table width=100% border=0 class="ms-titleareaframe" cellpadding=0>
 <TR>
 <TD valign=top width="100%" style="padding-top: 10px" class="ms-descriptiontext">
    <span id="ctl00_PlaceHolderMain_LabelMessage">The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators.</span>
    <P><span class="ms-descriptiontext">
  <span id="ctl00_PlaceHolderMain_helptopic_troubleshooting"><A Title="Troubleshoot issues with Windows SharePoint Services. - Opens in new window" HREF="javascript:HelpWindowKey('troubleshooting')">Troubleshoot issues with Windows SharePoint Services.</A></span>
  
  </span>
 </TD>
 </TR>
 </table>
<script type="text/javascript" language="JavaScript">
  var gearPage = document.getElementById('GearPage');
  if(null != gearPage)
  {
   gearPage.parentNode.removeChild(gearPage);
   document.title = "Error";
  }
</script>
    </td>
    </tr>
  </table>
   </td>
   <td class="ms-rightareacell">
<div class='ms-areaseparatorright'><IMG SRC="/_layouts/images/blank.gif" width=8 height=100% alt=""></div>
</td>
 </TR>
<tr>
 <td class="ms-pagebottommarginleft"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
 <td class="ms-pagebottommargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
 <td class="ms-bodyareapagemargin"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
 <td class="ms-pagebottommarginright"><IMG SRC="/_layouts/images/blank.gif" width=1 height=10 alt=""></td>
</tr>
 </TABLE></TD></TR>
  </TABLE>
 
 
   <input type="text" name="__spDummyText1" style="display:none;" size=1/>
   <input type="text" name="__spDummyText2" style="display:none;" size=1/>
  </form>
 
</BODY>
</HTML>
--. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
BUTTONS:
OK
------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------------------------
 
2. When I try to connect to the Report Manager. I get the error "The request failed with HTTP status 400: Bad Request."
 
The log file contains the following information:
-------------------------------------------------------------------------------------------------------------------------------------------------------------
<Header>
  <Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
  <Locale>en-US</Locale>
  <TimeZone>India Standard Time</TimeZone>
  <Path>D:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerWebApp__05_20_2008_20_12_13.log</Path>
  <SystemName>BTP8NMB03</SystemName>
  <OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
  <OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing ReportBuilderTrustLevel to '0'  as specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing ProcessRecycleOptions to default value of '0'  because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing WatsonFlags to default value of '1064'  because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing SecureConnectionLevel to default value of '1'  because it was not specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
w3wp!library!5!5/20/2008-20:12:13:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False'  because it was not specified in Configuration file.
w3wp!ui!5!5/20/2008-20:12:17:: e ERROR: The request failed with HTTP status 400: Bad Request.
w3wp!ui!5!5/20/2008-20:12:17:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 400: Bad Request.
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
   at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
   at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
   at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnInit(EventArgs e)
   at System.Web.UI.Page.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!5/20/2008-20:12:18:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!7!5/20/2008-20:12:26:: e ERROR: The request failed with HTTP status 400: Bad Request.
w3wp!ui!7!5/20/2008-20:12:26:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 400: Bad Request.
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
   at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
   at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
   at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnInit(EventArgs e)
   at System.Web.UI.Page.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!7!5/20/2008-20:12:27:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!1!5/20/2008-20:25:18:: e ERROR: The request failed with HTTP status 400: Bad Request.
w3wp!ui!1!5/20/2008-20:25:18:: e ERROR: HTTP status code --> 500
-------Details--------
System.Net.WebException: The request failed with HTTP status 400: Bad Request.
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
   at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
   at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
   at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
   at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Control.OnInit(EventArgs e)
   at System.Web.UI.Page.OnInit(EventArgs e)
   at System.Web.UI.Control.InitRecursive(Control namingContainer)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!5/20/2008-20:25:19:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
   at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at    at System.Threading.Thread.AbortInternal()
   at System.Threading.Thread.Abort(Object stateInfo)
   at System.Web.HttpResponse.End()
   at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
   at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

-------------------------------------------------------------------------------------------------------------------------------------------------------------
 
Any help in this regard would be appreciated.
Thanks in advance.
 
Thx,
Datta

View Replies View Related

CS0006 Error Accessing SSRS Report Manager Under Vista Ultimate

We receive the error below when attempting to access our newly installed reporting service under Windows Vista.  We can't seem to fix to this error.  While we can view reports deployed to my report server at http://ServerName/ReportServer, we cannot access the Report Manager that comes with SSRS via http://ServerName/Reports.  When we do we get the error below. 
 
According to the error it cannot find the 'C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll.  The missing dll is located in our C:$WINDOWS.~QDATAWindowsMicrosoft.NETFrameworkv2.0.50727System.EnterpriseServices.dll.  We do not have a GAC_32 directory in our Assembly directory and we cannot manually add any thing to the Assembly folder. 
 
Does anyone have any idea how to resolve this error?
 
Any assistance is greatly appreciated.
 
Server Error in '/Reports' Application.


Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS0006: Metadata file 'C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll' could not be found

Source Error:







[No relevant source lines]
Source File:    Line: 0



Show Detailed Compiler Output:





c:windowssystem32inetsrv> "C:WindowsMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl350805c340086ba6_164dc701ReportingServicesNativeClient.DLL" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl357073932092ba95_164dc701Microsoft.ReportingServices.Diagnostics.DLL" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl34957153c0086ba6_164dc701ReportingServicesFileShareDeliveryProvider.DLL" /R:"C:WindowsassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Runtime.Serialization3.0.0.0__b77a5c561934e089System.Runtime.Serialization.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Drawing2.0.0.0__b03f5f7f11d50a3aSystem.Drawing.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Web.RegularExpressions2.0.0.0__b03f5f7f11d50a3aSystem.Web.RegularExpressions.dll" /R:"C:WindowsassemblyGAC_MSILSystem.IdentityModel3.0.0.0__b77a5c561934e089System.IdentityModel.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl36a74e1360086ba6_164dc701ReportingServicesEmailDeliveryProvider.DLL" /R:"C:WindowsassemblyGAC_MSILSystem.Windows.Forms2.0.0.0__b77a5c561934e089System.Windows.Forms.dll" /R:"C:WindowsassemblyGAC_MSILSystem.ServiceModel3.0.0.0__b77a5c561934e089System.ServiceModel.dll" /R:"C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl39a6712b7092ba95_164dc701Microsoft.ReportingServices.Interfaces.DLL" /R:"C:WindowsassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl34c4caac70359ca7_164dc701ReportingServicesWebUserInterface.DLL" /R:"C:WindowsassemblyGAC_MSILSystem.DirectoryServices2.0.0.0__b03f5f7f11d50a3aSystem.DirectoryServices.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7assemblydl326b107a10e258c3_b4d0c501ReportingServicesCDOInterop.DLL" /R:"C:WindowsassemblyGAC_MSILSystem.Web.Mobile2.0.0.0__b03f5f7f11d50a3aSystem.Web.Mobile.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Configuration2.0.0.0__b03f5f7f11d50a3aSystem.Configuration.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Web.Services2.0.0.0__b03f5f7f11d50a3aSystem.Web.Services.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll" /R:"C:WindowsassemblyGAC_MSILSystem.ServiceProcess2.0.0.0__b03f5f7f11d50a3aSystem.ServiceProcess.dll" /R:"C:WindowsassemblyGAC_MSILSystem.Design2.0.0.0__b03f5f7f11d50a3aSystem.Design.dll" /R:"C:WindowsMicrosoft.NETFrameworkv2.0.50727mscorlib.dll" /R:"C:WindowsassemblyGAC_MSILSystem.DirectoryServices.Protocols2.0.0.0__b03f5f7f11d50a3aSystem.DirectoryServices.Protocols.dll" /R:"C:WindowsassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /out:"C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7App_global.asax.vk_hxeqb.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699 "C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7App_global.asax.vk_hxeqb.0.cs" "C:WindowsMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eportsaa13b3275d348ea7App_global.asax.vk_hxeqb.1.cs"


Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.312
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.

error CS0006: Metadata file 'C:WindowsassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll' could not be found








Version Information: Microsoft .NET Framework Version:2.0.50727.312; ASP.NET Version:2.0.50727.833

 

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved