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.