skip to main content
Administering Hybrid Data Pipeline : Logging : Updating Logging Level
  

Try Now

Updating Logging Level

You can update logging level for administrator data sources by clicking on the settings icon for the data source for which you wish to update the logging level.
Navigate to Logging settingsNavigate to Logging settings
If you want to update logging level for user data sources, you must navigate to the Manage Users page. Click the User Data Sources icon for the relevant user. Once the User datasources are displayed, you can click the settings icon for the relevant datasource.
Logging settings screenLogging settings screen
The ‘DataSource Logging' screen is displayed. Here, you can see and update logging settings for Data Access Service. You can use the sliders to update the Logging Level and Privacy Level. If you make any changes to the logging settings, click the SAVE button. If you choose to Restore Default Settings, the logging settings values should reset to default values. The default logging for non-relational drivers is that all four loggers are OFF. For relational drivers, the default driverlogginglevel is OFF, the DasLogLevel is CONFIG and the PrivacyLevel is set to AllowNone.
Logging: types, levels and valid values can set Data Access Service Logging Level to control the granularity of the logging. The valid values are SEVERE, WARNING, INFO, CONFIG, FINE, FINER, FINEST"
Table 7. Data Access Service Logging levels
Level Name
Description
SEVERE
Used by HDP to indicate system level problems that may require intervention.
WARNING
Possible servere situation, but problem probably averted.
INFO
Basic activity that probably always wants to be tracked by HDP.
CONFIG
Default user level for HDP. Tracks servlet and worker thread activity.
FINE
Debug diagnostics.
FINER
Debug diagnostics. More verbose than FINE.
FINEST
Debug diagnostics. This is the most verbose mode.
You can set Privacy Level as either AllowNone, AllowSQL or AllowData.
Table 8. Data Access Service Privacy levels
Level Name
Description
AllowNone
This is the most restrictive level. Here neither user data nor SQL statements are logged.
AllowSQL
This level allows the logging of SQL statements, but not input parameter values or result set column data.
AllowData
This is the least restrictive level. It allows SQL statements and any data values to be logged.
Update Logging Settings - Success messageUpdate Logging Settings - Success message
For some data stores, Hybrid Data Pipeline also provides further logging for troubleshooting issues. These data stores include: Salesforce, Dyanmics CRM, Oracle Service Cloud, Oracle Sales Cloud, Oracle Marketing Cloud, Rollbase, SugarCRM and Google Analytics.
The following loggers can be configured for these data sources:
*Adapter: Logs events related to how HDP communicates with the data store in question.
*SQL: Logs events associated with how the embedded SQL engine interacts with the data store and application.
*Drivercommunication: Logs events associated with the JDBC calls made into the embedded SQL engine.
*Cloud: Logs JDBC spy calls to troubleshoot JDBC interactions between HDP service and the data store.
Update Driver Logging SettingsUpdate Driver Logging Settings
Driver logging settings can be updated only when Data Access Service Privacy level is set to ‘AllowSQL’ or ‘AllowData’. If you choose to Restore Default Settings, the logging settings values should reset to default values. The default logging for non-relational drivers is that all four loggers are OFF. For relational drivers, the default driverlogginglevel is OFF, the DasLogLevel is CONFIG and the PrivacyLevel is set to AllowNone.
Update Driver Logging Settings: SQL, Cloud, DriverCommunication and AdapterUpdate Driver Logging Settings: SQL, Cloud, DriverCommunication and Adapter