KB484050: Manually extend MicroStrategy Enterprise Manager 2020 dimension tables and partitions on Statistics tables beyond the year 2020

Description

Strategy Enterprise Manager 2020 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. 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, 2020. 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:

• DB2
• SQL Server
• Oracle
• Teradata
• MySQL

The scripts extend the partition tables through December 31, 2025.
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. 
If you are using Strategy Enterprise Manager Version 9.x, see KB270405: How to Manually extend MicroStrategy Enterprise Manager version 9.x Date dimension tables and partitions on Statistics tables beyond year 2015.