Seeing in Accounts but not MarketData in Quick Start 8.0
jds711 Aug 9, 2012 4:15 PMRunning through the Quick Start examples again, this time with: teiid 8.1 Beta and Jboss 7.1.1 and have gotten a good deal further. I am able to see and query the instance very nicely! Howver, I only see the 'Accounts' model's table, not the MarketData one, even though the log (included below) seems to show that both loaded just fine. 3 additonal entries appear at the same level as Accounts - SYS, SYSADMIN, and pg_catalog - but not MarketData . Any suggestions?
Startup Log:
Calling "C:\Program Files\Java\jboss-as-7.1.1.Final\bin\standalone.conf.bat"
===============================================================================
JBoss Bootstrap Environment
JBOSS_HOME: C:\Program Files\Java\jboss-as-7.1.1.Final
JAVA: C:\Program Files\Java\jdk1.7.0_05\bin\java
JAVA_OPTS: -XX:+TieredCompilation -Dprogram.name=standalone.bat -Xms64M -Xmx51
2M -XX:MaxPermSize=256M -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.se
rver.gcInterval=3600000 -Djava.net.preferIPv4Stack=true -Dorg.jboss.resolver.war
ning=true -Djboss.modules.system.pkgs=org.jboss.byteman -Djboss.server.default.c
onfig=standalone.xml
===============================================================================
15:40:19,765 INFO [org.jboss.modules] JBoss Modules version 1.1.1.GA
15:40:20,302 INFO [org.jboss.msc] JBoss MSC version 1.0.2.GA
15:40:20,465 INFO [org.jboss.as] JBAS015899: JBoss AS 7.1.1.Final "Brontes" sta
rting
15:40:22,606 INFO [org.jboss.as.server] JBAS015888: Creating http management se
rvice using socket-binding (management-http)
15:40:22,615 INFO [org.xnio] XNIO Version 3.0.3.GA
15:40:22,643 INFO [org.xnio.nio] XNIO NIO Implementation Version 3.0.3.GA
15:40:22,652 INFO [org.jboss.remoting] JBoss Remoting version 3.2.3.GA
15:40:22,705 INFO [org.jboss.as.logging] JBAS011502: Removing bootstrap log han
dlers
15:40:22,727 INFO [org.jboss.as.configadmin] JBAS016200: Activating ConfigAdmin
Subsystem
15:40:22,939 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Po
ol -- 32) JBAS010280: Activating Infinispan subsystem.
15:40:23,054 INFO [org.jboss.as.connector] (MSC service thread 1-1) JBAS010408:
Starting JCA Subsystem (JBoss IronJacamar 1.0.9.Final)
15:40:23,047 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 39) JBAS0
11800: Activating Naming Subsystem
15:40:23,042 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 50)
JBAS015537: Activating WebServices Extension
15:40:23,031 INFO [org.jboss.as.security] (ServerService Thread Pool -- 45) JBA
S013101: Activating Security Subsystem
15:40:23,025 INFO [org.jboss.as.osgi] (ServerService Thread Pool -- 40) JBAS011
940: Activating OSGi Subsystem
15:40:23,015 INFO [org.jboss.as.connector.subsystems.datasources] (ServerServic
e Thread Pool -- 28) JBAS010403: Deploying JDBC-compliant driver class org.h2.Dr
iver (version 1.3)
15:40:23,723 INFO [org.jboss.as.connector.subsystems.datasources] (ServerServic
e Thread Pool -- 28) JBAS010404: Deploying non-JDBC-compliant driver class org.t
eiid.jdbc.TeiidDriver (version 8.1)
15:40:23,727 INFO [org.jboss.as.connector.subsystems.datasources] (ServerServic
e Thread Pool -- 28) JBAS010404: Deploying non-JDBC-compliant driver class org.t
eiid.jdbc.TeiidDriver (version 8.1)
15:40:23,725 INFO [org.jboss.as.naming] (MSC service thread 1-1) JBAS011802: St
arting Naming Service
15:40:23,935 INFO [org.jboss.as.mail.extension] (MSC service thread 1-1) JBAS01
5400: Bound mail session [java:jboss/mail/Default]
15:40:24,151 INFO [org.jboss.ws.common.management.AbstractServerConfig] (MSC se
rvice thread 1-1) JBoss Web Services - Stack CXF Server 4.0.2.GA
15:40:24,157 INFO [org.jboss.as.security] (MSC service thread 1-3) JBAS013100:
Current PicketBox version=4.0.7.Final
15:40:24,465 INFO [org.apache.coyote.http11.Http11Protocol] (MSC service thread
1-2) Starting Coyote HTTP/1.1 on http--0.0.0.0-8080
15:40:25,295 INFO [org.teiid.SECURITY] (ServerService Thread Pool -- 46) TEIID5
0011 Security enabled for transport "jdbc" with security-domain set to teiid-sec
urity
15:40:25,554 INFO [org.teiid.SECURITY] (ServerService Thread Pool -- 46) TEIID5
0011 Security enabled for transport "odbc" with security-domain set to teiid-sec
urity
15:40:26,014 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "access" added.
15:40:26,311 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "db2" added.
15:40:26,444 INFO [org.infinispan.factories.GlobalComponentRegistry] (MSC servi
ce thread 1-3) ISPN000128: Infinispan version: Infinispan 'Brahma' 5.1.2.FINAL
15:40:26,517 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "derby" added.
15:40:26,538 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "file" added.
15:40:26,627 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "h2" added.
15:40:26,675 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "hive" added.
15:40:26,706 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "hsql" added.
15:40:26,741 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "informix" added.
15:40:26,803 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "ingres" added.
15:40:26,834 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "ingres93" added.
15:40:26,881 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "intersystems-cache" added.
15:40:27,011 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "jdbc-ansi" added.
15:40:27,017 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "jdbc-simple" added.
15:40:27,027 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "jpa2" added.
15:40:26,898 INFO [org.jboss.as.clustering.infinispan] (MSC service thread 1-3)
JBAS010281: Started resultset cache from teiid container
15:40:26,887 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service
thread 1-1) JBAS010400: Bound data source [java:/accounts-ds]
15:40:27,073 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "ldap" added.
15:40:27,165 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "loopback" added.
15:40:27,186 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "metamatrix" added.
15:40:27,068 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service
thread 1-2) JBAS010400: Bound data source [java:jboss/datasources/ExampleDS]
15:40:27,158 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50001 Teiid
Engine 8.1.0.Beta2 Started = Thu Aug 09 15:40:27 EDT 2012
15:40:27,225 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "modeshape" added.
15:40:27,231 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50038 Teiid
Embedded transport enabled. Bound to: teiid/queryengine
15:40:27,300 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "mysql" added.
15:40:28,227 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "mysql5" added.
15:40:28,304 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "netezza" added.
15:40:28,323 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "olap" added.
15:40:28,350 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "oracle" added.
15:40:28,373 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "postgresql" added.
15:40:28,388 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "salesforce" added.
15:40:28,391 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50012 Teiid
JDBC - Host = 0.0.0.0, Port = 31000, SSL = OFF, security-domains = [teiid-secu
rity]
15:40:28,423 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50037 Teiid
ODBC - Host = 0.0.0.0, Port = 35432, SSL = OFF, security-domains = [teiid-secu
rity]
15:40:28,427 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "sqlserver" added.
15:40:28,452 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "sybase" added.
15:40:28,474 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "teiid" added.
15:40:28,502 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "teradata" added.
15:40:28,530 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 46) TEIID50
006 Teiid translator "ws" added.
15:40:28,667 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread
1-4) JBAS015012: Started FileSystemDeploymentService for directory C:\Program Fi
les\Java\jboss-as-7.1.1.Final\standalone\deployments
15:40:28,830 INFO [org.jboss.as.remoting] (MSC service thread 1-3) JBAS017100:
Listening on 0.0.0.0/0.0.0.0:4447
15:40:28,815 INFO [org.jboss.as.remoting] (MSC service thread 1-1) JBAS017100:
Listening on /0.0.0.0:9999
15:40:29,137 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBA
S015876: Starting deployment of "portfolio-vdb.xml"
15:40:29,138 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) JBA
S015876: Starting deployment of "teiid-connector-file.rar"
15:40:29,154 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBA
S015876: Starting deployment of "teiid-connector-ws.rar"
15:40:29,146 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBA
S015876: Starting deployment of "teiid-connector-salesforce.rar"
15:40:29,146 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBA
S015876: Starting deployment of "teiid-connector-ldap.rar"
15:40:29,770 WARN [org.jboss.as.dependency.private] (MSC service thread 1-3) JB
AS018567: Deployment "deployment.teiid-connector-salesforce.rar" is using a priv
ate module ("org.apache.cxf:main") which may be changed or removed in future ver
sions without notice.
15:40:29,818 WARN [org.jboss.as.dependency.private] (MSC service thread 1-3) JB
AS018567: Deployment "deployment.teiid-connector-salesforce.rar" is using a priv
ate module ("org.apache.cxf:main") which may be changed or removed in future ver
sions without notice.
15:40:29,784 WARN [org.jboss.as.dependency.private] (MSC service thread 1-1) JB
AS018567: Deployment "deployment.teiid-connector-ws.rar" is using a private modu
le ("org.apache.cxf:main") which may be changed or removed in future versions wi
thout notice.
15:40:29,875 WARN [org.jboss.as.dependency.private] (MSC service thread 1-1) JB
AS018567: Deployment "deployment.teiid-connector-ws.rar" is using a private modu
le ("org.apache.cxf:main") which may be changed or removed in future versions wi
thout notice.
15:40:29,819 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service th
read 1-4) IJ020001: Required license terms for file:/C:/Program%20Files/Java/jbo
ss-as-7.1.1.Final/standalone/tmp/vfs/temp4091ef268504e588/teiid-connector-ldap.r
ar-d26e491acded3f9d/contents/
15:40:30,254 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service th
read 1-1) IJ020001: Required license terms for file:/C:/Program%20Files/Java/jbo
ss-as-7.1.1.Final/standalone/tmp/vfs/temp4091ef268504e588/teiid-connector-file.r
ar-196b2fac162ed468/contents/
15:40:30,481 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service th
read 1-4) IJ020001: Required license terms for file:/C:/Program%20Files/Java/jbo
ss-as-7.1.1.Final/standalone/tmp/vfs/temp4091ef268504e588/teiid-connector-ws.rar
-6947f3460520f74a/contents/
15:40:30,476 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service th
read 1-2) IJ020001: Required license terms for file:/C:/Program%20Files/Java/jbo
ss-as-7.1.1.Final/standalone/tmp/vfs/temp4091ef268504e588/teiid-connector-salesf
orce.rar-1e662f5660cdf11d/contents/
15:40:30,528 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service
thread 1-1) IJ020001: Required license terms for file:/C:/Program%20Files/Java/
jboss-as-7.1.1.Final/standalone/tmp/vfs/temp4091ef268504e588/teiid-connector-fil
e.rar-196b2fac162ed468/contents/
15:40:30,541 INFO [org.jboss.as.deployment.connector] (MSC service thread 1-1)
JBAS010406: Registered connection factory java:/marketdata-file
15:40:30,551 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service
thread 1-1) IJ020002: Deployed: file:/C:/Program%20Files/Java/jboss-as-7.1.1.Fi
nal/standalone/tmp/vfs/temp4091ef268504e588/teiid-connector-file.rar-196b2fac162
ed468/contents/
15:40:30,555 INFO [org.jboss.as.deployment.connector] (MSC service thread 1-1)
JBAS010401: Bound JCA ConnectionFactory [java:/marketdata-file]
15:40:31,036 INFO [org.jboss.as] (MSC service thread 1-2) JBAS015951: Admin con
sole listening on http://0.0.0.0:9990
15:40:31,037 INFO [org.jboss.as] (MSC service thread 1-2) JBAS015874: JBoss AS
7.1.1.Final "Brontes" started in 11906ms - Started 311 of 408 services (95 servi
ces are passive or on-demand)
15:40:31,275 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB D
ynamicPortfolio.1 model "MarketData" metadata is currently being loaded. Start T
ime: 8/9/12 3:40 PM
15:40:31,308 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB D
ynamicPortfolio.1 model "Accounts" metadata is currently being loaded. Start Tim
e: 8/9/12 3:40 PM
15:40:31,324 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB
DynamicPortfolio.1 model "MarketData" metadata loaded. End Time: 8/9/12 3:40 PM
15:40:32,259 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50030 VDB
DynamicPortfolio.1 model "Accounts" metadata loaded. End Time: 8/9/12 3:40 PM
15:40:32,278 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018
559: Deployed "teiid-connector-ws.rar"
15:40:32,279 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018
559: Deployed "teiid-connector-salesforce.rar"
15:40:32,280 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018
559: Deployed "teiid-connector-ldap.rar"
15:40:32,281 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018
559: Deployed "teiid-connector-file.rar"
15:40:32,282 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018
559: Deployed "portfolio-vdb.xml"
15:40:32,311 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB
DynamicPortfolio.1 is set to ACTIVE
15:48:34,072 INFO [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue15) H2Execu
tionFactory Commit=true;DatabaseProductName=H2;DatabaseProductVersion=1.3.161 (2
011-10-28);DriverMajorVersion=1;DriverMajorVersion=3;DriverName=H2 JDBC Driver;D
riverVersion=1.3.161 (2011-10-28);IsolationLevel=2
15:56:21,241 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker5_QueryProcessorQueue11
2) TEIID30013 Loading materialized view table #MAT_PG_CATALOG.PG_CLASS
15:56:21,428 INFO [org.teiid.PROCESSOR.MATVIEWS] (Worker5_QueryProcessorQueue11
2) TEIID30014 Loaded materialized view table #MAT_PG_CATALOG.PG_CLASS with row c
ount 58.