--- title: Execute Load Control description: Executing load control runs the load objects of one execution plan in the order of their dependencies and logs each step. --- [Skip to content](https://knowledge.bigenius-x.com/execute-load-control#main-content) [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en) [![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/) Open main navigation Close main navigation - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new) - [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal) How can we help you? - There are no suggestions because the search field is empty. 1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/?hsLang=en) 2. [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en) 3. [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment) # Execute Load Control **Applies to** Platform: Microsoft SQL Server · Oracle Executing load control runs the load objects of one execution plan in the order of their dependencies and logs each step. Use it to load data, to add workers to a running load, to stop a load and to resume a failed one. Afterwards each run is an execution with one step per load object and a result you can query. ### Prerequisites - An execution plan exists: [Plan Load Control](https://knowledge.bigenius-x.com/plan-load-control?hsLang=en). The generated `execute.sql` builds `DEV_` and starts it. - The source data your Stage objects read is available. - On Oracle, the load-control user has `EXECUTE` on `SYS.DBMS_LOCK`; without it the execution procedures are invalid after deployment. ### Start an execution 1. Open a terminal in the folder of the replaced artifacts. 2. Run `execute.ps1`, or run a plan directly: ``` EXEC [LC].[Start_Execution] @ExecutionPlan = N'DEV_Datavault.Mssql'; ``` The procedure creates an execution, copies the dependencies of the plan's load objects and runs each step when the steps it depends on are finished. It ends with `Execution plan [DEV_Datavault.Mssql] completed by execution [].` 3. Optional parameters: `@LoadEffectiveTimestamp` (passed to every loader; default: the start time), `@Description` and `@ExecutionExternalReference` (stored with the execution). `execute.ps1` runs one worker. To run steps in parallel, call `Start_Execution` for the same plan from more sessions while the execution runs. Each call prints `Execution plan [] has active execution []. Adding worker.` and processes steps of the same execution. A plan has at most one active execution. ### Stop an execution 1. From another session, run `EXEC [LC].[Stop_Execution] @ExecutionPlan = N'DEV_Datavault.Mssql';`. It prints `Execution [] for execution plan [] stopped.` 2. Running steps finish; steps that have not started stay without result. The execution gets `IsCanceled` 1 and the result `Aborted`. Use the same procedure for an execution that is still active after its session ended, so that the plan can start again. ### Resume a failed or stopped execution 1. Find the cause of the failed step in `Execution_Step.ErrorDescription` (see [Monitor Load Control](https://knowledge.bigenius-x.com/monitor-load-control?hsLang=en)) and fix it. 2. Stop the execution if it is still active. 3. Run `EXEC [LC].[Resume_Execution] @ExecutionPlan = N'DEV_Datavault.Mssql';`. It creates a new execution with all steps that did not succeed, references the old one in `FK_ResumedExecution_ID` and keeps its `LoadEffectiveAt`. ### Check the result ``` SELECT [ID], [FK_ResumedExecution_ID], [IsActive], [IsCanceled], [ExecutionResult], [LoadEffectiveAt], [LoadCreatedAt] FROM [LC].[Execution] ORDER BY [ID] DESC; ``` `ExecutionResult` is `Success`, `Finished with errors` or `Aborted`. ### Example The Stage table of `CUSTOMER` is missing when `DEV_Datavault.Mssql` runs with the default error behavior: ``` Start_Execution [54]: Execution plan [DEV_Datavault.Mssql] completed by execution [3] with 34 FAILED or DISABLED load steps. ``` The number after `Start_Execution` is the session ID of the worker. Execution 3 has the result `Finished with 34 errors`: the Stage Loader failed, 33 dependent steps are `Disabled` and 69 steps succeeded. After the table is restored, `Resume_Execution` creates execution 4: ``` ID FK_ResumedExecution_ID ExecutionResult LoadEffectiveAt 3 NULL Finished with 34 errors 01:08:56.374 4 3 Success 01:08:56.374 ``` Execution 4 runs the 34 steps that did not succeed. ### Failure symptoms and recovery #### A step fails and its dependent steps are disabled Message: `Disabled due to error of method .` in `ErrorDescription` of the dependent steps. Cause: the loader returned an error with `ContinueOnError`. Fix: correct the cause, then resume the execution. #### The execution is aborted at the first error Message: `Execution [] step [] finished with error. AbortOnError configured: execution aborted.` Cause: the load object has `AbortOnError`. The failed step gets `Failure with abort`; the steps that did not start keep no result. Fix: correct the cause, then resume the execution. ### Platform differences On Oracle, call the procedures in a PL/SQL block: ``` BEGIN LC.PR_Start_Execution(v_Execution_Plan => 'DEV_test.datavault.oracle'); END; / ``` - `PR_Start_Execution` takes `v_Execution_Plan`, `v_Load_Effective_Timestamp` and `v_Description`; `PR_Stop_Execution` and `PR_Resume_Execution` take `v_Execution_Plan`. - The tables are `Execution`, `Execution_Step` and `Execution_Loadobject_Dependency`. A failed step stores `Failure:` followed by the Oracle error in `Execution_Result`. ### Related articles - Previous: [Plan Load Control](https://knowledge.bigenius-x.com/plan-load-control?hsLang=en) - Next: [Monitor Load Control](https://knowledge.bigenius-x.com/monitor-load-control?hsLang=en) - See also: [Understand Load Control](https://knowledge.bigenius-x.com/understand-load-control?hsLang=en), [Troubleshoot generation, deployment and load failures](https://knowledge.bigenius-x.com/troubleshoot-generation-deployment-and-load-failures?hsLang=en) - Microsoft SQL Server: [Load data - Native Load Control](https://knowledge.bigenius-x.com/microsoft-sql-server-load-data-native-load-control?hsLang=en) - Oracle: [Load data - Native Load Control](https://knowledge.bigenius-x.com/oracle-load-data-native-load-control?hsLang=en) - [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content) - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines) - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working) - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account) - [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en) - [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en) - [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content) - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration) - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions) - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features) - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects) - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches) - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections) - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview) - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps) - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms) - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping) - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships) - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality) - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes) - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling) - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts) - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings) - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace) - [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content) - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks) - [Databricks dbt](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks-dbt) - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse) - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse) - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server) - [Oracle](https://knowledge.bigenius-x.com/generators?hsLang=en#oracle) - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake) - [Snowflake dbt](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake-dbt) - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts) - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders) - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment) - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment) - [Deployment with an Azure DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azure-devops-pipeline) - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment) - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment) - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control) - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow) - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type) - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties) - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms) - [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content) - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations) - [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content) - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches) - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases) - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules) - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules) - [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en) - [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content) - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application) - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application) - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators) - [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content) - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs) - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#software-product-and-limits) - [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) - [Customer Portal](https://knowledge.bigenius-x.com/customer-portal) - [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login) [![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com) All rights reserved © 2025, biGENIUS AG