--- title: Monitor Load Control description: Monitoring load control shows the status, result, row counts and errors of each step of an execution. --- [Skip to content](https://knowledge.bigenius-x.com/monitor-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) # Monitor Load Control **Applies to** Platform: Microsoft SQL Server · Oracle Monitoring load control shows the status, result, row counts and errors of each step of an execution. Use it while a load runs and afterwards to find failed steps. The procedures and views below read the execution tables of the native load control. ### Prerequisites - At least one execution has run: [Execute Load Control](https://knowledge.bigenius-x.com/execute-load-control?hsLang=en). ### Check the current or last execution 1. Run `EXEC [LC].[Show_Execution] @ExecutionPlan = N'DEV_Datavault.Mssql';`. It lists the steps of the active execution of the plan, or of the last one when none is active. Pass `@Execution_ID` to show another execution. 2. Read `ExecutionStatus` per step: `Waiting` (not started), `Running` or `Finished`. 3. Read `ExecutionResult` per finished step: `Success`, `Failure`, `Failure with abort` or `Disabled`. `ErrorDescription` holds the error or the reason for the disabled step. Each row also shows the row counts `RowCountInserted`, `RowCountUpdated`, `RowCountDeleted`, `RowCountWarning`, `RowCountError`, the loader message, the steps it depends on, start, end and duration, and the session in `ExecutionProcessSPID`. ### Follow a running execution Run `EXEC [LC].[Show_ExecutionMonitor] @ExecutionPlan = N'DEV_Datavault.Mssql';` while the load runs. It returns one row per layer and part, for example `Raw Vault` and `Satellite Loader`, with the number of steps that are waiting, running, finished, successful, failed and disabled. Like `Show_Execution`, it shows the active execution or the last one, and accepts `@Execution_ID`. Run it again to see the counts move from `Waiting` to `Finished`. ### Check all executions - `Execution_All`: one row per step of every execution, with the same columns as `Show_Execution`. - `ExecutionMonitor_All`: per execution, layer and part, the number of steps waiting, running, finished, successful, failed and disabled, with durations. - `ExecutionPlan_All`: the load objects of each plan. ### Example List the failed and disabled steps of the last execution: ``` SELECT [LoadObject], [ExecutionResult], [ErrorDescription] FROM [LC].[Execution_Step] WHERE [FK_Execution_ID] = (SELECT MAX([ID]) FROM [LC].[Execution]) AND [ExecutionResult] <> N'Success'; ``` For the failed load in [Execute Load Control](https://knowledge.bigenius-x.com/execute-load-control?hsLang=en) the query returns 34 rows, for example: ``` LoadObject: STG_ST_CUSTOMER_Loader ExecutionResult: Failure ErrorDescription: ... Cannot find the object "STG_ST_CUSTOMER" LoadObject: RDV_HUB_load_customer_hub_Loader ExecutionResult: Disabled ErrorDescription: Disabled due to error of method st.STG_ST_CUSTOMER_Loader ``` ### Check the result An execution without errors has `ExecutionResult` `Success` in `Execution`, and all its steps have `Finished` and `Success`. ### Failure symptoms and recovery #### Steps stay Waiting and the execution is not active Cause: the execution was stopped, or it was aborted by a step with `AbortOnError`. Its result is `Aborted`. Fix: resume it as described in [Execute Load Control](https://knowledge.bigenius-x.com/execute-load-control?hsLang=en). ### Platform differences On Oracle, query the view `V_LastLoad` for the steps of the last executions, or the tables `Execution` and `Execution_Step` directly. Column names use underscores, for example `Execution_Result` and `Load_Object`. ### Related articles - Previous: [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), [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) - [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) - [Oracle](https://knowledge.bigenius-x.com/generators?hsLang=en#oracle) - [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