Who is this article for?

All Ideagen Quality Management Admins with training permissions.

Ideagen Quality Management site (and possibly SQL DB) accessis needed.

Customers may encounter issues where they are unable to turn off expiration on a training definition in the Ideagen Quality Management site. 

To make troubleshooting this issue easier to learn, this article is split into three sections so that you can either walk through the steps in sequence or you can jump to the section relevant to what you are finding:

1. Issue Experienced
2. Resolution
3. Further Reading

1. Issue Experienced

This section will explain what occurs when the customer is experiencing the issue.

The customer will have noticed they can't turn off or edit expiration settings for training definitions. This could potentially occur if expiration settings were changed to "Yes" with a but a date wasn't added before changes were saved. This only happens when navigating away from the training definition immediately after saving changes. 

2. Resolution 

This section will provide the resolution for editing the expiration through the SQL database. 

1. Run a report in the Ideagen Quality Management site to see if there were any instances from the definition that have already been completed. 
2. If there are no instances completed, cancel the assigned trainings, and delete the definition. It can then be recreated with proper expiration settings. 
3. If there are completed instances, run the following query on the Ideagen Quality Management SQL database to edit the expiration setting.

   Update TR_Trainings 
   Set ExpirationMethod = 0 
   Where Id = "AddTrainingDefIdHere"

3. Further Reading

This section will provide important links to further troubleshooting and resources.