---
title: Configure Load Control
description: Configuring load control registers every loader of your project as a load object with its dependencies, so that execution plans can run them in order.
---

[Skip to content](https://knowledge.bigenius-x.com/configure-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)

# Configure Load Control

**Applies to**  
Platform: Microsoft SQL Server · Oracle

Configuring load control registers every loader of your project as a load object with its dependencies, so that execution plans can run them in order. The generated deployment does it for you; use this workflow to check the configuration after a deployment or to run it again after a model change. Afterwards the load configuration of your project lists the load objects of all active model objects.

This workflow applies to the native load control. For the concepts, read [Understand Load Control](https://knowledge.bigenius-x.com/understand-load-control?hsLang=en).

### Prerequisites

- [LoadControl Options](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en) contains `Native Load Control`, and [Configure LoadControl](https://knowledge.bigenius-x.com/configure-loadcontrol-project?hsLang=en) is `true` (the default).
- Artifacts are generated, the placeholders are replaced, and the load control is deployed, either by this project ([Deploy LoadControl](https://knowledge.bigenius-x.com/deploy-loadcontrol-project?hsLang=en) `true`) or by the project that owns a shared load control.

### What the deployment registers

The generated `deploy.sql` calls `LoadControl\configure_loadcontrol.sql` after the layers and the load-control deployment. It runs one script per layer, for example `LoadControl\L010_Stage_Configuration.sql`. Each layer script does three things:

1. It calls `Build_LoadConfig` with the project name as load configuration, for example `Datavault.Mssql`. The procedure deactivates the layer's load objects and deletes their dependencies.
2. It calls `AddOrUpdate_LoadConfig_LoadObject` once per loader. An existing load object keeps its ID and is activated again.
3. It calls `AddOrUpdate_LoadConfig_LoadObject_Dependency` once per dependency.

Deactivated model objects have no load objects. The view `LoadConfig_LoadObject_Dependencies` lists each load object with the objects it depends on.

### Run the configuration again

1. Generate the artifacts and replace the placeholders.
2. Open a terminal in the folder of the replaced artifacts. The `:r` includes of the scripts are relative to it.
3. Run `sqlcmd -S <server> -E -i LoadControl\configure_loadcontrol.sql`, or deploy the whole project with `deploy.ps1`. `<server>` is your SQL Server instance; the scripts switch to the load-control database of the replacement configuration (`loadcontrol#loadcontrol#database_name`). The configuration scripts print no result rows; check the result as described below.

You can also create load configurations of your own with `AddOrUpdate_LoadConfig`, `AddOrUpdate_LoadConfig_LoadObject` and `AddOrUpdate_LoadConfig_LoadObject_Dependency`, and execution plans as described in [Plan Load Control](https://knowledge.bigenius-x.com/plan-load-control?hsLang=en).

Manually created load configurations and execution plans are deleted when load control is deployed again. Keep their scripts and run them after each deployment with Deploy LoadControl set to `true`.

### Check the result

Count the active load objects per layer:

```
SELECT [lo].[ModelObjectLayer], COUNT(*) AS [LoadObjects]
FROM [LC].[LoadConfig] AS [c]
JOIN [LC].[LoadConfig_LoadObject] AS [lo]
  ON [lo].[FK_LoadConfig_ID] = [c].[ID]
WHERE [c].[LoadConfig] = N'Datavault.Mssql'
  AND [lo].[IsActive] = 1
GROUP BY [lo].[ModelObjectLayer];
```

The query returns one row per layer with the number of load objects. Replace `LC` with your load-control schema and `Datavault.Mssql` with your project name.

### Example

The Data Vault Test Project `Datavault.Mssql` registers 103 load objects in three layers. After a second deployment with Deploy LoadControl `false`, the table still holds 103 load objects with the same IDs, and an execution plan created before the deployment still runs.

### Failure symptoms and recovery

#### A model object has no load object

Cause: the model object is deactivated, so the generator writes no loader for it.  
Fix: activate the model object and generate again. See [Troubleshoot generation, deployment and load failures](https://knowledge.bigenius-x.com/troubleshoot-generation-deployment-and-load-failures?hsLang=en).

#### On Oracle the configuration fails with ORA-01400

Message: `ORA-01400: cannot insert NULL into (...LOADCONFIG_LOADOBJECT."SCHEMA_NAME")`  
Cause: a schema placeholder of a layer is empty in the replacement configuration (Oracle).  
Fix: set all placeholder values, replace the placeholders again and rerun the configuration.

### Platform differences

Oracle uses the same steps with these names:

- Procedures `PR_Build_Loadconfig`, `PR_Add_Or_Update_Loadconfig_Loadobject`, `PR_ADD_Loadconfig_Loadobject_Dependency`.
- Tables `Loadconfig`, `Loadconfig_Loadobject`, `Loadconfig_Loadobject_Dependency`; views `V_Load_Conf_All`, `V_Load_Conf_Dependencies`.
- `deploy.sql` is a SQL\*Plus script; `configure_loadcontrol.sql` connects with the load-control user from the replacement configuration.

### Related articles

- Previous: [Understand Load Control](https://knowledge.bigenius-x.com/understand-load-control?hsLang=en)
- Next: [Plan Load Control](https://knowledge.bigenius-x.com/plan-load-control?hsLang=en)
- Reference: [Configure LoadControl (Project)](https://knowledge.bigenius-x.com/configure-loadcontrol-project?hsLang=en), [Deploy LoadControl (Project)](https://knowledge.bigenius-x.com/deploy-loadcontrol-project?hsLang=en), [LoadControl Options (Project)](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en)
- See also: 
    - 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)

<https://www.linkedin.com/company/bigenius> <https://www.youtube.com/@biGENIUS_DWA>

All rights reserved © 2025, biGENIUS AG