Report Server

Jeff,

We were having the same unexpected issue a few years ago. I installed a simple application monitor that polls the system every minute to see if gsrbatch is running. If not, it relaunches it. Haven't had a problem in a couple years now. We're running it on Windows server 2003. Here is the link to the free download:

http://www.jockersoft.com/english/appmonitor_index.php

~Dan

Jeff,

We were having the same unexpected issue a few years ago. I installed a simple application monitor that polls the system every minute to see if gsrbatch is running. If not, it relaunches it. Haven't had a problem in a couple years now. We're running it on Windows server 2003. Here is the link to the free download:

http://www.jockersoft.com/english/appmonitor_index.php

~Dan

Thanks Dan! I will check that out. In the mean time I just wrote a batch file that will kill the application and restart it again. Created a Windows schedule to run every 4 hours till I can get something else up and running.

Jeff, 
   I wouldn't suggest doing what you are doing even for a short period of time.  What if the report server is running a report that contains embedded sql or something else that modifies data in the tables.  Your data could be left in a half complete state.  I would suggest that you first check to see if GSRBAtch.exe is running.  Try some VBscript like this in your scheduled task:

Set WshShell = WScript.CreateObject ("WScript.Shell")
Set colProcessList = GetObject("Winmgmts:").ExecQuery ("Select * from Win32_Process")
'==============================================================================================
For Each objProcess in colProcessList
If objProcess.name = "gsrbatch.exe" then
vFound = True
End if
Next
If vFound = False then
WshShell.Run ("Path to GSRBATCH")
End If

Let me mention that I haven't tested this code so it may require a tweak to work correctly.

-Rich

Awesome Rich;

I implemented this, and am attaching the full contents to the file I named "gsrbatch.vbs" that is located on our report server within the C:\Report Server\ folder.

Also, I then created via Start-->Programs-->Accessories-->System Tools-->Scheduled Tasks; a new event:

Task Tab:

Run: "C:\Report Serveri\gsrbatch.vbs"

Start in: "C:\Report Server"

Run as: "your important account that can run these objects" (and click Set password to log in as that password)

Schedule Tab:

Click the "Show multiple Schedules" checkbox at bottom of tab

Setup one task: 1.  At System Startup.

Setup another task: 2.  Every X minutes from 12:00 AM for 24 hours(s) every day.

(X = the number of minutes your people can stand to be without reports IF the process should fail and the system not reboot)

------------

You will find Tessitura documents out there saying that you must update the system "Path" environmental variable, etc.  We did not need to do this.  We had problems getting all of this to work until we upgraded to Version 10.

Below is the code for GSRBatch.vbs:

-------------------

'''looks for current "GSRBATCH.EXE" process, if not found, launches new process;
'''Larry Brindise, Philharmonic Center Naples, 2011-10-18 with help from TessituraNetwork.com posting by Rich Tepper, McCarter Theatre
Set WshShell = WScript.CreateObject ("WScript.Shell")
Set colProcessList = GetObject("Winmgmts:").ExecQuery ("Select * from Win32_Process")
'
For Each objProcess in colProcessList
 If objProcess.name = "gsrbatch.exe" then
  vFound = True
 End if
Next
'
If vFound = False then
 CmdLine = "eventcreate /l Application /t Information /so ""GSRBATCH launch utility"" /id 700 /d ""GSRBATCH.EXE not detected as current process, attempting launch..."""
 WshShell.Run CmdLine
 WshShell.Run ("gsrbatch.exe")
End If

---------------