REST API query to VSQL and OData OpenAPI debug logging

book

Article ID: 141747

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

How can I convert the REST API query into the equivalent VSQL query sent to Vertica to retrieve the information.

How can logging to track OpenAPI Odata queries be enabled and reviewed?

How to debug OpenAPI Odata queries using Data Aggregator (DA) logging.

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Resolution

This information can be obtained from the OpenAPI debug. 

How to debug what vertica query OpenAPI is making to the database.

Add the following lines to /opt/IMDataAggregator/apache-karaf-/etc/org.ops4j.pax.logging.cfg and save.

log4j.category.com.ca.im.odata.vertica.impl.SQLRepositoryClientBase=DEBUG,sift

log4j.additivity.com.ca.im.odata.vertica.impl.SQLRepositoryClientBase=FALSE

Run the odata query again.

Check the /opt/IMDataAggregator/apache-karaf-/data/log/odata-services.impl.log file for the SQL call being made.