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?

Image

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.