Problem Note 64795: Accepting a risk assessment in SAS® Anti-Money Laundering results in a key constraint error
An error could occur when an extract, transform, load (ETL) job is loading the Core schema of SAS Anti-Money Laundering (AML), or when the user interface is adding records to the Knowledge Center (KC) schema.
The error is due to conflicting keys during an Add operation or Append operation. There is no specific error message. The text in the error message depends on your database and the action being performed at the time.
The SAS Anti-Money Laundering application uses a database sequence to allocate IDs within the Core and KC schemas.
For the ETL process to avoid the risk of creating duplicate IDs, it should also use this sequence, in order to allocate the keys to be used for any entity in the Core schema.
A macro that is shipped with SAS Anti-Money Laundering can retrieve the next sequence of keys to use. The usage of the macro is described below:
NAME: fcf_get_sequence_ids.sas
PRODUCT: SAS® Compliance Solutions
SYSTEM: Windows, UNIX
DESC: Retrieve Sequence IDs from FSK_SEQ
USAGE: %fcf_get_sequence_ids(numIDs=, globals=);
numIDs - number of IDs to allocate
default is 1
globals - return mechanism for allocated IDs
all - return via global vars allocated for each ID: seqID1, seqID2, ...
first - return only first ID via global var firstSeqID, all other IDs are sequential
default is 'all' for backward compatibility
Operating System and Release Information
SAS System | SAS Anti-Money Laundering | Microsoft® Windows® for x64 | 7.1 | | | |
64-bit Enabled AIX | 7.1 | | | |
64-bit Enabled Solaris | 7.1 | | | |
Linux for x64 | 7.1 | | | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2019-09-23 16:32:07 |
Date Created: | 2019-09-18 04:11:50 |