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)

/wp-content/uploads/2015/02/1_645405.png

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

/wp-content/uploads/2015/02/2_645406.png

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

/wp-content/uploads/2015/02/3_645408.png

  • 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

/wp-content/uploads/2015/02/4_645409.png

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

/wp-content/uploads/2015/02/5_645410.png

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

/wp-content/uploads/2015/02/6_645411.png

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

/wp-content/uploads/2015/02/7_645412.png

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

/wp-content/uploads/2015/02/8_645413.png

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


/wp-content/uploads/2015/02/9_645414.png

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

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

/wp-content/uploads/2015/02/10_645415.png

1. Create a New Folder “Tomcat Script”

/wp-content/uploads/2015/02/11_645416.png

2. Click on BOBJ Script Folder and Create Task

/wp-content/uploads/2015/02/12_645417.png


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

/wp-content/uploads/2015/02/13_645418.png

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

/wp-content/uploads/2015/02/14_645419.png

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

/wp-content/uploads/2015/02/15_645420.png

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

7. Set the following settings on Conditions & Settings tab

/wp-content/uploads/2015/02/16_645421.png

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:

/wp-content/uploads/2015/02/17_645422.png

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:

/wp-content/uploads/2015/02/18_645423.png

  • In this step select the 2nd 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


S.No

BusinessObjects Server

Windows Deployment

1

32-bit Connection Server

ConnectionServer32.exe

2

64-bit Connection Server

ConnectionServer.exe

3

Tomcat Application

tomcat7.exe

4

Adaptive Job Server

JobServer.exe

5

Adaptive Job Server Child

JobServerChild.exe

6

Central Management Server

cms.exe

7

Crystal Reports 2011 Processing Server

crproc.exe

8

Crystal Reports Cache Server

crcache.exe

9

Dashboards Cache Server

xccache.exe

10

Dashboards Processing Server

xcproc.exe

11

Event Server

EventServer.exe

12

File Server

fileserver.exe

13

Report Application Server

crystalras.exe

14

Web Intelligence Processing Server

wireportserver.exe

15

SAP Data Services Job Server

al_engine.exe

16

SAP Data Services Access Server

al_accessserver.exe

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


Log File Status:

/wp-content/uploads/2015/02/19_645424.png

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

/wp-content/uploads/2015/02/20_645425.png

Status in Log File, For e.g Tomcat_Stoplog

/wp-content/uploads/2015/02/21_645426.png

& Tomcat_Startlog

  /wp-content/uploads/2015/02/22_645427.png

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

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Uday Thakur

    Nice Document Daya related to SIA and Tomcat.

    But I need to know how can we monitor all the exes mentioned below ?

    Thank you.

    Exes.PNG

    (0) 
  2. Hardik Naidu

    Hi Daya,

    Thanks a lot.

    This was helpful for restarting of the Tomcat servers but I am unable to generate the logs for the start and stop.

    Can you please help ?

    Thanks,

    Hardik

    (0) 

Leave a Reply