"A processing error occurred while loading the membership data for the Direct segment into temporary tables" might occur when executing a segment map


The following error message might occur when you execute a segment map in SAS® Customer Intelligence 360:

"Node xyz failed. A processing error occurred while loading the membership data for the Direct segment into temporary tables."

This error message indicates that you very likely have two or more data items in your Information Map that are part of the Subject_ID.

To confirm whether you have multiple data items in your Information Map, open SAS® Information Map Studio and check whether your Information Map contains the UseInSubjectId custom property for more than one data item.

If you are unsure, you can also check the onprem_direct.log file and search for the following step. This file is located at <dm-agent-dir>/logs/onprem_direct.log.

creating CSV file K3_07100000001FHHE1LXJQBAAQPPE.csv from  MATable named MATables.K3_07100000001FHHE1LXJQBAAQPPE with columnNameList ID_CUSTOMER HOUSEHOLD and columnFormatList $64. F5.0
MPRINT(MACRTCSV):   data null;
MPRINT(MACRTCSV):   format ID_CUSTOMER $64. ;
MPRINT(MACRTCSV):   format HOUSEHOLD F5.0 ;

The above example contains two data items in the columnNameList. To circumvent this issue, remove UseInSubjectID from one of the data items. In SAS® 360 Engage: Direct, you can set the UseInSubjectID custom property for only one information map data item per subject_id.

For more information, see Setting Up Custom Properties for a SAS Information Map. (Note: Find the section with the following sentence: "For any subject that is used in SAS Customer Intelligence 360, only one column can be specified.")