This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice This article is not considered official documentation for K2 software and is provided "as is" with no warranties.

Issue

When attempting to appify a SharePoint list by clicking on the K2 Blackpearl for SharePoint ribbon button, the following error appears: 

Thread 1: Procedure or function ProcessListSharePointSetting has too many arguments specified.HelpLink.ProdName : Microsoft SQL Server HelpLink.ProdVer : 11.00.7462 HelpLink.EvtSrc : MSSQLServer HelpLink.EvtID : 8144 HelpLink.BaseHelpUrl : http://go.microsoft.com/fwlink HelpLink.LinkId : 20476

Symptoms

Unable to appify a SharePoint list. The K2 for SharePoint app has been successfully deployed to the app catalog, but after clicking on the K2 Blackpearl for SharePoint ribbon button, the error appears.

The [Integration].[ProcessSharePointSetting] table is missing the column 'DefaultFormName' type 'nvarchar(200)' NULL.  The stored procedures [Integration].[ProcessSaveSharePointSettings], [Integration].[ProcessListSharePointSetting], and [Integration].[ProcessClearSharePointSettings] are also missing the same column in their respective references to the table.

The symptoms from https://help.k2.com/kbs100189 do not match, meaning the 'SP2013_Version' column value in the [HostServer].[HostServerSetting] table is reading correctly as '4.14120.8.0.'

Resolution

Direct modification of the K2 database is needed in order to have the column added to the table and stored procedures.  Please log a new support ticket that references this KB article for assistance with the needed modifications.

Do not modify any database definition or database content unless specifically instructed to do so by K2. No changes to the K2 Database definition or content are supported unless specifically instructed by K2.