My Oracle Support Banner

New OID 11g Replication Environment Fails to Replicate. Replication Log Error: ORA error = 1756 message = ORA-01756: quoted string not properly terminated (Doc ID 1934644.1)

Last updated on MAY 06, 2021

Applies to:

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


Oracle Internet Directory (OID) 11g, i.e.,

Created other environments previous exactly as this one, with the same replication configuration, and all are running fine.

On this one environment, after replication configuration, testing by creating two simple OUs entries under the users container (cn=users,dc=<COMPANY>,dc=com) never replicates to the other nodes.

Replication log shows:

[2014-10-08T15:37:21-07:00] [OID] [NOTIFICATION:16] [] [OIDLDAPD] [host:<OID_REPLICA_HOSTNAME>] [pid:<PID>] [tid: <TID>] [ecid: <ECID>] ServerWorker (REG):[[
ConnID:18 mesgID:14 OpID:13 OpName:add ConnIP:<IP_ADDRESS> ConnDN:cn=replication dn,orclreplicaid=<OID_REPLICA_HOSTNAME>_<OID_REPLICA_SID>,cn=replication configuration
gsldudiSetSqlStmt: Sql prepare failed (INSERT into attr_uniqueness (EntryID, AttrValue, AttrType, Constraint) ( SELECT entryid, attrvalue, attrtype, 3315 from CT_uid where entryid in ( SELECT dn.entryid from ct_dn dn, ct_objectclass obj where dn.parentdn='dc=com,dc=<COMPANY>,cn=users,ou=<OU>, AND obj.attrvalue='inetorgperson' AND dn.entryid = obj.entryid)) LOG ERRORS INTO attr_uniqueness_log ('uid') REJECT LIMIT 1000)
  ORA error = 1756 message = ORA-01756: quoted string not properly terminated

An oidcmprec operation=compare report shows no differences for realm entries between the nodes.  An oiddiag report shows no problems or inconsistencies, and the OID Database (DB) alert log shows no related errors either.




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.