Installation Note 41617: CRM_ACCOUNT table is not populated correctly after running Populate ETL03_LOAD_DATAMART_CRM_ACCOUNT job
In the staging job named ETL03_LOAD_DATAMART_CRM_ACCOUNT, the join between the I_CREDIT_RISK_MITIGANT table extract, the I_FINANCIAL_COLLATERAL table, and the I_PRIMARY_CPTY_CR_MITIGANT table is missing a subsetting condition. Without the condition, the resulting table can have too many records.
As a workaround, use the following steps to update the join in the ETL03_LOAD_DATAMART_CRM_ACCOUNT job. These steps assume that you have already installed SAS® Detail Data Store for Banking. They also assume that you have unpackaged the SAS Credit Risk Management for Banking ETL jobs (see "How to Install the ETL Jobs" in the SAS® Credit Risk Management for Banking: Administrator's Guide):
- Open SAS® Data Integration Studio.
- In the Folders Tree, double-click the ETL03_LOAD_DATAMART_CRM_ACCOUNT job name. You can now see the ETL job flow in the Job Editor.
- In the Job Editor, right-click the SQL Join node, and then select Open. The SQL join opens in the Job Editor.
- In the Navigation pane, select the first join. You can now see a table with the join clauses at the left of the Navigation pane.
- Click New to add a row to the table.
- In the second row of the table (which you have just added), select the first Operand column. Then, click the arrow at the right of this field, and select Advanced. The Expression Builder opens.
- Enter NOT MISSING(I_FINANCIAL_COLLATERAL.ACCOUNT_RK) in the Expression Text box. Then, click OK to save the expression to the Operand column.
- In the second row of the table, select the text (an equal sign) in the Operator column, and delete it. The updated Join condition SQL code should read:
I_FINANCIAL_COLLATERAL.FINANCIAL_COLLATERAL_RK = W52YU71V.FINANCIAL_COLLATERAL_RK and NOT MISSING(I_FINANCIAL_COLLATERAL.ACCOUNT_RK)

- Close the ETL03_LOAD_DATAMART_CRM_ACCOUNT -> SQL Join* window. When prompted, select Yes to save your changes.
After you have edited the join condition in this ETL job, continue through the remaining documented steps for ETL Job Deployment in the SAS® Credit Risk Management for Banking: Administrator's Guide.
Operating System and Release Information
| SAS System | SAS Credit Risk Management for Banking | Microsoft® Windows® for x64 | 4.6 | 4.7 | | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.6 | 4.7 | | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.6 | 4.7 | | 9.3 TS1M2 |
| Microsoft Windows Server 2003 Standard Edition | 4.6 | 4.7 | | 9.3 TS1M2 |
| Microsoft Windows Server 2003 for x64 | 4.6 | 4.7 | | 9.3 TS1M2 |
| Microsoft Windows Server 2008 | 4.6 | 4.7 | | 9.3 TS1M2 |
| Microsoft Windows Server 2008 for x64 | 4.6 | 4.7 | | 9.3 TS1M2 |
| Microsoft Windows XP Professional | 4.6 | 4.7 | | 9.3 TS1M2 |
| Windows 7 Enterprise 32 bit | 4.6 | 4.7 | | 9.3 TS1M2 |
| Windows 7 Enterprise x64 | 4.6 | 4.7 | | 9.3 TS1M2 |
| Windows 7 Home Premium 32 bit | 4.6 | 4.7 | | 9.3 TS1M2 |
| Windows 7 Home Premium x64 | 4.6 | 4.7 | | 9.3 TS1M2 |
| Windows 7 Professional 32 bit | 4.6 | 4.7 | | 9.3 TS1M2 |
| Windows 7 Professional x64 | 4.6 | 4.7 | | 9.3 TS1M2 |
| Windows 7 Ultimate 32 bit | 4.6 | 4.7 | | 9.3 TS1M2 |
| Windows 7 Ultimate x64 | 4.6 | 4.7 | | 9.3 TS1M2 |
| Windows Vista | 4.6 | 4.7 | | 9.3 TS1M2 |
| Windows Vista for x64 | 4.6 | 4.7 | | 9.3 TS1M2 |
| 64-bit Enabled AIX | 4.6 | 4.7 | | 9.3 TS1M2 |
| 64-bit Enabled HP-UX | 4.6 | 4.7 | | 9.3 TS1M2 |
| 64-bit Enabled Solaris | 4.6 | 4.7 | | 9.3 TS1M2 |
| HP-UX IPF | 4.6 | 4.7 | | 9.3 TS1M2 |
| Linux | 4.6 | 4.7 | | 9.3 TS1M2 |
| Linux for x64 | 4.6 | 4.7 | | 9.3 TS1M2 |
| Solaris for x64 | 4.6 | 4.7 | | 9.3 TS1M2 |
*
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: | Installation Note |
| Priority: | high |
| Date Modified: | 2010-11-17 15:42:51 |
| Date Created: | 2010-11-17 08:12:57 |