Unable to Add Learner To Learner Group

[dartajax]

There is a learner (Ilios user-id 8850) who is Class of 2017 - School of Pharmacy Student. We needed to add her to Learner Group 6697.

https://curriculum.ucsf.edu/learnergroups/6697

We found two straggler records in that group who did not have primary cohorts but did have user roles in Ilios of 1 and 4. They were added to the secondary cohort Class of 2017.

Here is a snippet that may prove to be helpful.

[2016-01-15 00:27:02] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\UniqueConstraintViolationException: "An exception occurred while executing 'INSERT INTO ilm_session_facet_x_group (ilm_session_facet_id, group_id) VALUES (?, ?)' with params [1988, 6697]:  SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1988-6697' for key 'PRIMARY'" at /web/ilios/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 66 {"exception":"[object] (Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException(code: 0): An exception occurred while executing 'INSERT INTO ilm_session_facet_x_group (ilm_session_facet_id, group_id) VALUES (?, ?)' with params [1988, 6697]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1988-6697' for key 'PRIMARY' at /web/ilios/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:66, Doctrine\\DBAL\\Driver\\PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1988-6697' for key 'PRIMARY' at /web/ilios/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1988-6697' for key 'PRIMARY' at /web/ilios/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"}

We ended up manually adding the user to the group.

[stopfstedt]

i am able to reproduce this. working on it...