Column count doesn't match value count at row 1 while ldap users import

[yash]

Getting below error while running full import for LDAP

java.sql.BatchUpdateException: Column count doesn't match value count at row 1 at com.mysql.cj.util.Util.handleNewInstance(Util.java:192) at com.mysql.cj.util.Util.getInstance(Util.java:167) at com.mysql.cj.util.Util.getInstance(Util.java:174) at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224) at com.mysql.cj.jdbc.StatementImpl.executeBatchInternal(StatementImpl.java:893) at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:796) at com.saviynt.ecm.services.AdImportService$_mapDataToDbUsers_closure14_closure95_closure96.doCall(AdImportService.groovy:1511) at com.saviynt.ecm.services.AdImportService$_mapDataToDbUsers_closure14_closure95.doCall(AdImportService.groovy:1466) at com.saviynt.ecm.services.AdImportService$_mapDataToDbUsers_closure14.doCall(AdImportService.groovy:1465) at com.saviynt.ecm.services.AdImportService.mapDataToDbUsers(AdImportService.groovy:1463) at com.saviynt.ecm.services.AdImportService.getLdapResultAndExecute(AdImportService.groovy:4474) at com.saviynt.ecm.services.AdImportService.doImportInternal(AdImportService.groovy:937) at com.saviynt.ecm.services.AdImportService.doImport(AdImportService.groovy:185) at com.saviynt.ecm.services.AdImportService.doUserImport(AdImportService.groovy:100) at com.saviynt.ecm.integration.ExternalConnectionCallService.importUserUsingExternalConnection(ExternalConnectionCallService.groovy:1228) at UserImportJob.execute(UserImportJob.groovy:108) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)Caused by: java.sql.SQLException: Column count doesn't match value count at row 1 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1335) at com.mysql.cj.jdbc.StatementImpl.executeBatchInternal(StatementImpl.java:859)

[rushikeshvartak]

• It was working before ?
• Share connector configs 

[yash]

Object Filter : {
"full": "(&(unitnumber=*)(uid=*)(isAccountEnabled=true))"
}

[rushikeshvartak]

• Is it working without filter ?

[yash]

We need the filter in place

[rushikeshvartak]

1. Please share all connector configs
2. It was working before ?

[yash]

STATUS_THRESHOLD_CONFIG: {"statusAndThresholdConfig":{"statusColumn":"customproperty30","activeStatus":["true","TRUE","1"],"inactiveStatus":["false","FALSE","0"],"deleteLinks":false,"accountThresholdValue":450000,"correlateInactiveAccounts":true,"inactivateAccountsNotInFile":false}}

USER_ATTRIBUTE: [CITY::l#String,
Country::co#String,
CREATEDBY::creatorsName#String,
DEPARTMENTNUMBER::departmentNumber#String,
DEPARTMENTNAME::departmentName#String,
DISPLAYNAME::displayName#String,
EMAIL::email#String,
EMPLOYEETYPE::HRpersontype#String,
EMPLOYEEID::employeeNumber#String,
EMPLOYEECLASS::jobfamilyname#String,
FIRSTNAME::givenName#String,
JOBCODE::ihcjobglnumber#String,
JOBDESCRIPTION::title#String,
LASTNAME::sn#String,
LOCATION::ihcfacilityabbr#String,
LOCATIONDESC::location#String,
LOCATIONNUMBER::businesssite#String,
MANAGER::managerUid#String,
MIDDLENAME::middleName#String,
SYSTEMUSERNAME::unitnumber#String,
PHONENUMBER::telephonenumber#String,
PREFEREDFIRSTNAME::knownas#String,
REGION::departmentFacility#String,
REGIONCODE::deptfacilitynum#String,
SECONDARYPHONE::mobile#String,
STATE::st#String,
STREET::street#String,
TERMDATE::termDate#customDate--dd-MMM-yy,
USERNAME::uid#String,
STATUSKEY::isAccountEnabled#number,
CREATEDATE::createtimestamp#customDate--yyyyMMddHHmmss,
UPDATEDATE::modifytimestamp#customDate--yyyyMMddHHmmss,
STARTDATE::ihchiredate#customDate--dd-MMM-yyyy,
RECONCILATION_FIELD::USERNAME]

IMPORTJSON:

{
"envproperties":{
"com.sun.jndi.ldap.connect.timeout":"10000",
"com.sun.jndi.ldap.read.timeout":"50000"
}
}

[yash]

it never worked before for full import, only the incremental one is working

[rushikeshvartak]

• What configuration has been updated on saviynt side ?
• Does the environment have upgraded saviynt/ldap? 

[yash]

Sorry one correction , it never worked before for full import, only the incremental one is working

[yash]

"ecm-worker","services.AdImportService","quartzScheduler_Worker-9-gv6f5","ERROR","Exception while executing tempusers batch: "

Getting this in the logs

[rushikeshvartak]

share full logs in text file