What to do if after upgrading the TIBCO Data Virtualization Server, an error pops up when a test connection to the SAP ( SAP, SAP BW and SAP BWEX) data sources is tested?

What to do if after upgrading the TIBCO Data Virtualization Server, an error pops up when a test connection to the SAP ( SAP, SAP BW and SAP BWEX) data sources is tested?

book

Article ID: KB0070454

calendar_today

Updated On:

Products

TIBCO Data Virtualization

Description

The error "Unable to initialize SAP JCo. Verify that SAP JCo 3.0.9 or higher is properly installed" is seen when the SAP drivers are not configured correctly.
The steps to do so are mentioned below.

Issue/Introduction

This article will provide a guide for Windows on what are the steps to follow, to solve the "Unable to initialize SAP JCo. Verify that SAP JCo 3.0.9 or higher is properly installed" error?

Environment

Windows

Resolution

Please follow the below steps:
--------------------------
1. Unzip the SAP JCo zip file for your machine into a temporary directory.

2. Execute the command to create jre folder under <TDV_install_dir>/jdk:
         — ./bin/jlink --module-path jmods --add-modules java.desktop --output ../jre
         — create a folder named as ext under <TDV_install_dir>\jre\lib

3. Copy sapjco3.jar and sapjco3.dll to below location of <TDV_install_dir>/ where <TDV_install_dir> is the root directory of your TDV Server.
                -- <TDV_install_dir>/jre/lib/ext
                -- <TDV_install_dir>apps\dlm\app_ds_sap\lib       --For SAP adapter connectivity
                --  <TDV_install_dir>apps\dlm\app_ds_sapbw\lib   -- For SAP BW adapter connectivity
                --   <TDV_install_dir>apps\dlm\app_ds_sapbwbex\lib   -- For SAP BW Bex adapter connectivity

4. Add the path in system environment variables to point to the directory where the library files have been placed in the previous step.
                --    <TDV install dir>\apps\dlm\app_ds_sap\lib

5. Restart TDV monitor service 

6. Open TDV Studio and establish a connection to your SAP instance using the SAP adapter.
--------------------------

Additional Information

For Linux, refer- https://support.tibco.com/s/article/How-to-configure-the-SAP-Java-Connector-Library-in-TIBCO-Data-Virtualization-on-a-Linux-environment.