New OID 11g Replication Environment Fails to Replicate. Replication Log Error: ORA error = 1756 message = ORA-01756: quoted string not properly terminated
Last updated on MARCH 08, 2017
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., 126.96.36.199.0.
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=mycompany,dc=com) never replicates to the other nodes.
Replication log shows:
ConnID:18 mesgID:14 OpID:13 OpName:add ConnIP:<IP Address> ConnDN:cn=replication dn,orclreplicaid=myoidreplica_myreplicasid,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=mycompany,cn=users,ou=myou1, 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.
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