LDAP import: user record not created after sync

Transform map coalesce field is not matching existing records correctly, causing the system to skip record creation when it should create new users or update existing ones. (high likelihood)

LDAP query filter is too restrictive and excludes users that should be imported, or the query syntax contains errors that silently filter out records. (high likelihood)

Required field mappings are missing or incorrect in the transform map, causing record creation to fail validation without generating obvious error messages. (medium likelihood)

Business rules or ACLs on the sys_user table are preventing record creation during the import process, particularly those that run on insert operations. (medium likelihood)

The LDAP server connection or authentication failed during the sync, but the import process continued and appeared successful while actually retrieving no data. (low likelihood)

Step 1: Navigate to System Import Sets > Administration > Transform Maps and locate your LDAP import transform map to verify the coalesce field settings match your intended logic for creating vs updating records.

Step 2: Check System Diagnostics > Log > Application Log for any additional error messages during the import timeframe that might indicate validation failures or business rule issues.

Step 3: Go to System Import Sets > Import Set Tables and examine the import set table data to confirm that records were actually retrieved from LDAP and populated in the staging table.

Step 4: Review the LDAP server configuration at System LDAP > LDAP Servers and test the connection, then verify the query filter syntax and scope are correct for your intended user population.

Step 5: In the transform map, verify all required field mappings exist and check that mapped LDAP attributes contain valid data by examining sample records in the import set table.

Step 6: Navigate to System Definition > Business Rules and review any business rules on sys_user table that run on insert operations to ensure they aren't preventing record creation.

Step 7: Use System Import Sets > Run Transform to manually execute the transform on a small subset of records with debug logging enabled to identify specific failure points.

Step 8: If records still aren't created, check User Administration > Users to confirm the users don't already exist with different values in the coalesce field than expected.