KB489192: Manually extend Strategy One Enterprise Manager dimension tables and partitions on Statistics tables beyond the year 2025 (from 2026 - 2028)

Description

Strategy One Enterprise Manager contains data dimension tables that are used for various things, including data loading. When using Teradata as an Enterprise Manager Warehouse with no partition tables, you are unable to use dates that go beyond January 31, 2020. You can refer to KB484050 to extend the data dimension tables from year 2020 to year 2025. However you are still unable to use dates that go beyond December 31, 2025 even with the workaround in KB484050. In this case, you receive the following error message:

[CDATA[java.sql.SQLException: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [HY000:-5728: on SQLHANDLE] [Teradata][ODBC Teradata Driver][Teradata Database](-5728)SP_IS_SESSION:Partitioning violation for table XXXXXX.IS_SESSION.]]

For other database platforms, the partition tables and date tables only exist until December 31, 2025. This includes data inside the following date dimension tables: 
 

• DT_DATE
  
  
• DT_QUARTER
  
  
• DT_QUARTER_YTD
  
  
• DT_MONTH
  
  
• DT_MONTH_YTD
  
  
• DT_YEAR
  
  

Solution

Use the following scripts to update the partition tables and/or data dimension tables according to your environment.
Note: Please make a backup of the Enterprise Manager Warehouse before running the scripts:

• DB2.zip
  
  
• SQL Server.zip
  
  
• Oracle.zip
  
  
• Teradata.zip
  
  
• MySQL.zip
  
  

Note: No partition tables exist for MySQL based Enterprise Manager, therefore, the tables do not need to be extended; however, they still need to be updated as partition versus dimension. 
Note: The scripts extend the partition tables through December 31, 2028. This aligns with our strategy that marks the End of Support (EOS) for MEP. For more information on the EOS of MEP, please refer to our Technical Support News Letter.