SAP Business One Company Initialization Error SAP DBTech JDBC: [259]: invalid table name: Could not find table/view M_TIME_DIMENSION in schema _SYS_BI

 Error: 

2022-04-29 11:03:39|ERROR|ENABLEMENT|Failed to re-initialize company :module id=Hana Model Deployer; cause:com.sap.businessone.model.renew.exception.ModelException: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259]: invalid table name:  Could not find table/view M_TIME_DIMENSION in schema _SYS_BI: line 4 col 14 (at pos 99)|

2022-04-29 11:03:38|ERROR|MODEL_DEPLOYMENT|Failed to execute sql statement: Create View Next6MonthEndView as

Select Top 6 Year, Month, Max(Date_SQL) as MonthEnd

From _SYS_BI.M_TIME_DIMENSION

Where Date_SAP <= Last_Day(Add_Months(Add_Days(CURRENT_DATE, 1-DayOfMonth(CURRENT_DATE)), 6))

and Date_Sql >Last_Day(CURRENT_DATE)

Group By Year , Month

Order By Year Desc, Month Desc, root cause: SAP DBTech JDBC: [259]: invalid table name:  Could not find table/view M_TIME_DIMENSION in schema _SYS_BI: line 4 col 14 (at pos 99)|

Solution:

•  Login to HANA studio 
• Run the below Query from SYSTEM, B1ADMIN and SYSTEM DB user

    select * from _SYS_BI.M_TIME_DIMENSION; 

M_TIME_DIMENSIONS table is deleted from the _SYS_BI schema it is present in the SYSTEMDB 

Can also refer to the below note

 https://launchpad.support.sap.com/#/notes/2212872