Versions Compared

Old Version 1

changes.mady.by.user Hyzer

Saved on

compared with

New Version Current

changes.mady.by.user Hyzer

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
select to_char(created_on), change_log_category, action_name, string01, label_string02, 
string02, label_string03, string03, label_string04, string04, label_string05, string05
 from grouper_change_log_temp_v where
string01 = 'c5c3a39cd7b84aada804b76c4641df5a'
or string02 = 'c5c3a39cd7b84aada804b76c4641df5a'
or string03 = 'c5c3a39cd7b84aada804b76c4641df5a'
or string04 = 'c5c3a39cd7b84aada804b76c4641df5a'
or string05 = 'c5c3a39cd7b84aada804b76c4641df5a'
or string06 = 'c5c3a39cd7b84aada804b76c4641df5a'
or string07 = 'c5c3a39cd7b84aada804b76c4641df5a'
or string08 = 'c5c3a39cd7b84aada804b76c4641df5a'
or string09 = 'c5c3a39cd7b84aada804b76c4641df5a'
or string10 = 'c5c3a39cd7b84aada804b76c4641df5a'
or string11 = 'c5c3a39cd7b84aada804b76c4641df5a'
or string12 = 'c5c3a39cd7b84aada804b76c4641df5a'
order by created_on
1497469830262000privilegeaddPrivilege3b250c963f29444480f8102e89f371f1privilegeNameupdatesubjectIdef1563fcdb0d4604b9ed3e45fe1a85f6sourceIdg:gsaprivilegeTypeaccess
1497469850914000memberaddMemberc5c3a39cd7b84aada804b76c4641df5asubjectIdef1563fcdb0d4604b9ed3e45fe1a85f6subjectSourceIdg:gsasubjectTypeIdgroupsubjectIdentifier0penn:isc:XXXXXXXXX

This happened when time on servers was not correct, and WS is running on multiple servers

...

Code Block
update grouper_change_log_entry_temp set created_on = 149746983026200014974698302XXXXX - 1 where created_on = 14974698509XXXXX;
 
or
 
update grouper_change_log_entry_temp
set created_on = 1497469850914000 14974698302XXXXX
where change_log_type_id = (select id from grouper_change_log_type where 
change_log_category = 'group' and action_name = 'addGroup');
commit;