Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

We need a way to fix this in Grouper.

Maybe this helps to fix your registry:

Find the assignments and values (I think this is what you need, not 100% 
sure):

select * from GROUPER_AVAL_ASN_ASN_GROUP_V gaaagv 
where gaaagv.attribute_def_name_id2 = (select id from 
grouper_attribute_def_name where extension = 
'instrumentationDataInstanceLastUpdate')
and exists (
    select 1 from grouper_attribute_assign gaa where 
gaaagv.attribute_assign_id1 = gaa.owner_attribute_assign_id
    and gaaagv.attribute_assign_id2 != gaa.id and 
gaaagv.attribute_def_name_id2 = gaa.attribute_def_name_id );

Then, pick one to delete (the older value?)

delete from grouper_attribute_assign_value where id = 
'<attribute_assign_value_id_from_above_result>';

delete from grouper_attribute_assign where id = 
'<attribute_assign_id2_from_above_result>';

each should remove 1 record.  And you should be all set.  ok?

Thanks
Chris

-----Original Message-----
From: 

 
[mailto:]
 On Behalf Of Black, Carey M.
Sent: Tuesday, March 27, 2018 10:24 AM
To: Gouper Users List 
<>
Subject: [grouper-users] Error: Attribute is not multi-valued, but has 
multiple results! ( 
etc:attribute:instrumentationData:instrumentationDataInstanceLastUpdate )

I miss-clicked on the "UiV2Main.miscellaneous" list of functions and clicked 
on "Instrumentation". I was promptly presented with this error msg. (and 
nothing else)

"
Error: Attribute is not multi-valued, but has multiple results! 
etc:attribute:instrumentationData:instrumentationDataInstanceLastUpdate, 
 AttributeAssignValueDelegate[ attributeAssign=AttributeAssign
        
[id=0f5b3b35b1764fde9f7a37f9ba7b9831,action=assign,attributeDefName=etc:attribute:instrumentationData:instrumentationDataInstanceLastUpdate,ownerAttributeAssignId=20245cda30f14b7d9ee6197668c50bfe]],
        size: 2, 
 Problem calling method instrumentation on 
edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2Admin
"

I understand what the error is saying. However:
        I don't know how the system came to be in this state. ( At this 
point, I assume due to some automated process that went sideways. )
                Is this a known bug at some patch level? Result of a failed 
process? (loader job? I2 Instrumentation?)
        I don't know the right way to fix this either.
                Track down where the multiple assignment(s) are remove (one? 
All?) them?
                Change the attribute to be multi-valued?
                What is the downside to those actions?

If more information is needed then please send gsh/sql commands/UI click 
paths/files to grep/etc.... 
        I would be glad to poke around . ( Just give me the right stick to 
poke with.)  :)

Thanks in advance.      
-- 
Carey Matthew