> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://ocient.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://ocient.ferndocs.com/_mcp/server.

# Configure Data Pipeline Logging

> 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.

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**`streamloader.extractorEngineParameters.loggingConfig` | **Derived Level for**`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**](/guides/load-data/monitor-data-pipelines)

[**Data Pipeline Loading Errors**](/guides/sql-reference/errors-and-warnings/data-pipeline-loading-errors)