Error while loading metadata

[sanjeev.gour]

We are using 8.7 and recently started seeing the below two warnings during the metadata load. This is causing the application startup failure. The application ran fine until recently when several updates were made to the environment, most important of which is a DB2 maintenance that was applied and a IBM Java update, the Java update however has no effect as it worked with updated version in our internal environment.

The data is on the updated DB2 is accessible outside the application and that these table are in fact available. These access is not done using a JDBC driver though. We are looking for some pointers which could lead to this problem, the parameters to look in the customer environment to understand the root cause.

This occurs at a customer site so unfortunately we haven't been able to debug it at code level. From the stack trace it appears that it happens while getting the primary keys.

1.

03 Aug 2015 14:50:43,295 WARN  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2)  TEIID31071 Invalid table; Table SECURITY_CIA_DB2_SHADOWDTA1_CIADB01.ADMNDATA has no columns defined

2.

03 Aug 2015 14:50:39,387 WARN  [com.ca.chorus.teiid.safety.SafetyHarnessExecutionFactory] (teiid-async-threads - 3)  Error on getMetaData call: org.teiid.metadata.MetadataException: TEIID60011 No column found with name RSNCODE

  at org.teiid.metadata.MetadataFactory.assignColumn(MetadataFactory.java:347) [teiid-api-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

  at org.teiid.metadata.MetadataFactory.assignColumns(MetadataFactory.java:455) [teiid-api-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

  at org.teiid.metadata.MetadataFactory.addPrimaryKey(MetadataFactory.java:255) [teiid-api-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

  at org.teiid.translator.jdbc.JDBCMetdataProcessor.getPrimaryKeys(JDBCMetdataProcessor.java:446)

  at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:131)

  at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:309)

  at com.ca.chorus.db2.security.translator.DB2SecurityExecutionFactory.getMetadata(DB2SecurityExecutionFactory.java:227)

  at com.ca.chorus.db2.security.translator.DB2SecurityExecutionFactory.getMetadata(DB2SecurityExecutionFactory.java:29)

  at org.teiid.translator.BaseDelegatingExecutionFactory.getMetadata(BaseDelegatingExecutionFactory.java:127) [teiid-api-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

  at com.ca.chorus.teiid.safety.SafetyHarnessExecutionFactory.getMetadata(SafetyHarnessExecutionFactory.java:175)

  at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:73) [teiid-engine-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

  at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

  at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

  at org.teiid.jboss.VDBService$7.run(VDBService.java:442) [teiid-jboss-integration-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]

  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1157) [rt.jar:1.7.0]

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:627) [rt.jar:1.7.0]

  at java.lang.Thread.run(Thread.java:798) [vm.jar:1.7.0]

  at org.jboss.threads.JBossThread.run(JBossThread.java:122)

Thanks.

Sanjeev.

[shawkins]

> These access is not done using a JDBC driver though.

You'll need to compare ideally using the same driver with the same account.

> 03 Aug 2015 14:50:43,295 WARN  [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2)  TEIID31071 Invalid table; Table SECURITY_CIA_DB2_SHADOWDTA1_CIADB01.ADMNDATA has no columns defined

If this table is not needed, then it could be excluded from import.  Otherwise you'd have to see if DatabaseMetaData.getColumns returns anything for that table.  If it does, then there is an issue with the import logic.  If not, then there is a permission issue or the table should be excluded.

> 03 Aug 2015 14:50:39,387 WARN  [com.ca.chorus.teiid.safety.SafetyHarnessExecutionFactory] (teiid-async-threads - 3)  Error on getMetaData call: org.teiid.metadata.MetadataException: TEIID60011 No column found with name RSNCODE

Similarly you'll need to see what DatabaseMetaData.getColumns is exposing here for the table here.  Unfortunately the message does not include the table name, so we should make a change on the Teiid side so that's clear.

[sanjeev.gour]

Thanks Steve, will run these diagnostics and see how it goes.