Symptom
In the phase Run Source Online Migration step, you are getting the error below in the file MTI_SAP_COM~TC~KMC~RF~UMMIG~JMT_ONLINE_ENGINE_MC_XX.ERR.
[TIMESTAMP] com.sap.kmc.component.migration.sap_com_tc_kmc_rf_ummig_jmt.online_engine_mcerr [Thread[main,5,main]] Error: Error while migrating controller com.sap.kmc.component.migration.KMCMapPrincipalsMigrationController. CSN component - EP-KM-MIG . Reason: RMI remote call exception. java.sql.SQLException: error when writing principal mapping table (com.sap.sql.log.OpenSQLException: The SQL statement "INSERT INTO "KMC_UPGRADE_UM" ("EP5NAME","EP5TYPE","UMEID","UMENAME") VALUES (?,?,?,?)" contains the semantics error[s]: - 1:13 - the table or view >>KMC_UPGRADE_UM<< does not exist).
[TIMESTAMP] com.sap.sdt.jmtx.migrationtool [Thread[main,5,main]] Info: Executing migration controller com.sap.kmc.component.migration.KMCMapPrincipalsMigrationController. CSN component for this controller - EP-KM-MIG.
[TIMESTAMP] com.sap.sdt.jmtx.migrationtool [Thread[main,5,main]] Info: Add migration controller migrate.online.engine.data data in JMT data model.
[TIMESTAMP] com.sap.sdt.jmtx.migrationtool [Thread[main,5,main]] Info: The migration controller migrate.online.engine.data data is saved in the JMT data model.
mig_jmt.online_engine_mc [Thread[main,5,main]] Info: Error while migrating controller com.sap.kmc.component.migration.KMCMapPrincipalsMigrationController. CSN component - EP-KM-MIG . Reason: RMI remote call exception. java.sql.SQLException: error when writing principal mapping table (com.sap.sql.log.OpenSQLException: The SQL statement "INSERT INTO "KMC_UPGRADE_UM" ("EP5NAME","EP5TYPE","UMEID","UMENAME") VALUES (?,?,?,?)" contains the semantics error[s]: - 1:13 - the table or view >>KMC_UPGRADE_UM<< does not exist).
Read more...
Environment
- SAP NetWeaver 7.0
- SAP enhancement package 1 for SAP NetWeaver 7.0
- SAP enhancement package 2 for SAP NetWeaver 7.0
Product
Keywords
KM, upgrade, update, system error, table, online upgrade, deployment, deploy, scratch, Knowledge Management, 701, 702 , KBA , EP-KM-MIG , Migrations , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview