Package and Deployment - Deploy package fails with 'The package is missing at least one SharePoint related item required to successfully deploy'
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 [Name] = '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.
The issue could appears too if you don't have all columns of the origin environnement in the destination environnement.
Example of column name that could appear/disappear according the SharePoint version:
ExtractedText KeyPoints Tags KeyPoints_MediaServiceKeyPoints_ Tags_MediaServiceAutoTags0 MediaServiceAutoTags MediaServiceKeyPoints MediaServiceOCR