Technical Articles
SAP Data Services 4.2 SP12 Upgrade steps
Purpose:
The purpose of this document is to up-grade SAP Data Services from 4.2 SP9 to SAP Data Services 4.2 SP12
Overview:
Environment Details:
Operating system: Windows Server 2016 64 Bit
Database: Microsoft SQL Server 2012 R2
Web Application: Tomcat 8
SAP Business Objects Tools: Information Platform Services 4.2 SP7; SAP Data Services 4.2 SP12
Migration Tools: Data Services Repository Manager
Repository version: BODI 11.7 or BODS 3.X or BODS 4.X
Installation & Configuration steps to upgrade SAP BODS 3.X/4.X to SAP BODS 4.2 SP12:
Pre Installation Check List:
- Backup of repositories, configuration files & Data Cleanse files:
- Backup of Local, Profile & Central Repository
- Backup of Following Configuration Files:
- admin.xml
- sapconnections.xml
- as.xml
- dsconfig.txt
- Backup of Data Cleanse Files
- Create a Check list of Number of Batch Jobs/Real Time Jobs, Number of Access Server, Number of Job Server & Configuration Path (Datastore) of Source & Target Systems
- Create a Check list of Jobs Scheduling in SAP Business Objects Data Services Management Console
- Create a Check list of Groups & Users Available in SAP Business Objects Data Services Management Console
Post Installation Check List:
- Installation of EIM(Enterprise Information Management) or IPS(Information Platform Services) Package in New Landscape
- Installation of SAP BODS 4.2 SP12
- Installation & Configuration of Address Cleansing Package 4.2
- Best Practices says use the same Database that you have use in SAP BODS 4.x make a cloned copy and Use in SAP BODS 4.2 SP12 environment
- Up-gradation of Local /Central repository Using Data Services Repository Manager
- Configuration of Repository in EIM or IPS (Package Name) Central management Console.
- Configuration of SAP RFC in Data Services Management Console 4.2 SP12
- Configuration of Adapters in Data Services Management Console 4.2 SP12
- Apply Rights & Security according to your requirement in BIM or IPS (Package Name) Central management Console
- Now Login in SAP BODS Designer 4.2 SP12 and configure Jobs (Real Time/Batch Jobs)
- Configuration of Datastore (SAPR3,SAP BW, RDBMS), Substitution Parameters, Job Server, Access Server, Format Data Type (Flat Files, CSV)
- Now validate the Jobs at Top Level and if error comes fix those errors
- Now Execute the Jobs using Scheduler or other BI Tools
SAP Business Objects Information Platform Services 4.x SPxx Installation & Configuration Documents:
Product Infrastructure Dependency:
Data Services (DS) requires SAP BusinessObjects Business Intelligence (BI) or Information Platform Services (IPS) for security capability. The table below shows the BI/IPS version and the corresponding compatible version of Data Services.
For more information on the compatibility of Data Services with BI platform or IPS versions, and compatible patch information, please see SAP Note 1740516
https://service.sap.com/sap/support/notes/1740516
1789731 – What version is compatible with Data Services 4.X? – Data Quality Management for SAP
Supported Platform Link:
Validation of Current Environment before and after application upgrade:
For Validation of Jobs, Access Server, Adapter & Web Services I am using script to populate the data in text file, Please refer the o/p for your reference.
S.No | Validation Activity | Count |
1 | Count of Local Repository | 1 |
2 | Count of Secure Central Repository | 1 |
3 | Count of Job Server | 1 |
4 | Count of Access Server | 1 |
5 | Count of Batch Job | 18 |
6 | Count of Real Time Job | 18 |
7 | Count of Adapter | 1 |
8 | Count of Web Services | 18 |
Count of Repository: Currently I have 1 “Local & 1 “Secure Central repository” highlighted in Yellow color.
* For validation you can also use “Local repository” metadata for above details. Here I used BATCH script to check all above parameter in my current systems, Please refer the below screenshot for your reference.
Count of Job Server:
Count of Access Server:
Count of Batch & Real Time Job:
Same details you can get from batch script for Adapter & Web Services.
Up gradation & Configuration Documents:
When the prerequisite system check completes successfully, click Next
On the “SAP BusinessObjects Information platform services 4.2 SP7 setup” page, click Next.
Accept the License Agreement, and click Next.
Select Language (English) By Default, and click on Next
Type a password for the CMS Administrator account, and click Next
Now Select Installation mode as “Standard Installation” and click on Next
To start the installation, click Next.
Installation is in progress
Finish
Up gradation & Configuration Documents of Data Services:
When the prerequisite system check completes successfully, click Next
On the “SAP BusinessObjects Data Services 4.2 SP12 setup” page, click Next.
Accept the License Agreement, and click Next.
Click Next to accept the default path to the folder where the program will be installed.
Click Next so that it can use the same location where SAP BusinessObjects Data services related files are deployed, once upgrade is done please validate the configuration
Click Next as “English” is by default Language, You can select as per your requirement
Update SAP BusinessObjects Administrator credential to update the Metadata w.r.t new setup and click on Next
Click on Yes
SAP BusinessObjects Data Services Installation is started, Click on Next
Installation is in progress
Finish
SAP Business Objects Data Services 4.2 SP12 Configuration Documents:
Before upgrade of local repository below are the error in SAP BusinessObjects Data Services Designer/Central Management console
So before login upgrade the repository using SAP Business Objects Repository manager.Below are the steps for upgrade of local repository details:
Below are the steps for upgrade of local repository & upgrade of secure central repository
Upgrade of Local Repository using SAP Data Services Repository manager:
Open SAP Data Services repository manager and check the version before migrating, You can also check in repository metadata through SQL
And after validating click on upgrade tab
Upgrade of Secure Central Repository:
Do the same validation for Secure central repository
And after validating click on upgrade tab
After Installation & Up-gradation of SAP business Objects BOE/IPS Server, SAP Business Objects Data Services 4.2SP12 below are the status that i upgraded in VM Ware
S.No | Repository Name | Repository Version | Upgraded Version | Status |
1 | LOCAL_REPO | 14.2.3 | 14.2.12 | Completed |
2 | CENTRAL_REPO | 14.2.3 | 14.2.12 | Completed |
Then Login to Central Management Console -> Go to Data Services
Then Click on Data Services and check the repository version details.
Now try to login in SAP BusinessObjects Data Services Designer with SAP Business Objects Credential
Click on Logon and Click on “ok”
Now login in SAP BusinessObjects Data Services management console
Click on “Administrator” tab
Relevant Systems
These enhancements were successfully implemented in the following systems:
- SAP Information Platform Services 4.2 SP7
- SAP BusinessObjects Data Services 4.2 SP12
This document is relevant for
- SAP BusinessObjects Data Services Administrator
This blog does not cover:
- SAP BusinessObjects Data Quality Management Up-Gradation
Upgrade installation of SAP Data Services 4.2 SP12:- Some items to keep in mind when you install this upgrade:
- The installer migrates the objects in the DSConfig.txt file to the new Data Services 4.2 SP9 locations. For more information about these changes, see User Access Control (UAC) support.
- If, during the installation, you choose to configure a Data Services repository with an Oracle database, the installer will not accept the ojdbc5.jar file as a supported Oracle JDBC driver, and the installation will be blocked. The ojdbc5.jar file is not a supported Oracle JDBC driver in Data Services 4.2 SP12, so use ojdbc6.jar instead.
- While you are performing an upgrade installation, if the existing Data Services product keys are already expired, the installation will be blocked.
- For Windows, the upgrade installer contains an option to change the default location of the Data Services common directory (DS_COMMON_DIR). The new directory must be local and be accessible to all applicable users. Additionally the new directory must have sufficient disk space for the configuration and log files that reside in the common directory. For more information, see the Installation Guide for Windows (Installation, Interactive installation using default configuration, Change DS_COMMON_DIR location).
Whether you are upgrading from Data Services 4.x or some other prior version, keep in mind the following, because they apply to both upgrade scenarios.
-
- Data Services Profiler configuration: When you upgrade to Data Services 4.2 SP12, the Profiler configuration parameters are set to default values. If you had previously modified any of the Profiler configuration parameters, after installing 4.2 SP12, you need to log on to the Management Console and change the Profiler configuration parameters to your custom settings.
- Oracle users: Before upgrading to version 4.2 SP12, be sure to grant the database account the create any sequence privilege
Reference Material:-
Upgrade Guide:
https://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_upgrade_en.pdf
Installation Guide Windows:
https://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_install_win_en.pdf
Installation Guide UNIX:
https://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_install_unix_en.pdf
SAP Data Services 4.2:
https://help.sap.com/bods
SAP Data Services 4.2 Product Availability Matrix:
https://websmp208.sap-ag.de/~sapidb/011000358700000441762013E
SAP Data Services Blueprints (Sample ATL Files of BODS 4.x)
Links
http://scn.sap.com/docs/DOC-8820
Data Services Product Tutorials:
Links
http://wiki.scn.sap.com/wiki/display/EIM/Data+Services+Product+Tutorials
http://wiki.scn.sap.com/wiki/display/EIM/Data+Services
Video Tutorials:
Links
http://wiki.scn.sap.com/wiki/display/EIM/Video+Tutorials
SNotes:
1388363 – Where can I download Data Services software, support packages, and patches?
2766985 – Release Notes for SAP Data Services 4.2 Support Pack 12 (Version 14.2.12.2235)
2799743 – SQL pushdown to PostGreSQL database breaking down to multiple queries – SAP Data Services
2758141 – Primary address is not recognized for India address – Data Services
2839282 – Data Services 4.2 SP12 Client Install fails with existing BI Client SP7
1263925 – Are Data Quality blueprints available? – Data Services
1530081 – Troubleshooting tips for SAP Data Services 4.x
1723342 – Data Services 4.1 Upgrade Scenarios
1725915 – Release Notes for SAP Data Services 4.1 (14.1.0) Ramp-Up
1694041 – BI 4.0 Consulting:- How to size the Adaptive Processing Server
1769406 – Best Practices on taking a Hot Backup for a SAP BI 4.0 deployment
746938 – How to backup or restore a Data Services 4.0 cleansing package.
DS4.1 – Address Cleansing using Global Address Cleanse transform
1645932 – How to setup SSL certificates in a Distributed Environment – Data Services XI 4.0
1416303 – Can’t reach Job Server from DS Designer
1789731 – What version is compatible with Data Services 4.X? – Data Quality Management for SAP
1842698 – SAP Data Services 4.2 Upgrade Scenarios
2039877 – License Manager GUI removed from Windows – Data Services 4.2.2
1975789 – Considering upgrading from Data Services 3.2 to Data Services 4.2
1977090 – Is a new license key required when upgrading from 4.0/4.1? – Data Services 4.2
2016824 – Support for Windows Server 2012 R2 – Data Services 4.2
1916294 – Upgrading SAP System fails with issues from /BODS functions
2156333 – Data Services RFC Server hangs occasionally
1820474 – DS 4.1 job failing with: CRFC error: RFC_LOGON_FAILURE- Password must be changed.
2055489 – Jobs run out of virtual memory after upgrading HANA – Data Services 4.2
2099802 – Performance decrease after upgrading Data Services to 4.2 SP3 Patch 2.
2045240 – DS Job fails after import into repository of higher version
1926563 – JMS Adapter initialization error when configured for MQ – SAP Data Services 4.2
1812981 – Installing two different versions of Designer on the same box – Data Services
Related Blog Post: –
SAP Data Services 4.2 SP8 Upgrade steps
Nice explained!
Hi Daya,
Thanks for sharing information!
Recently we upgraded BODS to 4.2 SP12.
After upgrading repository, I found that most of the annotations are missing which we defined at different object levels
Is there any way to get it back ?
Thanks,
Darshil Shah
Hi Darshil,
This issue are in older version, could you please raise an OSS message with SAP.
In my case i have not face such issue in my landscape, please refer below KBA for your reference.
In older version it was bug, SAP has fixed it.
1912759 - Annotations are partially missing after upgrade - SAP Data Services 4.1
Regards,
Daya Jha
Hi Daya,
What will be the steps for upgrading from SAP BusinessObjects BI Platform 4.1 Support Pack 5 Patch 2 to SAP businessObjects BI platform 4.2 latest support pack
Thanks and Regards
Hi Vinod,
Please refer below blog for more details.
How to Upgrade to BI4.1 SP06 Patch 3 to BI4.2 SP07
https://blogs.sap.com/2019/12/31/how-to-upgrade-to-bi4.1-sp06-patch-3-to-bi4.2-sp07/
How to Upgrade to BI4.1 SP06 to BI4.2 Steps
How to Upgrade to BI4.1 SP02 to BI4.1SP06 Steps including Lumira Server
How to Upgrade to BI4.2 to BI4.2 SP3 Steps
Regards,
Daya Jha
Hi Daya,
The script you used to validate Jobs, Access Server, Adapter & Web Services etc was part of any SAP note.
If not, can you please share the scripts you used ??
Thanks
Hi Daya,
Our BODS 4.2 SP9 is installed on Windows 2012. Want to upgrade Windows from 2012 to 2019 and hence also require to upgrade BODS 4.2 SP9 to BODS 4.2 SP14.
Just wanted to know, can we perform first windows upgrade and then BODS to 4.2 Sp14 on the same server?
Is there any major activities need to perform apart from what you mentioned above?
Highly appreciate your reply.
Thanks,
Darshil Shah