Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

"[ERROR] Error while Initialization: [Unable to load sapjco.jar. Please ensure sapjco.jar is installed correctly]" while running a Data Synchronization/Mapping task using SAP Table connector in IICS
Problem Description
When running a Data Synchronization/Mapping task using SAP Table Connector in IICS, the task fails with the following error:

[ERROR] Error while Initialization: [Unable to load sapjco.jar. Please ensure sapjco.jar is installed correctly].

The complete stack seen in the session log of the task is as follows:

READER_1_1_1> CMN_1761 [2016-06-22 02:03:17.897] Timestamp Event: [Wed Jun 22 02:03:17 2016]
READER_1_1_1> GENERIC_READ_22 [2016-06-22 02:03:17.897] [ERROR] Error while Initialization: [Unable to load sapjco.jar. Please ensure sapjco.jar is installed correctly]
READER_1_1_1> CMN_1761 [2016-06-22 02:03:17.897] Timestamp Event: [Wed Jun 22 02:03:17 2016]
READER_1_1_1> JAVA PLUGIN_1762 [2016-06-22 02:03:17.897] [ERROR] com.informatica.powercenter.sdk.SDKException: com.informatica.cloud.api.adapter.runtime.exception.InitializationException: Unable to load sapjco.jar. Please ensure sapjco.jar is installed correctly

at com.informatica.cloud.adapter.sap.table_reader.plugin.SAPPlugin.getConnection(Unknown Source)

at com.informatica.cloud.api.adapter.reader.runtime.GenericRdrPartitionDriver.init(Unknown Source)
​​
Cause
In this case, the 'tpl.properties' file was missing in the <Informatica Secure Agent installation directory>\main\bin\rdtm-extra\plugins\300620 folder.​
Solution
To resolve this issue, do the following and verify that the configuration changes are valid:

1. Copy the JCo libraries (sapjco3.jar and sapjco3.dll) to the following directory:

​<Informatica Secure Agent installation directory>\main\bin\rdtm-extra\tpl\sap
Note

Before you copy the JCo files, you must create the tpl\sap directory within the rdtm-extra directory if the tpl\sap directory does not already exist.

2. Delete the 'sapjco3.jar' if it exists under the 300620 plugin folders. You must delete the sapjco3.jar file from the following locations if it exists:

<Informatica Secure Agent installation directory>\main\bin\rdtm-extra\plugins\300620​
<Informatica Secure Agent installation directory>\main\bin\rdtm\javalib\300620​

3. The 'tpl.properties' file will exist in the below location, DO NOT delete it. If it does not exists, download the attached file and place it in the following location:

<Informatica Secure Agent installation directory>\main\bin\rdtm-extra\plugins\300620​

4. Configure the JAVA_LIBS property in Informatica Cloud as follows:

a. Log in to Informatica Cloud.

b. Click Configure > Runtime Environments to access the Runtime Environments page.

c. To the left of the agent name, click Edit Secure Agent.

d. From the Type list, select Tomcat JRE.

e. Enter the JAVA_LIBS value based on the operating system on which the Secure Agent runs.

 

Operating System

Value

Windows

../bin/rdtm-extra/tpl/sap/sapjco3.jar;../bin/rdtm/javalib/sap/sap-adapter-common.jar

Linux

../bin/rdtm-extra/tpl/sap/sapjco3.jar:../bin/rdtm/javalib/sap/sap-adapter-common.jar


5. Restart the secure agent.

More Information
Applies To
Product: Cloud Data Integration
Problem Type: Configuration
User Type: Administrator
Project Phase: Configure
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:7/17/2019 9:00 PMID:498243
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)