Applies to:Product Release: V7 (Enterprise)
Version: 7.5.3 
Database: IBM DB2 7.2 FixPack 3sa
Application Server OS: Microsoft Windows 2000 Advanced Server SP 3
Database Server OS: IBM AIX 5L 5.1
This document was previously published as Siebel SR 38-1787786381.
We have a problem with our eChannel application configuration. When we add a user through the
administration -> users view and don't conform to the password policy in LDAP, and then we try
to correct the password entry, we get an error "A record that contains identical values to the
record you have created already exists. If you would like to enter a new record, please ensure
that the field values are unique.(SBL-DAT-00381)"
We have checked the database, and there are no records that exist with this login id that we are attempting to add. We have also searched Supportweb and can't seem to find this particular issue that we are experiencing.
The weird thing is that if we cancel out of the error and add the same information back this time conforming to the password policy in LDAP, everything works as expected and the new user record is saved.
I am attaching 2 spooled files - one that gets generated when we get the error (...user exists error) and the other one that works correctly. We only have 2 weeks left of QA before we go to production, and we need to figure out a solution to this problem because our password policy is a little cryptic so we think this will be a big issue with our partners.
I tried the same steps with sample.srf and my custom srf. Both scenarios were with LDAP and with the same siebel cfg file (i.e. connect to the same DB).
Scenario #1 - test with sample.srf and LDAP
a. Login as my local portal user
b. Navigate to Administration -> Org Explorer, then expand the org trees and the to the Users View.
c. Click New.
d. Enter values into all required fields.
e. Enter and confirm a password that does NOT meet the password complexity policy. f. Click Save.
g. Got the message "The requested password does not confirm to our password policy. Please review password requirements and select a new password. Constraint violation(SBL-DAT-00348)".
h. Enter and confirm a new password that meets the complexity policy.
i. Click Save
j. The user is created in LDAP and Siebel.
<same steps a to h>
i. Click Save
j. Got the message "(SBL-DAT-00381) A record that contains identical values to the record you have created already exists. (SBL-DAT-00381)"
After I turned on the environment variable to trap more detail log files, I attached 2 event log files, siebel_sample_srf.log (for Scenario #1) and siebel_mcafee_srf.log (for Scenario #2) after I ran the 2 scenarios as described above. I noticed that there was some errors on file #2 on the audit trail of the Employee BC. I turned off our Employee audit trail on our Siebel server and try the scenario #2 again. THIS TIME, IT WORKED.
So the question is why the error audit trail on Employee may have caused the looping error in step (j) of scenario #2? We have audit on the following fields on Employee BC: Login Name, Position and Responsibility.
Please try to re-create the same problem in your vanilla srf with LDAP and Employee audit trail on for these BC's fields (see above).