rsInternalError Reporting Server error !

Salam,

I get this error, if any one can help me

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get For more information about this error navigate to the report server on the local server machine, or enable remote errors

But I could solve the problem by restarting the IIS , so each time this message appear I restart the IIS and the ReportServer's will work but after some time the problem again will appear . I think the problem with cache in IIS because the session still opened and not closed so how I can solve this

Hi,

Try to set up the "Recycle worker process (in minutes)" to shorter frequency in the report server application pool.

Also, you will be able to find detaild information about the service health in the log files at "Microsoft SQL Server\MSSQL.n\Reporting Services\LogFiles" folder.

Regards,

Janos

|||

Thanks,

I set up the "Recycle worker process (in minutes)" to 60 minutes and I will see .

and this is the log file for today

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Jerusalem Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__07_04_2007_12_56_21.log</Path>
<SystemName>PAYROLL</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2, v.4035</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!webserver!1!04/07/2007-12:56:21:: i INFO: Reporting Web Server started
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!04/07/2007-12:56:21:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!04/07/2007-12:56:22:: i INFO: Reporting Services starting SKU: Developer
w3wp!resourceutilities!1!04/07/2007-12:56:22:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!1!04/07/2007-12:56:22:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!04/07/2007-12:56:22:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!04/07/2007-12:56:22:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!04/07/2007-12:56:22:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!07/04/2007-12:56:24:: Call to GetPermissionsAction(/).
w3wp!library!1!07/04/2007-12:56:24:: i INFO: Catalog SQL Server Edition = Developer
w3wp!library!1!07/04/2007-12:56:24:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!5!07/04/2007-12:56:24:: Call to GetSystemPermissionsAction().
w3wp!library!7!07/04/2007-12:56:24:: Call to ListChildrenAction(/, False).
w3wp!library!6!07/04/2007-12:56:24:: Call to GetSystemPropertiesAction().
w3wp!library!7!07/04/2007-12:56:39:: Call to GetPermissionsAction(/Payroll).
w3wp!library!7!07/04/2007-12:56:39:: Call to GetPropertiesAction(/Payroll, PathBased).
w3wp!library!7!07/04/2007-12:56:39:: Call to GetSystemPermissionsAction().
w3wp!library!6!07/04/2007-12:56:39:: Call to ListChildrenAction(/Payroll, False).
w3wp!library!6!07/04/2007-12:56:39:: Call to GetSystemPropertiesAction().
w3wp!library!7!07/04/2007-12:56:44:: Call to GetPermissionsAction(/Payroll/Company).
w3wp!library!7!07/04/2007-12:56:44:: Call to GetPropertiesAction(/Payroll/Company, PathBased).
w3wp!library!7!07/04/2007-12:56:44:: Call to GetSystemPermissionsAction().
w3wp!library!7!07/04/2007-12:56:44:: Call to ListChildrenAction(/Payroll/Company, False).
w3wp!library!6!07/04/2007-12:56:44:: Call to GetSystemPropertiesAction().
w3wp!library!5!07/04/2007-12:56:46:: Call to GetPermissionsAction(/Payroll/Company/ASU-HR).
w3wp!library!7!07/04/2007-12:56:46:: Call to GetSystemPermissionsAction().
w3wp!library!7!07/04/2007-12:56:48:: Call to GetDataSourceContentsAction(/Payroll/Company/ASU-HR).
w3wp!library!5!07/04/2007-12:56:48:: Call to GetPropertiesAction(/Payroll/Company/ASU-HR, PathBased).
w3wp!library!6!07/04/2007-12:56:48:: Call to ListChildrenAction(/, False).
w3wp!library!6!07/04/2007-12:56:48:: Call to ListChildrenAction(/Payroll, False).
w3wp!library!6!07/04/2007-12:56:49:: Call to ListChildrenAction(/Payroll/Company, False).
w3wp!library!7!07/04/2007-12:56:49:: Call to ListChildrenAction(/, False).
w3wp!library!7!07/04/2007-12:56:49:: Call to ListChildrenAction(/Payroll, False).
w3wp!library!7!07/04/2007-12:56:49:: Call to ListChildrenAction(/Payroll/Company, False).
w3wp!library!5!07/04/2007-12:56:49:: Call to GetSystemPropertiesAction().
w3wp!library!7!07/04/2007-12:59:05:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeInsuranceCard).
w3wp!library!7!07/04/2007-12:59:05:: i INFO: Call to RenderFirst( '/Payroll/Company/rpt_EmployeeInsuranceCard' )
w3wp!library!7!07/04/2007-12:59:09:: Using folder C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\RSTempFiles for temporary files.
w3wp!webserver!7!07/04/2007-12:59:10:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeInsuranceCard', Stream=''
w3wp!library!5!07/04/2007-12:59:11:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeInsuranceCard).
w3wp!library!5!07/04/2007-12:59:11:: i INFO: Call to RenderNext( '/Payroll/Company/rpt_EmployeeInsuranceCard' )
w3wp!cache!5!07/04/2007-12:59:11:: i INFO: Session live: /Payroll/Company/rpt_EmployeeInsuranceCard
w3wp!webserver!5!07/04/2007-12:59:11:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeInsuranceCard', Stream=''
w3wp!library!6!07/04/2007-12:59:19:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeInsuranceCard).
w3wp!library!6!07/04/2007-12:59:19:: i INFO: Call to RenderNext( '/Payroll/Company/rpt_EmployeeInsuranceCard' )
w3wp!cache!6!07/04/2007-12:59:19:: i INFO: Session live: /Payroll/Company/rpt_EmployeeInsuranceCard
w3wp!webserver!6!07/04/2007-12:59:22:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeInsuranceCard', Stream=''
w3wp!library!6!07/04/2007-13:04:10:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeTranspotationCard).
w3wp!library!6!07/04/2007-13:04:10:: i INFO: Call to RenderFirst( '/Payroll/Company/rpt_EmployeeTranspotationCard' )
w3wp!webserver!6!07/04/2007-13:04:11:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeTranspotationCard', Stream=''
w3wp!library!7!07/04/2007-13:04:17:: Call to GetItemTypeAction(/Payroll/Company/rpt_EmployeeTranspotationCard).
w3wp!library!7!07/04/2007-13:04:17:: i INFO: Call to RenderNext( '/Payroll/Company/rpt_EmployeeTranspotationCard' )
w3wp!cache!7!07/04/2007-13:04:17:: i INFO: Session live: /Payroll/Company/rpt_EmployeeTranspotationCard
w3wp!webserver!7!07/04/2007-13:04:17:: i INFO: Processed report. Report='/Payroll/Company/rpt_EmployeeTranspotationCard', Stream=''
w3wp!library!6!7/4/2007-13:06:22:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams

|||

again the problem still exist even after I set up the Recycle worker process to 60 m .

what I can do to solve this problem.

|||Well, you must check the log files for more details to this error. Please check all log files in the directory I specified before. (just the today's file )|||

which log files there is a lot of todays files .

|||Try to check the ReportServerService_main.log, ReportServerWebApp.log.

rsInternalError - Urgent please

Hi
I am getting an error like An internal error occurred on the report
server.(rsInternalError) The timeout period elapsed prior to obtaining a
connection from the pool. This may have occurred because all pooled
connections were in use max pool size was reached
Could anyone please solve this problem.
Help is strongly appreciated.
Thanks & Best Regards
MukeshThis link might help,
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=290788
daw
"mukesh" wrote:
> Hi
> I am getting an error like An internal error occurred on the report
> server.(rsInternalError) The timeout period elapsed prior to obtaining a
> connection from the pool. This may have occurred because all pooled
> connections were in use max pool size was reached
> Could anyone please solve this problem.
> Help is strongly appreciated.
> Thanks & Best Regards
> Mukesh
>
>sql

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
>
>

RS2000 & internal RS Database in SQL 2005

Dear all,
We are migrating step by step our different environements, we would like to
migrate SQL 2005 first, then migrate all the other applications to .NET v2.0,
Reporting Services 2005, ...etc.
We already bought the new SQL 2005 servers and we have several questions
about this :
- Could Reporting Services 2000 that is installed in the Web Servers have
internal Reporting Services Databases that are installed in SQL 2005?
- Is it supported by Microsoft? if so could yoiu please indicate a link to
Microsoft Web site confirming this?
- In order to point to the new databases do we have to uninstall RS 2000
and then install it again on the same machine and pointing to the new Servers
OR can I use rsconfig.exe to change the server and create the Reporting
Services Databases?
Best regards,
Stefan
http://www.itsconsulting.frAny response to my question above?
How can I get this information?
Stefan|||I know that RS 2005 can have its databases on SQL 2000 (and is fully
supported). I do not think that it is supported the other way. My guess is
that it will do a version check of the database and complain. However, would
RS 2000 continue working if you upgraded the database? Probably, but I don't
think it is officially supported.
When you get around to migrating RS 2000 a bit of advice. When you upgrade
the server the reports are still in RS 2000 format. They will continue to
work but I had the case with a few weird little problems here and there.
When I opened each report into the RS 2005 designer and converted them to RS
2005 format and redeployed, all my little problems disappeared.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stefan" <Stefan@.discussions.microsoft.com> wrote in message
news:11DF485F-901E-4A81-9B85-813F93DE3CF3@.microsoft.com...
> Dear all,
> We are migrating step by step our different environements, we would like
> to
> migrate SQL 2005 first, then migrate all the other applications to .NET
> v2.0,
> Reporting Services 2005, ...etc.
> We already bought the new SQL 2005 servers and we have several questions
> about this :
> - Could Reporting Services 2000 that is installed in the Web Servers have
> internal Reporting Services Databases that are installed in SQL 2005?
> - Is it supported by Microsoft? if so could yoiu please indicate a link to
> Microsoft Web site confirming this?
> - In order to point to the new databases do we have to uninstall RS 2000
> and then install it again on the same machine and pointing to the new
> Servers
> OR can I use rsconfig.exe to change the server and create the Reporting
> Services Databases?
> Best regards,
> Stefan
> http://www.itsconsulting.fr
>

RS integrated with MOSS - Internal Error - AdjustTokenPrivileges

I'm running MOSS 2007 Enterprise, SQL 2005 SP2, RS integrated with MOSS and have a number of reports deployed to a Reports Library in MOSS. 3 out of 10 times I run a report I get a error message stating that 'An internal error occured on the report server.' Just hitting Apply on the parameter panel will fix the problem and render the report as expected.

Previous entries to the forum about this error hints at an error that supposedly was fixed in SP2; since I'm running SP2 something else must be the problem.

Any insight to what might cause the problem ?

Regards,

Trond

Relevant content from the RS error log included below:

04/26/07 11:42:21, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ProcessID = 7008

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ThreadId = 0

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,Flags = 0x0

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,MiniDumpFlags = 0x0

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,SqlInfoPtr = 0x47405860

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,DumpDir = <NULL>

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ExceptionRecordPtr = 0x00000000

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ContextPtr = 0x00000000

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ExtraFile = <NULL>

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,InstanceName = <NULL>

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE,ServiceName = <NULL>

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used

04/26/07 11:42:21, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used

04/26/07 11:42:23, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used

04/26/07 11:42:23, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0147.mdmp

04/26/07 11:42:23, ACTION,w3wp.exe, Watson Invoke: No

w3wp!processing!1!4/26/2007-11:42:21:: a ASSERT: Assertion failed!Call stack:

Microsoft.ReportingServices.ReportProcessing.ReportProcessing.UpdateTimingInformation(RunningJobContext jobContext, Int64 totalDurationMs, Int64 reportDataRetrievalDurationMs, Int64 reportRenderingDurationMs)

Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)

Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)

Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)

Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)

Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)

Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()

Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()

Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)

Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)

Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)

Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)

Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()

Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()

Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)

System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

System.Web.HttpApplication.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!1!4/26/2007-11:42:21:: 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 processing;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

Reapplying SP2, rebooting and then reapplying SP2 once more because I got frustrated beyond what's good for my health, seems to have fixed this issue.

Why the initial and the second SP2 didn't help is beyond my understanding.

Trond

RS deployment on load balanced servers

Could anybody offer any advice on the internal mechanics of report server?
Our server setup is as follows.
SQL Server 2000 clusters in active/passive. Load balanced web servers x 3.
One of which is a publisher with files replicated to the other two.
We'd like to set up reporting services, but need a bit of advice as to the
role of the report server.
Our plan is to set up RS on all three servers for load balancing, all
pointing to the same SQL cluster.
As I understand it, when an rdl file is deployed or uploaded to report
server, report server takes the file, breaks it down, encrypts it and
publishes it to the RS database. Is this correct? Doe RS have any other
function at this point? Are references to the reports stored on the IIS
server?
In our setup when we publish to http://abcdefg/ReportServer, our content
switches will decide which server the report is sent to. If it *doesn't* go
to our publishing server, do we need to be concerned with replication?
Also, what issues do we face RE encryption key on the three servers? We need
to ensure that they are all the same. Is this something that can be specified
during setup?
I Hope this makes sense!
JoeThis is 100% supported configuration. Search BOL for web farm (if you do not
have RS installed yet and don't have BOL then you can search the Microsoft
site for this). I don't have a web farm configuration but based on my
experience with RS this is what happens: In a web farm all the server front
ends use the same SQL Server database. So, when you deploy you only need to
deploy once and that gets the information used by the app into the database.
RS has three parts. The SQL Server database object store, and two asp.net
1.1 applications. One of the applications is core to the product, it does
all the rendering of the reports and uses the object store. The other
(Report Manager) you can consider a portal. This is optional, some people
use either URL integration or webservices and have their own front end
instead of using Report Manager.
Note that for a web farm you need to have enterprise licenses. Not only for
the SQL server cluster you have but you need an SQL Server interprise
license for each IIS server in your web farm. Every server used by RS has to
have a SQL Server license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:0739946E-1912-4EB1-BDC1-E4DA34740295@.microsoft.com...
> Could anybody offer any advice on the internal mechanics of report server?
> Our server setup is as follows.
> SQL Server 2000 clusters in active/passive. Load balanced web servers x 3.
> One of which is a publisher with files replicated to the other two.
> We'd like to set up reporting services, but need a bit of advice as to the
> role of the report server.
> Our plan is to set up RS on all three servers for load balancing, all
> pointing to the same SQL cluster.
> As I understand it, when an rdl file is deployed or uploaded to report
> server, report server takes the file, breaks it down, encrypts it and
> publishes it to the RS database. Is this correct? Doe RS have any other
> function at this point? Are references to the reports stored on the IIS
> server?
> In our setup when we publish to http://abcdefg/ReportServer, our content
> switches will decide which server the report is sent to. If it *doesn't*
go
> to our publishing server, do we need to be concerned with replication?
> Also, what issues do we face RE encryption key on the three servers? We
need
> to ensure that they are all the same. Is this something that can be
specified
> during setup?
> I Hope this makes sense!
> Joe|||Thanks for the information Bruce. It looks like our options are to compromise
our SQL cluster by putting IIS and RS on it, something anybody with an ounce
of sense wouldn't do, or to pay MS for 3 additional enterprise liscences! I
don't know about you, but this seems to me like this is a liscence to print
money!
"Bruce L-C [MVP]" wrote:
> This is 100% supported configuration. Search BOL for web farm (if you do not
> have RS installed yet and don't have BOL then you can search the Microsoft
> site for this). I don't have a web farm configuration but based on my
> experience with RS this is what happens: In a web farm all the server front
> ends use the same SQL Server database. So, when you deploy you only need to
> deploy once and that gets the information used by the app into the database.
> RS has three parts. The SQL Server database object store, and two asp.net
> 1.1 applications. One of the applications is core to the product, it does
> all the rendering of the reports and uses the object store. The other
> (Report Manager) you can consider a portal. This is optional, some people
> use either URL integration or webservices and have their own front end
> instead of using Report Manager.
> Note that for a web farm you need to have enterprise licenses. Not only for
> the SQL server cluster you have but you need an SQL Server interprise
> license for each IIS server in your web farm. Every server used by RS has to
> have a SQL Server license.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:0739946E-1912-4EB1-BDC1-E4DA34740295@.microsoft.com...
> > Could anybody offer any advice on the internal mechanics of report server?
> >
> > Our server setup is as follows.
> >
> > SQL Server 2000 clusters in active/passive. Load balanced web servers x 3.
> > One of which is a publisher with files replicated to the other two.
> >
> > We'd like to set up reporting services, but need a bit of advice as to the
> > role of the report server.
> >
> > Our plan is to set up RS on all three servers for load balancing, all
> > pointing to the same SQL cluster.
> >
> > As I understand it, when an rdl file is deployed or uploaded to report
> > server, report server takes the file, breaks it down, encrypts it and
> > publishes it to the RS database. Is this correct? Doe RS have any other
> > function at this point? Are references to the reports stored on the IIS
> > server?
> >
> > In our setup when we publish to http://abcdefg/ReportServer, our content
> > switches will decide which server the report is sent to. If it *doesn't*
> go
> > to our publishing server, do we need to be concerned with replication?
> >
> > Also, what issues do we face RE encryption key on the three servers? We
> need
> > to ensure that they are all the same. Is this something that can be
> specified
> > during setup?
> >
> > I Hope this makes sense!
> >
> > Joe
>
>|||Depends on your licensing how bad a hit it is. If you are doing processor
licenses then it is a pretty big hit. If all you are paying for is the
server license then not too bad (especially if you compare against Crystal
or BO). In my case my corporation has SQL Server client licenses covered for
all PCs so I have no CALs to do, just the server license. It is a different
story if you are doing processor licenses.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:EECC39FD-C9F0-4F5A-B6EE-C19D689A2F15@.microsoft.com...
> Thanks for the information Bruce. It looks like our options are to
compromise
> our SQL cluster by putting IIS and RS on it, something anybody with an
ounce
> of sense wouldn't do, or to pay MS for 3 additional enterprise liscences!
I
> don't know about you, but this seems to me like this is a liscence to
print
> money!
> "Bruce L-C [MVP]" wrote:
> > This is 100% supported configuration. Search BOL for web farm (if you do
not
> > have RS installed yet and don't have BOL then you can search the
Microsoft
> > site for this). I don't have a web farm configuration but based on my
> > experience with RS this is what happens: In a web farm all the server
front
> > ends use the same SQL Server database. So, when you deploy you only need
to
> > deploy once and that gets the information used by the app into the
database.
> > RS has three parts. The SQL Server database object store, and two
asp.net
> > 1.1 applications. One of the applications is core to the product, it
does
> > all the rendering of the reports and uses the object store. The other
> > (Report Manager) you can consider a portal. This is optional, some
people
> > use either URL integration or webservices and have their own front end
> > instead of using Report Manager.
> >
> > Note that for a web farm you need to have enterprise licenses. Not only
for
> > the SQL server cluster you have but you need an SQL Server interprise
> > license for each IIS server in your web farm. Every server used by RS
has to
> > have a SQL Server license.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Joe" <Joe@.discussions.microsoft.com> wrote in message
> > news:0739946E-1912-4EB1-BDC1-E4DA34740295@.microsoft.com...
> > > Could anybody offer any advice on the internal mechanics of report
server?
> > >
> > > Our server setup is as follows.
> > >
> > > SQL Server 2000 clusters in active/passive. Load balanced web servers
x 3.
> > > One of which is a publisher with files replicated to the other two.
> > >
> > > We'd like to set up reporting services, but need a bit of advice as to
the
> > > role of the report server.
> > >
> > > Our plan is to set up RS on all three servers for load balancing, all
> > > pointing to the same SQL cluster.
> > >
> > > As I understand it, when an rdl file is deployed or uploaded to report
> > > server, report server takes the file, breaks it down, encrypts it and
> > > publishes it to the RS database. Is this correct? Doe RS have any
other
> > > function at this point? Are references to the reports stored on the
IIS
> > > server?
> > >
> > > In our setup when we publish to http://abcdefg/ReportServer, our
content
> > > switches will decide which server the report is sent to. If it
*doesn't*
> > go
> > > to our publishing server, do we need to be concerned with replication?
> > >
> > > Also, what issues do we face RE encryption key on the three servers?
We
> > need
> > > to ensure that they are all the same. Is this something that can be
> > specified
> > > during setup?
> > >
> > > I Hope this makes sense!
> > >
> > > Joe
> >
> >
> >|||Per processor licenses!!

RS 2005: Subscription fails with Internal error

Hi all,

I have a (for me) strange problem with subscribing reports.

I've setup several reports that I want to create monthly and store to a file share.
In BIDS Preview and deployed to the report server everything works fine.

Each of my reports has an own schedule (they'll be created step by step), export format is Excel, as credentials I use a local user, all parameters are set porperly.
When the time to render the reports has gone, I just see the following behind each subscription:

Failure writing file LIS04 : An internal error occurred on the report

server. See the error log for more details.

The Log file contains the following: (I highlighted what I think to be the key error)

ReportingServicesService!library!4!12/19/2006-10:20:35:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!e!12/19/2006-10:20:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties.
ReportingServicesService!runningjobs!f!12/19/2006-10:21:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:21:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1a!12/19/2006-10:22:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:22:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1b!12/19/2006-10:23:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:23:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!3!12/19/2006-10:24:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!17!12/19/2006-10:24:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!17!12/19/2006-10:25:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!3!12/19/2006-10:25:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!16!12/19/2006-10:26:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:26:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!18!12/19/2006-10:27:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!13!12/19/2006-10:27:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!d!12/19/2006-10:28:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:28:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1c!12/19/2006-10:29:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:29:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!13!12/19/2006-10:30:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:30:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1c!12/19/2006-10:31:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!8!12/19/2006-10:31:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!c!12/19/2006-10:32:10:: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 executed at 12/19/2006 10:32:10 AM.
ReportingServicesService!schedule!f!12/19/2006-10:32:10:: Creating Time based subscription notification for subscription: 2ae5c0ed-9eea-4ca4-8e41-be5cde9f7908
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 execution completed at 12/19/2006 10:32:10 AM.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling finished processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!dbpolling!c!12/19/2006-10:32:20:: NotificationPolling processing 1 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!13!12/19/2006-10:32:20:: NotificationPolling processing item b216a965-eaa7-4003-b776-4663c19c8d54
ReportingServicesService!library!13!12/19/2006-10:32:21:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!13!12/19/2006-10:32:21:: 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.OverflowException: Arithmetic operation resulted in an overflow.
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
End of inner exception stack trace
ReportingServicesService!runningjobs!17!12/19/2006-10:32:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:32:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams

Does anyone have an idea what goes wrong here?

Best regards
Florian
Are you running 64 bit RS? If yes, it looks like a known problem that will be fixed in SP2.