Skip to main content

 

 

Turns out refreshing the service instance in the tester show:

 

SmartObject Server Exception: Timeout expired. The timeout period elapsed prior to completion of the operation of the server is not responding.

 

Source: SourceCode.SmartOjbects.Management

 

 


15216i1EDCADC4BABA3914.jpg

Is this a SQL Server service instance?  If so, the following may be applicable:


http://community.k2.com/t5/K2-blackpearl/SQL-Server-Service-Instance-Timeouts/ta-p/88096


Hi,


 


Is this the first time registering this particular SQL service instance? Does it work with with a different database on the the same SQL box? The following post might help. http://community.k2.com/t5/K2-blackpearl/Timeout-when-refreshing-workflow-reporting-service-instance/m-p/97408#M31707


 


Another thing is, how big is the database?  If you only need to access certain objects (i.e. table, stored procedure) in the table, you might want to to limit the permissions of the account  to only those objects. That way, K2 won't go in and check every object in the database, see sample steps below.
-In Object Explorer of SQL Management studio, expand the Databases, expand your Database, expand Tables, right-click your table, and then click Properties.
-On the Permissions page, under Users or Roles, click Search.
-On Select Users or Roles page, click Browse, find and select the user, then click OK until you are back to the Permissions page.
-In the Permission for <user>section, find the permission and click Grant or Deny box as your requirement, then click OK. For example, if you want to give the user Read-Only access to the table, just find the SELECT (that's the read permission) and click the Grant box. Then click OK.


 


 


Reply