Symptoms

Stored Procedure Smart Object Creation Difference between Servers
 

Diagnoses

When stored procedures are created as smart objects in development and UAT environment, the parameters are usually categorized as properties.
However, when deployed to production, the parameters are categorized as parameters. Thus, the object can't be used and needs to be recreated.
 

Resolution

This behavior is to be expected as the service instance for the production environment is configured to use parameters for stored procedures while the other environments were set to False. Please switch it to false and refresh the service instance.