3 Replies Latest reply on Feb 14, 2018 1:11 AM by EMRAH OZBEKAR

    AR Error(382) The value(s) for this entry violate a unique index that has been defined for this form

    EMRAH OZBEKAR

      Hi all,

      Somebody has removed (by mistake) a user's login id from CTM:People while changing the user to non-support staff. Now I'm trying to update Login ID on CTM:People but it gives me the error below:

      AR Error(382) The value(s) for this entry violate a unique index that has been defined for this form

      The user does not exist in User and CTM:People Permission Groups form. I've checked the user_cache table, an entry with same login id was available there. Then I've deleted this entry as well. I've also checked H15 table, there is no orphan entry there. If I go to User form and create a user with this login id, I get the same error.

      Please see the attached api+filter+sql log. In the log file, you will see the error below which occurs when creating entry in User form.

      > /* Tue Feb 13 2018 12:05:11.3040 */ <Filter Level:0 Number Of Filters:158> Checking "CTM:PPL:ChgSubUserInfo_502_PUSR" (502)

      >         0 : Push Fields -> "User"

      >               <deferred from filter CTM:PPL:ChgSubUserInfo_502_PUSR>

      ...

      >               Full Text License Type (110) = 0

      >               License Type (109) = 0

      >               Email Address (103) = mark.miller@mycompany.com

      >               Login Name (101) = mark.miller

      >               Full Name (8) = Mark MILLER

      >               Status (7) = 0

      ...

      > /* Tue Feb 13 2018 12:05:11.3060 */ **** Error while performing filter action. Error Number: 382

      > /* Tue Feb 13 2018 12:05:11.3060 */ ERROR (382): The value(s) for this entry violate a unique index that has been defined for this form

      > /* Tue Feb 13 2018 12:05:11.3060 */ **** Filter "CTM:PPL:ChgSubUserInfo_502_PUSR": No enabled error handler

      > /* Tue Feb 13 2018 12:05:11.3060 */    End of filter processing (phase 2) -- Operation - SET on CTM:People - PPL000000003111

      > /* Tue Feb 13 2018 12:05:11.3060 */ ROLLBACK TRANSACTION

      I wanted to run arreload utility but it is not running on version 9.1. In following article, it says modifying all users does the same as arreload but it did not help in my case.

      https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=kA214000000P8jDCAS&type=Solution 

       

      I've checked some other discussions in communities but could not find a solution.

       

      Thanks in advance.