Troubleshooting Warehouse Connector

Document created by RSA Information Design and Development on Sep 14, 2017Last modified by RSA Information Design and Development on Nov 16, 2017
Version 5Show Document
  • View in full screen mode
 

The following information suggests the possible issues that NetWitness users may encounter when adding a Warehouse service to the Reporting Engine as a data source for reporting in NetWitness. Look for explanations and solutions in this section.

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.

add warehouse as data source to RE

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.

chk fls command

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 (HortonWorks) server, and the Reporting Engine system.
You are here
Table of Contents > Troubleshoot the Warehouse Connector

Attachments

    Outcomes