My Oracle Support Banner

SnpsLdapDriver Pagination - Only 1000 Data Records are Returned From an ODI LDAP Driver Datastore on a Microsoft Active Directory Instance (Doc ID 1541459.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

After successfully creating and connecting to an Oracle Data integrator (ODI) Lightweight Directory Access Protocol (LDAP) Technology Data Server, and creating a corresponding Model to reverse engineer the metadata, using the right > click View Data and Data menu items, you retrieve the dataset which is limited to 1000 records even though there are more than 1000 records found when using the Microsoft Management Console.

It appears that the SnpsLdapDriver Pagination is not allowing more than 1000 records to display.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 Solution 1. Update the MaxPageSize LDAP policy to a higher value
 Solution 2. Apply ODI patch, and set the ODI page_size property to match LDAP MaxPageSize policy
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.