Error while loading metadata
sanjeev.gour Aug 14, 2015 3:19 AMWe 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.