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.
The following error occurs when attempting to deploy a Package using the K2 Cloud Package and Deployment Tool:
“The package is missing at least one SharePoint related item required to successfully deploy. This is most likely the result of having manually removed either the list or library SmartObject, service object or workflow”
If you click on "OK" the P&D tool closes.
This is caused by the SmartObject name in the [Integration].[ProcessSharePointSetting] table not having a corresponding entry in the [SmartBroker].[SmartObject] table.
To confirm, run the following SQL statement. Please remember to fill in the variables for 'LIST_NAME" and 'SYSTEM_NAME_FROM_PREVIOUS_QUERY':
SELECT * FROM [Integration].[ProcessSharePointSetting]
WHERE [SmartObjectName] like '%LIST_NAME%'
SELECT * FROM [SmartBroker].[SmartObject]
WHERE [SystemName] = 'SYSTEM_NAME_FROM_PREVIOUS_QUERY'
If the second query does not return any results, it might be due to SharePoint site name changes, and proper SmartObject clean up steps not being followed.
When searching in the [SmartBroker].[SmartObject] table, you might find duplicate entries as follows:
If this is the case where the ProcessSharePointSetting table is pointing to the incorrect SmartObject, please log a Support Ticket for support to investigate.