The Data Integration Service could not find the run-time OSGi bundle for the adapter [com.informatica.adapter.infajdbc.InfaJDBCConnectInfo

[#1]

Hi ,

While running the informatica mapping , iam getting the error as mentioned below.

2018-02-03 21:37:30.604 <DefaultWorkManager-WorkerThread-7> INFO: [2904][2018-02-03 21:37:29.095] Invoke M_load_bm_dl_his_sla_ticket_submaster_invoke: Faulting: Mapping-error : java.lang.Exception: [MPSVCCMN_10094] The Mapping Service Module failed to run the job with ID [MdOS0gj8EeiQDeexJuc-4Q] because of the following error: [HIVE_1070] The Integration Service failed to run Hive query [exec0_query_6] for task [exec0] due to following error: Hive error code [2], Hive message [FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1517663055306_0153_1_00, diagnostics=[Task failed, taskId=task_1517663055306_0153_1_00_000000, diagnostics=[TaskAttempt 0 failed, info=[Error: Failure while running task:java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: java.io.IOException: Mapping execution failed with the following error: ODL_26128 Database error encountered in connection object [pri_sqoop_dwh3] with the following error message: [Database error encountered in connection object [com.informatica.adapter.infajdbc.InfaJDBCConnectInfo] with the following error message: [There is no runtime plugin entry for OSType[LINUX], objectName[com.informatica.adapter.infajdbc.InfaJDBCConnectInfo] and interfaceName[INFASQLDataAdapter]. ] The Data Integration Service could not find the run-time OSGi bundle for the adapter [com.informatica.adapter.infajdbc.InfaJDBCConnectInfo] for the operating system [LINUX]. Copy the adapter run-time OSGi bundle and verify that you have set the correct library name in the plugin.xml file.] Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.io.IOException: Mapping execution failed with the following error: ODL_26128 Database error encountered in connection object [pri_sqoop_dwh3] with the following error message: [Database error encountered in connection object [com.informatica.adapter.infajdbc.InfaJDBCConnectInfo] with the following error message: [There is no runtime plugin entry for OSType[LINUX], objectName[com.informatica.adapter.infajdbc.InfaJDBCConnectInfo] and interfaceName[INFASQLDataAdapter]. ]

Thanks,

Kotesh.

[#2]

Could you share a bit more about your issue, like the scenario or the process that you are doing? You would get more responses that way. 🙂

[#3]

workflow-log.txt@Sivaprasanna

I am use informatica BDM 10.0.1 version.

Source is mysql and target is HIVE table.

While executing the Infoematica workflow iam getting the error as mentioned.

FYR

I am attaching the workflow log.

Thanks.