Skip to main content

Error Executing SQL Command

Error Executing SQL Command explained.

Praise Magidi avatar
Written by Praise Magidi
Updated yesterday

Step

SQL Server Source

Message

The definition of object `PROC_NAME` has changed since it was compiled.

Cause

This SQL Server error occurs when there's a mismatch between a compiled object (like a stored procedure, function, or view) and its current definition in the database.

Resolution

To resolve the error, make sure you refresh the compiled definition of the `PROC_NAME` object so that it matches the current database schema. You might need to seek the help of your database administrator.

Error Detail

{
"message": "Error executing sql command",
"statusCode": 400,
"errorMessage": "The definition of object PROC_NAME has changed since it was compiled.",
"error": {
"message": "The definition of object 'PROC_NAME' has changed since it was compiled.",
"code": "EREQUEST",
"number": 2801,
"state": 1,
"class": 10,
"serverName": "DB-SERVER-01",
"procName":"DB_NAME.PROC_NAME",
"lineNumber": 110
},
"stepType": "Source",
"stepName": "SQLServer",
"stepid": "ef7c000b-73cc-4b44-931b-fdfaa7235913",
"mapStepld":"eedzSZ7ADo",
"mapStepPath": "eedzSZ7ADo",
"mapStepType": "Step",
"module": "SQLServer",
"messageId": "085a8od0b1200ade247f8a2c",
"threadid": 1
}

Did this answer your question?