The SAS^® Performance Management Solutions 9.2 <cind_dds_10400_load_dimension_type_table> job might fail on systems that were migrated from a SAS Performance Management Solutions 9.1.3 environment.   The SAS Data Integration Studio log will display the error message:

     ERROR: Column VALID_FROM_DTTM could not be found in the table/view 
     identified with the correlation name A.

To correct this problem:

1. Start SAS Data Integration Studio, 
   open the Connection Profile 
   and logon to the SAS Metadata Server.

2. Select Tools > Code Editor.

3. Copy the following code into the Code Editor: 

%startsln(sol);


%bldLibNm(sesetl_sasLibRef=_CIDDS


        , sesetl_OMRSASLibraryObjName=&CrossIndustryDDStier_folder./&CrossIndustryDDSLibObj./&CrossIndustryDDSLibObj


        , sesetl_useType=BASE


        ,  sesetl_validateLib=Y


         ) ;


PROC SQL;


    DROP TABLE _CIDDS.DIMENSION_TYPE_X;


    delete from _CIDDS.DIMENSION_TYPE;


quit;

4. Select Run.

5. After the job has run successfully, close the Code Editor window.

Operating System and Release Information