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 JULY 10, 2017

Applies to:

Oracle Internet Directory - Version 9.0.4 and later
Information in this document applies to any platform.

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: 

dipassistant ERROR: [LDAP: error code 2 - Decoding 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms