Topic
When trying to create a Data Access Policy for a SmartObject in K2 Management, after clicking the 'Create Policy' button, the button briefly disappears and then returns without creating the access policy. Looking in the Host Server logs, the following errors can be seen:
"Error","System","2025","InternalMarshalError","SourceCode.Hosting.Server.Runtime.HostServerBroker.InternalMarshal","2025 Error Marshalling SourceCode.SmartObjects.Runtime.SmartObjectManagementServer.SB_CreatePolicy, Error executing compiled SQL from Policy Compiler GenerateCreatePolicy method."
"Error","Communication","8130","ConnectionPacketError","SourceCode.SocketService.Legacy::HandlePacket","8130 Error processing message from local: Error executing compiled SQL from Policy Compiler GenerateCreatePolicy method."
"Error","SmartObjects","10702","Error","SourceCode.SmartObjects.ServiceBroker [ExecuteSmartObject]","10702 An error occurred in the K2_Management Service Instance. System.Exception: Error executing compiled SQL from Policy Compiler GenerateCreatePolicy method. ---> System.Data.SqlClient.SqlException: Invalid object name 'Smartbox.GlobalAccessCheck'."
Instructions
The issue is caused by the Smartbox.GlobalAccessCheck table valued function missing from the K2 database. In order to resolve the issue, log a support case and provide the results of the below query so that Support can provide the needed script to create the missing function.
SELECT [UpdateName], [VersionOfK2Patched], [DateImplemented] FROM [HostServer].[UpdateHistory]