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 Commerce Cloud 2105 ; SAP Commerce Cloud 2205 ; SAP Commerce Cloud 2211


Relationship, PrincipalGroupRelation, hybris , KBA , CEC-SCC-PLA-PL , Platform , 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.