My Oracle Support Banner

B1_SYNC_CONTEXT Fails With Error 'ODI-30059: MAX_CHILD_ERROR Parameter' (Doc ID 2528338.1)

Last updated on FEBRUARY 15, 2024

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version and later
Information in this document applies to any platform.


**Examples provided in this article do not represent real life personal/confidential information**

**Disclaimer:** This KM article may include the following abbreviations:

ODI - Oracle Data Integrator

B1_SYNC_CONTEXT fails with error 'ODI-30059: MAX_CHILD_ERROR parameter'

ODI-1217: Session B1_SYNC_CONTEXT (1121) fails with return code 7000.
ODI-1226: Step B1_SYNC_CONTEXT fails after 1 attempt(s).
ODI-1232: Procedure B1_SYNC_CONTEXT execution fails.
Caused By: com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30059: The number of child sessions in error state is greater or equal to the MAX_CHILD_ERROR parameter
at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(
at oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(
at oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(
at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(
at oracle.odi.runtime.agent.execution.SessionTask.processTask(
at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.