My Oracle Support Banner

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:

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


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


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

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