BI Publisher 11.1.1.7 - LDAP Data Source Username Containing An Ampersand (&) Character Fails When Selecting Apply Changes, and Username Characters Before The Ampersand Are Truncated (Doc ID 2026826.1)

Last updated on OCTOBER 04, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.7.x to 11.1.1.7.x [Release 11.1]
Information in this document applies to any platform.

Symptoms

LDAP data sources containing an Ampersand '&' in the username string fail when selecting apply changes button, and text before the ampersand '&' is truncated.

For example, if the LDAP data source contains something similar to:

Username entered is 'CN=Firstname Surname,OU=DB & BI,OU=Operations,OU=Oracle,DC=com' it works fine, test succeeds and apply to save the changes.
However when opening the same LDAP Data Source again, the connection is shown as 'BI,OU=Operations,OU=Oracle,DC=com'

The bipublisher.log file shows:

[2015-01-24T15:36:33.752+03:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid:
121] [userId: <anonymous>] [ecid:
8cf662749f788d85:-319c0fdf:14ae1eb5a02:-8000-00000000000a1ca8,0] [APP:
bipublisher#11.1.1] ldap://Ldap.oracle.com:389
[2015-01-24T15:36:33.754+03:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid:
121] [userId: <anonymous>] [ecid:
8cf662749f788d85:-319c0fdf:14ae1eb5a02:-8000-00000000000a1ca8,0] [APP:
bipublisher#11.1.1] BI,OU=Operations,OU=Oracle,DC=com
[2015-01-24T15:36:33.754+03:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid:
121] [userId: <anonymous>] [ecid:
8cf662749f788d85:-319c0fdf:14ae1eb5a02:-8000-00000000000a1ca8,0] [APP:
bipublisher#11.1.1] com.sun.jndi.ldap.LdapCtxFactory
[2015-01-24T15:36:33.757+03:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid:
121] [userId: <anonymous>] [ecid:
8cf662749f788d85:-319c0fdf:14ae1eb5a02:-8000-00000000000a1ca8,0] [APP:
bipublisher#11.1.1] javax.naming.AuthenticationException: [LDAP: error code
@ 49 - 80090308: LdapErr: DSID-0C0903A9, comment: AcceptSecurityContext error,
data 52e, v1db1 ][[
at com.sun.jndi.ldap.LdapCtx.mapErrorCode(LdapCtx.java:3067)
at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:3013)
at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2815)
at com.sun.jndi.ldap.LdapCtx.connect(LdapCtx.java:2729)
at com.sun.jndi.ldap.LdapCtx.<init>(LdapCtx.java:296)

 

The 'CN=Firstname Surname,OU=DB & BI,OU=Operations,OU=Oracle,DC=com' is truncated to 'BI,OU=Operations,OU=Oracle,DC=com'.


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