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 , Bug Filed

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.