--- title: Plan Load Control description: An execution plan selects the load objects that one execution runs. --- [Skip to content](https://knowledge.bigenius-x.com/plan-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) # Plan Load Control **Applies to** Platform: Microsoft SQL Server · Oracle An execution plan selects the load objects that one execution runs. The generated plan `DEV_` runs every load object of your project; build your own plans to load a single model object, one layer or one dataflow. Afterwards the plan exists in `ExecutionPlan` and can be started with [Execute Load Control](https://knowledge.bigenius-x.com/execute-load-control?hsLang=en). ### Prerequisites - The load control is deployed and configured: [Configure Load Control](https://knowledge.bigenius-x.com/configure-load-control?hsLang=en). - You can run SQL against the load-control database. The examples use the default schema `LC`, the project `Datavault.Mssql` and the plan name `DEV_Load_PIT`; replace them with your values. ### The generated plan `LoadControl\LoadControl_Execution_.sql`, called by `execute.sql` and `execute.ps1`, contains: ``` EXEC [LC].[Build_ExecutionPlan] @ExecutionPlan = N'DEV_Datavault.Mssql'; EXEC [LC].[Build_ExecutionPlan_AddLoadObjects] @ExecutionPlan = N'DEV_Datavault.Mssql', @LoadConfig = N'Datavault.Mssql'; EXEC [LC].[Start_Execution] @ExecutionPlan = N'DEV_Datavault.Mssql'; ``` When you generate a single view of the project instead of the whole project, the plan is named `DEV__partial_` and contains the model objects of that view. ### Build an execution plan 1. Create an empty plan: `EXEC [LC].[Build_ExecutionPlan] @ExecutionPlan = N'DEV_Load_PIT';` 2. Add load objects with `Build_ExecutionPlan_AddLoadObjects`. Each parameter you pass filters the active load objects; parameters you leave out select all values. 3. Remove load objects with `Build_ExecutionPlan_RemoveLoadObjects`, which takes the same filters except `@ErrorBehavior` and `@ExecutionPriority`. 4. Check the plan in the view `ExecutionPlan_All`. Parameters of `Build_ExecutionPlan_AddLoadObjects`: - `@ExecutionPlan`: the plan name (required). - `@LoadConfig`: the load configuration, which is the project name. Without it, load objects of all configurations in the load control are added. - `@ModelObject`, `@ModelObjectType`, `@ModelObjectLayer`, `@ModelObjectPart`, `@ModelObjectDataflow`: filters on the columns of the same name in `LoadConfig_LoadObject`, for example `Satellite` (type), `Raw Vault` (layer), `Satellite Loader` (part) and `Dataflow1` (dataflow). - `@ErrorBehavior`: `ContinueOnError` (default) disables the steps that depend on a failed step and runs all others; `AbortOnError` cancels the execution at the first failed step. - `@ExecutionPriority`: overrides the priority stored with the load object. The procedure adds only the load objects that match. It does not add the objects they depend on, so add those as well. ### Example To load the PIT `customer_based_on_hub` with the objects it depends on, run the query [LoadOnlyOneModelObject\_TSQL.sql](https://f926da42ec3845beb4acf72f.blob.core.windows.net/hubspotknowledgebase/LoadOnlyOneModelObject_TSQL.sql) with `@LoadObjectName = 'customer_based_on_hub'`. The query reads the schema `LC`; change it when your schema differs. It returns: ``` ModelObjectLayer ModelObjectPart ModelObject Stage Stage Loader CUSTOMER Raw Vault PIT Loader customer_based_on_hub Raw Vault Satellite Hashing Loader load_caching_hashing Raw Vault Satellite Loader load_caching_hashing Raw Vault Satellite Loader load_customer_sat ``` Build the plan from these four model objects: ``` EXEC [LC].[Build_ExecutionPlan] @ExecutionPlan = N'DEV_Load_PIT'; EXEC [LC].[Build_ExecutionPlan_AddLoadObjects] @ExecutionPlan = N'DEV_Load_PIT', @LoadConfig = N'Datavault.Mssql', @ModelObject = N'CUSTOMER', @ModelObjectLayer = N'Stage'; EXEC [LC].[Build_ExecutionPlan_AddLoadObjects] @ExecutionPlan = N'DEV_Load_PIT', @LoadConfig = N'Datavault.Mssql', @ModelObject = N'load_caching_hashing'; EXEC [LC].[Build_ExecutionPlan_AddLoadObjects] @ExecutionPlan = N'DEV_Load_PIT', @LoadConfig = N'Datavault.Mssql', @ModelObject = N'load_customer_sat'; EXEC [LC].[Build_ExecutionPlan_AddLoadObjects] @ExecutionPlan = N'DEV_Load_PIT', @LoadConfig = N'Datavault.Mssql', @ModelObject = N'customer_based_on_hub'; ``` ### Check the result `SELECT * FROM [LC].[ExecutionPlan_All] WHERE [ExecutionPlan] = N'DEV_Load_PIT';` returns five load objects, one per row of the query above, and an execution of the plan has five steps. ### Failure symptoms and recovery #### The plan is not found Message: `Build_ExecutionPlan_AddLoadObjects: Execution plan [] not found.` Cause: the plan does not exist, for example because a deployment with Deploy LoadControl `true` recreated the load-control tables. Fix: run `Build_ExecutionPlan` first, then add the load objects again. #### A dependent step fails because a source table is empty or missing Cause: the plan contains a load object without the load objects it depends on. Fix: add the missing objects; the query above lists them. ### Platform differences Oracle offers the same steps as PL/SQL procedures with named parameters: - `PR_Build_Execution_Plan(v_Execution_Plan => ...)`. - `PR_Build_Execution_Plan_Add_Loadobjects` and `PR_Build_Execution_Plan_Remove_Loadobjects` with `v_Execution_Plan`, `v_Load_Config`, `v_Model_Object`, `v_Model_Object_Part`, `v_Model_Object_Dataflow`, `v_Model_Object_Layer`, `v_Model_Object_Type`; the add procedure also takes `v_Error_Behaviour` (default `ContinueOnError`). - Tables `Execution_Plan` and `Execution_Plan_Load_Object`; `PR_Remove_Execution_Plan` removes a plan. ### Related articles - Previous: [Configure Load Control](https://knowledge.bigenius-x.com/configure-load-control?hsLang=en) - Next: [Execute Load Control](https://knowledge.bigenius-x.com/execute-load-control?hsLang=en) - See also: [Understand Load Control](https://knowledge.bigenius-x.com/understand-load-control?hsLang=en), [Understand Dataflow, Dataflow Set and Dataflow Set Model Object](https://knowledge.bigenius-x.com/understand-dataflow-dataflow-set-and-dataflow-set-model-object?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