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.
SAP Knowledge Base Article - Preview