+2
I have an issue with SmartObjects that were created on the basis of SQL table. SmartObjects can be created without any problems, but when it comes to methods especially GetList one, it doesn't work (rest of methods work correctly). If you have any ideas, please let me know. Please see the attachment.
+5
Hi megcen,
Normally When SQL server database is on a different server and the SQL service instance is configured for on a different database. The following property “On Different SQL Server “must be set to true. Also, it looks like the authentication mode is set to ‘Statics’. The ‘Use Native SQL Execution’ mode should only be set to true when you are using impersonate.
Also, please verify K2 service account has all the necessary permissions in SQL and you can grant the K2 service account sysadmin role on the SQL box until and after the linked server gets properly created.
In “workspace/SmartObject service tester” update the service instance as follow:
1. Please run the Smartobject Service Tester Tool located at C:Program Files(x86)K2 blackpearlBin on the K2 server or use workspace.
2. Find the service instance of your database under 'SQL Server Service'
3. Right click on it and 'Edit Service Instance'
4. Change the 'Use Native SQL Execution - Required' = false and change 'On Different SQL Server - Required' = true
5. Click 'Next' and then 'Update'
6. Test the execution of the List method again”
Kind Regards,
Julia
+3
Hi,
This is very strange.
Do you already tried to refresh and/or recreate the smartobject? If you don't, try it and check if that solves your issue.
Take a look into your database relationships too. Make sure the primary/foreign keys are properly configured.
Best Regards,
Óscar Gomes
+2
Thanks guys for your help. The problem was because of bad configuration.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.