Symptom
Creating and saving many users/principals with relations is slow.
If viewing the JDBC logs the following query can be seen taking a taking a lot of time:
SELECT item_t1.PK FROM pgrels item_t0 JOIN usergroups item_t1 ON item_t0.TargetPK = item_t1.PK
WHERE ( item_t0.Qualifier = ? AND item_t0.SourcePK = ? AND item_t0.languagepk IS NULL)
AND (item_t1.TypePkString IN (?,?,?,?,?) ) order by item_t0.SequenceNumber ASC , item_t0.PK ASC
Read more...
Product
SAP hybris Commerce Suite 5.2 ; SAP hybris Commerce Suite 5.3 ; SAP hybris Commerce Suite 5.4 ; SAP hybris Commerce Suite 5.5 ; hybris Commerce Suite 4.8 ; hybris Commerce Suite 5.0 ; hybris Commerce Suite 5.1
Keywords
Relationship, PrincipalGroupRelation, hybris , KBA , CEC-COM-CPS-COR , SAP Commerce Core , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.