Account and Access Import job is failing with 'Unknown column 'YRAA' in 'field list''

[Diwakar]

Hi,

Our both import jobs(Account and access) are failing with attached job log error. Request to suggest the fix as its impacting prod operations.

Thanks,

Diwakar

[SumathiSomala]

@Diwakar was both jobs working earlier?

Could you please share the import mapping JSONs for account and groups.

[Diwakar]

Hi Sumathi,

Yes it was working previously, suddenly it started failing. Please find the below import mapping JSON.

{
"entitlementTypeName": "",
"importGroupHierarchy": "true",
"performGroupAccountLinking": "true",
"incrementalTimeField": "whenChanged",
"groupObjectClass": "(objectclass=group)",
"advanceGroupFilter": {
"memberOf": {
"OU=Benefit,OU=Groups,OU=Polaris,DC=ad,DC=Y****,DC=com": ["(&(objectClass=group))"]
}
},
"mapping": "memberHash:member_char,customProperty12:sAMAccountType_char,customProperty3:uSNCreated_char,customProperty4:groupType_char,customProperty2:dn_char,customProperty5:cn_char,lastscandate:whenCreated_date,entitlement_glossary:description_char,customProperty9:name_char,customProperty10:objectCategory_char,customProperty6:sAMAccountName_char,entitlement_value:distinguishedName_char,customProperty7:objectClass_char,customProperty11:extensionAttribute10_char,updatedate:whenChanged_date,displayName:cn_char,status:isCriticalSystemObject_Binary,RECONCILATION_FIELD:entitlement_value"
}

Please advise further.

Regards,

Diwakar.

[SumathiSomala]

@Diwakar 

Did you make any changes to connection configuration?

also share ACCOUNT_ATTRIBUTE mapping.

[Diwakar]

@SumathiSomala We didnt make any changes to the connection configuration not sure why we are seeing this issue suddenly!

Below is the account_attribute mapping. Please suggest next.

[
DISPLAYNAME::displayName#String,
NAME::sAMAccountName#String,
STATUS::userAccountControl#number,
ACCOUNTID::distinguishedName#String,
CUSTOMPROPERTY2::objectGUID#Binary,
CUSTOMPROPERTY1::company#String,
CUSTOMPROPERTY3::department#String,
CUSTOMPROPERTY4::displayname#String,
CUSTOMPROPERTY5::employeeID#String,
CUSTOMPROPERTY6::employeeNumber#String,
CUSTOMPROPERTY7::employeetype#String,
CUSTOMPROPERTY8::givenName#String,
CUSTOMPROPERTY9::sn#String,
CUSTOMPROPERTY10::middleName#String,
CUSTOMPROPERTY11::mail#String,
CUSTOMPROPERTY12::physicalDeliveryOfficeName#String,
CUSTOMPROPERTY13::userPrincipalName#String,
CUSTOMPROPERTY14::st#String,
CUSTOMPROPERTY15::streetAddress#String,
CUSTOMPROPERTY17::title#String,
CUSTOMPROPERTY18::mobile#String,
CUSTOMPROPERTY19::manager#String,
CUSTOMPROPERTY20::telephoneNumber#String,
CUSTOMPROPERTY21::co#String,
CUSTOMPROPERTY22::extensionAttribute4#String,
CUSTOMPROPERTY23::extensionAttribute14#String,
CUSTOMPROPERTY24::extensionAttribute6#String,
CUSTOMPROPERTY25::extensionAttribute1.contains('1')?'1':'0'#String,
CUSTOMPROPERTY26::extensionAttribute5#String,
CUSTOMPROPERTY27::language#String,
CUSTOMPROPERTY28::extensionAttribute2#String,
CUSTOMPROPERTY29::extensionAttribute11#number,
CUSTOMPROPERTY30::userAccountControl#String,
CUSTOMPROPERTY31::extensionAttribute12#String,
CUSTOMPROPERTY32::mailNickname#String,
CUSTOMPROPERTY33::extensionAttribute7#String,
CUSTOMPROPERTY34::l#String,
RECONCILATION_FIELD::CUSTOMPROPERTY2
]

Regards,

Diwakar.

[Diwakar]

Hi,

Any further suggestion or idea on this issue. What went wrong suddenly why this two jobs are failing?

Thanks

Diwakar.

[Diwakar]

@SumathiSomala Can you please help to suggest further on this issue. As its prod hence impacting our operations. Please help.

Regards,

Diwakar.

[SumathiSomala]

@Diwakar Run the account and access import job and share the error logs.

and also check any changes are made to connection parameters in the connection history tab.

also raise support ticket Support : Saviynt Inc as you are facing issue in prod environment.

[Diwakar]

@SumathiSomala No changes are made to the connection, below is the only error which I see in logs for this issue.

"2023-10-20T08:38:15.106+00:00","ecm-worker","","","","2023-10-20T08:38:14.38630882Z stdout F java.sql.BatchUpdateException: Unknown column 'YRAA' in 'field list'"
"2023-10-20T08:38:15.106+00:00","ecm-worker","","","","2023-10-20T08:38:14.390161115Z stdout F 2023-10-20 08:38:14,390