Skip to Content

Summary

When I was working on a project and needed to remote access SAP BusinessObjects Data Services server. I had done some research on internet and finally successfully made it. This blog is to explain about setting up connection for SAP BusinessObjects Data Services from external to internal network through NAT or firewall. This document may resolve one or some fellow errors: “Session: SDK failure”; “BODI-1112172”; “BODI-1241021”; “login error: could not reach CMS”.

 

Environment

  • Microsoft Windows Server 2012 R2 (64-bit)
  • Microsoft SQL Server 2012 (64-bit)
  • SAP BusinessObjects BI platform 4.1 SP5
  • SAP BusinessObjects Data Services 4.2 SP5

Let us assume BODS and BIP are installed in the same server connecting to a gateway/router. Repository Database is using port 1433. When installing BIP and BODS server we accept all default configurations, we are able to log on BODS Designer, Workbench, CMC and CMS. Now we will configure CMS and NAT port forwarding to setup the connection.

 

Introduction

Before setting up proper port mapping, we are facing this error when logging on SAP Data Services Designer from external network.

 

Desiger log on error.png

 

Resolution Steps

 

1. Let us read the SAP Data Services 4.2 SP 6 Installation Guide for Windows first to find out the required ports for Data Services server and clients.

 

There are specific communication ports that are used by Data Services server components.

If you deploy Data Services with firewalls, use this information to open the minimum number of ports in those firewalls.

Port requirements for Data Services server components.png

Communication ports that are used by Data Services client applications and web applications.

If you deploy Data Services with firewalls, you can use this information to open the minimum number of ports in those firewalls.

Port requirements for Data Services client applications.png

I had read the installation guide before and always thought that request ports were dynamic, could not be configured as fix even SAP notes say so. But this time I read again and found below notes.

 

Note

  • Use the Central Management Console (CMC) to configure a fixed BI platform Central Management Server (CMS) request port.

For more information, see “Server Administration, Configuring server network settings, Configuring port

numbers” the BI platform Administrator Guide or the Information platform services Administrator Guide.

  • Use the Designer to configure fixed debugger and Job Server request ports.

 

2. Below are the ports required to setup port forwarding on router and are required to be opened on firewall.

  • BI platform Central Management Server (CMS)

Name server port – 6400

Request port – configured on CMS to 6500

  • Job Server

Communication port – 3500

Request port – configured on Designer to 3511

Debugger port (optional) – 5001

Adapter communication port (optional) – 4000

  • Access Server Communication port – 4001
  • EIM Adaptive Processing Server – 4010 to 4013
  • Web application server Communication port – 8080
  • Repository database server Connection port – 1433

 

3. Use the Central Management Console (CMC) to configure a fixed BI platform Central Management Server (CMS) Request port

  • Select Servers on CMC from drop-down list, click on Servers List, right click on CentralManagementServer, click on Properties from pop-up menu

CMS properties.png

  • Uncheck Auto assign then enter the prefer port number on Common Settings section

CMS request port.png

  • Do the same changers to other servers required then restart the all servers that were changed port settings.

4. Use the Designer to configure fixed debugger and Job Server request ports

Log on BODS Designer from local computer then select manual Tools -> Options -> Designer -> Environment to change port settings.

bods designer communication ports.png

5. Now we should be able to log on from external.

BODS Designer logged on internal network repository.png

Yes, we can now look up the repository list but Opps other error comes up

version error.png

This is because the version of remote computer BODS client components is not compatible.

 

6. After upgrading the client software try again then we are facing ODBC driver error

ODBC error  for SQL Server.png

Launch ODBC Data Sources Administrator from C:\Windows\System32\C:\Windows\System32 create a system DSN pointing to remote repository database. Choosing the relevant authentication method and entering the credentials where applicable, click on Client Configuration button. This will open the Add Network Library Configuration window.

SQL ODBC configuration.png

SQL client configuration.png

7. Finally, try again — We logged on remotely!!!

BODS Designer after logged on internal network.png

 

Reference Material

SAP Data Services 4.2 SP 6 Installation Guide for Windows

How to resolve connectivity error “BODI-1112172” when running SAP Business Objects Data Services Designer on Windows 7 Client

SAP BODS 4.1 Designer port issue

To report this post you need to login first.

2 Comments

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

  1. Jerry Liu Post author

    I would like to correct my mistake at step 4.

    In real environment the Designer does not connect to Job Server yet therefore it will not keep the changes made at this step. You will be prompted error BODI-120016.

    JOB Server error BODI-120016.png

    Anyway you still can login and on the Designer taskbar you can see Job Server connected icon but there is notification server error(BODI-1241023).

    JOB Server error BODI-1241023.png

    You cannot run any job from Designer.

    (0) 
  2. Jerry Liu Post author

    Since job server needs two way communication in order to make job server work on external network it will need few more steps involving port forwarding, local DSUserConfig file changes etc.

    1. Edit local DSUserConfig.txt (C:\Users\<user name>\AppData\Local\SAP\Data Services\conf\DSUserConfig.txt) section [AdminClient], change ports to your desire one.

    [AdminClient]

    NotificationPortID =3520

    LocalPortBegin=3520

    LocalPortEnd=3520

    DSUserConfig.png

    2. On your router configure port 3520 forwarding to the computer where DS desiger is installed

    Job Server Port Forward.png

    3. if you have firewall enable you also need to open port 3520.

    Filrewall Open Port.png

    Now Job Server is ready, your Designer connects to Job Server and can run job from local.

    Job Server is Ready.png

    (0) 

Leave a Reply