Dynamics Community Forum Thread Details

msdyn_AIConfiguration Size

Hi folks

I am seeing a huge file utilization in our environment related to msdyn_AIConfiguration (10441 MB). There is no information about this entity anywhere or how to reduce its size.

Any one facing this issue or know how to clean it up?

Hi Mouda,

1.Cause:

The msdyn_AIConfiguration table is designed for keeping records of backend job (different features).

Each job running will generate a record. The storage issue causes by case topic extraction feature, which runs everyday, and generates an intermediate file for the next day's job running.

The intermediate file generated every day use all the storage.

2.File storage--msdyn_AIConfiguration

Customer Service Insights uses AI to give you insights into your customer service data by grouping semantically related cases and generating a topic. New cases that match the generated topic will be automatically added to the topic group. This can help you identify areas for improvement that can have the greatest impact on system performance.

The AI-driven technology empowers informed decision-making about how to improve resolution rates, reduce wait times, and decrease customer service costs. You can use case resolution insights, backlog trends, and historical comparisons to evaluate agent performance and business impact, and address inefficiencies in your system.

https://docs.microsoft.com/en-us/dynamics365/customer-service/configure-topics-clustering-cases-cs

https://docs.microsoft.com/en-us/dynamics365/customer-service/ai-topic-clustering-conversations

3.Steps to clean it up:

If they do not want to grow the table size, then they can perform the recurring bulk deletion job which will erase the table size for every 30 days.

We have provided the below steps to perform the bulk deletion job for the environment by putting the below condition.

(1)- Go to Settings > System Job.

(2)- Click on More Actions, then select Bulk Delete:

(3)- Then you will get default criteria for deleting System Job records, then you can select the below criteria:
Selected query for System Job
Look For: AI Configurations
AIModel – Equals - CaseTopicExtraction
Created On – Older Than X Days – 7

(4)- Click on the Next button, and you will get the below screen for setting the scheduled bulk deleting

(5)- Set the Scheduling information as you want then click Next, Then Submit.

4.Others

Also as requested we provided an information that why this table increased suddenly because we are using a new platform to run all the AI related jobs (like topic extraction pipeline). The new platform change is since the middle of last year. Specifically, the topic pipeline started to onboard on the new platform from last Nov. That is the reason customers only see the changes in recent months.

Quick Links