SAP Knowledge Base Article - Preview

2226531 - Batch creation of users with relations is slow


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



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


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.