---
title: Configure Data Pipeline Logging
slug: j-sq-troubleshoot
description: To troubleshoot Ocient data pipelines, log levels can be adjusted using SQL commands, impacting performance. Set the log level using `ALTER SYSTEM ALTER LOG LEVEL SET`, then configure specific logging parameters. 
docTags: 
createdAt: Wed Apr 03 2024 19:29:29 GMT+0000 (Coordinated Universal Time)
updatedAt: Mon Mar 30 2026 18:52:29 GMT+0000 (Coordinated Universal Time)
---

You can troubleshoot data pipelines using the standard logging mechanism in Ocient®.

Set these log levels in consultation with Ocient Support because this setting might impact performance.

## Modify the Level of Logging

Execute these two SQL statements in this order to bump up the log message.

First, set the log level.

```sql
ALTER SYSTEM ALTER LOG LEVEL SET 'log4j' 'EDEBUG';
```

Then, set the level for the logging configuration.

```sql
ALTER SYSTEM ALTER CONFIG SET 'streamloader.extractorEngineParameters.loggingConfig.com.ocient.extractor.allowLevel' 'trace';
```

If the log level of the first SQL statement is lower than the log level of the second SQL statement, the system loses log entries.

It is also possible to repeat the second SQL statement for different package names, such as:

- `ALTER SYSTEM ALTER CONFIG SET 'streamloader.extractorEngineParameters.loggingConfig.com.ocient.extractor.allowLevel' 'Info';`
- `ALTER SYSTEM ALTER CONFIG SET 'streamloader.extractorEngineParameters.loggingConfig.com.ocient.extractor.en gine.allowLevel' 'Trace';`

## Valid Log Levels

This table provides an overview of the log levels you can specify for the `ALTER SYSTEM ALTER LOG LEVEL SET` SQL statements with the `streamloader.extractorEngineParameters.loggingConfig` keys. The necessary log level for `log4j` must be set accordingly to at least the value specified in the column for the `log4j` level.

| **Log Level of&#x20;**`streamloader.extractorEngineParameters.loggingConfig` | **Derived Level for&#x20;**`log4j` |
| ---------------------------------------------------------------------------- | ---------------------------------- |
| FATAL                                                                        | ERROR                              |
| ERROR                                                                        | ERROR                              |
| WARN                                                                         | WARN                               |
| INFO                                                                         | INFO                               |
| DEBUG                                                                        | DEBUG                              |
| TRACE                                                                        | EDEBUG                             |

## Reset the Log Level

To reset the log level after you reproduce a problem, execute these SQL statements.

```sql
ALTER SYSTEM ALTER CONFIG RESET 'streamloader.extractorEngineParameters.loggingConfig.com.ocient.extractor.allowLevel';
ALTER SYSTEM ALTER CONFIG RESET 'log4j';
```

## Related Links

[Monitor Data Pipelines](<./././Load Data/Monitor Data Pipelines.md>)

[Data Pipeline Loading Errors](<./././SQL Reference/Errors and Warnings/Data Pipeline Loading Errors.md>)

