Workflows and Automation

K2 5.7 Upgrade Error: Blocking Issue with Orphaned Service Instances Error Message:             07:30:39:>> AuthorizationBase.RegisterServiceInstanceObjects: Current ServiceType and ServiceInstance details: ServiceType.Guid = GUIDValue1. ServiceInstance.Guid = GUIDValue2 . ServiceInstance.Name = ServiceInstanceName             07:30:39:>> ConnectionHelper.GetServerInstance: Create 'AuthorizationClient' instance using ConnectionContext             07:30:39:>> AuthorizationBase.RegisterObject: Validate Parent             07:30:39:>> AuthorizationBase.Execute: Logged Error: Failed: System.Exception: Item 'GUIDValue1' does not exist    at SourceCode.Install.Package.Actions.Authorization.AuthorizationBase.RegisterObject(String name, Guid id, Guid parentID, Guid classID, String className, Boolean inherit, Boolean propagate, IIdentityReferenc...

 When exporting and importing NAC workflow between tenants, connections will get mapped automatically when they share the same name. As such it would be best practice to name your connections more generically. For example, if you name your connection 'Salesforce Dev' in your Development NAC tenant, but want the connections to get mapped automatically when importing to your Production NAC tenant, you would also have to name your Salesforce connection 'Salesforce Dev' in Production. Instead, if it was named more generically 'Salesforce Connection' in Development, then in Production it can also share this same generic 'Salesforce Connection' name.

 When upgrading to K2 5.6, you may run into an Encryption Validation error that stops the upgrade and puts it in a 'Recover' stage: Error in the installer trace log indicates: However, after the K2 database was migrated, the following script was already completed to drop and re-add encryption: OPEN MASTER KEY DECRYPTION BY PASSWORD = 'passwordhere';  ALTER MASTER KEY DROP ENCRYPTION BY SERVICE MASTER KEY;  ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY;  CLOSE MASTER KEY; And the following does show that data is property decrypted: OPEN SYMMETRIC KEY SCSSOKey  DECRYPTION BY CERTIFICATE SCHostServerCert;  SELECT [VariableToken],        CONVERT(nvarchar(max), DECRYPTBYKEY([VariableValue])) as 'Decrypted Value',     [VariableValue]     FROM [HostServer].[Configuration] WHERE [Encrypted]=1 The issue was due to the [K2HOSTCONNECTIONSTRING_SYSTEM] row in the HostServer.Configuration table not being encrypted, but the...

K2 Server Migration: SmartActions Not Functioning - Resolved! Problem: After migrating a K2 server, SmartActions stopped processing emails despite receiving replies in the designated mailbox. Cause: The previous K2 server was still "running" in the new database, conflicting with the new server's SmartActions functionality. Troubleshooting: Verbose HostServer logs revealed missing "Allocated" message for the SmartActions server, indicating the server wasn't designated for the task. Investigation discovered the previous K2 server (K2server1) persisted in the migrated database ("copy of K2database1") despite running in parallel with a different SmartActions account. Resolution: Executed  server.kClusterDown  on the "copy of K2database1" to shut down K2server1 within the database. Manually removed references to K2server1 from relevant tables in the "copy of K2database1" database: Server.Server HostServer.Server HostServer.LicenseKey...