Skip to main content
All CollectionsCommon Errors
SQL Server Unable to Load Subflow
SQL Server Unable to Load Subflow

SQL Server Unable to Load Subflow error explained.

Praise Magidi avatar
Written by Praise Magidi
Updated over a week ago

Step

Subflow / Control Steps

Message

"Unable to load SubFlow:xxxxxxxxxx",

Cause

This error is caused by an improperly configured SQL Server source step within a Subflow where one of the input parameters does not have a value.

Resolution

In the SQL Server source step configuration, make sure your input parameters have valid values or default values where applicable. If the error persists after adding values for the Input Parameters table, delete them all and then add them again.

Error Detail

json
{
"message": "Unable to load SubFlow:0hBzh5w8zc",
"statusCode": 500,
"error": {
"message": "Invalid Step Config: SQLServer.Source. SQLServer:471906ec-df21-441f-a2ad-85b37671f1a9",
"error": null,
"invalid": [
"message": "should have required property 'value'",
"dataPath": ".inputParameters[0]",
"keyword": "required",
"schemaPath": "#/properties/inputParameters/items/required"
],
"stepType": "Source",
"statusCode": 400,
"stepId": "471906ec-df21-441f-a2ad-85b37671f1a9",
"stepModule": "SQLServer",
"title": null,
"subFlowId": null,
"errorMessage": null
}
}

Did this answer your question?