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

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

RSExecution Log

Does anyone have a link where I can download the RS Execution Log add-in for
RS 2000? I've looked everywhere I can think and Can't locate the file.
Thanks
ScottHello Scott,
I would like to know what do you mean about the RS Execution Log add-in.
If you mean to the DTS package which discribed in the BOL, you could copy
these files from the Product CD.
Querying and Reporting on Report Execution Log Data
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
/arp_rslogfiles_v1_88gy.asp
If you could not find these files, please send an email to me and I will
try to provide these files to you.
My direct email address is weilu@.ONLINE.microsoft.com ( Please remove
ONLINE when you send the email ), you may send the request to me directly.
Thank you!
direct email address is weilu@.ONLINE.microsoft.com ( Please remove ONLINE
when you send the email ), you may send the file to me directly|||Yes, that is exactly what I needed. I forgot that they were on the CDs :)
We had a server crash and things haven't been the same!!! Still trying to
recover, thanks for your help.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:uPdIBGOxGHA.5560@.TK2MSFTNGXA01.phx.gbl...
> Hello Scott,
> I would like to know what do you mean about the RS Execution Log add-in.
> If you mean to the DTS package which discribed in the BOL, you could copy
> these files from the Product CD.
> Querying and Reporting on Report Execution Log Data
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
> /arp_rslogfiles_v1_88gy.asp
> If you could not find these files, please send an email to me and I will
> try to provide these files to you.
> My direct email address is weilu@.ONLINE.microsoft.com ( Please remove
> ONLINE when you send the email ), you may send the request to me directly.
> Thank you!
> direct email address is weilu@.ONLINE.microsoft.com ( Please remove ONLINE
> when you send the email ), you may send the file to me directly
>|||Hi Scott,
Thank you for the update. If you have any questions on the recover issue,
please feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hello Scott,
How is the recover going? Is is all be fine? If you have any problem,
please feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Well, I was having page locks left and right on my RS's temp DB
(ReportServerTempDB). I think I resolved those, though. There were no
indexes on the DB and the recovery model was set to full. Trying out the
indexes and simple mode today. Will post onto how it did.
Just putting this out there so someone can Google it if they have the issue
:)
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:ychB29oxGHA.400@.TK2MSFTNGXA01.phx.gbl...
> Hi Scott,
> Thank you for the update. If you have any questions on the recover issue,
> please feel free to let me know.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
>

RS Execution Log and SQL 2005

Hello All,
SQL 2000 Reporting Services came with a DTS package that could be configured
to collect data daily on Report Execution. The results were then stored in a
RSExecutionLog database. Is this functionality still supported in 2005
Reporting Services?Well, for RS 2005 it is not a DTS package, it is a Integration Services
package. I was trying to get this working and I did not have Integration
Services installed (which requires reinstalling all service packs). So I
delayed until I had some time to install it.
Bruce Loehle-Conger
"EFrayer@.community.nospam"
<EFrayercommunitynospam@.discussions.microsoft.com> wrote in message
news:9F060287-4EAF-4FBD-9DA8-A1192674999E@.microsoft.com...
> Hello All,
> SQL 2000 Reporting Services came with a DTS package that could be
> configured
> to collect data daily on Report Execution. The results were then stored
> in a
> RSExecutionLog database. Is this functionality still supported in 2005
> Reporting Services?|||Can I get a little more information on how to do this? Where can I find this
Integration Services package that you are taking about?
"Bruce L-C [MVP]" wrote:
> Well, for RS 2005 it is not a DTS package, it is a Integration Services
> package. I was trying to get this working and I did not have Integration
> Services installed (which requires reinstalling all service packs). So I
> delayed until I had some time to install it.
> Bruce Loehle-Conger
> "EFrayer@.community.nospam"
> <EFrayercommunitynospam@.discussions.microsoft.com> wrote in message
> news:9F060287-4EAF-4FBD-9DA8-A1192674999E@.microsoft.com...
> > Hello All,
> > SQL 2000 Reporting Services came with a DTS package that could be
> > configured
> > to collect data daily on Report Execution. The results were then stored
> > in a
> > RSExecutionLog database. Is this functionality still supported in 2005
> > Reporting Services?
>
>