SyncEngine.RunHistory table has too many records

Managing SyncEngine.RunHistory Table Size for Identity Service

Key Point:

  • The SyncEngine.RunHistory table can significantly grow without automated cleanup, potentially impacting performance.

Recommended Actions:

  1. Regularly Delete Old Data:

    • Use this query to retain only 30 days of logs:
      SQL
      DELETE FROM [SyncEngine].[RunHistory]
WHERE [SyncEnd] < GETUTCDATE() - 30
    • Automate with SQL Job: Create a scheduled job to execute this query regularly.

  2. Consider Performance and Disk Space:

    • Stop K2 Service: Temporarily pause K2 services during cleanup to minimize impact.
    • Ensure Adequate Disk Space: Verify sufficient space on the SQL server for transaction logs, especially for large deletions.

Additional Tips:

  • Customize Retention Period: Adjust the '-30' value in the query to match your desired log retention period.
  • Monitor Table Size: Regularly check the table size to ensure it's within acceptable limits.
  • Explore Alternative Cleanup Methods: If manual or scheduled cleanups become unwieldy, investigate options for automating the process within the K2 environment itself.

By following these guidelines, you can effectively manage the SyncEngine.RunHistory table size and maintain optimal performance of your Identity service.

Comments

Post a Comment

Popular posts from this blog

Blocking Error during K2 5.6 Server migration

  Error Encountered: Error during K2 5.6 migration to a new machine, keeping the SQL server unchanged. Error message:                       20:49:59:>> Certificates.FindCertificate: Found 1 certificates                       20:49:59:>> RegisterShard.Execute: Adding additonal connection string parameters to config service shard                       20:49:59:>> AdditionalConnectionStringParameters.AmendSQLConnectionString: Additional connection string parameter value: empty                       20:49:59:>> AdditionalConnectionStringParameters.AmendSQLConnectionString: Additional ConnectionString Parameters is empty                       20:50:04:>> AnalyzableAction.PopulateValidate...
Read more

Client Credentials flow with K2 Cloud with Odata, Workflow REST or SCIM

Image
This guide outlines the steps to using the Client Credentials Flow for accessing Nintex K2 Cloud's OData, Workflow REST, or SCIM APIs. Before you begin: Ensure your environment is eligible for Client Credentials Flow by contacting Nintex support ( https://customer.nintex.com/cases/Pages/default.aspx ). Have a SHA256 hash of the client secret of your choosing ready. Steps: Onboarding: Open a support ticket with Nintex requesting the onboarding of the Client Credentials Flow for your environment. Provide the SHA256 hash of your the client secret. https://help.nintex.com/en-US/k2cloud/userguide/current/Content/IdProviders/ClientCredentials.htm You can Generate the secret hash from a Client Secret value in a .NET console application. The onboarding team does not need the actual secret value, only the hash of it. Use the following steps and code example to generate the hash: Add the  IdentityModel  NuGet package. Add the  IdentityModel  library reference in the ...
Read more

Blocking error RegisterServiceInstanceObjects when upgrading to K2 5.6/5.7

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...
Read more