Problem Note 64586: Certain column names in the Lookup list definition can cause problems in SAS® Fraud Management
 |  |  |  |
In SAS Fraud Management, the following problems might occur when you create a Lookup list definition:
- The OnDemand Decision Engine (ODE) does not start.
- The rules redeployment does not complete.
- The rule test does not complete.
- The rule-estimation process does not complete.
The problem occurs when the column names in the Lookup list definition follow this formula:
((Length of all key fields) +(length of all variable fields) +2*(number of key fields) +3*(number of variable fields) +4) MOD 71 = 0
In the SAS log from the ODE, the Lookup list definition and the error are displayed as follows:
CARD000073 NAME=A_dllr_cardproductw14d0
CARD000074 COLS=$masked_card_no_cardproduct #m_ll_rcardproduct_c1w14d0@
#m_ll_rcar+
CARD000075 dproduct_c2w14d0@ #m_ll_rcardproduct_c3w14d0@
#m_ll_rcardproduct_c4w14d+
CARD000076 0@ #m_ll_rcardproduct_c5w14d0@ #m_ll_rcardproduct_c6w14d0@
#m_ll_rcardp+
CARD000077 roduct_c7w14d0@ #m_ll_rcardproduct_c9w14d0@
#m_ll_rcardproduct_c8w14d0@+
CARD000078
CARD000079 INDS=LOA.dllr_cardproductw14d0
CARD000080 ID=0
ERROR: Expecting 'INDS=' in record 77 but got: len=4
lookupspec= name=A_dllr_cardproductw14d0 inds=
cols=$masked_card_no_cardproduct #m_ll_rcardproduct_c1w14d0@
#m_ll_rcardproduct_c2w14d0@ #m_ll_rcardproduct_c3w14d0@
#m_ll_rcardproduct_c4w14d0@ #m_ll_rcardproduct_c5w14d0@
#m_ll_rcardproduct_c6w14d0@ #m_ll_rcardproduct_c7w14d0@
#m_ll_rcardproduct_c9w14d0@
#m_ll_rcardproduct_c8w14d0@INDS=LOA.dllr_cardproductw14d0 id= rc= usesSor=0
lastSorName= specnum=11 cardnum=77 i=356 len=4 colcount=. macname= _ERROR_=0
_INFILE_=ID=0 _N_=11
RULE:
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
----+----9----+----0
80 ID=0 4
NOTE: 80 records were read from the infile INCAT.
The minimum record length was 1.
The maximum record length was 72.
CARD000073 NAME=A_dllr_cardproductw14d0
CARD000074 COLS=$masked_card_no_cardproduct #m_ll_rcardproduct_c1w14d0@
#m_ll_rcar+
CARD000075 dproduct_c2w14d0@ #m_ll_rcardproduct_c3w14d0@
#m_ll_rcardproduct_c4w14d+
CARD000076 0@ #m_ll_rcardproduct_c5w14d0@ #m_ll_rcardproduct_c6w14d0@
#m_ll_rcardp+
CARD000077 roduct_c7w14d0@ #m_ll_rcardproduct_c9w14d0@
#m_ll_rcardproduct_c8w14d0@+
CARD000078
CARD000079 INDS=LOA.dllr_cardproductw14d0
CARD000080 ID=0
ERROR: Expecting 'INDS=' in record 77 but got: len=4
lookupspec= name=A_dllr_cardproductw14d0 inds=
cols=$masked_card_no_cardproduct #m_ll_rcardproduct_c1w14d0@
#m_ll_rcardproduct_c2w14d0@ #m_ll_rcardproduct_c3w14d0@
#m_ll_rcardproduct_c4w14d0@ #m_ll_rcardproduct_c5w14d0@
#m_ll_rcardproduct_c6w14d0@ #m_ll_rcardproduct_c7w14d0@
#m_ll_rcardproduct_c9w14d0@
#m_ll_rcardproduct_c8w14d0@INDS=LOA.dllr_cardproductw14d0 id= rc= usesSor=0
lastSorName= specnum=11 cardnum=77 i=356 len=4 colcount=. macname= _ERROR_=0
_INFILE_=ID=0 _N_=11
RULE:
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
----+----9----+----0
80 ID=0 4
NOTE: 80 records were read from the infile INCAT.
The minimum record length was 1.
The maximum record length was 72.
If you encounter any of the problems that are described in this note, modify the column names in the Lookup list such that they do not follow the formula that is shown earlier.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Fraud Management | 64-bit Enabled AIX | 4.4_M1 | 9.4 TS1M5 | ||
| Linux for x64 | 4.4_M1 | 9.4 TS1M5 | ||||
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-08-23 14:59:58 |
| Date Created: | 2019-08-08 16:09:12 |