Showing posts with label experiencing. Show all posts
Showing posts with label experiencing. Show all posts

Friday, March 23, 2012

Report Viewer Control - Export to PDF, Works on local IIS computer, but not another.

When exporting a report to a pdf file, I am experiencing what seems to be a "hang up" on the server. The code executes fine from my development machine, but when moved to the server I get this response. I also recieve this message if I click the refresh button. Acrobat could not open 'pdf9c9.tmp' because it is either not a supported file type or because the file has been damaged (for example, it was sent as an email attachment and wasn't correctly decode). To create an Adobe PDF document, go to the source application. Then print the document to Adobe PDF.

Here is my code for reference. It works fine on one IIS, but not another. What could I be missing?

Dim warningsAs Microsoft.Reporting.WebForms.Warning() =Nothing

Dim streamidsAsString() =Nothing

Dim mimeTypeAsString =Nothing

Dim encodingAsString =Nothing

Dim extensionAsString =Nothing

Dim deviceInfoAsString

Dim bytesAsByte()

Dim lrAsNew Microsoft.Reporting.WebForms.LocalReport

lr.ReportPath ="Report1.rdlc"

'lr.DataSources.Add(New Microsoft.Reporting.WebForms.ReportDataSource("DischargeSummary", ObjectDataSource1()))

deviceInfo ="<DeviceInfo><SimplePageHeaders>True</SimplePageHeaders></DeviceInfo>"

bytes = ReportViewer1.LocalReport.Render("PDF", deviceInfo, mimeType, encoding, extension, streamids, warnings)

Response.ClearContent()

Response.ClearHeaders()

Response.ContentType ="application/pdf"

Response.BinaryWrite(bytes)

Response.Flush()

Response.Close()

Check security permission on the server.

Monday, March 12, 2012

Report Services Error

We are cuurently experiencing problems with the reporting services web site.
You can deploy new rep-orts to the site but when you attempt to examine the
properties of the report (or data source) the following error is displayed
Unable to generate a temporary class (result=1). error CS1514: { expected
error CS1001: Identifier expected error CS1031: Type expected error CS1519:
Invalid token '{' in class, struct, or interface member declaration error
CS1514: { expected error CS1001: Identifier expected error CS1031: Type
expected error CS1519: Invalid token '{' in class, struct, or interface
member declaration
In the logs the folowing details can be extracted
error CS1519: Invalid token '{' in class, struct, or interface member
declaration
at System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns,
CompilerParameters parameters, Evidence evidence)
at System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[]
xmlMappings, Type[] types, String defaultNamespace, Evidence evidence,
CompilerParameters parameters, Assembly assembly, Hashtable assemblies)
at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings,
Type[] types, String defaultNamespace, String location, Evidence evidence)
at System.Xml.Serialization.XmlSerializer.GenerateTempAssembly(XmlMapping
xmlMapping, Type type, String defaultNamespace)
at System.Xml.Serialization.XmlSerializer..ctor(Type type, String
defaultNamespace)
at System.Xml.Serialization.XmlSerializer..ctor(Type type)
at
Microsoft.ReportingServices.UI.SerializeHelper.SerializeExtensionArray(Extension[] extensions)
at
Microsoft.ReportingServices.UI.DataSourceProperties.GetDataExtensionList()
at
Microsoft.ReportingServices.UI.DataSourceProperties.Control_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.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.AddedControl(Control control, Int32 index)
at System.Web.UI.ControlCollection.Add(Control child)
at Microsoft.ReportingServices.UI.SharedArea.Control_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.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.AddedControl(Control control, Int32 index)
at System.Web.UI.ControlCollection.Add(Control child)
at Microsoft.ReportingServices.UI.DataSourcePage.Page_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.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!1598!08/07/2005-10:44:16:: 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 would be greatly appreciated.
Thanks in advance.
NickI have the same trouble - any solutions yet?
Thanks
Rainer
"chamben" wrote:
> We are cuurently experiencing problems with the reporting services web site.
> You can deploy new rep-orts to the site but when you attempt to examine the
> properties of the report (or data source) the following error is displayed
> Unable to generate a temporary class (result=1). error CS1514: { expected
> error CS1001: Identifier expected error CS1031: Type expected error CS1519:
> Invalid token '{' in class, struct, or interface member declaration error
> CS1514: { expected error CS1001: Identifier expected error CS1031: Type
> expected error CS1519: Invalid token '{' in class, struct, or interface
> member declaration
> In the logs the folowing details can be extracted
> error CS1519: Invalid token '{' in class, struct, or interface member
> declaration
> at System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns,
> CompilerParameters parameters, Evidence evidence)
> at System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[]
> xmlMappings, Type[] types, String defaultNamespace, Evidence evidence,
> CompilerParameters parameters, Assembly assembly, Hashtable assemblies)
> at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings,
> Type[] types, String defaultNamespace, String location, Evidence evidence)
> at System.Xml.Serialization.XmlSerializer.GenerateTempAssembly(XmlMapping
> xmlMapping, Type type, String defaultNamespace)
> at System.Xml.Serialization.XmlSerializer..ctor(Type type, String
> defaultNamespace)
> at System.Xml.Serialization.XmlSerializer..ctor(Type type)
> at
> Microsoft.ReportingServices.UI.SerializeHelper.SerializeExtensionArray(Extension[] extensions)
> at
> Microsoft.ReportingServices.UI.DataSourceProperties.GetDataExtensionList()
> at
> Microsoft.ReportingServices.UI.DataSourceProperties.Control_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.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Control.AddedControl(Control control, Int32 index)
> at System.Web.UI.ControlCollection.Add(Control child)
> at Microsoft.ReportingServices.UI.SharedArea.Control_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.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Control.AddedControl(Control control, Int32 index)
> at System.Web.UI.ControlCollection.Add(Control child)
> at Microsoft.ReportingServices.UI.DataSourcePage.Page_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.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!1598!08/07/2005-10:44:16:: 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 would be greatly appreciated.
> Thanks in advance.
> Nick|||I just started getting this error message when trying to edit subscriptions
(funny that I used to be able to do this just fine). A quick search at
google returned:
http://support.microsoft.com/default.aspx?scid=kb;en-us;896181&sd=rss&spid=1249
I am trying to get the Hotfix right now to see if it fixes the problem.
Don't know if this will solve your problem but it may.
Cheers!
"Rainer" wrote:
> I have the same trouble - any solutions yet?
> Thanks
> Rainer
> "chamben" wrote:
> > We are cuurently experiencing problems with the reporting services web site.
> > You can deploy new rep-orts to the site but when you attempt to examine the
> > properties of the report (or data source) the following error is displayed
> >
> > Unable to generate a temporary class (result=1). error CS1514: { expected
> > error CS1001: Identifier expected error CS1031: Type expected error CS1519:
> > Invalid token '{' in class, struct, or interface member declaration error
> > CS1514: { expected error CS1001: Identifier expected error CS1031: Type
> > expected error CS1519: Invalid token '{' in class, struct, or interface
> > member declaration
> >
> > In the logs the folowing details can be extracted
> >
> > error CS1519: Invalid token '{' in class, struct, or interface member
> > declaration
> >
> > at System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns,
> > CompilerParameters parameters, Evidence evidence)
> > at System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[]
> > xmlMappings, Type[] types, String defaultNamespace, Evidence evidence,
> > CompilerParameters parameters, Assembly assembly, Hashtable assemblies)
> > at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings,
> > Type[] types, String defaultNamespace, String location, Evidence evidence)
> > at System.Xml.Serialization.XmlSerializer.GenerateTempAssembly(XmlMapping
> > xmlMapping, Type type, String defaultNamespace)
> > at System.Xml.Serialization.XmlSerializer..ctor(Type type, String
> > defaultNamespace)
> > at System.Xml.Serialization.XmlSerializer..ctor(Type type)
> > at
> > Microsoft.ReportingServices.UI.SerializeHelper.SerializeExtensionArray(Extension[] extensions)
> > at
> > Microsoft.ReportingServices.UI.DataSourceProperties.GetDataExtensionList()
> > at
> > Microsoft.ReportingServices.UI.DataSourceProperties.Control_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.Control.InitRecursive(Control namingContainer)
> > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > at System.Web.UI.Control.AddedControl(Control control, Int32 index)
> > at System.Web.UI.ControlCollection.Add(Control child)
> > at Microsoft.ReportingServices.UI.SharedArea.Control_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.Control.InitRecursive(Control namingContainer)
> > at System.Web.UI.Control.AddedControl(Control control, Int32 index)
> > at System.Web.UI.ControlCollection.Add(Control child)
> > at Microsoft.ReportingServices.UI.DataSourcePage.Page_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.Control.InitRecursive(Control namingContainer)
> > at System.Web.UI.Page.ProcessRequestMain()
> > w3wp!ui!1598!08/07/2005-10:44:16:: 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 would be greatly appreciated.
> >
> > Thanks in advance.
> >
> > Nick|||The link I gave before was for something else. This one is actually the
right one:
http://support.microsoft.com/?kbid=895242&SD=tech
Sorry. Looks like you just need to uninstall a security update apply a
patch and then reapply the security update (but differently this time).
Cheers!
"asnewbie+rs=argh" wrote:
> I just started getting this error message when trying to edit subscriptions
> (funny that I used to be able to do this just fine). A quick search at
> google returned:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;896181&sd=rss&spid=1249
> I am trying to get the Hotfix right now to see if it fixes the problem.
> Don't know if this will solve your problem but it may.
> Cheers!
> "Rainer" wrote:
> > I have the same trouble - any solutions yet?
> >
> > Thanks
> > Rainer
> >
> > "chamben" wrote:
> >
> > > We are cuurently experiencing problems with the reporting services web site.
> > > You can deploy new rep-orts to the site but when you attempt to examine the
> > > properties of the report (or data source) the following error is displayed
> > >
> > > Unable to generate a temporary class (result=1). error CS1514: { expected
> > > error CS1001: Identifier expected error CS1031: Type expected error CS1519:
> > > Invalid token '{' in class, struct, or interface member declaration error
> > > CS1514: { expected error CS1001: Identifier expected error CS1031: Type
> > > expected error CS1519: Invalid token '{' in class, struct, or interface
> > > member declaration
> > >
> > > In the logs the folowing details can be extracted
> > >
> > > error CS1519: Invalid token '{' in class, struct, or interface member
> > > declaration
> > >
> > > at System.Xml.Serialization.Compiler.Compile(Assembly parent, String ns,
> > > CompilerParameters parameters, Evidence evidence)
> > > at System.Xml.Serialization.TempAssembly.GenerateAssembly(XmlMapping[]
> > > xmlMappings, Type[] types, String defaultNamespace, Evidence evidence,
> > > CompilerParameters parameters, Assembly assembly, Hashtable assemblies)
> > > at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings,
> > > Type[] types, String defaultNamespace, String location, Evidence evidence)
> > > at System.Xml.Serialization.XmlSerializer.GenerateTempAssembly(XmlMapping
> > > xmlMapping, Type type, String defaultNamespace)
> > > at System.Xml.Serialization.XmlSerializer..ctor(Type type, String
> > > defaultNamespace)
> > > at System.Xml.Serialization.XmlSerializer..ctor(Type type)
> > > at
> > > Microsoft.ReportingServices.UI.SerializeHelper.SerializeExtensionArray(Extension[] extensions)
> > > at
> > > Microsoft.ReportingServices.UI.DataSourceProperties.GetDataExtensionList()
> > > at
> > > Microsoft.ReportingServices.UI.DataSourceProperties.Control_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.Control.InitRecursive(Control namingContainer)
> > > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > > at System.Web.UI.Control.AddedControl(Control control, Int32 index)
> > > at System.Web.UI.ControlCollection.Add(Control child)
> > > at Microsoft.ReportingServices.UI.SharedArea.Control_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.Control.InitRecursive(Control namingContainer)
> > > at System.Web.UI.Control.AddedControl(Control control, Int32 index)
> > > at System.Web.UI.ControlCollection.Add(Control child)
> > > at Microsoft.ReportingServices.UI.DataSourcePage.Page_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.Control.InitRecursive(Control namingContainer)
> > > at System.Web.UI.Page.ProcessRequestMain()
> > > w3wp!ui!1598!08/07/2005-10:44:16:: 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 would be greatly appreciated.
> > >
> > > Thanks in advance.
> > >
> > > Nick

Friday, March 9, 2012

Report Server Windows Service cannot connect to the report server

We are experiencing the error below on our SQL Server 2005 server. Any help
would be appreciated. Thank you.
Report Server Windows Service (MSSQLSERVER) cannot connect to the report
server database.
--
MikeMike,
Try using the Reporting Services Configuration tool to help troubleshoot.
Steve MunLeeuw
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:D25C9CD8-7279-428C-AEE6-C535157ED8D6@.microsoft.com...
> We are experiencing the error below on our SQL Server 2005 server. Any
> help
> would be appreciated. Thank you.
> Report Server Windows Service (MSSQLSERVER) cannot connect to the report
> server database.
> --
> Mike|||I assume this is your Report Server database you are referring to?
Does this correct itself or do you have to restart the sql server or
service?
I'm getting these errors a lot in our production environment. They seem
to occur when there are large, poorly performing reports running. Check
to see what's running at the time of the error to see if you have long
running queries running.
I also get this one a lot too--> Scheduled operations cannot be
created. SQL Server Agent is not running.
Reporting Services does not seem to be able to handle much of a
workload.
Mike wrote:
> We are experiencing the error below on our SQL Server 2005 server. Any help
> would be appreciated. Thank you.
> Report Server Windows Service (MSSQLSERVER) cannot connect to the report
> server database.
> --
> Mike