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:
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | |||||
A fix for this issue for SAS Compliance Solutions 7.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A5T.html#64795| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-09-23 16:32:07 |
| Date Created: | 2019-09-18 04:11:50 |