Creating an OID DIP Sync Profile Using a Very Large SQL Statement Fails with: dipassistant ERROR: [LDAP: error code 2 - Decoding Error] (Doc ID 377001.1)

Last updated on AUGUST 16, 2022

Applies to:

Symptoms

Configuration of an OID DIP synchronization profile using a very large SQL statement that has a Union in it, for sync with a database fails with the following error: 

Steps to reproduce, i.e. from dipassistant -gui (but the same error can occur from dipassistant mp command line also):

1. Edit the profile in dipassistant -gui

2. Select Filtering tab, and change the Connected Directory Matching Filter value to a larger value.

3. Click Save and it returns the error

Cause

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