CSV Lookup plugin stopped working, returns Null values.

Products

• Data Loss Prevention Core Package

Issue/Introduction

After updating attributes in System > Incident Data > Lookup Plugins > CSV PLUGIN

All attributes in incidents no longer populate.

In Localhost logs we are presented with:

Level: WARNING
Source: com.vontu.lookup.csv.CsvLookup
Message: incident attributes contains null keys, hence there is no key to query the database

Followed by Incident Attribute XXXXXXX=null

with Null values for all following attributes.

Cause

attr.sender-email = EMAIL_ADDRESS
attr.User_ID = COMIT_ID

 

attr.XXX = XXX
attr.Phone = BUSINESS_PHONE
attr.Last_Name = LAST_NAME
attr.First_Name = FIRST_NAME
attr.User_Status = USER_TYPE
attr.Email_Address = EMAIL_ADDRESS
attr.XXXX_ID = EMPLOYEE_ID_NUMBER
attr.Country = WORK_LOCATION_COUNTRY
attr.State = WORK_LOCATION_STATE
attr.City = WORK_LOCATION_CITY
attr.HR_Department = HR_DEPARTMENT
attr.HR_Department_Description=HR_DEPARTMENT_DESC
attr.Segment_ID = SEGMENT_ID
attr.Segment_Short_Description = SEGMENT_SHORT_DESCRIPTION
attr.Segment_Description = SEGMENT_DESCRIPTION
attr.XXX1 = XXX1_DESCRIPTION
attr.XXX = XXX_DESCRIPTION
attr.Sector_ID = SECTOR_ID
attr.Sector = SECTOR_SHORT_DESCRIPTION
attr.MU_Name = MANAGEMENT_UNIT_DESCRIPTION
attr.Management_Unit = MANAGEMENT_UNIT
attr.Manager_ID = HR_SUPERVISOR_ID
attr.Manager_Last_Name = HR_SUPERVISOR_LAST_NAME
attr.Manager_First_Name = HR_SUPERVISOR_FIRST_NAME
attr.Manager_Email_Address = HR_EMAIL_ADDRESS

keys = EMAIL_ADDRESS:COMIT_ID

Resolution

The lines in bold represent the problem field.

Because EMAIL_ADDRESS is being used as a key field when it was reused later in the list it created a null value. Because it is a key field mapping was not achieved and all subsequent fields return a value of null. 

By moving it to the end of the list it is able to retain it's value, and mapping is successful.

 

attr.XXX = XXX
attr.Phone = BUSINESS_PHONE
attr.Last_Name = LAST_NAME
attr.First_Name = FIRST_NAME
attr.User_Status = USER_TYPE
attr.Email_Address = EMAIL_ADDRESS
attr.XXXX_ID = EMPLOYEE_ID_NUMBER
attr.Country = WORK_LOCATION_COUNTRY
attr.State = WORK_LOCATION_STATE
attr.City = WORK_LOCATION_CITY
attr.HR_Department = HR_DEPARTMENT
attr.HR_Department_Description=HR_DEPARTMENT_DESC
attr.XXX1 = XXX1_DESCRIPTION
attr.XXX = XXX_DESCRIPTION
attr.Sector_ID = SECTOR_ID
attr.Sector = SECTOR_SHORT_DESCRIPTION
attr.MU_Name = MANAGEMENT_UNIT_DESCRIPTION
attr.Management_Unit = MANAGEMENT_UNIT
attr.Manager_ID = HR_SUPERVISOR_ID
attr.Manager_Last_Name = HR_SUPERVISOR_LAST_NAME
attr.Manager_First_Name = HR_SUPERVISOR_FIRST_NAME
attr.Manager_Email_Address = HR_EMAIL_ADDRESS

attr.sender-email = EMAIL_ADDRESS
attr.User_ID = COMIT_ID

keys = EMAIL_ADDRESS:COMIT_ID