SAP Knowledge Base Article - Preview

2023101 - A system error occurred. Contact the administrator if the error persists (UIM-10142) - Data Insight

Symptom

  • Receive the error when adding a new table to any Information Steward project.
  • Cannot add tables or views to a Data Insight project.
  • Cannot add by name or by browsing the metadata.
  • Can view data on those tables in the browse metadata window, but cannot add the table to the project.
  • Brand new repository, not upgraded, or altered in any way.
  • Primary key constraint.
  • Primary key violation.
  • Error: java.lang.NullPointerException: while trying to invoke the method java.lang.String.equals(java.lang.Object) of an object returned java.SQLException.getSQLState()
  • Error from ApplicationService log:  [E] <date> <time> [ApplicationService][Transport:Shared-7658/56] Executing SQL: INSERT INTO <reponame>.MMT_Ep_Col_Map(ccolumn_id,ctable_id,column_name,display_name,data_type_cd,last_updated) VALUES(<specific values>)
    [E] <date> <time> [ApplicationService][Transport:Shared-7658/56] ORA-00001: unique constraint (<reponame>.MMT_PK_70) violated
    [E] <date> <time> [ApplicationService][Transport:Shared-7658/56] java.sql.BatchUpdateException: ORA-00001: unique constraint (<reponame>.MMT_PK_70) violated
    at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10345)
    at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230)
    at com.bobj.mm.core.sqlimpl.SQLProcessor.executeUpdateImpl(SQLProcessor.java:303)
    at com.bobj.mm.core.MMSqlProcessor.executeUpdate(MMSqlProcessor.java:404)
    at com.bobj.mm.core.sqlimpl.ArrayBinding.persist(ArrayBinding.java:244)
    at com.bobj.mm.core.sqlimpl.ArrayBinding.persist(ArrayBinding.java:234)
    at com.bobj.mm.core.sqlimpl.ArrayBinding.persist(ArrayBinding.java:204)
    at com.bobj.mm.core.sqlimpl.ArrayBindingManager.persist(ArrayBindingManager.java:104)
    at com.bobj.mm.sdk.DBObject.processArrayBinding(DBObject.java:2909)
    at com.sap.icc.sdk.Utility.createDataElementIds(Utility.java:881)
    at com.sap.icc.sdk.connection.internal.RelationalImporter.importTable(RelationalImporter.java:340)
    at com.sap.icc.sdk.connection.internal.RelationalImporter.processTables(RelationalImporter.java:154)
    at com.sap.icc.sdk.connection.internal.RelationalImporter.importDataGroups(RelationalImporter.java:131)
    at com.sap.icc.sdk.connection.internal.DatabaseConnection.importDataGroups(DatabaseConnection.java:135)
    at com.sap.icc.sdk.connection.internal.Connection.importDataGroups(Connection.java:441)
    at com.sap.icc.sdk.connection.internal.Connection.importDataGroups(Connection.java:379)
    at com.sap.icc.sdk.connection.internal.Connection.importDataGroups(Connection.java:280)
    ...


Read more...

Environment

SAP Information Steward 4.2 and later

Product

SAP Information Steward 4.2

Keywords

IS, system error, UIM-10142, add table, DI , KBA , EIM-IS-DI , Information Steward - Data Insight , EIM-IS , Information Steward (Use Subcomponent) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.