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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.