Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/07/2024 06:13 AM
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)
10/07/2024 06:14 AM
10/07/2024 06:29 AM
Object Filter : {
"full": "(&(unitnumber=*)(uid=*)(isAccountEnabled=true))"
}
10/07/2024 06:31 AM
10/07/2024 06:35 AM
We need the filter in place
10/07/2024 06:35 AM
10/07/2024 07:07 AM
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"
}
}
10/07/2024 07:08 AM - edited 10/07/2024 07:25 AM
it never worked before for full import, only the incremental one is working
10/07/2024 07:17 AM
10/07/2024 07:20 AM
Sorry one correction , it never worked before for full import, only the incremental one is working
10/08/2024 02:34 AM
"ecm-worker","services.AdImportService","quartzScheduler_Worker-9-gv6f5","ERROR","Exception while executing tempusers batch: "
Getting this in the logs
10/08/2024 10:38 AM
share full logs in text file