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
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.