KB214536: Nightly MicroStrategy license compliance check invalidates subscriptions and removes contacts from the metadata without removing the corresponding addresses in MicroStrategy Intelligence Server 9.x.

SUMMARY

This technical note outlines an issue found with the nightly Strategy license compliance check where it invalidates subscriptions and removes contacts in the metadata but leaves the contact's addresses.
 

SYMPTOMS

In some scenarios, end users will notice undesirable behavior when duplicating a project on one day and then duplicating another project the following day. This can include errors with further project duplications related to violation of primary key constraints, missing subscriptions and contacts for users and user errors in the project duplication log file.
At midnight, Strategy Intelligence Server runs a compliance check to make sure the enabled users are not consuming more licenses than allowed.
During this process, users may notice that certain contact objects disappear from the metadata after a duplication and the nightly compliance check.
In order for the issue to reproduce, a project must be carried over with project-related users, and two user objects must exist across the source and destination environments for the duplication with different object IDs but the same Trusted Authentication ID or login. Both trusted authentication ID and user login must be unique in an environment as that is the only user facing unique identification for users.
 
STEPS TO REPRODUCE

1. Create a metadata (metadata1) with user A (login A and trusted authentication ID test) 
2. Create a contact, address and subscription for this user in a project in metadata 1 
3. Create a metadata (metadata2) with user B (login B and trusted authentication ID test) 
4. Create a contact, address and subscription for this user in a project in metadata 2 
5. Perform project duplication of the project from metadata 1 to metadata 2 with the option unchecked to merge users by login 
6. Wait until midnight has passed after the duplication to and then do the duplication again causing the error to appear.

CAUSE

This is a known issue in Strategy Intelligence Server 9.x. Subscriptions are invalidated and contacts are removed, however the addresses tied to those contacts remain in the metadata. This can cause issues in subsequent project duplications.
 

ACTION

Contact Strategy Technical Support for updates on this issue.
The Strategy internal reference number for the issue described in this technical note is 982125.