Symptoms

Customer is getting the following error when executing SQL Stored Procedure SmartObjects that were packaged from Test environment and deployed to QA environment.
“Inconsistent SmartObject. Mapped ServiceObject Property does not exist….”
 

Diagnoses

In 4.6.5, we introduced the option to enable “Use parameters for stored procedure” when configuring Service Instance.
-http://help.k2.com/KB001550_

Please look at the K2 4.6.5 New Features List.pdf on the upper right of the above release note.

If you edit service instance in Test, I believe the setting for this might be set to false or NULL. You can try to set it true and see if it has any negative impact in Test, or if you want to keep the same setting in QA to match Test, you can do so as well.
Please see link below for service instance reference:
http://help.k2.com/onlinehelp/k2blackpearl/UserGuide/4.6.6/SIC02.html
 

Resolution

Customer changed the “Use parameters for stored procedure” option for the service instance in Test to true, and was able to get the SmartObjects in both environments consistent.