--- title: Execute Load Control description: "Executing the Load Control means loading the data by following an execution plan. This is done in several steps: Please find more details about Load Control execution plans here: Plan Load Control. Al" --- [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 ### Execute Load Control Executing the Load Control means loading the data by following an execution plan. This is done in several steps: - Create an execution log with a step for each load object part of the execution plan - Create a list of dependencies between these load objects - Start one or more execution threads that execute all load objects in the appropriate order Please find more details about Load Control execution plans here: [Plan Load Control](https://knowledge.bigenius-x.com/plan-load-control?hsLang=en). All the details for each target technology can be found here: [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control). It is possible to execute a load with several threads. The default execution generated by biGENIUS-X contains a single thread. ### Example For example, in a **Microsoft SQL Server Generator with a native Load Control**, the executions are stored in the following tables: ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Aug-01-2024-03-15-05-4357-PM.png?width=323&height=179&name=image-png-Aug-01-2024-03-15-05-4357-PM.png) - **Execution**: the execution (load) itself is identified by an ID that will be used in the other tables ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Aug-01-2024-03-18-08-7109-PM.png?width=688&height=34&name=image-png-Aug-01-2024-03-18-08-7109-PM.png) - **Execution\_LoadObject\_Dependency**: the dependencies between the Load Objects added in the execution plan ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Aug-01-2024-03-22-44-2502-PM.png?width=688&height=78&name=image-png-Aug-01-2024-03-22-44-2502-PM.png) - **Execution\_Step**: the steps of the execution according to the execution plan ![](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Aug-01-2024-03-19-01-7804-PM.png?width=688&height=71&name=image-png-Aug-01-2024-03-19-01-7804-PM.png) #### Execute a load The execution is done in the *LoadControl\_Execution\_XXXX.sql* script (executed by the helper *execute.ps1*) by the following code: ``` --The execution plan name must be the same as in the Plan Load Control stepEXEC [LC].[Start_Execution]                    @ExecutionPlan = N'DEV_XXXX'; ``` #### Cancel a running execution An active execution can be canceled by setting the value of the column *IsCanceled* of the table *Execution* to 1. The following procedure does this: ``` EXEC [LC].[Stop_Execution]                        @ExecutionPlan = N'DEV_XXXXX'; ``` This procedure can also be used to terminate a broken execution. This will deactivate the active flag so that a new execution can be started. #### Why cannot an execution be started There can only be one active execution for each execution plan. If another execution is still active, a new execution can not be started. This can have multiple reasons: - the **other execution is still running**: Check the state of the other execution. The process must be terminated before a new execution can be started. The procedure *Stop\_Execution* can cancel the running execution. - the **other execution was not terminated correctly**: Examine the execution log (table *ExecutionStep*). Check for the failures and fix them. #### Resume an execution If an execution step fails, all depending execution steps are disabled. The execution is continued for the other steps. The result of the execution is “finished with errors”. There are execution steps that could not be executed. The following tasks must be fulfilled before the execution can be resumed: - Find the reason for the failure and fix it - Stop the execution if it is still active (with the corresponding procedure). Then the execution can be resumed. The following procedure does this: ``` EXEC [LC].[Resume_Execution]                      @ExecutionPlan = N'DEV_XXXX'; ``` This procedure looks for an execution with steps that were not executed successfully. It creates a new execution log with log steps and dependencies for all steps that were not executed successfully. A new execution thread is started for this execution. It is handled like a “normal” execution. All maintenance and info procedures can be applied.   You can now [monitor your Load Control](https://knowledge.bigenius-x.com/monitor-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) - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse) - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse) - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks) - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake) - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server) - [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 Azuze DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azuze-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