Purpose:

The purpose of this document is to create Batch Script to START/ STOP ‘Server Intelligence Agent’ (SIA) & Tomcat Application on Windows Server Step-by-Step for SAP Business Objects Data Services.

Overview:

Environment Details:

Operating system: Windows Server 2008 64 Bit

Database: Microsoft SQL Server 2008 R2

Web Application: Tomcat

SAP Business Objects Tools: SAP Business Objects Information Platform Services 4.1 SP2; SAP Data Services 4.1 SP2

Repository version: BODS 4.X

Description:
Requirement of script is to automate housekeeping activity during off business hours.

In this post, I will go through the necessary steps to create/ setup and schedule a batch script to START/ STOP Tomcat Application/Server Intelligence Agent/SAP Business Objects Data ServicesApplication service on Windows 2008 Server.

Steps can be followed for SAP BusinessObjects XI3.0, XI3.1 & BI4.0 or BI4.1 or BOIPS 4.X:

• Scripts can be scheduled on multiple Windows Servers across the network
• It can be very well utilized in those environments where backup activities happens automatically using 3rd party tools
• Same script can be embedded with the Backup tools to ensure BI services get stopped and start automatically during and after the backup process starts/ finishes.

Configuration Steps for Automate SAP Business Objects Application:

Step I: Create script for automate stop of Tomcat, Data Services & Server Intelligence Agent Application

• Log in to Windows Server using Administrator account/ Domain user_id.
• Go to (START >> Administrative Tools >> Services)
• Look for the service called as ‘Apache Tomcat for BI 4’
• Go to its properties screen and COPY its service name, for e.g. (BOEXI40Tomcat)

• Look for the service called as ‘SAP Data Services’
• Go to its properties screen and COPY its service name, for e.g. (DI_JOBSERVICE)

• Look for the service called as ‘Apache Tomcat for BI 4’
• Go to its properties screen and COPY its service name, for e.g. (BOEXI40SIABI4SERVER)

• Create 3 batch scripts file for Stop SAP Business Objects Application – follow below screenshots to create using Notepad

Batch Script File 1 >>

• Open Notepad and type following mentioned in screenshot for Stop Tomcat Application

• Open Notepad and type following mentioned in screenshot for Stop SAP Business Objects Data Services Application

• Open Notepad and type following mentioned in screenshot for Stop SAP Business Objects Services Application

Step II: Create script for automate start of Tomcat, Data Services & Server Intelligence Agent Application

• Create 3 batch scripts file for Start SAP Business Objects Application – follow below screenshots to create using Notepad

Batch Script File 2 >>

• Open Notepad and type following mentioned in screenshot for Start Tomcat Application

• Open Notepad and type following mentioned in screenshot for Start SAP Business Objects Data Services Application

• Open Notepad and type following mentioned in screenshot for Stop SAP Business Objects Services Application

Step III: Now you can schedule above BATCH file using Windows Scheduler or other 3^rd Party Tools, Currently I am using Windows Scheduler in this blog

• Go to, (START >> Control Panel >> Administrative Tools >> Task Scheduler)

1. Create a New Folder “Tomcat Script”

2. Click on BOBJ Script Folder and Create Task

3. On the General tab, Set the NAME/ DESCRIPTION for the task:

4. On Triggers Tab, click on new button and set the followings:

5. On Actions Tab, click on New button and set the followings:

6. In the setting window select ‘BO_TOMCATSTOP_Script’.bat’ file from Automate Script directory

7. Set the following settings on Conditions & Settings tab

8. Click on Ok button, program will prompt for Username/ Password window, please enters the domain credentials.

9.Task scheduler will show the created task as follows:

10. Repeat the # 2 to 7 for Stop Tomcat, Start & Stop SIA and Finally Start & Stop Data Services script

11. One completed, task scheduler window should look like as follows:

• In this step select the 2^nd script created to start the Tomcat Application, Start & Stop SIA, Start & Stop Data Services
• As per the backup activity and the duration required for entire process, set the Start time of the script accordingly.
• This is to ensure Tomcat Application has sufficient time to shut-down and restart tomcat services appropriately.

Step III:  You can also monitor the services below is the list of exe of SAP Business Objects Application Services

 
Step IV: Now you can check the log file status.

Log File Status:

After completion of Windows schedule job below is the log file status

Status in Log File, For e.g Tomcat_Stoplog

& Tomcat_Startlog

 

Reference Material:

• For execution of Batch Script below are the rights required for Domain User (For Windows Environement)
• Below Rights required in Domain Server for execution of Batch Script.
  • Act as part of the operating system
  • Allow log on locally
  • Create a token object
  • Log on as a batch job
  • Log on as a service
  • Replace process level token

SAP Knowledge Base Article:

http://www.forumtopics.com/busobj/viewtopic.php?t=124355

1305228 – How to start or stop SIA and Tomcat with command line or Windows scripts in Business Objects XI3.x?

https://service.sap.com/sap/support/notes/1305228

1203539 – How to use a Windows script to start or stop BusinessObjects services

https://service.sap.com/sap/support/notes/1203539

1287046 – How to use Windows script to start or stop BusinessObjects services

for Business Objects XI 3.0?

https://service.sap.com/sap/support/notes/1287046

1406782 – How do you schedule a batch script for stopping and restarting the SIA properly on Windows platform?

https://service.sap.com/sap/support/notes/1406782

1634962 – BI4 – How to import or export a LifeCycle Manager BIAR file using command line utility

https://service.sap.com/sap/support/notes/1634962

2058607 – How to restart BI4.1 Explorer services automatically on linux using a script?

https://service.sap.com/sap/support/notes/2058607

1292866 – How to Automatically start services which go down in BOE XI R2

https://service.sap.com/sap/support/notes/1292866