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:"Function [INFASQLExecute] failed in adapter with error code [-1]. FnName: INFASQLExecute -- execute(). SQLException: [JDBC Driver]Index: 1, Size: 1" while running profiles on a hive data object
Problem Description
While running profiles on hive data objects, the profiles are failing with the below error snippet.
===================================================

2020-04-05 20:12:00.789 <TASK_47361879181056-TRANSF_1_1_1> INFO: [TT_11186] Lookup cache of [??_UITS_BASE_DATA], previously started by an additional concurrent pipeline, is now needed on demand.

2020-04-05 20:12:10.714 <TASK_47361948649216-LKPDP_1:READER_1_1> SEVERE: [RR_4035] SQL Error [

 

Function [INFASQLExecute] failed in adapter [/work/infa/Informatica/10.2.0/plugins/dynamic/infajdbcruntime/libinfajdbc.so] with error code [-1].

FnName: INFASQLExecute -- execute(). SQLException: [JDBC Driver]Index: 1, Size: 1

===================================================


NOTE: This issue is intermittent.

Cause
The profile failed due to connectivity failure with exception to the configured database. At the time of scorecard failure , the hive JDBC connection failed to fetch data from the database and hence the error.
Solution

Informatica does not support/Certify JDBC type of the connection for hive.

If you wish to use HIVE database, it is strongly recommended to use 'HIVE' type of database.

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

Reference
Attachments
Last Modified Date:6/1/2020 9:43 PMID:621521
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)