SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 35289: The SAS® Money Laundering Detection account_transaction_prep program might truncate columns within the account transaction prep table

DetailsHotfixAboutRate It

The account_transaction_prep.sas program might truncate columns within the account transaction table. This happens if the customer changes the DDL for the Core data model. The account_transaction_prep code does not synchronize with the column changes in the DDL due to hard-coded length statments.

These hard-coded length statements have been removed from the code.

If there are changes to the exsisting DDL, take the following steps to synchronize the metadata of the account transaction prep table with the header code:

  1. Create the account_transactions_prep using the new account_transactions_prep.sas.
  2. Invoke Scenario Administrator.
  3. Select Create and Edit Headers and click the Next button.
  4. Select account_header and click the Edit... button.
  5. Click the Details... button.

    You will be prompted with the following message:

    "Header columns have been either added to or removed from this header"
  6. Click OK and this will re-synchronize the metadata. It is now safe to run the AGP using the new account_transactions_prep table.

Select the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Money Laundering DetectionMicrosoft Windows 2000 Advanced Server1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Server1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows 2000 Professional1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows NT Workstation1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Enterprise Edition1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows Server 2003 Standard Edition1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Microsoft Windows XP Professional1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
Windows Vista1.41.49.1 TS1M3 SP49.1 TS1M3 SP4
* 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.