Connection SAP Vora Tools <=> Thriftserver

[Former Member]

Hi all,

we've set up a Vora 1.4 sandbox system based on Ambari. Almost everything seems to run fine, but the Vora Tools fail to connect to the thriftserver. The connection icon in the Vora Tools screen shows connection "OFFLINE". If we click on it, the browser opens an authorization dialog, and it seems that the information entered there is used to authenticate against the thriftserver.

This is what we see in the logs:

• ERROR|error accessing database default: {<somehostname> 19123 <someuser> <somepassword>}, java.io.IOException: RSCClient instance stopped.|datatools|vora-tools|0|datatools.(*dataTools).handleConnectionErrorInternal|datatools.go(296)

• WARN |Auth type: 'NONE'|hive|vora-tools|0|datatools.connectionLogger.Write|datatools.go(412)

• WARN |Error status when opening session: java.io.IOException: RSCClient instance stopped.|hive|vora-tools|0|datatools.connectionLogger.Write|datatools.go(412)

The thriftserver logs contain the following

• INFO ContextLauncher: org.apache.hadoop.service.ServiceStateException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: vora is not allowed to impersonate sapvora

Did we miss some configuration steps?

Thanks for any help,
Elmar.

[JasonHinsperger · Accepted solution]

Are you using HDP 2.5.5? If so, there was a change which caused issues with the Thriftserver. As outlined in the Vora 1.4 troubleshooting guide you can fix the behavior as follows:

1. In the SAP Vora Manager, choose Vora Thriftserver Configuration .

2. In the field Extra arguments for SAP Vora Thriftserver, append the following: --hiveconf hive.server2.enable.doAs=false

The default setting should then be: --conf vora.hadoop.distro=vora --hiveconf hive.server2.enable.doAs=false

HTH

--Jason

[former_member409893 · Accepted solution]

Hi Jason,
thanks a lot! It works now.

Best regards,
Niklas