Skip to main content

KI-49

Fulfillment Record Creation Breaks After 50,000 Limit With Populated Anonymous Key Field

Key/Summary

KI-49 Fulfillment Record Creation Breaks After 50,000 Limit With Populated Anonymous Key Field

Status

Done

Created

03/18/2021

Updated

03/24/2021

Description

Anonymous keys are not deleted or expired in Medical Information Cloud. When orgs reach more than 50,000 Fulfillments, Fulfillments can no longer be generated until older anonymous keys are deleted or expired.

Impacted Capabilities

None

Affected Apps

Medical Information Cloud - Classic

Medical Information Cloud - Lightning

Affects Versions

None

Fix Version

MIC V10

Steps to Reproduce

  1. Access an org with 50,000 Fulfillments visible to the same user, all with the "Anonymous Key" field populated.

  2. Create a new Fulfillment. You will not be able to create new Fulfillment records as the 50,000 limit has been met and a "Too many query rows" error will be thrown.

Workaround

  1. Mass delete the "Anonymous Key" field value on the oldest Fulfillments to be able to continue generating new Fulfillments.

  2. Create a time-based Workflow or Process Builder to delete the Anonymous Key field after a set amount of time so that fewer than 50,000 Fulfillments have the Anonymous Key field populated at any given time.