SmartObject List method returns Invalid Object Name error
kbt142890
PRODUCTIssue
When executing the List method against an Azure SQL database, the following error appears:
Symptoms
All methods execute successfully, except for the List method.Troubleshooting Steps
To resolve the issue, please complete the following steps:
1. On the SmartObject service tester tool, find the service instance of your database under 'SQL Server Service'
2. Right-click on it and 'Edit Service Instance'
3. Change the 'Use Native SQL Execution - Required' = false
4. Click 'Next' and then 'Update'
5. Test the execution of the List method again.