Troubleshooting: A constraint exception is thrown when executing ianalyze

Issue

When executing ianalyze, the following constraint exception is thrown:

Unhandled Exception: System.Data.ConstraintException: 
Column 'TUID' is constrained to be unique. Value '19BB49A30C-4D889090-122' is already present.

Details

This exception occurs because ianalyze processes not only the client_performance.log file, but it also looks for other log files that could be stored in the log directory with the following pattern:

*performance*.log

Therefore, if you copied the client_performance.log into the log folder, and left the name the same, ianalyze picks it up and tries to process it. As the TUIDs exist on both files, an exception occurs.

Solution

Copy the client_performance.log file into a different folder. Or after copying the client_performance.log file into the log folder, rename it so that it does not match the pattern above.