Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.ocient.com/llms.txt

Use this file to discover all available pages before exploring further.

You can troubleshoot data pipelines using the standard logging mechanism in . 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.loggingConfigDerived Level for log4j
FATALERROR
ERRORERROR
WARNWARN
INFOINFO
DEBUGDEBUG
TRACEEDEBUG

​
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';
Monitor Data Pipelines Data Pipeline Loading Errors
Last modified on May 27, 2026