Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Hello, I am trying to configure Apache Hive connection but i am getting the below error, Could any one please help what the error means and how to resolve. Thanks.


saicharan kancharla

Recommended Posts

(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF) XOPEN: 00000

(FOC1500) : (-1) [00000] JDBFOC>> makeConnection(): conn is NULLjava.sql.

(FOC1500) : SQLException: [Cloudera][HiveJDBCDriver](500593) Communication link

(FOC1500) : failure. Failed to connect to server. Reason: HTTP Response code: 401,

(FOC1500) : Error message: Unknown. OpenSession.

(FOC1500) : at com.cloudera.hiveserver2.exceptions.jdbc4.JDBC4ExceptionConverter.

(FOC1500) : convertToJDBC4Exception(Unknown Source)

(FOC1500) : at com.cloudera.hiveserver2.exceptions.jdbc4.JDBC4ExceptionConverter.

(FOC1500) : toSQLException(Unknown Source)

(FOC1500) : at com.cloudera.hiveserver2.exceptions.ExceptionConverter.

(FOC1500) : toSQLException(Unknown Source)

(FOC1405) SQL PREPARE ERROR.

Test for HiveSQL (SQLHIV) failed due to prepare error:

FOC1405

Link to comment
Share on other sites

Hi Saicharan

I think this looks like the sort of thing you might want to open a as on with TIBCO.

But - let me ask you some questions:

1) what release of WebFOCUS are you working on?

2) what manuals are you looking at to try to solve your issue? Hint - you should be looking at a mnual that has 'adapter administration' in the title.

I can tell you from a quick internet search that an HTTP 401 means 'unauthorized' which may or may not be a real error message. It's possible your communication to Hive just didn't work and the 401 is really coming following the lack of a connection. Maybe it's really reaching the Hive server and getting kicked back for authentication problems, or maybe you never reached it to ask if your userid/pw was correct.

Sometimes in these cases, I like to remove WebFOCUS from the picture all together. Use a standalone product like DBVIsualizer installed on the same machine as your WebFOCUS Reporting Server and see if you can connect with JDBC that way. If you can get DBVisualizer to work, you'll probably be able to get WebFOCUS to work.

https://support.dbvis.com/support/solutions/articles/1000252068-hive-connect-to-apache-hive-hadoop

Dig in more with these hints and let us know how it's going. Or just open a case and post the outcome of your case here to wrap up your original question.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...