Symptoms

We have created a SmartBox SmartObject and deployed it from testing to UAT environment. Now there is an error when trying to executing any of the SmartObject’s methods.

Invalid column name ‘column_name_id’
Service: SmartBoxService
Service Guid: e54xxx.xxx.xxxx.
Severity: Error

 

Diagnoses

N/A
 

Resolution

The SQL table (no data in table present) associated to the SmartObject had PK key set to ‘ID’ name, but SmartObject was using specific ID name. Since the UAT environment was recently setup and there has not been any testing, we dropped the SQL table from target environment and removed previous solution deployed via PandD tool. After that, we re-deployed the PandD package again and was able to resolve the issue.