Symptoms

Cannot Execute Smart Object
 

Diagnoses

When we create Smart Object from SQL table and choose "Execute SmartObject", there is only "List" option in the "Method to Ececute" drop-down. So it's missing Create, Read, Update, and Delete options. When we click Execute, we are getting error "Invalid Object Name".
We recently upgraded to 4.6.9
 

Resolution

The 'Invalid Object Name' issue was resolved by flipping the 'Use Native SQL Execution' to 'false'. The URL pasted below explains the process further.

https://help.k2.com/onlinehelp/k2blackpearl/userguide/4.6.9/webframe.html_sic02.html

The issue in regards to the 'List' method being the only available method is due to the fact that their DB lacks primary keys. This is by design in regards to the out of the box software solution that is deployed. Due to the backend of the software package being used lacking primary keys stored procs are being developed for data retrieval as well as simple table updates, and web services will be used for more complex updates.