Bulkload Fails With Sql*Loader-704: Internal Error / Schema Check failed with error=20 / Failed to find changetype in mandatory or optional attribute list. Same File OK With Ldapadd (Doc ID 437472.1)

Last updated on AUGUST 14, 2018

Applies to:

Symptoms

• bulkload fails with bulkload.log error:

  FATAL ERROR: Sqlldr could not load complete data due to some reasons.
  Check /u01/app/oracle/product/10.1.2/idm/ldap/log/bsl_*.log files for more details.

  OR
  

  ...Setting OID server mode to read-modify on "oimt" node...
  Getting scn and storing in tmpblkload table
  Info: Setting input language to .al32utf8
  Info: Setting output language to .AL32UTF8
  2011/02/24:09:43:28 * *Error at line:1, "dn: cn=users,dc=zalecorp,dc=com"
  2011/02/24:09:43:28 * *Error at line:20, "2011/02/24:09:43:28 * *Error at line:10, "dn: cn=app_rms_detail_pagoda,cn=users,dc=zalecorp,dc=com"
  2011/02/24:09:43:28 * Failed to find cn in mandatory or optional attribute list.
  2011/02/24:09:43:28 * *Error at line:38, "dn: cn=app_rms_planner_pagoda,cn=users,dc=zalecorp,dc=com"
  2011/02/24:09:43:28 * Schema Check failed with error=20
  2011/02/24:09:43:28 * Schema Check failed with error=20
  2011/02/24:09:43:28 * Failed to find changetype in mandatory or optional attribute list.
  2011/02/24:09:43:28 * *Error at line:
  2011/02/24:09:43:28 * *Error at line:60, "dn: cn=monette clark,cn=users,cn=users,dc=zalecorp,dc=com"
  2011/02/24:09:43:28 * Schema Check failed with error=20

• bulkload check shows errors:   Schema Check failed with error=20
• All the referenced bsl_*.log files show these errors:

  SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
  ORA-12516: TNS:listener could not find available handler with matching protocol stack

• sqlplus from the OID Oracle Home to the OID database is successful using this format:

  sqlplus ods/<pwd>@<connect_string>

• ldapadd of the LDIF file is successful
• bootstrap.log error also shows:

  Failed to find changetype in mandatory or optional attribute list.
  Error: Schema Check failed for DN "cn=kmandal310,cn=Users,dc=oracle,dc=com", rc=20.

Changes

none

Cause

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