Symptoms

Have a SmartObject that is associated with the Document Sets in a document library in SharePoint. I am populating a list box control on a SmartForm with the 'Name' value from the list of Document Sets. Upon testing I realized that the list box was only returning 50 of 170+ document set names in the list box. I get the same result in the SmartObject Tester.
Is there a default limit on the list box? Or why am I only able to return 50 items?

 

Diagnoses

Need to update the SharePoint Service Instance Throttling to be more than 50+. Since it is a SP 2013 service instance, the change needs to be done thru the Workspace - Service Instance section.
Here is a link on How to update the Service Instance: http://help.k2.com/onlinehelp/k2forsharepoint/userguide/1.0.1/default.htm#build_integrate/the_sharepoint_2013_service_brokers/sharepoint_2013_broker.htm

Received error when updating the throttling using service instance, error "Cannot contact site at the specified URL https://spapp-1378e01b9cb96e.spapp.prod.asurion.net/sites/teams/ALPM/AustraliaProgramme/careteam/Test 12. The system cannot find the file specified. (Exception from HRESULT: 0x80070002)"
 

Resolution

Use sql script to update the throttling property.
UPDATE TK2].2SmartBroker].rServiceInstance]
SET ServiceInstanceXML = '... 80 ...' where ID = serviceinstanceID

We do not have a limit, but since that is a lot of documents MS doesn't recommends that due the load. We are guided on MS specifications so if you set it to more than 50 we should be able to handle them. You should be careful since that could be a lot of load for SharePoint.