Troubleshooting Warehouse Connector

Document created by RSA Information Design and Development on Apr 28, 2016Last modified by RSA Information Design and Development on Apr 28, 2016
Version 2Show Document
  • View in full screen mode
 
  

This topic provides information about possible issues that Security Analytics users may encounter when adding a Warehouse service to the Reporting Engine as a data source for reporting in Security Analytics. Look for explanations and solutions in this topic.

While adding a Warehouse service to the Reporting Engine as a data source for reporting, you may observe some of the errors listed in this document. Information is provided on how to troubleshoot the errors and add the data source successfully.

The following figure shows the New Service dialog.

NewServDg.png

For more information, see the Add Warehouse as a Data Source to Reporting Engine topic in the Reporting Engine Configuration Guide.

                          
ErrorPossible Solutions
Could not open connection to HiveServer
  • Ensure that the HiveServer2 is running on the Host.
  • Check if the port provided can be accessible from the Reporting Engine server.
No Schema found in HDFS path

Ensure that meta avro data file(s) are available in the HDFS path
(<HDFS Path>/rsasoc/v1/sessions/meta) mentioned.
The following figure shows an example of the command to check the files in hdfs.

ChkFlsCmd.png

Could not open connection to HiveServer, GSS initiate failedGSS initiate failed errors will be observed only in the case of Kerberos enabled Hive.
Ensure that the proper keytab file is provided and it should have read options for the rsasoc user (user on which the Reporting Engine Server runs).
Ensure that the system time is synchronized between KDC, Hadoop (Pivotal) server, and the Reporting Engine system.
You are here: Troubleshooting Warehouse Connector

Attachments

    Outcomes