Error Reporting: Installation on SQL 2005 on x64

I installed SQL 2005 on x64 machine and notice that my Y: drive (data drive) has these additional directories (shown below). I know those files are components of “Microsoft Application Error Reporting”. They are shared among multiple applications, hence them being in “common files”. After disabling the error reporting using Microsoft SQL Server 2005->Configuration Tools->Error and Usage Reporting, can I get rid of those directories or specify which directory that it should go to? Has anyone seen this before? Thanks.

The following had been installed to the drive that we did not specify in the installation of SQL 2005. Is there any way to redirect these file back the window directory?

Volume in drive Y is New Volume
Volume Serial Number is 882B-9F43
NULL
Directory of y:\program files\common files\microsoft shared\dw
NULL
06/01/2006 11:26 AM <DIR> .
06/01/2006 11:26 AM <DIR> ..
06/01/2006 11:26 AM <DIR> 1028
06/01/2006 11:26 AM <DIR> 1031
06/01/2006 11:26 AM <DIR> 1033
06/01/2006 11:26 AM <DIR> 1036
06/01/2006 11:26 AM <DIR> 1040
06/01/2006 11:26 AM <DIR> 1041
06/01/2006 11:26 AM <DIR> 1042
06/01/2006 11:26 AM <DIR> 2052
06/01/2006 11:26 AM <DIR> 3082
04/25/2005 01:44 PM 1,030,336 DW20.EXE
04/25/2005 01:44 PM 496,328 DWDCW20.DLL
04/25/2005 01:44 PM 489,672 DWTRIG20.EXE
3 File(s) 2,016,336 bytes
11 Dir(s) 85,983,068,160 bytes free
NULL

I'm pretty sure this is a setup bug where some components are not defaulting to the system drive, or sql drive, but to the drive where you launched setup from. I'm guessing you launched setup from the Y: drive. Don't know if there's a simple way to move them, but you can always uninstall, then reinstall, but this time launch setup from the drive you want these components installed on.sql

Error Reporting service

hi
i am using SQL Server 2005 reporting services, i am getting an error message while deploying .rdl file error is:" Connection could not be established to remote server http://localhost/ReportServer"
Additional information is :
"client found response content type of text/html; charset=utf-8 but expected text/XML"Are you just trying to connect through the browser or to upload a file?|||Oh sorry I see. Are you able to connet to the instance through the browser?|||now its working properly, i have executed aspnet_regsql -ga aspnet commond on command prompt. But now while deploying i m getting another problem: "An internal error occurred on the report server. See the error log for more details."

Error Reporting in SSAS...

Is there a way to achieve the following on a UDM:

1) When an error occurs while processing a record
in a dimension, write the primary key of the record
along with the error to a record in a database.

2) Continue on all errors after logging them.

3) Launch a script when cube processing is complete
to notify affected parties of the errors.

Any suggestions to achieve something similar would
be greatly appreciated.

Filip

You can use SSIS package to put all that in one package.

You create a package using Analysis Services Processing Task. Then go to Menu -> SSIS -> Logging... In the Provider Type select SQL Server then check the "Details" tab. You have to try different Events and check it's logging all you want not more or less.

Continue logging on error is the properties setting on cube/dimension side also if you double click Analysis Services Processing Task you can set that in "Change Settings..."

Last one you have to query the log database table and use send email task in SSIS package.

Hope this will help - Ashok

|||

Thanks Ashok, I'll give that a try and report back ;-)

Filip

Error Reporting from Stored Procedures

How do you report errors from a stored procedure? For example, if the stored
procedure is trying to insert something into a table and the database is
full, how can the stored procedure return an error string to the caller?Hi Swami,
This article might help...
http://www.sqljunkies.com/Article/5...3B6D84BF94.scuk
"Swami" wrote:

> How do you report errors from a stored procedure? For example, if the stor
ed
> procedure is trying to insert something into a table and the database is
> full, how can the stored procedure return an error string to the caller?
>|||Thanks--great article.
"Ryan Randall" wrote:
> Hi Swami,
> This article might help...
> [url]http://www.sqljunkies.com/Article/564F5D77-2F7E-41FB-91C7-353B6D84BF94.scuk[/url
]
>
> "Swami" wrote:
>

Error reporting from SP to .NET code, how?

Hey

ASP.NET 2.0 + MS Sql Server 2005 Express (that version which comes with VS2005)

This code below fails. The Delete method executes a stored procedure, but somehow this SP fails. The SP shown here is a short version of the actual SP. As you see from the code below, there are no way the Delete method can know if SP executed successfully. I assume I just could have returned @.@.error, but that just gives an error number, and not the description of the error??.. And how should I capture exceptions like these?? How should code this SP so it report the error??

Any suggestions??

public override void Delete(System.Guid id, int user)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("SendMessage", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@.id", SqlDbType.UniqueIdentifier).Value = id;
cmd.Parameters.Add("@.user", SqlDbType.Int).Value = user;
}
}

ALTER PROCEDURE dbo.DeleteMessage @.id uniqueidentifier, @.user int
AS
BEGIN
UPDATE table_A set column_A = 1 WHERE Id = @.id;
DELETE FROM table_B WHERE Id = @.id;
IF (@.@.error = 0)
COMMIT TRAN;
ELSE
ROLLBACK TRAN;
END

there is a couple of way to report that what happened, you can use execute nonquery to get number of rows affected by last SQL command, you can return from your procedure single cell using SELECT with value 0 for success and 1 for error and finally you can use output parameters and read its values after procedure executes. See T-SQL help in SQL management studio express which is very good and you can find everything you wont.

Error reporting against Oracle 10g

I've got RS SP2 reporting against an Oracle 10g database. The reports will
run fine for a while, and then for some reason they will error out with the
error:
ORA-12154: TNS:could not resolve the connect identifier specified
If I restart the World Wide Web Publishing Service the reports will again
run fine for a while, and then the error out again.
Has anyone seen a similar issue?*Think* I found it.
The yahoo running their network had the server looking for itself (ala dns)
at an unresolvable external IP. Some wierd / inconsistent things were
happening tyring to access the server by name when on the server.
One entry to the hosts file, and we'll see if it does the trick.
"Jack" <anonymous@.microsoft.com> wrote in message
news:uIHh3OU5FHA.4076@.tk2msftngp13.phx.gbl...
> I've got RS SP2 reporting against an Oracle 10g database. The reports
> will run fine for a while, and then for some reason they will error out
> with the error:
> ORA-12154: TNS:could not resolve the connect identifier specified
> If I restart the World Wide Web Publishing Service the reports will again
> run fine for a while, and then the error out again.
> Has anyone seen a similar issue?
>sql

Error Rendering trough Web Service to WebArchivo format

Hi,
We are using the Reporting Services Web Service, in order to expose some
reports in our Web Application, right now I am trying to enable exporting the
report to the available formats in Reporting Services, and altough everything
seems to be working fine, when I try to render as Web Archive, I get the
following exception:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> The parameter is incorrect.
first I tough it was because of the device info configuration I was using,
since it was the same of the html format (which had things like turning off
the toolbar), thus I instead didnt pass any deviceinfo(null), in both cases
it works fine in all formats but it doesnt in Web Archive.
I have been searching for info about the error, but I havent found any ...
if anyone knows what is happening, I will be thankfull :) ... in the mean
time, I will keep trying, and if I find anything I will post it here.I have continued digging on the problem, I havent found anything on the
internet, and I have cleared out some things about the problem ...
so, here are some aditional info about the problem:
- it isnt only happening when I try to render the report trough the Web
Service, it also happens when I use url access.
- it is happening specifically in this report, there are other reports that
works well
- I am not using any totals/subtotals formulas (I say this, since I have
read this might cause trouble in certain rendering extensions)
- I just found something else (I have 3 reports):
- the report that is working doesnt receive any parameter
- the 2 reports that doesnt work receive 1 parameter, and additionaly have
a list of valid values ...
it looks like it were a bug, something along the lines that rendering
extension either ignores the parameters, or gets confused where there is a
list of valid values ...
Any help will be greatly appreciated ... in the mean time, I will be playing
with the reports definition, in order to find what is exactly happening, if I
dont find a solution soon I will restrict that rendering extension from being
used :(:(:( ...|||I am done with this, I am pretty certain is a bug, just not the type of bug I
tough ...
it is really weird, I played with the parameter options in the report and
the error kept happening, then I decided playing with the report design ...
well, whenever I put a third column in my report, the error happens when I
try to export it to web archive ... I put all types of definition in the
third column, to see if I managed to see anything making it fail, but didnt
arrive to anything, I tried from the simplest one (static text + no
formatting) all trough a "complex" one (formatting + dinamic text ...)

Error Rendering SSRS Reports via SOAP

I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003
server. The configuration has been unchanged for approx. 3 weeks. Suddenly
over the last two days, reports being accessed via an ASP.NET 2.0 application
(on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver
became inaccessable. End users received the following error:
********************************************************
Message: An error occurred during rendering of the report. -->
An error occurred during rendering of the report. -->
An error occurred during rendering of the report. -->
An error occurred during rendering of the report. -->
Attempted to read or write protected memory. This is often an indication
that other memory is corrupt.
Stack Trace: at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at IFA.CAP.SQLReportingService.ReportingService.Render(String Report,
String Format, String HistoryID, String DeviceInfo, ParameterValue[]
Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
Warning[]& Warnings, String[]& StreamIds) in C:\Applications\IFACAP\Web
References\SQLReportingService\Reference.vb:line 1319
at IFA.CAP.BusinessObjects.Reports.Certificate(Int32 certificateID,
Boolean isDraft, Boolean isCertified) in
C:\Applications\IFACAP\BusinessObjects\IFA.CAP.BusinessObjects.Report.vb:line
551
at IFA.CAP.CertificateDetail.PrintCertificate(Object sender, EventArgs e)
in C:\Applications\IFACAP\Main\CertificateDetail.aspx.vb:line 2287
********************************************************
A short term resolution has been to perform iisrest on the ReportServer.
However, the problem reappears later at random intervals.
This only seems to be an issue with reports being called using SOAP.
Reports being rendering in the .NET Report Viewer control appear unaffected.
Here is some sample code to illustrate how we call some of our reports from
ASP.NET through the SSRS web service:
************************************************************
Private callback As New
System.Net.Security.RemoteCertificateValidationCallback(AddressOf
RemoteCertificateValidationCallback)
Private Function RemoteCertificateValidationCallback(ByVal sender As Object, _
ByVal cert As
System.Security.Cryptography.X509Certificates.X509Certificate, _
ByVal chain As
System.Security.Cryptography.X509Certificates.X509Chain, _
ByVal sslPolicyErrors As System.Net.Security.SslPolicyErrors) As Boolean
Return True
End Function
Sub RenderReport()
Dim rs As New SQLReportingService.ReportingService
Dim results As [Byte]() = Nothing
System.Net.ServicePointManager.ServerCertificateValidationCallback = callback
rs.Credentials = New System.Net.NetworkCredential("User", "Password",
"Domain")
results = rs.Render(String.Concat("TargerFolder", "ReportName"), "PDF",
Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
Nothing, Nothing)
Response.Clear()
Response.Buffer = True
Response.Expires = 0
Response.ContentType = "application/pdf"
Response.AppendHeader("Content-Disposition", "attachment;
filename=Report.pdf")
Response.BinaryWrite(results)
Response.End()
End Sub
************************************************************
Does anyone see a problem with the above code. It has been in production
for 3 weeks now and has been working fine until yesterday. Any help would be
greatly appreciated!Try running memtest: www.memtest.org. You may have bad memory.
"mjorangehawk" wrote:
> I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003
> server. The configuration has been unchanged for approx. 3 weeks. Suddenly
> over the last two days, reports being accessed via an ASP.NET 2.0 application
> (on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver
> became inaccessable. End users received the following error:
> ********************************************************
> Message: An error occurred during rendering of the report. -->
> An error occurred during rendering of the report. -->
> An error occurred during rendering of the report. -->
> An error occurred during rendering of the report. -->
> Attempted to read or write protected memory. This is often an indication
> that other memory is corrupt.
> Stack Trace: at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at IFA.CAP.SQLReportingService.ReportingService.Render(String Report,
> String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> Warning[]& Warnings, String[]& StreamIds) in C:\Applications\IFACAP\Web
> References\SQLReportingService\Reference.vb:line 1319
> at IFA.CAP.BusinessObjects.Reports.Certificate(Int32 certificateID,
> Boolean isDraft, Boolean isCertified) in
> C:\Applications\IFACAP\BusinessObjects\IFA.CAP.BusinessObjects.Report.vb:line
> 551
> at IFA.CAP.CertificateDetail.PrintCertificate(Object sender, EventArgs e)
> in C:\Applications\IFACAP\Main\CertificateDetail.aspx.vb:line 2287
> ********************************************************
> A short term resolution has been to perform iisrest on the ReportServer.
> However, the problem reappears later at random intervals.
> This only seems to be an issue with reports being called using SOAP.
> Reports being rendering in the .NET Report Viewer control appear unaffected.
> Here is some sample code to illustrate how we call some of our reports from
> ASP.NET through the SSRS web service:
> ************************************************************
> Private callback As New
> System.Net.Security.RemoteCertificateValidationCallback(AddressOf
> RemoteCertificateValidationCallback)
> Private Function RemoteCertificateValidationCallback(ByVal sender As Object, _
> ByVal cert As
> System.Security.Cryptography.X509Certificates.X509Certificate, _
> ByVal chain As
> System.Security.Cryptography.X509Certificates.X509Chain, _
> ByVal sslPolicyErrors As System.Net.Security.SslPolicyErrors) As Boolean
> Return True
> End Function
>
> Sub RenderReport()
> Dim rs As New SQLReportingService.ReportingService
> Dim results As [Byte]() = Nothing
> System.Net.ServicePointManager.ServerCertificateValidationCallback = callback
> rs.Credentials = New System.Net.NetworkCredential("User", "Password",
> "Domain")
> results = rs.Render(String.Concat("TargerFolder", "ReportName"), "PDF",
> Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
> Nothing, Nothing)
>
> Response.Clear()
> Response.Buffer = True
> Response.Expires = 0
> Response.ContentType = "application/pdf"
> Response.AppendHeader("Content-Disposition", "attachment;
> filename=Report.pdf")
> Response.BinaryWrite(results)
> Response.End()
> End Sub
> ************************************************************
> Does anyone see a problem with the above code. It has been in production
> for 3 weeks now and has been working fine until yesterday. Any help would be
> greatly appreciated!
>|||Actually, it turns out the problem was related to a database image that was
being loaded into the report dynamically. The image control on the report
had a MIME type of jpg but we had a few cases of images that had been
inserted into the database as TIF's. Once we replaced those with JPG
versions the problem went away.
"breno" wrote:
> Try running memtest: www.memtest.org. You may have bad memory.
> "mjorangehawk" wrote:
> > I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003
> > server. The configuration has been unchanged for approx. 3 weeks. Suddenly
> > over the last two days, reports being accessed via an ASP.NET 2.0 application
> > (on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver
> > became inaccessable. End users received the following error:
> >
> > ********************************************************
> >
> > Message: An error occurred during rendering of the report. -->
> > An error occurred during rendering of the report. -->
> > An error occurred during rendering of the report. -->
> > An error occurred during rendering of the report. -->
> > Attempted to read or write protected memory. This is often an indication
> > that other memory is corrupt.
> >
> > Stack Trace: at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters)
> > at IFA.CAP.SQLReportingService.ReportingService.Render(String Report,
> > String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> > Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> > String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> > Warning[]& Warnings, String[]& StreamIds) in C:\Applications\IFACAP\Web
> > References\SQLReportingService\Reference.vb:line 1319
> > at IFA.CAP.BusinessObjects.Reports.Certificate(Int32 certificateID,
> > Boolean isDraft, Boolean isCertified) in
> > C:\Applications\IFACAP\BusinessObjects\IFA.CAP.BusinessObjects.Report.vb:line
> > 551
> > at IFA.CAP.CertificateDetail.PrintCertificate(Object sender, EventArgs e)
> > in C:\Applications\IFACAP\Main\CertificateDetail.aspx.vb:line 2287
> >
> > ********************************************************
> >
> > A short term resolution has been to perform iisrest on the ReportServer.
> > However, the problem reappears later at random intervals.
> >
> > This only seems to be an issue with reports being called using SOAP.
> > Reports being rendering in the .NET Report Viewer control appear unaffected.
> >
> > Here is some sample code to illustrate how we call some of our reports from
> > ASP.NET through the SSRS web service:
> >
> > ************************************************************
> >
> > Private callback As New
> > System.Net.Security.RemoteCertificateValidationCallback(AddressOf
> > RemoteCertificateValidationCallback)
> >
> > Private Function RemoteCertificateValidationCallback(ByVal sender As Object, _
> > ByVal cert As
> > System.Security.Cryptography.X509Certificates.X509Certificate, _
> > ByVal chain As
> > System.Security.Cryptography.X509Certificates.X509Chain, _
> > ByVal sslPolicyErrors As System.Net.Security.SslPolicyErrors) As Boolean
> >
> > Return True
> >
> > End Function
> >
> >
> > Sub RenderReport()
> > Dim rs As New SQLReportingService.ReportingService
> > Dim results As [Byte]() = Nothing
> >
> > System.Net.ServicePointManager.ServerCertificateValidationCallback = callback
> >
> > rs.Credentials = New System.Net.NetworkCredential("User", "Password",
> > "Domain")
> >
> > results = rs.Render(String.Concat("TargerFolder", "ReportName"), "PDF",
> > Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
> > Nothing, Nothing)
> >
> >
> > Response.Clear()
> > Response.Buffer = True
> > Response.Expires = 0
> > Response.ContentType = "application/pdf"
> > Response.AppendHeader("Content-Disposition", "attachment;
> > filename=Report.pdf")
> > Response.BinaryWrite(results)
> > Response.End()
> > End Sub
> >
> > ************************************************************
> >
> > Does anyone see a problem with the above code. It has been in production
> > for 3 weeks now and has been working fine until yesterday. Any help would be
> > greatly appreciated!
> >

Error programaticaly rendering a report using Reporting Services Web Services

I'm using Reporting Services 2005 SP1 and wrote some code to render reports server-side.
My sample report has few parameters that must be passed so I pass these parameters with code.

<My code>
ReportServiceExecution.ReportExecutionService rs = new ReportServiceExecution.ReportExecutionService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
string extension, mimeType, encoding;
ReportServiceExecution.Warning[] warnings;
string[] streamID;

ParameterValue[] parameters = new ParameterValue[2];

parameters[0] = new ParameterValue();
parameters[0].Name = "pID";
parameters[0].Value = "6548747";

parameters[1] = new ParameterValue();

parameters[1].Name = "pClass";

parameters[1].Value = "8";

ExecutionHeader header = new ExecutionHeader();
ExecutionInfo executionInfo = rs.LoadReport(reportPayslip.Name, null);
executionInfo = rs.SetExecutionParameters(parameters, "en-us");
rs.ExecutionHeaderValue = header;
rs.ExecutionHeaderValue.ExecutionID = executionInfo.ExecutionID;

byte[] report = rs.Render("PDF", "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>", out extension, out mimeType, out encoding, out warnings, out streamID);
</My code>

Actually, I have several more parameters but I've checked the collection and all the parameters I want are there and have values. Their names match those found in executionInfo.Parameters. But when I run my code I get the following error on Render():

<Error>
"This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. > This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. > This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value."
</Error>

I've double-checked and my parameter array does have the problematic parameter, I passed it a value but when I check executionInfo.Parameters I see that it's the only parameter that hasn't been give a default value after calling SetExecutionParameters(). So my parameters do seem to be passed but one seems to refuse getting a value. If I comment out the SetExecutionParameters() line I get, as expected a similar error but on another parameter (first one in the executionInfo.Parameters collection). So I'm left to beleive that the SetExecutionParameters() has some kind of bug as it works for all but one parameter. I've checked casing, spelling, tried passing phony parameters and from what I've seen I should be getting an error when I pass the parameters if I got something wrong.

Any help would be much appreciated.

I've done some (desperate) tests and changed the following line:
executionInfo = rs.SetExecutionParameters(parameters, "en-us");
to
executionInfo = rs.SetExecutionParameters(parameters, "fr-ch");
I'm currently based in French Switzerland but our reports are written in english, besides, the documentation about this parameter is basically "A .Net language" which is not very helpful. So now it works but I'm afraid if I have to access a server that is of another culture it will fail.

Error opening reports on web browser

Hi All

i am very new to using sql reporting services. After installation of reporting services and configuration i get this error on the browser.

Can anyone highlight the problem in the configuration?

my system is configured as

Windows 2003 SP1 server

MSSQL 2005 sp1

Server Error in '/Reports' Application.
--

The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files'.
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.Web.HttpException: The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files'.

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.

Stack Trace:

[HttpException (0x80004005): The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files'.]
System.Web.HttpRuntime.SetUpCodegenDirectory(CompilationSection compilationSection) +3474107
System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +226

[HttpException (0x80004005): The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files'.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426839
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

thanks

ga

Hello ga,

I think what you need to do is to install your version of ASP.Net. You can acomplish this by following these steps.

Navigate to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727' via a command prompt.
Type aspnet_regiis.exe -i and hit enter.
You may need to restart your server, but I can't remember for sure.

Hope this helps.

Jarret

|||

ga,

Did this fix your issue?

Jarret

|||

Jarret

Thanks a lot for the tip!

ga

|||

Glad I could help, can you mark this one as answered so others can view the solution?

Jarret

sql

Error opening PDF files exported from Reporting Services

Hi,
When I try exporting reports from Reporting Services to a PDF format, I
get the following error:
"There was an error opening this document. The file is damaged and
could not be repaired."
This has started to happen all of a sudden. There were no problems
with pdf exports before. I have checked and there have been no recent
changes to adobe reader version(5.01) on the user's machine.
Any ideas or guidance on this would be appreciated.
Thanks & Regards,
Hemil.Did you ever find a solution to this? I'm all of a sudden having the same
problem with a report that worked fine earlier.
"hemil.deshmukh@.gmail.com" wrote:
> Hi,
> When I try exporting reports from Reporting Services to a PDF format, I
> get the following error:
> "There was an error opening this document. The file is damaged and
> could not be repaired."
> This has started to happen all of a sudden. There were no problems
> with pdf exports before. I have checked and there have been no recent
> changes to adobe reader version(5.01) on the user's machine.
> Any ideas or guidance on this would be appreciated.
> Thanks & Regards,
> Hemil.
>|||If anyone knows the answer to this . . .
I believe it may have something to do with the version of Adobe Reader. I
just updated to 7.0.5 and started having the same problem. Does reporting
services have a patch or do I need to drop back a version on Adobe Reader?
--
gwf
"ryan" wrote:
> Did you ever find a solution to this? I'm all of a sudden having the same
> problem with a report that worked fine earlier.
> "hemil.deshmukh@.gmail.com" wrote:
> > Hi,
> >
> > When I try exporting reports from Reporting Services to a PDF format, I
> > get the following error:
> >
> > "There was an error opening this document. The file is damaged and
> > could not be repaired."
> >
> > This has started to happen all of a sudden. There were no problems
> > with pdf exports before. I have checked and there have been no recent
> > changes to adobe reader version(5.01) on the user's machine.
> >
> > Any ideas or guidance on this would be appreciated.
> >
> > Thanks & Regards,
> > Hemil.
> >
> >|||I am having a similar issue like the one I found on TechNet (at the bottom of
this email).
There are 4 emails generated by Reporting Services for this particular
report, two go to our customers in the â'To:â' area of the email and two in the
â'Bcc:â' area. The two going to the â'To:â' area can not open the PDF file. They
get the error â?¦
Adobe Reader could not open 'Dealer Report FI Only [1].pdf because its
either not a supported file type or because the file has been damaged (for
example, it was sent as an email attachment and wasnt correctly decoded).
(note that the above message was typed by our customer and may not be
exactly what was issued)
The customer says that they have the latest version of Adobe Reader. The
curious thing is that when they forward the email to me I can open it just
fine. Very strange.
Can anyone in the Microsoft world help with this issue?
Thanks,
Larry
"hemil.deshmukh@.gmail.com" wrote:
> Hi,
> When I try exporting reports from Reporting Services to a PDF format, I
> get the following error:
> "There was an error opening this document. The file is damaged and
> could not be repaired."
> This has started to happen all of a sudden. There were no problems
> with pdf exports before. I have checked and there have been no recent
> changes to adobe reader version(5.01) on the user's machine.
> Any ideas or guidance on this would be appreciated.
> Thanks & Regards,
> Hemil.
>

Error on reporting services

I am using VS 2003 + SQL Server 2000 Reporting services.

When i want to print the report, clicking the trigger button, and pop up a browser and get the following error.

Error occurs when handling the report (rsProcessingAborted)

Request on dataset 'PG' fails (rsErrorExecutingCommand)

Must declare the variable'@.qcode'.

- I already got qcode in my url link... i would like to know what's the problems about.

Thank you.

Hi,

Can you run this report successfully when you browse the report in the VS.NET IDE?

I think, you are passing a parameter which is not declared in the stored procedure. Are you using a stored procedure as the datasource of the dataset PG by the way?

Since you have the parameter qcode in the url, either this parameter is not defined in the report or is not defined in the SP.

You know, while naming parameters in SQL RS, you do not use the "@." preior the parameter name, but you use it within the sql SP.

Eralper

http://www.kodyaz.com

Error on reporting service

I got a error like below.
Anyone has any idea?
================================== An unexpected error occurred in Report Processing.
(rsInternalError) Get Online Help
For more information about this error navigate to the
report server on the local server machine, or enable remote errorsOn Apr 20, 9:25 am, "Ken" <k...@.jeromegroup.com> wrote:
> I got a error like below.
> Anyone has any idea?
> ==================================> An unexpected error occurred in Report Processing.
> (rsInternalError) Get Online Help
> For more information about this error navigate to the
> report server on the local server machine, or enable remote errors
This is kind-of a vague error. To check the SSRS log file for possible
error reasons or descriptions, go to the following location (normally,
may vary slightly):
C:\Program Files\Microsoft SQL Server\MSSQL.2(it may be MSSQL.3 (etc),
depending on the number of services installed)\Reporting Services
\LogFiles.
and see if the log file around the time of the error explains the
problem any better. Hope this is helpful.
Regards,
Enrique Martinez
Sr. Software Consultantsql

Error on Reporting Server - but only through the ReportViewer control

We are using the webviewer control.

We get the following error when we try to export to EXCEL.

InternetExploer cannot download ...n=OnlyHtmlInline&Format=EXCEL from app.webcobra.com.

Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later.

This error comes up almost immediatly after it starts trying to download the file. It is a large dataset but it isn't "overly large". There are basically 44 records.

The other wierd thing is that it works fine on our BETA servers but not on our Production servers. We figure this is a setting somewhere that we have missed.

And now I found out that if it just leave it sitting there it eventually asks me if I want to open the file and it opened fine.

So what was the above error all about?

Does anyone have any ideas that I can look into?

Thanks!

Doesn't sound like a reporting service config problem. Maybe you should check your pro box or firewall's settings, including authentication, etc.|||

It doesn't happen with smaller amounts of records. If I have 4 or 5 records it doesn't give the message.

|||There is no firewall between the production box and the application servers.|||

Here is the fix...it problem was SSL

"Internet Explorer file downloads over SSL do not work with the cache control headers"

http://support.microsoft.com/kb/323308/en-us

|||

Well, that didn't fix it. It was promising but it didn't work.

First, the registry update is on a client computer. We don't have access to everyone's client computer. We need a fix for our servers.

And we updated one of our computers with the registry fix and we still got the message. Any other ideas?

|||

Hi:

We had the same issue. Does your fixed?

Error on Reporting Server - but only through the ReportViewer control

We are using the webviewer control.

We get the following error when we try to export to EXCEL.

InternetExploer cannot download ...n=OnlyHtmlInline&Format=EXCEL from app.webcobra.com.

Internet Explorer was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later.

This error comes up almost immediatly after it starts trying to download the file. It is a large dataset but it isn't "overly large". There are basically 44 records.

The other wierd thing is that it works fine on our BETA servers but not on our Production servers. We figure this is a setting somewhere that we have missed.

And now I found out that if it just leave it sitting there it eventually asks me if I want to open the file and it opened fine.

So what was the above error all about?

Does anyone have any ideas that I can look into?

Thanks!

Doesn't sound like a reporting service config problem. Maybe you should check your pro box or firewall's settings, including authentication, etc.|||

It doesn't happen with smaller amounts of records. If I have 4 or 5 records it doesn't give the message.

|||There is no firewall between the production box and the application servers.|||

Here is the fix...it problem was SSL

"Internet Explorer file downloads over SSL do not work with the cache control headers"

http://support.microsoft.com/kb/323308/en-us

|||

Well, that didn't fix it. It was promising but it didn't work.

First, the registry update is on a client computer. We don't have access to everyone's client computer. We need a fix for our servers.

And we updated one of our computers with the registry fix and we still got the message. Any other ideas?

|||

Hi:

We had the same issue. Does your fixed?

Error on Report based on Analysis Services

I've got most of my first stab at using Reporting Services. I am using the
Report Viewer control in VS 2005. When I point it at a report based on
standard TSQL it runs. My next query is based on Analysis Services. It runs
via the URL when I login as an Administrator but I get the following error
when I do it via the Report Viewer. The problem is the web server can't
"see" itself (i.e. typing the URL of the ASP.net page doesn't seem to work)-
something which I will get the network people to look at tomorrow so I can't
see a more detailed error. I am just starting trying to get an understanding
of roles etc but some pointers would be great. Regards, Chris.
a..
An error has occurred during report processing. a.. Query execution failed
for data set 'Analysis_Services_Project1'. a.. For more information about
this error navigate to the report server on the local server machine, or
enable remote errors a..I figured it out - I needed to add the IUSR as a role to the Analysis
Services DB.
"Fresno Bob" <nospam@.nospam.com> wrote in message
news:%23QvrOp98HHA.3940@.TK2MSFTNGP05.phx.gbl...
> I've got most of my first stab at using Reporting Services. I am using the
> Report Viewer control in VS 2005. When I point it at a report based on
> standard TSQL it runs. My next query is based on Analysis Services. It
> runs via the URL when I login as an Administrator but I get the following
> error when I do it via the Report Viewer. The problem is the web server
> can't "see" itself (i.e. typing the URL of the ASP.net page doesn't seem
> to work)- something which I will get the network people to look at
> tomorrow so I can't see a more detailed error. I am just starting trying
> to get an understanding of roles etc but some pointers would be great.
> Regards, Chris.
> a..
> An error has occurred during report processing. a.. Query execution failed
> for data set 'Analysis_Services_Project1'. a.. For more information about
> this error navigate to the report server on the local server machine, or
> enable remote errors a..
>

Error on one of SQL Reporting Services Samples

Hi there,
I am running the reports that comes with the samples one and I'm getting
this error when I run this code;
="SELECT c.firstname, c.lastname, e.title, d.departmentID " &
"From HumanResources.EmployeeDepartmentHistory D " &
"INNER JOIN HumanResources.Employee E " &
"ON D.EmployeeID = E.EmployeeID " &
"INNER JOIN Person.Contact C " &
"ON E.ContactID = C.ContactID " &
Iif(Parameters!Department.Value = 0, "", "WHERE D.DepartmentID = " &
Parameters!Department.Value) &
"ORDER BY C.LastName"
The error is saying that all those columns can not be bounded. can anybody
tells me where the error is this piece of code?
Thanks very much in advance.
Midway.The IIF in there is for internal RS expressions and not T-SQL. This appears
to have been modified ('). Which report and dataset is this from?
SalesEmps within the Employee Sales Summary report looks similiar:
SELECT E.EmployeeID, C.FirstName + N' ' + C.LastName AS Employee
FROM HumanResources.Employee E INNER JOIN
Sales.SalesPerson SP ON E.EmployeeID = SP.SalesPersonID INNER JOIN
Person.Contact C ON E.ContactID = C.ContactID
ORDER BY C.LastName, C.FirstName
RDA Corp
Business Intelligence Evangelist Leader
www.rdacorp.com
"Midway" wrote:
> Hi there,
> I am running the reports that comes with the samples one and I'm getting
> this error when I run this code;
> ="SELECT c.firstname, c.lastname, e.title, d.departmentID " &
> "From HumanResources.EmployeeDepartmentHistory D " &
> "INNER JOIN HumanResources.Employee E " &
> "ON D.EmployeeID = E.EmployeeID " &
> "INNER JOIN Person.Contact C " &
> "ON E.ContactID = C.ContactID " &
> Iif(Parameters!Department.Value = 0, "", "WHERE D.DepartmentID = " &
> Parameters!Department.Value) &
> "ORDER BY C.LastName"
> The error is saying that all those columns can not be bounded. can anybody
> tells me where the error is this piece of code?
> Thanks very much in advance.
> Midway.

Error on install

I'm trying to install an instance of Reporting Services onto a 2003 Server.
Everything works great until I get to the part where I connect it to a
database. I'm attempting to connect it to a SQL 2005 server. I get an error
when it trys to "Create A Grants Rights Script." Here's the rest of the error:
System.Management.ManagementException: Access denied
at
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
errorCode)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String
machine)
at
ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
dbServer)
at
ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
connectionString, String server, String database,
ConfigurationCredentialsType credsType, String account, String password,
Boolean upgrade, String dbVersion)
Now. There should be no reson for me to get an access denied error on this
portion. I've tried it 2 different ways. First, I've tried using my windows
credentials. I'm the system dba with all the access, secondly, I've tried
creating a sql account will all the access I can possibly give it, and I
still get this error.
Any ideas anyone has would be great.
-- CaseyHi Casey,
I am having same problem, do you have any luck?
thanks.
SKip
"Casey" wrote:
> I'm trying to install an instance of Reporting Services onto a 2003 Server.
> Everything works great until I get to the part where I connect it to a
> database. I'm attempting to connect it to a SQL 2005 server. I get an error
> when it trys to "Create A Grants Rights Script." Here's the rest of the error:
> System.Management.ManagementException: Access denied
> at
> System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
> errorCode)
> at System.Management.ManagementScope.InitializeGuts(Object o)
> at System.Management.ManagementScope.Initialize()
> at System.Management.ManagementObjectSearcher.Initialize()
> at System.Management.ManagementObjectSearcher.Get()
> at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String
> machine)
> at
> ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> dbServer)
> at
> ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> connectionString, String server, String database,
> ConfigurationCredentialsType credsType, String account, String password,
> Boolean upgrade, String dbVersion)
> Now. There should be no reson for me to get an access denied error on this
> portion. I've tried it 2 different ways. First, I've tried using my windows
> credentials. I'm the system dba with all the access, secondly, I've tried
> creating a sql account will all the access I can possibly give it, and I
> still get this error.
> Any ideas anyone has would be great.
> -- Casey|||Hi,
I am also having the same problem. Please anybody has an answer the this?
Thanks,
Henry
"Skip" wrote:
> Hi Casey,
> I am having same problem, do you have any luck?
> thanks.
> SKip
> "Casey" wrote:
> > I'm trying to install an instance of Reporting Services onto a 2003 Server.
> > Everything works great until I get to the part where I connect it to a
> > database. I'm attempting to connect it to a SQL 2005 server. I get an error
> > when it trys to "Create A Grants Rights Script." Here's the rest of the error:
> >
> > System.Management.ManagementException: Access denied
> > at
> > System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
> > errorCode)
> > at System.Management.ManagementScope.InitializeGuts(Object o)
> > at System.Management.ManagementScope.Initialize()
> > at System.Management.ManagementObjectSearcher.Initialize()
> > at System.Management.ManagementObjectSearcher.Get()
> > at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String
> > machine)
> > at
> > ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> > dbServer)
> > at
> > ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> > connectionString, String server, String database,
> > ConfigurationCredentialsType credsType, String account, String password,
> > Boolean upgrade, String dbVersion)
> >
> > Now. There should be no reson for me to get an access denied error on this
> > portion. I've tried it 2 different ways. First, I've tried using my windows
> > credentials. I'm the system dba with all the access, secondly, I've tried
> > creating a sql account will all the access I can possibly give it, and I
> > still get this error.
> >
> > Any ideas anyone has would be great.
> >
> > -- Casey

Error on generating report

I am using VS2003 and SQL Server 2000 with Reporting Services.

I try to generate the report but get an error "must declare the variable '@.qcode'

I check the file quotation.rdl and i found it should have declared... it's like

</PageFooter>
<ReportParameters>
<ReportParameter Name="qcode">
<DataType>String</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<DataSetReference>
<DataSetName>DS_quot_code</DataSetName>
<ValueField>quot_code</ValueField>
</DataSetReference>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Quotation Code:</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>DS_quot_code</DataSetName>
<ValueField>quot_code</ValueField>
<LabelField>quot_code</LabelField>
</DataSetReference>
</ValidValues>
</ReportParameter>

I would like to know what trigger the problem and what shall i do so as to solve it?

Thank you.

This sounds for me like a SQL Exception not a Reporting Services error. Can you run the command which is specified as the dataset command separately, or does it come up with the same error (I guess this is the case)

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Thank you for your answer.

Does you mean that the problem comes from the SQL query stated in the rdl file?

|||Exactly.

Error on Exporting Matrix to Excel

I get the following error when deploying my matrix to excel:
Reporting Services Error
----
Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help
Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.
Object reference not set to an instance of an object.
----
Microsoft Reporting Services
I was previously able to export(prior to SP1). Any thoughts?
Thanks,
ShaneCan you post the RDL? Can you view source on the error page and see the
stack trace?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shane Castle" <ShaneCastle@.discussions.microsoft.com> wrote in message
news:E54AA708-882E-4960-98AB-A16A0F34A27C@.microsoft.com...
>I get the following error when deploying my matrix to excel:
> Reporting Services Error
> ----
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> Object reference not set to an instance of an object.
> ----
> Microsoft Reporting Services
> I was previously able to export(prior to SP1). Any thoughts?
> Thanks,
> Shane