1EEDO519X"DDL Source" "DATABASETABLEALERTQUERY_CDS" could not be activated in SAP

-
Error in ACT_UPG during upgrade from a source release lower than NW 7.5 SP03You perform an upgrade from a source release lower than NW 7.5 SP03, and you encounter in 
phase ACT_UPG DDIC activaton errors such as:

1EEDO519X"DDL Source" "DATABASETABLEALERTQUERY_CDS" could not be activated
1EEDO519 "DDL Source" "DATABASETABLEALERT_CDS" could not be activated
1EEDO519 "DDL Source" "DATABASETABLEQUERYUNION_CDS" could not be activated
1EEDO519 "DDL Source" "DATABASETABLEQUERY_CDS" could not be activated
1EEDO519 "DDL Source" "DATASETSMEMORYAGGREGATION1_CDS" could not be activated
1EEDO519 "DDL Source" "DATASETSMEMORYAGGREGATION2_CDS" could not be activated
1EEDO519 "DDL Source" "DATASETSMEMORYSOURCE1" could not be activated
1EEDO519 "DDL Source" "DATASETSMEMORYSOURCE3" could not be activated
1EEDO519 "DDL Source" "DATASETSMEMORY_CDS" could not be activated
1EEDO519 "DDL Source" "DATASETSTOTALMEMORYSIZE2_CDS" could not be activated
1EEDO519 "DDL Source" "DATASETSTOTALMEMORYSIZES_CDS" could not be activated
1EEDO519 "DDL Source" "DATASETSTOTALMEMORYSIZE_CDS" could not be activated
1EEDO519 "DDL Source" "DATASETSTOTALMEMSIZEAGGR1_CDS" could not be activated
1EEDO519 "DDL Source" "DATASETSTOTALMEMSIZEAGGR2_CDS" could not be activated
1EEDO519 "DDL Source" "DATASETSTOTAL_CDS" could not be activated
1EEDO519 "DDL Source" "STATCURRENTALERT_CDS" could not be activated
1EEDO519 "DDL Source" "STATCURRENTALERT_TABFUNC" could not be activated
1EEDO519 "DDL Source" "STATHOSTCOLMNTABSIZE_TABFUN" could not be activated
1EEDO519 "DDL Source" "STATHOSTCOLMTABSIZE_CDS" could not be activated
1EEDO519 "DDL Source" "SYSTEMTABLEDESCRIPTION" could not be activated
1EEDO519 "DDL Source" "SYSTEMTABLEDESCRIPTION_TABFUNC" could not be activated
1 ETP111 exit code : "8"

As a solution - Repeat the phase ACT_UPG.

Comments

Post a Comment

Popular posts from this blog

SAP Business One Web Client Tiles Not Loading (tiles.svc 500 Internal Server Error)

-
Image
Error: W hile trying to read the field 'bind' of a null object loaded from field com.sap.b1.infra.meta.tile.Tile.action of an object loaded from local variable 'tile" when we are logging into specific company Issue: This issue mainly occurs when adding any web client extension tile to the web client home page and you unassign the extension from the extension manager. Solution: Delete the existing users from the SAP Business One and OUSR table and then recreate the user. Then tiles should load in the Web client.
Read more

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

-
Image
 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...
Read more