Page tree

Versions Compared

Key

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

...

  • change parent/version from 1.2.6 to 1.2.7
  • change properties/syncope.version from 1.2.6 to 1.2.7

Other

SYNCOPE-

...

748

Replace the following file with its 1.2.7 counterpart:

Add the following lines

 

SYNCOPE-735

Manual clean-up of some Activiti tables can be performed.

  1. approve / reject any pending request
  2. shut down the Java EE container running Apache Syncope core
  3. execute the queries below
  4. start up again the Java EE container with Apache Syncope core

Code Block
language

...

sql

...

<entry key="Membership_syncopeRoleIndex">CREATE INDEX Membership_syncopeRoleIndex ON Membership(syncopeRole_id)</entry>
<entry key="Membership_syncopeUserIndex">CREATE INDEX Membership_syncopeUserIndex ON Membership(syncopeUser_id)</entry>
<entry key="RAttrValue_attributeIdIndex">CREATE INDEX RAttrValue_attribute_idIndex on RAttrValue(attribute_id)</entry>
<entry key="UAttrValue_attributeIdIndex">CREATE INDEX UAttrValue_attribute_idIndex on UAttrValue(attribute_id)</entry>
<entry key="MAttrValue_attributeIdIndex">CREATE INDEX MAttrValue_attribute_idIndex on MAttrValue(attribute_id)</entry>
<entry key="CAttrValue_attributeIdIndex">CREATE INDEX CAttrValue_attribute_idIndex on CAttrValue(attribute_id)</entry>

<entry key="RAttr_templateIdIndex">CREATE INDEX RAttr_template_idIndex on RAttr(template_id)</entry>
<entry key="MAttr_templateIdIndex">CREATE INDEX MAttr_template_idIndex on MAttr(template_id)</entry>
<entry key="RAttr_owner_id_index">CREATE INDEX RAttr_owner_id_index on RAttr(owner_id)</entry>
<entry key="UAttr_owner_id_index">CREATE INDEX UAttr_owner_id_index on UAttr(owner_id)</entry>
<entry key="MAttr_owner_id_index">CREATE INDEX MAttr_owner_id_index on MAttr(owner_id)</entry>

<entry key="RDerAttr_owner_id_index">CREATE INDEX RDerAttr_owner_id_index on RDerAttr(owner_id)</entry>
<entry key="UDerAttr_owner_id_index">CREATE INDEX UDerAttr_owner_id_index on UDerAttr(owner_id)</entry>
<entry key="MDerAttr_owner_id_index">CREATE INDEX MDerAttr_owner_id_index on MDerAttr(owner_id)</entry>

<entry key="RVirAttr_owner_id_index">CREATE INDEX RVirAttr_owner_id_index on RVirAttr(owner_id)</entry>
<entry key="UVirAttr_owner_id_index">CREATE INDEX UVirAttr_owner_id_index on UVirAttr(owner_id)</entry>
<entry key="MVirAttr_owner_id_index">CREATE INDEX MVirAttr_owner_id_index on MVirAttr(owner_id)</entry>

to indexes.xml

DELETE FROM ACT_GE_BYTEARRAY WHERE NAME_ LIKE 'hist.%';

DELETE FROM ACT_HI_VARINST;
DELETE FROM ACT_HI_TASKINST;
DELETE FROM ACT_HI_ACTINST;