An error is encountered when trying to activate Odata API
kbt163298
PRODUCTK2 Five 5.2
BASED ONK2 Five 5.2
TAGSK2 API
K2 Services
OData API
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
You receive an error when attempting to activate Odata API.Symptoms
The following error is displayed:
Could not refresh services, try again?
Troubleshooting Steps
Execute the following SQL select statement against your K2 database to check for duplicate SmartObjects:
SELECT [SmartObjectGUID] ,[Version] ,COUNT(*) AS [DuplicatesCount]
FROM [SmartBroker].[SmartObject]
GROUP BY [SmartObjectGUID] ,[Version]
HAVING COUNT(*) > 1
If there are duplicates, please log a support ticket.
