Symptoms
K2 workflow continues to throw (404) Not Found error
Diagnoses
Executing list method of Smartobject from Sharepoint List results in 404 error
"2015-08-13 09:18:20","Error","SmartObjects","10702","Error","SourceCode.SmartObjects.ServiceBroker rExecuteSmartObject]","10702 An error occurred in the portal_denallix_com_portal Service Instance. The remote server returned an error: (404) Not Found.","anonymous","0.0.0.0","K2Server:C:Program Files (x86)K2 blackpearlHost ServerBin","50009038","abfce0990ead49ea8a338711bc4ade47",""
"50079070","2015-08-13 15:29:20","Error","General","0","ErrorMessage","ActivityName","0 Service: portal_denallix_com_portal
Service Guid: 151b7aae-bd28-4499-a490-a222665566aa
Severity: Error
Error Message: The remote server returned an error: (404) Not Found.
InnerException Message:
","anonymous","0.0.0.0","DESPK201:C:Program Files (x86)K2 blackpearlHost ServerBin","50079070","c3138bdb96dc48ba90faf9613a796e03",""
"50079074","2015-08-13 09:18:20","Error","General","28083","ExtenderExecuteError","ProcessInstance.HandleException","28083 ServerEvent: Service: portal_denallix_com_portal
Service Guid: 151b7aae-bd28-4499-a490-a222665566aa
Severity: Error
Error Message: The remote server returned an error: (404) Not Found.
InnerException Message:
InnerException: Exception has been thrown by the target of an invocation.
InnerException: Service: portal_denallix_com_portal
Service Guid: 151b7aae-bd28-4499-a490-a222665566aa
Severity: Error
Error Message: The remote server returned an error: (404) Not Found.
InnerException Message:
","","","K2Server:C:Program Files (x86)K2 blackpearlHost ServerBin","50009046","9f90194d1670469b850f8cdd77e58ffa",""
Resolution
This behavior was reproducible with the list template in question. The Create method will execute successfully but List and Read method will error with HTTP 404 error. After removing some of the People columns and regenerating the smartobject, the List and Read methods are now executing successfully. I believe that you are also hitting the Sharepoint Lookup Limit (either 8 or 12 depending on CU). Please see the documentation below:
http://blogs.msdn.com/b/spses/archive/2013/12/02/sharepoint-2010-2013-list-view-lookup-threshold-uncovered.aspx
I believe lookup columns are also not limited to People columns and can include:
"Standard lookup columns, single-value managed metadata, multiple-value managed metadata, single-value people and group columns, and multiple-value people and group columns , Workflow Status , Created by , Modified by ( people ) are obviously counted as lookup columns."
