Problem Note 69233: You are unable to migrate attachments from SAS® Anti-Money Laundering 7.1 using the SAS® Anti-Money Laundering 8.3 migration process
 |  |  |  |  |
Attachments from your SAS Anti-Money Laundering legacy system (7.1) do not get migrated to SAS Anti-Money Laundering 8.3 using the provided migration process. This issue occurs because the migration_status field is defined as CHAR (3-byte) instead of VARCHAR2 (3).
A workaround is to change the underlying SQL query (sasaml.migration.attachments.selectUnprocessedByCode.sql) to use the TRIM() function to remove extra spaces in the migration_status field.
Here is an example:
(SELECT DISTINCT object_id FROM migration.migration_attachment WHERE object_type_cd = ? AND trim(migration_status) = ? FETCH NEXT ? ROWS ONLY) i \
ON a.object_id = i.object_id WHERE a.object_type_cd = ? AND trim(migration_status) = ? ORDER BY a.object_id, a.create_date DESC
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Linux for x64 | 8.3 | Viya | ||
An update for this issue is available for SAS Compliance Solutions 8.3. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/ComplianceSol_83_home.html#69233| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2023-06-21 12:28:24 |
| Date Created: | 2022-05-26 08:41:17 |