Creating new SIA

[nsandee]

Hello All,

I have read some articles on "Creating new SIA" where i understood

1. We can create multiple SIA's in the same machine pointing to the same repository (with different port Number)

2. We can create multiple SIA's in the same machine pointing to different repository (with different port Number)

What are the advantages of having multiple SIA's ? Do we create multiple SIA's when we have multiple user accounts or is there any other purpose too?

Suppose when we schedule a .WID report, Adaptive job server \ Web intelligence processing server will be taking care of the request but

how can we know that which Adaptive job server \ web intelligence processing server takes care of scheduling out of these SIA's configured.

Any help in this regard would be highly appreciated.

Best Regards

Sandy

[Former Member · Accepted solution]

Hi Sandy,

It all boils down to why we need a 2nd SIA on the same server.

What 1 SIA does:

An SIA holds / acts as a container of the BusinessObjects services which are required for various purposes.

If a server has 1 SIA connecting to 1 CMS repository, it means:

a. The physical server provides RAM, CPU for this SIA and its servers to run.

b. The BO installation holds binaries, libraries for these services to run.

c. 1 Filestore for holding reports belonging to this 1 CMS db (local or remote).

d. This server can be connected to by various clients for the BO requirements.

Why a 2nd SIA would be required:

Adding a 2nd SIA on the same server connecting to the same repository becomes redundant?

Unless there is a need to test something which requires a fresh new SIA, the old one is stopped and a new one created. This is possibly due to failure, errors for one SIA. Or kept as a "tester".

If a 2nd SIA/set of services are needed, they're usually for facilitating more processing power to this BO "cluster". Which thereby also means we would need more hardware.

In such cases, a 2nd server is setup for BO with its own SIA and servers pointing still to the same CMS repository.

This way multiple servers can serve the same number of clients for their BO needs using this ONE (central) repository.

You can then assess whether more "horizontal" scaling is required and cluster more servers to this repository.

Multiple SIAs, multiple repositories, 1 server:

Not recommended given points a and b above.

Taking note of point c, different repositories = different filestores.

If this is not a cluster, do you hold multiple Filestores locally? Even if they're remote that just adds to the disk I/O!

Severe isolation is required in terms of directories, ports, etc.

Therefore, there is not much from a usability perspective that multiple SIAs on the same server would benefit from. Yes, troubleshooting / testing can be easily done by doing so but again requires port isolation.

From a performance, resource allocation and conflict perspective it is not recommend to have multiple SIAs running on the same server.

I may have missed out some scenarios, workflows where this comes in handy... but this is just a generic outlook.

Regards

Sid

[nsandee · Accepted solution]

Hello Onkar\Siddhartha,

Thanks for the detail explaination on this.

Suppose there are N no of users set up in our "Standalone" environment. When we are working on any tool such as WebI(BI launch Pad) \ Crystal reports, how the servers will be handling the requests (Refreshing, scheduling etc).

By Default, we have only one SIA. How can these servers handle 'N' no of requests from the users if we have only one Adaptive Job Server\Adaptive processing server & WebI \ Crystal Processing servers.

Best Regards

Sandy

[onkarvelhals · Accepted solution]

Hi Sandy,

I would suggest you to begin with holy grail of BI: (quicklink: sap.com/learnbi)

Start with the workflows. Simultaneously, make use of admin guide.

Find more documents:

Analytics Knowledge Center

Regards,

Onkar

[Former Member]

Hi Sandy,

One SIA doesn't necessarily mean ONE Job server or ONE processing server.

The tool does have the ability to add more than one processing, job servers within an SIA.

Use the "Create a server" option inside CMC -> Servers to do the same.

There would naturally be a limit (resource wise) to the number of servers you can add within an SIA (not advised to have 4 Job server, 4 processing servers, etc.)

You would need to peform a thorough sizing to understand the number of users, concurrent logins, etc. are available.

http://service.sap.com/sizing - is a good place to start for this.

I would also recommend you to have a look at the Administrator's guide to help understand what actions can be performed.

-Sid

[CdnConnection]

Sandy,

    You can create several SIA on the same machine but only ONE can run at a time.  You can NOT have multiple SIA running at the same time on ONE machine.

Regards,

Ajay

[onkarvelhals]

I guess we can! This is a standalone server. And both are healthy.

[onkarvelhals]

Hi Sandy,

Lets take this step by step:

1. We can create multiple SIA's in the same machine pointing to the same repository (with different port Number)

Answer: You can create multiple SIA's on same machine which point to same repository with same port number provided you run one at a time. viz. Ports used by SIA/ CMS should be available.

More info: These two SIA's would be two nodes in a cluster on running on same machine.

2. We can create multiple SIA's in the same machine pointing to different repository (with different port Number)

Answer: You can create multiple SIA's on same machine which point to different repository with same port number provided you run one at a time. viz. Ports used by SIA/ CMS should be available.

More info: These two SIA's would be two independent nodes running on same machine.

3. What are the advantages of having multiple SIA's ? Do we create multiple SIA's when we have multiple user accounts or is there any other purpose too?

Answer: Well, there is no advantage of having multiple SIA's on same machine.

When there would be need to create multiple SIA's on same machine?

You can create multiple SIA on single machine when you have to troubleshoot issue/s (or the overall integrity) with first SIA.

4.How can we know that which Adaptive job server \ web intelligence processing server takes care of scheduling out of these SIA's configured?

Answer: You can find out which Adaptive job server took care of the instance from Instance details page.

How to get to Instance details page?

Login to CMC> Navigate to Folders> Select your report> Right click Goto History> Choose the instance> Right Click Choose instance details from View menu.

Look for server used field.

Comments:

You can create as many SIA's on a single machine. If you to want more than one SIA running, your machine should be capable enough to handle all these services. (Lots of RAM, better processing etc) This can be termed as vertical sizing of the environment. Rather than adding SIA pointing to same database you can add services on same (first) SIA and size to get serve more requests.

However, it is always better to create different SIA (node) on different machine. Its not only easier to maintain but also helps to maintain overall reliability by providing a failover type case.

You can read more from Admin guide found here:

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp5_bip_admin_en.pdf

Regards,

Onkar