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 MARCH 11, 2019
Applies to:
Oracle Internet Directory - Version 10.1.2 and laterInformation in this document applies to any platform.
***Checked for relevance on 27-Jan-2013***
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.
...Setting OID server mode to read-modify on "xxx" 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=COMPANY,dc=com"
2011/02/24:09:43:28 * *Error at line:20, "2011/02/24:09:43:28 * *Error at line:10, "dn: cn=AdminUser,cn=users,dc=COMPANY,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=AdminUser,cn=users,dc=COMPANY,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=username,cn=users,cn=users,dc=COMPANY,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=username,cn=Users,dc=company,dc=com", rc=20.
Changes
none
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |