RSClientPrint deployment question.

I have read the thread 'print active x question' posted more than a year ago
and would like to follow up...
We have an application using a webbrowser control to access reporting
services and have run into the issue of needing RSClientPrint installed
during our setup because security policies/settings may prevent the user from
installing the activex at runtime.
Has MS provided an .msi or merge module, etc. to deploy this yet? If not, is
there a definitive answer to which folder we should put the files?...is it
possible/safe to put them in Downloaded Program Files?
Thanks!
KevinHello Kevin,
We solved this problem with this small startscript in the computer group
policy.
Dim env, wshShell, fso
Set wshShell = WScript.CreateObject("WScript.Shell")
Set env = wshShell.Environment("PROCESS")
Set fso = CreateObject("Scripting.FileSystemObject")
if(Not (fso.FileExists (env("windir") & "\downloaded program
files\RSClientPrint.dll"))) Then
On Error Resume next
fso.CopyFile "\\server\rsclient\gdiplus.dll",env("windir") & "\downloaded
program files\"
On Error Resume next
fso.CopyFile "\\server\rsclient\RSClientPrint.dll", env("windir") &
"\downloaded program files\"
On Error Resume next
fso.CopyFile "\\server\rsclient\RSClientPrint.inf", env("windir") &
"\downloaded program files\"
On Error Resume next
fso.CopyFile "\\server\rsclient\RSClientPrint_1028.rll", env("windir") &
"\downloaded program files\"
On Error Resume next
fso.CopyFile "\\server\rsclient\RSClientPrint_1031.rll", env("windir") &
"\downloaded program files\"
On Error Resume next
fso.CopyFile "\\server\rsclient\RSClientPrint_1033.rll", env("windir") &
"\downloaded program files\"
On Error Resume next
fso.CopyFile "\\server\rsclient\RSClientPrint_1036.rll", env("windir") &
"\downloaded program files\"
On Error Resume next
fso.CopyFile "\\server\rsclient\RSClientPrint_1040.rll", env("windir") &
"\downloaded program files\"
On Error Resume next
fso.CopyFile "\\server\rsclient\RSClientPrint_1041.rll", env("windir") &
"\downloaded program files\"
On Error Resume next
fso.CopyFile "\\server\rsclient\RSClientPrint_1042.rll", env("windir") &
"\downloaded program files\"
On Error Resume next
fso.CopyFile "\\server\rsclient\RSClientPrint_1043.rll", env("windir") &
"\downloaded program files\"
On Error Resume next
fso.CopyFile "\\server\rsclient\RSClientPrint_1046.rll", env("windir") &
"\downloaded program files\"
On Error Resume next
fso.CopyFile "\\server\rsclient\RSClientPrint_1053.rll", env("windir") &
"\downloaded program files\"
On Error Resume next
fso.CopyFile "\\bkhl\host\stdsw\tools\rsclient\RSClientPrint_2052.rll",
env("windir") & "\downloaded program files\"
On Error Resume next
fso.CopyFile "\\bkhl\host\stdsw\tools\rsclient\RSClientPrint_3082.rll",
env("windir") & "\downloaded program files\"
wshShell.Run "REGSVR32.EXE /s """ & env("windir") & "\downloaded program
files\RSClientPrint" & """", vbMinimizedNoFocus
End if
on error resume next
Hope it helps.
Regards
Bernhard|||Bernhard,
Thanks. It answers my question that other people are having the same
problem and handling it by manually deploying the files to the Downloaded
Program Files folder.
We will most likely add the files to our existing client install. It would
be nice if Reporting Services contained a Windows Installer module for this
(hint hint).
Thanks,
Kevin
"Bernhard Weitlaner" wrote:
> Hello Kevin,
> We solved this problem with this small startscript in the computer group
> policy.
>
> Dim env, wshShell, fso
> Set wshShell = WScript.CreateObject("WScript.Shell")
> Set env = wshShell.Environment("PROCESS")
> Set fso = CreateObject("Scripting.FileSystemObject")
> if(Not (fso.FileExists (env("windir") & "\downloaded program
> files\RSClientPrint.dll"))) Then
> On Error Resume next
> fso.CopyFile "\\server\rsclient\gdiplus.dll",env("windir") & "\downloaded
> program files\"
> On Error Resume next
> fso.CopyFile "\\server\rsclient\RSClientPrint.dll", env("windir") &
> "\downloaded program files\"
> On Error Resume next
> fso.CopyFile "\\server\rsclient\RSClientPrint.inf", env("windir") &
> "\downloaded program files\"
> On Error Resume next
> fso.CopyFile "\\server\rsclient\RSClientPrint_1028.rll", env("windir") &
> "\downloaded program files\"
> On Error Resume next
> fso.CopyFile "\\server\rsclient\RSClientPrint_1031.rll", env("windir") &
> "\downloaded program files\"
> On Error Resume next
> fso.CopyFile "\\server\rsclient\RSClientPrint_1033.rll", env("windir") &
> "\downloaded program files\"
> On Error Resume next
> fso.CopyFile "\\server\rsclient\RSClientPrint_1036.rll", env("windir") &
> "\downloaded program files\"
> On Error Resume next
> fso.CopyFile "\\server\rsclient\RSClientPrint_1040.rll", env("windir") &
> "\downloaded program files\"
> On Error Resume next
> fso.CopyFile "\\server\rsclient\RSClientPrint_1041.rll", env("windir") &
> "\downloaded program files\"
> On Error Resume next
> fso.CopyFile "\\server\rsclient\RSClientPrint_1042.rll", env("windir") &
> "\downloaded program files\"
> On Error Resume next
> fso.CopyFile "\\server\rsclient\RSClientPrint_1043.rll", env("windir") &
> "\downloaded program files\"
> On Error Resume next
> fso.CopyFile "\\server\rsclient\RSClientPrint_1046.rll", env("windir") &
> "\downloaded program files\"
> On Error Resume next
> fso.CopyFile "\\server\rsclient\RSClientPrint_1053.rll", env("windir") &
> "\downloaded program files\"
> On Error Resume next
> fso.CopyFile "\\bkhl\host\stdsw\tools\rsclient\RSClientPrint_2052.rll",
> env("windir") & "\downloaded program files\"
> On Error Resume next
> fso.CopyFile "\\bkhl\host\stdsw\tools\rsclient\RSClientPrint_3082.rll",
> env("windir") & "\downloaded program files\"
> wshShell.Run "REGSVR32.EXE /s """ & env("windir") & "\downloaded program
> files\RSClientPrint" & """", vbMinimizedNoFocus
> End if
> on error resume next
>
> Hope it helps.
> Regards
> Bernhard|||Kevin,
If you have visual studio it's a pretty simple job to create an MSI to do
the same thing as Bernards script. Then you can deploy the MSI with a GPO or
whatever means you want.
Regards,
Martin.
"Kg" wrote:
> Bernhard,
> Thanks. It answers my question that other people are having the same
> problem and handling it by manually deploying the files to the Downloaded
> Program Files folder.
> We will most likely add the files to our existing client install. It would
> be nice if Reporting Services contained a Windows Installer module for this
> (hint hint).
> Thanks,
> Kevin
> "Bernhard Weitlaner" wrote:
> > Hello Kevin,
> >
> > We solved this problem with this small startscript in the computer group
> > policy.
> >
> >
> > Dim env, wshShell, fso
> > Set wshShell = WScript.CreateObject("WScript.Shell")
> > Set env = wshShell.Environment("PROCESS")
> > Set fso = CreateObject("Scripting.FileSystemObject")
> >
> > if(Not (fso.FileExists (env("windir") & "\downloaded program
> > files\RSClientPrint.dll"))) Then
> >
> > On Error Resume next
> > fso.CopyFile "\\server\rsclient\gdiplus.dll",env("windir") & "\downloaded
> > program files\"
> > On Error Resume next
> > fso.CopyFile "\\server\rsclient\RSClientPrint.dll", env("windir") &
> > "\downloaded program files\"
> > On Error Resume next
> > fso.CopyFile "\\server\rsclient\RSClientPrint.inf", env("windir") &
> > "\downloaded program files\"
> > On Error Resume next
> > fso.CopyFile "\\server\rsclient\RSClientPrint_1028.rll", env("windir") &
> > "\downloaded program files\"
> > On Error Resume next
> > fso.CopyFile "\\server\rsclient\RSClientPrint_1031.rll", env("windir") &
> > "\downloaded program files\"
> > On Error Resume next
> > fso.CopyFile "\\server\rsclient\RSClientPrint_1033.rll", env("windir") &
> > "\downloaded program files\"
> > On Error Resume next
> > fso.CopyFile "\\server\rsclient\RSClientPrint_1036.rll", env("windir") &
> > "\downloaded program files\"
> > On Error Resume next
> > fso.CopyFile "\\server\rsclient\RSClientPrint_1040.rll", env("windir") &
> > "\downloaded program files\"
> > On Error Resume next
> > fso.CopyFile "\\server\rsclient\RSClientPrint_1041.rll", env("windir") &
> > "\downloaded program files\"
> > On Error Resume next
> > fso.CopyFile "\\server\rsclient\RSClientPrint_1042.rll", env("windir") &
> > "\downloaded program files\"
> > On Error Resume next
> > fso.CopyFile "\\server\rsclient\RSClientPrint_1043.rll", env("windir") &
> > "\downloaded program files\"
> > On Error Resume next
> > fso.CopyFile "\\server\rsclient\RSClientPrint_1046.rll", env("windir") &
> > "\downloaded program files\"
> > On Error Resume next
> > fso.CopyFile "\\server\rsclient\RSClientPrint_1053.rll", env("windir") &
> > "\downloaded program files\"
> > On Error Resume next
> > fso.CopyFile "\\bkhl\host\stdsw\tools\rsclient\RSClientPrint_2052.rll",
> > env("windir") & "\downloaded program files\"
> > On Error Resume next
> > fso.CopyFile "\\bkhl\host\stdsw\tools\rsclient\RSClientPrint_3082.rll",
> > env("windir") & "\downloaded program files\"
> >
> > wshShell.Run "REGSVR32.EXE /s """ & env("windir") & "\downloaded program
> > files\RSClientPrint" & """", vbMinimizedNoFocus
> >
> > End if
> > on error resume next
> >
> >
> > Hope it helps.
> >
> > Regards
> > Bernhard|||Hello Martin
> If you have visual studio it's a pretty simple job to create an MSI to do
> the same thing as Bernards script. Then you can deploy the MSI with a GPO or
> whatever means you want.
>
This sounds very interesting. How is this possible? I have visual studio.
Regards
Bernhard|||Bernhard,
Here's the recipe...
You'll need the extracted the CabFile contents.
Then in Visual Studio:
1. Create a New Set Up Project (it's under Other Project Types). You can
call it what you like but I used RSClientPrintRedist.
2. In the Configuration properties of the SetUp Project click the
prerequisite... button and make sure none of the prerequisites are checked
and that the Create setup program to install prerequisite components is
cleared. I usually do this first because it's easy to forget and GPO
processing seems to fail if it tries to fire of an external setup file.
3. Next on the project properties set InstallAllUsers to true.
4. Under File System on Target Machine click on Applciation Folder and set
the default location to [WindowsFolder]Downloaded Program Files. You can
remove the other folders they're not needed.
5. Add all the extracted files to this folder.
6. On the properties tab for the rsclientprint.dll set the Register property
to vsdrfCOMSelfReg
7. Under the Registry on Target Machine Settings remove HKLM and KKCU
[Manufacturer Keys]
8. Under User Interface remove the Target Directory dialog screen. We don't
need to be able to specify an alternative location.
9. Build you project.
If all goes well you should have a file "RSClientPrintRedist.msi" under the
current config directoy of your project.
Creating setup kits this way is really powerful, and you don't have to be
deploying a .NET app to use them. If you have a play around with the various
options you'll see there isn't much you can't do on the target machine.
Martin
"Bernhard Weitlaner" wrote:
> Hello Martin
> >
> > If you have visual studio it's a pretty simple job to create an MSI to do
> > the same thing as Bernards script. Then you can deploy the MSI with a GPO or
> > whatever means you want.
> >
> This sounds very interesting. How is this possible? I have visual studio.
> Regards
> Bernhard|||Hello Martin,
Thank you very much.
Regards
Bernhardsql

RSClientPrint ActiveX causes client PC to reboot

We have a client PC trying to run a report. When they hit the print button it
first asks them to install a SQL active X control which is RSClientPrint
Class. Once installed they hit the print button on the report which then
loads the active X print dialog - when they hit print their system reboots.
I had this person delete the control and go through the same process with
the same results; they are running Windows XP SP2 with IE6.
Any ideas? Thank You.That is exactly what I am running (XP SP2 IE6).
Are they in the local administrators group on the machine (i.e. do they have
the rights to install the activeX control?)
Do they have any printers connected to their PC? This is printing locally
not at the server.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Zaccarine" <Dan Zaccarine@.discussions.microsoft.com> wrote in message
news:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
> We have a client PC trying to run a report. When they hit the print button
> it
> first asks them to install a SQL active X control which is RSClientPrint
> Class. Once installed they hit the print button on the report which then
> loads the active X print dialog - when they hit print their system
> reboots.
> I had this person delete the control and go through the same process with
> the same results; they are running Windows XP SP2 with IE6.
> Any ideas? Thank You.
>|||Which version of RS do you use?
I have one computer (WinXP, DELL laptop, 2 years old) with a HP1320 printer
connected. the RS Client print alway causes "blue screen death" when try to
print report. Printing anything else is OK.
However, the printer prints RS report OK when connected to any other
computers. So, I guess it is some sort of hardware issue with that
particular computer/printer combination. The solution is by that user a
different printer. Now the reporting print with that computer is fine and
the previous computer also happily work with other computer when printing RS
report.
So, you may try to update the printer's driver first, and then try to use a
different computer.
Just an experience using RS2000 printing. RS2000 reporitn rendering/printing
horribly bad.
"Dan Zaccarine" <Dan Zaccarine@.discussions.microsoft.com> wrote in message
news:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
> We have a client PC trying to run a report. When they hit the print button
> it
> first asks them to install a SQL active X control which is RSClientPrint
> Class. Once installed they hit the print button on the report which then
> loads the active X print dialog - when they hit print their system
> reboots.
> I had this person delete the control and go through the same process with
> the same results; they are running Windows XP SP2 with IE6.
> Any ideas? Thank You.
>|||On Nov 28, 11:20 am, "Norman Yuan" <NoAddr...@.NoEmail.fake> wrote:
> Which version of RS do you use?
> I have one computer (WinXP, DELL laptop, 2 years old) with a HP1320 printer
> connected. the RS Client print alway causes "blue screen death" when try to
> print report. Printing anything else is OK.
> However, the printer prints RS report OK when connected to any other
> computers. So, I guess it is some sort of hardware issue with that
> particular computer/printer combination. The solution is by that user a
> different printer. Now the reporting print with that computer is fine and
> the previous computer also happily work with other computer when printing RS
> report.
> So, you may try to update the printer's driver first, and then try to use a
> different computer.
> Just an experience using RS2000 printing. RS2000 reporitn rendering/printing
> horribly bad.
> "Dan Zaccarine" <Dan Zaccar...@.discussions.microsoft.com> wrote in messagenews:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
>
> > We have a client PC trying to run a report. When they hit the print button
> > it
> > first asks them to install a SQL active X control which is RSClientPrint
> > Class. Once installed they hit the print button on the report which then
> > loads the active X print dialog - when they hit print their system
> > reboots.
> > I had this person delete the control and go through the same process with
> > the same results; they are running Windows XP SP2 with IE6.
> > Any ideas? Thank You.- Hide quoted text -
> - Show quoted text -
I have seen the same issue. However, I only get the reboot when I am
printing a matrix report. All other report types print Ok.|||I am having same problem any idea to solve this issue
"RDV" wrote:
> On Nov 28, 11:20 am, "Norman Yuan" <NoAddr...@.NoEmail.fake> wrote:
> > Which version of RS do you use?
> >
> > I have one computer (WinXP, DELL laptop, 2 years old) with a HP1320 printer
> > connected. the RS Client print alway causes "blue screen death" when try to
> > print report. Printing anything else is OK.
> >
> > However, the printer prints RS report OK when connected to any other
> > computers. So, I guess it is some sort of hardware issue with that
> > particular computer/printer combination. The solution is by that user a
> > different printer. Now the reporting print with that computer is fine and
> > the previous computer also happily work with other computer when printing RS
> > report.
> >
> > So, you may try to update the printer's driver first, and then try to use a
> > different computer.
> >
> > Just an experience using RS2000 printing. RS2000 reporitn rendering/printing
> > horribly bad.
> >
> > "Dan Zaccarine" <Dan Zaccar...@.discussions.microsoft.com> wrote in messagenews:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
> >
> >
> >
> > > We have a client PC trying to run a report. When they hit the print button
> > > it
> > > first asks them to install a SQL active X control which is RSClientPrint
> > > Class. Once installed they hit the print button on the report which then
> > > loads the active X print dialog - when they hit print their system
> > > reboots.
> >
> > > I had this person delete the control and go through the same process with
> > > the same results; they are running Windows XP SP2 with IE6.
> >
> > > Any ideas? Thank You.- Hide quoted text -
> >
> > - Show quoted text -
> I have seen the same issue. However, I only get the reboot when I am
> printing a matrix report. All other report types print Ok.
>|||I saw this last spring:
>>>>>>>>
> > It only affects printers using the PCL 6 driver. If I print to any of
> > the others using a PCL 5e driver it works. All of our printers are HP.
> > > It doesn't appear to be a general print driver issue. As I said, only
> > > the HP 4250's have this problem.
> > > > It appears to be a print driver issue due to some recent update. If
> > > > you change your print drivers to PCL 5e it won't crash any longer.
>>>>>>>>>>>
Again, I have no real knowledge of this. Hopefully the above will help.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Irfan" <Irfan@.discussions.microsoft.com> wrote in message
news:EBD33316-B4BA-4D9D-819B-33AC540278CB@.microsoft.com...
>I am having same problem any idea to solve this issue
> "RDV" wrote:
>> On Nov 28, 11:20 am, "Norman Yuan" <NoAddr...@.NoEmail.fake> wrote:
>> > Which version of RS do you use?
>> >
>> > I have one computer (WinXP, DELL laptop, 2 years old) with a HP1320
>> > printer
>> > connected. the RS Client print alway causes "blue screen death" when
>> > try to
>> > print report. Printing anything else is OK.
>> >
>> > However, the printer prints RS report OK when connected to any other
>> > computers. So, I guess it is some sort of hardware issue with that
>> > particular computer/printer combination. The solution is by that user a
>> > different printer. Now the reporting print with that computer is fine
>> > and
>> > the previous computer also happily work with other computer when
>> > printing RS
>> > report.
>> >
>> > So, you may try to update the printer's driver first, and then try to
>> > use a
>> > different computer.
>> >
>> > Just an experience using RS2000 printing. RS2000 reporitn
>> > rendering/printing
>> > horribly bad.
>> >
>> > "Dan Zaccarine" <Dan Zaccar...@.discussions.microsoft.com> wrote in
>> > messagenews:89B4C6AC-14D6-4F05-8915-2892D3AD2DA8@.microsoft.com...
>> >
>> >
>> >
>> > > We have a client PC trying to run a report. When they hit the print
>> > > button
>> > > it
>> > > first asks them to install a SQL active X control which is
>> > > RSClientPrint
>> > > Class. Once installed they hit the print button on the report which
>> > > then
>> > > loads the active X print dialog - when they hit print their system
>> > > reboots.
>> >
>> > > I had this person delete the control and go through the same process
>> > > with
>> > > the same results; they are running Windows XP SP2 with IE6.
>> >
>> > > Any ideas? Thank You.- Hide quoted text -
>> >
>> > - Show quoted text -
>> I have seen the same issue. However, I only get the reboot when I am
>> printing a matrix report. All other report types print Ok.|||Hi all !
I found a solution for your problem. You probably installed the hotfix
925902 recently. Its a known issue for Microsoft. Some printers only (until
now : Ricoh LAN Fax Driver, Gestetner P7026n PCL, Ricoh Laser AP2600N PCL,
HP LaserJet 9050, HP LaserJet 4200, HP 4050 PCL6, HP LaserJet 4345 PCL 6 and
Canon Pixma MP170) are impacted.
This problem occurs when a printer driver makes a call that has invalid
parameters to the Win32K.sys component.
The hotfix KB935843 solved the problem on my computer.

rsClientPrint Active X question

After loading the object clause for rsClientPrint on my ASPX page, I get the
message at the client that Microsoft is blocking the software because the
publisher is unknown. Can anyone tell me what I might need to do to get past
that.
--
Thanks,
CGWFound my problem.
--
Thanks,
CGW
"CGW" wrote:
> After loading the object clause for rsClientPrint on my ASPX page, I get the
> message at the client that Microsoft is blocking the software because the
> publisher is unknown. Can anyone tell me what I might need to do to get past
> that.
> --
> Thanks,
> CGW|||Hi, how did you fix your problem? I have the same problem, that is
preventing me from using a program download (from american greetings.com)
that I've been using all along. I need a new Active-X plugin, but the
publisher is unverifiable. Thanks much!
Mary
"CGW" wrote:
> Found my problem.
> --
> Thanks,
> CGW
>
> "CGW" wrote:
> > After loading the object clause for rsClientPrint on my ASPX page, I get the
> > message at the client that Microsoft is blocking the software because the
> > publisher is unknown. Can anyone tell me what I might need to do to get past
> > that.
> > --
> > Thanks,
> >
> > CGW|||I wish I could remember. We ended up taking a different approach and I didn't
keep my work on that. I know I googled around for an answer and it seems that
it had to do with getting the cab file in the right location. Sorry. If I
remember, I'll send it to you. And from now on, when I find a solution, I'll
mention what it was while it's still fresh on my mind.
--
Thanks,
CGW
"Mary" wrote:
> Hi, how did you fix your problem? I have the same problem, that is
> preventing me from using a program download (from american greetings.com)
> that I've been using all along. I need a new Active-X plugin, but the
> publisher is unverifiable. Thanks much!
> Mary
> "CGW" wrote:
> > Found my problem.
> > --
> > Thanks,
> >
> > CGW
> >
> >
> > "CGW" wrote:
> >
> > > After loading the object clause for rsClientPrint on my ASPX page, I get the
> > > message at the client that Microsoft is blocking the software because the
> > > publisher is unknown. Can anyone tell me what I might need to do to get past
> > > that.
> > > --
> > > Thanks,
> > >
> > > CGW

RS on MS Cluster Active/Passive configuration

I have insatalled RS onto an Active Passive SQL Server with IIS installed on
the cluster
as well. I have configured RS on two node work with the same ReportServer
database.
I have moved virtual directory to Shared store...
And now I can run reports on localhost on two nodes,but from Shared store RS
works
only,when Node 1 is active.Then Node 2 is active i get error message :
The encrypted value for configuration setting Dsn cannot be decrypted.
(rsFailedToDecryptConfigInformation) Get Online Help
An internal error occurred on the report server. See the error log for more
details.
(rsInternalError) Get Online Help
My configuration :
MS cluster Active/Passive Windows 2003
SQL 2000 Enterprise + SP3a + Fix 859
RS enterprise + SP1
Any help and guidance in this arena would be appreciated. Thanks.oleg,
It appears that installing RS on an active passive cluster where both
instances of IIS use the same data store it not possible. The reason
is that the DSN information is encrypted per machine and is unique to
the machine. I tried to get luck and synch up the machine keys on the
memebers in the cluster but even after they were synched up, it was
still not possible to get it working. What I have opted to do instead
is to allow each instance of IIS (default web) in the A/P cluster to
respond to the name of the SQLCluster name. When I fail from one box
to the other I am still able to serve up the other version of reporting
services. So while I am not NLB'ing the cluster I am still able to
server two instances of RS. Best idea I have had so far. I am
researching into getting both machines to use the same encryption
algorythm.
Hope that helps.
oleg wrote:
> I have insatalled RS onto an Active Passive SQL Server with IIS
installed on
> the cluster
> as well. I have configured RS on two node work with the same
ReportServer
> database.
> I have moved virtual directory to Shared store...
> And now I can run reports on localhost on two nodes,but from Shared
store RS
> works
> only,when Node 1 is active.Then Node 2 is active i get error message
:
> The encrypted value for configuration setting Dsn cannot be
decrypted.
> (rsFailedToDecryptConfigInformation) Get Online Help
> An internal error occurred on the report server. See the error log
for more
> details.
> (rsInternalError) Get Online Help
> My configuration :
> MS cluster Active/Passive Windows 2003
> SQL 2000 Enterprise + SP3a + Fix 859
> RS enterprise + SP1
> Any help and guidance in this arena would be appreciated. Thanks.

RS creates Active Sessions too easily

Problem: Can't run a script to test reports over night without running out
of memory because too many Active Sessions are being generated.
We have a Reporting Service test utiltiy that we are trying to run over
night. It gathers up all the possible parameter combinations and runs all of
these. The trouble is the number of Active Sessions increases by one for
each report and eventually the server fails. We added the ability to
generate a script when the test utility runs.
The .rss is compiled and ran against a single rs instance, still a new
session for every report render.
This is the same report getting rendered over and over, just with different
parameters.
Running the same report with the same parameters doesn't generate new Active
Sessions.
Running the reports from the RS Manager, I can change the parameters and not
get an additional Active Session, but when I switch reports and switch back
I get a new Active Session, once for the new report and once again when I
switch back to the report I was just on.
My guess is that this relates to the Web Service keeping my info in Session
State, and releasing it after 10 minutes.
Anyone with any ideas what I should do? I'd like to keep my session state
to 10 minutes, this same machine is used during the day by QA.
Here's my .rss code:
Dim ParentPath As String = "/" + ReportDir
Public Sub Main()
RunReport("myReport", "c:\temp\run1.pdf", "a,b,c", "1,2,3")
RunReport("myReport", "c:\temp\run2.pdf", "a,b,c", "4,5,6")
RunReport("myReport", "c:\temp\run3.pdf", "a,b,c", "4,5,6")
End Sub
Public Sub RunReport(ByVal reportName As String, ByVal FileName As String,
ByVal ParamNames As String, ByVal ParamValues As String)
Dim objReportResult As Byte()
Dim encoding As String
Dim mimeType As String
Dim rptParamsUsed As ParameterValue()
Dim warnings As Warning()
Dim streamIDs As String()
Dim fs As FileStream
Dim Names As String()
Dim Values As String()
Dim rptParamValues As ParameterValue()
Dim Counter As Integer
If ParamNames Is Nothing Then
rptParamValues = Nothing
Else
Names = ParamNames.Split(",")
Values = ParamValues.Split(",")
ReDim rptParamValues(Names.Length - 1)
For Counter = 0 To Names.Length - 1
rptParamValues(Counter) = New ParameterValue()
rptParamValues(Counter).Name = Names(Counter)
rptParamValues(Counter).Value = Values(Counter)
Next Counter
End If
Try
objReportResult = rs.Render(ParentPath + "/" + reportName, "PDF", Nothing,
Nothing, rptParamValues, Nothing, Nothing, encoding, mimeType,
rptParamsUsed, warnings, streamIDs)
fs = new FileStream(FileName, FileMode.OpenOrCreate)
fs.Write(objReportResult, 0, objReportResult.Length)
fs.Close()
Catch e As Exception
Console.WriteLine(e.Message)
End Try
End Sub
Here's the documentation on MSRS 2005 Web Service Active Sessions:
Active Sessions
Number of active sessions. This counter provides a cumulative count of all
browser sessions generated from report subscriptions, whether they are still
active or not.
The counter is decremented as session records are removed. By default,
sessions are removed after ten minutes no activity.
Steve MunLeeuwEntered support incident, need to provide stack trace of error. Will do
tomorrow. Took about an hour to get the support incident set up...fun :)
"Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
news:OhBp4jf1GHA.1040@.TK2MSFTNGP06.phx.gbl...
> Problem: Can't run a script to test reports over night without running
> out of memory because too many Active Sessions are being generated.
> We have a Reporting Service test utiltiy that we are trying to run over
> night. It gathers up all the possible parameter combinations and runs all
> of these. The trouble is the number of Active Sessions increases by one
> for each report and eventually the server fails. We added the ability to
> generate a script when the test utility runs.
> The .rss is compiled and ran against a single rs instance, still a new
> session for every report render.
> This is the same report getting rendered over and over, just with
> different parameters.
> Running the same report with the same parameters doesn't generate new
> Active Sessions.
> Running the reports from the RS Manager, I can change the parameters and
> not get an additional Active Session, but when I switch reports and switch
> back I get a new Active Session, once for the new report and once again
> when I switch back to the report I was just on.
> My guess is that this relates to the Web Service keeping my info in
> Session State, and releasing it after 10 minutes.
> Anyone with any ideas what I should do? I'd like to keep my session state
> to 10 minutes, this same machine is used during the day by QA.
> Here's my .rss code:
> Dim ParentPath As String = "/" + ReportDir
> Public Sub Main()
> RunReport("myReport", "c:\temp\run1.pdf", "a,b,c", "1,2,3")
> RunReport("myReport", "c:\temp\run2.pdf", "a,b,c", "4,5,6")
> RunReport("myReport", "c:\temp\run3.pdf", "a,b,c", "4,5,6")
> End Sub
>
> Public Sub RunReport(ByVal reportName As String, ByVal FileName As String,
> ByVal ParamNames As String, ByVal ParamValues As String)
> Dim objReportResult As Byte()
> Dim encoding As String
> Dim mimeType As String
> Dim rptParamsUsed As ParameterValue()
> Dim warnings As Warning()
> Dim streamIDs As String()
> Dim fs As FileStream
> Dim Names As String()
> Dim Values As String()
> Dim rptParamValues As ParameterValue()
> Dim Counter As Integer
> If ParamNames Is Nothing Then
> rptParamValues = Nothing
> Else
> Names = ParamNames.Split(",")
> Values = ParamValues.Split(",")
> ReDim rptParamValues(Names.Length - 1)
> For Counter = 0 To Names.Length - 1
> rptParamValues(Counter) = New ParameterValue()
> rptParamValues(Counter).Name = Names(Counter)
> rptParamValues(Counter).Value = Values(Counter)
> Next Counter
> End If
>
> Try
> objReportResult = rs.Render(ParentPath + "/" + reportName, "PDF", Nothing,
> Nothing, rptParamValues, Nothing, Nothing, encoding, mimeType,
> rptParamsUsed, warnings, streamIDs)
> fs = new FileStream(FileName, FileMode.OpenOrCreate)
> fs.Write(objReportResult, 0, objReportResult.Length)
> fs.Close()
> Catch e As Exception
> Console.WriteLine(e.Message)
> End Try
> End Sub
>
> Here's the documentation on MSRS 2005 Web Service Active Sessions:
> Active Sessions
>
> Number of active sessions. This counter provides a cumulative count of all
> browser sessions generated from report subscriptions, whether they are
> still active or not.
> The counter is decremented as session records are removed. By default,
> sessions are removed after ten minutes no activity.
> Steve MunLeeuw
>