rsInternalError

I get this error message while deploying report:
An internal error occurred on the report server.
See the error log for more details. (rsInternalError)
Invalid text, ntext, or image pointer value
0xFDFF7F5F000000000303000001000200.
The statement has been terminated.
This happens to all reports I am trying to deploy either through VS.NET or
froom rds file
How do I resolve it?
Thanks,
-StanHI,
Did you ever resolve this issue? I'm getting the same message. Just
started during my last attempt to deploy.
thanks
"Stan" wrote:
> I get this error message while deploying report:
> An internal error occurred on the report server.
> See the error log for more details. (rsInternalError)
> Invalid text, ntext, or image pointer value
> 0xFDFF7F5F000000000303000001000200.
> The statement has been terminated.
> This happens to all reports I am trying to deploy either through VS.NET or
> froom rds file
> How do I resolve it?
>
> Thanks,
> -Stan
>
>

rs.exe Questions on using rss file

Multiple Questions on deploying a bulk insertion script file for inserting
reports into reporting services. The script provided by MSDN PublishReports
is really straight forward with some exceptions or at least for me.
How can I ensure that the Data connection that is added in the script gets
added to each report that gets published in the script?
I am recieving an error that states the data set 'Default' refers to a
shared data source 'Default', which is not published on the report server
when I run my script. However the dataconnection that I specified in the
script gets created by the script and works perfectly.
How can I specify a Published Name that is different than the Report.rdl
Name in the scrtipt at the time of insertion? Basically just as if you were
to do the publishing of a report one at a time through the manager and after
uploading the file you can change the name of the Report. How can I do that
in the script?
Thank you for the assitance!
Bradd
please email me @. the following address if you need further clarification to
help my stupid mind. bradd.schick@.fnf.com Thank youSorry the Data Connection taht I am creating in the script is not called
default it is named something different. Just incase anyone neede to know
that.
So Why am I getting an error on Default?
Thanks again
"Bradd Schick" wrote:
> Multiple Questions on deploying a bulk insertion script file for inserting
> reports into reporting services. The script provided by MSDN PublishReports
> is really straight forward with some exceptions or at least for me.
> How can I ensure that the Data connection that is added in the script gets
> added to each report that gets published in the script?
> I am recieving an error that states the data set 'Default' refers to a
> shared data source 'Default', which is not published on the report server
> when I run my script. However the dataconnection that I specified in the
> script gets created by the script and works perfectly.
> How can I specify a Published Name that is different than the Report.rdl
> Name in the scrtipt at the time of insertion? Basically just as if you were
> to do the publishing of a report one at a time through the manager and after
> uploading the file you can change the name of the Report. How can I do that
> in the script?
> Thank you for the assitance!
> Bradd
> please email me @. the following address if you need further clarification to
> help my stupid mind. bradd.schick@.fnf.com Thank you|||Alright I got my head out of you know where and I have solved the first
question of the data connection's. The person writing the report (rdl) file
screwed up. I still need help on the second question of the report name.
Thanks
"Bradd Schick" wrote:
> Multiple Questions on deploying a bulk insertion script file for inserting
> reports into reporting services. The script provided by MSDN PublishReports
> is really straight forward with some exceptions or at least for me.
> How can I ensure that the Data connection that is added in the script gets
> added to each report that gets published in the script?
> I am recieving an error that states the data set 'Default' refers to a
> shared data source 'Default', which is not published on the report server
> when I run my script. However the dataconnection that I specified in the
> script gets created by the script and works perfectly.
> How can I specify a Published Name that is different than the Report.rdl
> Name in the scrtipt at the time of insertion? Basically just as if you were
> to do the publishing of a report one at a time through the manager and after
> uploading the file you can change the name of the Report. How can I do that
> in the script?
> Thank you for the assitance!
> Bradd
> please email me @. the following address if you need further clarification to
> help my stupid mind. bradd.schick@.fnf.com Thank you|||Try this snippet in your script:
' Create an array representing the files in the specified directory.
Dim di As New DirectoryInfo(strPathName)
Dim fi As FileInfo() = di.GetFiles()
' Optional to echo to console
Console.WriteLine("The following files exist in the current
directory:")
' Iterate through the names of the files in the current directory.
Dim fiTemp As FileInfo
For Each fiTemp In fi
strReportName = Path.GetFileNameWithoutExtension(fiTemp.Name)
PublishReport(strReportName)
Next fiTemp
Just a bit of those new VB .NET methods.
--
Brian J. Matuschak
brian@.electronic-atlas.com
"Bradd Schick" wrote:
> Alright I got my head out of you know where and I have solved the first
> question of the data connection's. The person writing the report (rdl) file
> screwed up. I still need help on the second question of the report name.
> Thanks
> "Bradd Schick" wrote:
> > Multiple Questions on deploying a bulk insertion script file for inserting
> > reports into reporting services. The script provided by MSDN PublishReports
> > is really straight forward with some exceptions or at least for me.
> >
> > How can I ensure that the Data connection that is added in the script gets
> > added to each report that gets published in the script?
> > I am recieving an error that states the data set 'Default' refers to a
> > shared data source 'Default', which is not published on the report server
> > when I run my script. However the dataconnection that I specified in the
> > script gets created by the script and works perfectly.
> >
> > How can I specify a Published Name that is different than the Report.rdl
> > Name in the scrtipt at the time of insertion? Basically just as if you were
> > to do the publishing of a report one at a time through the manager and after
> > uploading the file you can change the name of the Report. How can I do that
> > in the script?
> >
> > Thank you for the assitance!
> >
> > Bradd
> > please email me @. the following address if you need further clarification to
> > help my stupid mind. bradd.schick@.fnf.com Thank you

RS utility - folder structure for storing reports

I am trying to use the RS utility for deploying reports I create to our
customers. I need to hand them an install CD that does everything. I can
deploy reports via RS, but I am wondering how to preserve a folder structure
for organizing the reports. Also, how do I script subscriptions, and deploy
RDSs. The sample MS provides creates a new data source, not use the ones I
have already created in report design.
Thanks,
--
JasonYou might want to have a look at Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62
I haven't got around to subscriptions yet but it should handle most of you
requirements
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:6F2C98BD-CA88-4D6C-9BB9-A33960052690@.microsoft.com...
>I am trying to use the RS utility for deploying reports I create to our
> customers. I need to hand them an install CD that does everything. I can
> deploy reports via RS, but I am wondering how to preserve a folder
> structure
> for organizing the reports. Also, how do I script subscriptions, and
> deploy
> RDSs. The sample MS provides creates a new data source, not use the ones
> I
> have already created in report design.
> Thanks,
> --
> Jason|||Thanks. Like like a great utility. Is it freeware?
"Jasper Smith" wrote:
> You might want to have a look at Reporting Services Scripter
> http://www.sqldbatips.com/showarticle.asp?ID=62
> I haven't got around to subscriptions yet but it should handle most of you
> requirements
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
> news:6F2C98BD-CA88-4D6C-9BB9-A33960052690@.microsoft.com...
> >I am trying to use the RS utility for deploying reports I create to our
> > customers. I need to hand them an install CD that does everything. I can
> > deploy reports via RS, but I am wondering how to preserve a folder
> > structure
> > for organizing the reports. Also, how do I script subscriptions, and
> > deploy
> > RDSs. The sample MS provides creates a new data source, not use the ones
> > I
> > have already created in report design.
> >
> > Thanks,
> > --
> > Jason
>
>

RS problems after upgrade from SQLExpress to Standard

Hello

I've uninstalled SQLExpress(with adv. features, RS worked fine) and then installed Standard edition.

After reinstallation and deploying reports I failed in viewing report through web browser.

Here are errors:

- when I try to view report

Reporting Services Error

---

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Error executing child request for /ReportServer/Pages/ReportViewer.aspx. Exception of type 'System.Web.HttpUnhandledException' was thrown. Value does not fall within the expected range.

- when I try to navigate to Get Online Help Error executing child request for /ReportServer/Pages/ReportViewer.aspx. Exception of type 'System.Web.HttpUnhandledException' was thrown. Value does not fall within the expected range.

- when I try to navigate to http://localhost/reports

The website cannot display the page

Thank you for any help!

Here is log:

aspnet_wp!library!1!05/09/2007-17:05:01:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.InvalidOperationException: Computer name could not be obtained.
at System.Environment.get_MachineName()
at Microsoft.ReportingServices.Diagnostics.RunningJobContext..ctor(String jobId, String requestPath, JobActionEnum action, JobType type, RunningJobList parentList, UserContext userContext, HttpContext optionalWebCtx)
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase..ctor(String jobId, String requestPath, JobActionEnum action, JobType jobType, UserContext userContext)

.....

aspnet_wp!library!1!05/09/2007-17:05:01:: e ERROR: Error rending control: System.ArgumentException: Value does not fall within the expected range.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at System.Web.Configuration.MachineKeySection.GetHMACSHA1Hash(Byte[] buf, Byte[] modifier, Int32 start, Int32 length)
at System.Web.Configuration.MachineKeySection.HashData(Byte[] buf, Byte[] modifier, Int32 start, Int32 length)
at System.Web.Configuration.MachineKeySection.GetEncodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32& length)
at System.Web.UI.ObjectStateFormatter.Serialize(Object stateGraph)
at System.Web.UI.ObjectStateFormatter.System.Web.UI.IStateFormatter.Serialize(Object state)
at System.Web.UI.Util.SerializeWithAssert(IStateFormatter formatter, Object stateGraph)
at System.Web.UI.HiddenFieldPageStatePersister.Save()
at System.Web.UI.Page.SavePageStateToPersistenceMedium(Object state)
at System.Web.UI.Page.SaveAllState()

.....