this is how we solved it.
1) Query the Composed type table which holds all many-to-many relation types.
select * from COMPOSEDTYPES where INTERNALCODE = <your-type-here>. Copy the data and save it in a file.
2) Look at the ITEMJNDINAME column in the result set returned by this query. Let us assume the JNDI name is de.hybris.platform.persistence.link.Link.
3) This means all data related to these types are stored in the Links table. Removing these relations from -items.xml will have no effect. On running system update, Hybris picks up the old deployment table(de.hybris.platform.persistence.link.Link) based on the JNDI name.
4) We need to remove these entries from the ComposedType table by executing the query below.
delete from COMPOSEDTYPES where INTERNALCODE = <your-type-here>
5) Perform step-1 to double check if entries have been deleted from this table.
6) Now change your items.xml file and add deployment table for these many-to-many types.
7) Run ant clean all and start hybris server, followed by system update
😎 At this time, run step-1 again to see the JNDI name of the result set, it should have changed to de.hybris.platform.persistence.link.<your-ext-here>_<your-type-here>
9) Now use below query to update PKs of many-to-many relations. Copy the PK from the backup file saved in step-1
10) update COMPOSEDTYPES set pk= where INTERNALCODE= <your-type-here>
11) Once done, run a system-update again
12) All select & insert operations should now be performed on new deployment tables. Run an impex to verify.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.