Problem Note 41517: Error: Invalid business key defined
The following error message might occur in SAS® Human Capital Management when you open the SCD
Type 2 Loader properties and select any of the tabs in the Properties window.
Error: Invalid business key defined.
Please perform the steps below for each of the following SAS Data Integration Studio jobs to correct this problem.
cind_dds_104700_load_pay_level_structure_table
cind_dds_101000_load_action_type_table
cind_dds_100900_load_action_reason_table
cind_dds_100800_load_absence_type_table
-
Log on to SAS Data Integration Studio as a user
privileged to edit the CrossIndustryDDS jobs.
-
Open the specific job.
-
Select the SCD Type 2 Loader transformation.
-
Right-click and select Properties.
-
In the Properties window, select the Detect Changes
tab.
-
Remove all columns from the Selected Columns selection
list.
-
Select OK to exit the Properties window.
-
Select File->Save to save the job changes.
Operating System and Release Information
| SAS System | SAS Human Capital Management | Microsoft® Windows® for x64 | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 for x64 | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows Server 2008 | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows Server 2008 for x64 | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Microsoft Windows XP Professional | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Windows 7 Enterprise 32 bit | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Windows 7 Enterprise x64 | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Windows 7 Home Premium 32 bit | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Windows 7 Home Premium x64 | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Windows 7 Professional 32 bit | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Windows 7 Professional x64 | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Windows 7 Ultimate 32 bit | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| Windows 7 Ultimate x64 | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| 64-bit Enabled AIX | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| 64-bit Enabled Solaris | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
| HP-UX IPF | 5.1 | 5.2_M1 | 9.2 TS2M2 | 9.2 TS2M2 |
*
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: | medium |
| Date Modified: | 2011-11-09 14:05:44 |
| Date Created: | 2010-11-05 15:04:24 |