Skip to Content

(VDS)Multiple Entries With Same MSKEYVALUE

Hi All,

I am trying to expose SAP NW IdM Identity Store using SAP VDS default IDM Identity Center 72 template.

I have set the Size Limit on the FullAccess Rule to allow the third party application to fetch all entries.

The size limit is greater than the available entries in the Identity Store.

The last setting will result in some strange behaviour as SAP VDS will return double entries for each MX_PERSON object in SAP Identity Store.

If I try to execute the select statement with TOP Size Limit the system will return the correct entries.

Any clues why this is happening?

Thanks very much.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 29, 2015 at 01:31 AM

    Hi Ridouan,

    Setting TOP changes the query that VDS is passing back to the Identity store.  What database is the Identity Store using? I seem to remember TOP is best for SQL Server and ROWNUM for Oracle.

    I just tested this with my 7.2 SP3 implementation on SQL Server.  LIMIT returned nothing, TOP worked fine.


    Add comment
    10|10000 characters needed characters exceeded