Problem Note 18531: Solutions Repository - ERROR: Failed to create metric table
If you are using SAS Financial Management 4.2, SAS Human Capital
Management 4.2 or SAS Strategic Performance Management 2.2, and there
has been an upgrade of SAS Data Integration Studio 3.3 to 3.4, the
upgrade will cause the Metric Tables to fail.
For example: If you are attempting to Export as Measure using SAS
Financial Management you will receive the following ERROR:
ERROR [MeasureExportManagerBean]
com.sas.solutions.finance.models.FinanceServerException: Failed to
create metric table
The upgrade overrides the TreeType of Metric Tables from MetricTables to
BIP Folder. For the solutions, this treetype is being used as a subset
to determine tables identified as Metric Tables. The upgrade changes
the type in the BIP tree metadata which causes problems in the Solutions
Repositories.
If there has been an upgrade to SAS Data Inegration Studio 3.4,
you will need to run this code to restore the BIP tree metadata to
the pre-upgrade status. The code to restore this can be found here:
link ftp://ftp.sas.com/techsup/download/sasnotes/
SAS_Solutions_dottwo_DI_Studio_34.zip
The instructions for upgrading to Data Integration Studio 3.4 with the
solutions can be found here:
ftp://ftp.sas.com/techsup/download/sasnotes/Upgrade_to_DI_Studio_3.4_Dot
2.doc
A fix for this issue is available at:
http://www.sas.com/techsup/download/hotfix/dis34.html#018531
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS Strategic Performance Management | Microsoft Windows XP Professional | 1.2 | |
| Microsoft Windows NT Workstation | 1.2 | |
| Microsoft Windows Server 2003 Standard Edition | 1.2 | |
| Microsoft Windows Server 2003 Enterprise Edition | 1.2 | |
| Microsoft Windows Server 2003 Datacenter Edition | 1.2 | |
| Microsoft Windows 2000 Server | 1.2 | |
| Microsoft Windows 2000 Professional | 1.2 | |
| Microsoft Windows 2000 Datacenter Server | 1.2 | |
| Microsoft Windows 2000 Advanced Server | 1.2 | |
| SAS System | SAS Financial Management | Microsoft Windows NT Workstation | 1.2 | |
| Microsoft Windows XP Professional | 1.2 | |
| Microsoft Windows Server 2003 Enterprise Edition | 1.2 | |
| Microsoft Windows Server 2003 Standard Edition | 1.2 | |
| Microsoft Windows Server 2003 Datacenter Edition | 1.2 | |
| Microsoft Windows 2000 Server | 1.2 | |
| Microsoft Windows 2000 Professional | 1.2 | |
| Microsoft Windows 2000 Datacenter Server | 1.2 | |
| Microsoft Windows 2000 Advanced Server | 1.2 | |
*
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: | high |
| Date Modified: | 2006-10-19 14:49:11 |
| Date Created: | 2006-09-15 13:25:27 |