-
1. Re: Problem displaying date
shawkins Apr 18, 2017 11:28 AM (in response to cristopher.torres)There's not quite enough there to see what is happening. Can you confirm if the generated sql is correct?
-
2. Re: Problem displaying date
cristopher.torres Apr 18, 2017 11:49 AM (in response to shawkins)It's correct, I just applied a select * from to the table.
I even tested both a table consisting of two fonts and single tables without having integrated with any other source and the error is the same.
-
3. Re: Problem displaying date
shawkins Apr 18, 2017 12:47 PM (in response to cristopher.torres)Can you provide the full stacktrace?
-
4. Re: Problem displaying date
cristopher.torres Apr 19, 2017 11:25 AM (in response to shawkins)Ok, I am reviewing the data in the Database Developer and this is what I see when viewing the data:
10:05:59,214 INFO [org.jboss.modules] (main) JBoss Modules version 1.2.2.Final-redhat-1
10:05:59,354 INFO [org.jboss.msc] (main) JBoss MSC version 1.0.4.GA-redhat-1
10:05:59,417 INFO [org.jboss.as] (MSC service thread 1-6) JBAS015899: JBoss EAP 6.1.1.GA (AS 7.2.1.Final-redhat-10) iniciando
10:06:00,212 INFO [org.xnio] (MSC service thread 1-3) XNIO Version 3.0.7.GA-redhat-1
10:06:00,212 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS015888: Creando el servicio de administración http utilizando el enlace de socket (management-http)
10:06:00,213 INFO [org.xnio.nio] (MSC service thread 1-3) XNIO NIO Implementation Version 3.0.7.GA-redhat-1
10:06:00,213 INFO [org.jboss.remoting] (MSC service thread 1-3) JBoss Remoting version 3.2.16.GA-redhat-1
10:06:00,245 INFO [org.jboss.as.configadmin] (ServerService Thread Pool -- 28) JBAS016200: Activando el sub-sistema ConfigAdmin
10:06:00,245 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 33) JBAS010280: Activando el sub-sistema Infinispan.
10:06:00,260 INFO [org.jboss.as.security] (ServerService Thread Pool -- 46) JBAS013171: Activando el sub-sistema de seguridad
10:06:00,260 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 40) JBAS011800: Activando el sub-sistema de nombrado
10:06:00,260 INFO [org.jboss.as.jsf] (ServerService Thread Pool -- 51) JBAS012605: Se activaron las siguientes implementaciones JSF: [main, 1.2]
10:06:00,276 INFO [org.jboss.as.osgi] (ServerService Thread Pool -- 41) JBAS011906: Activando el Sub-sistema OSGI
10:06:00,276 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 52) JBAS015537: Activando WebServices Extension
10:06:00,291 INFO [org.jboss.as.security] (MSC service thread 1-16) JBAS013170: Versión PicketBox actual=4.0.17.SP2-redhat-2
10:06:00,307 INFO [org.jboss.as.connector.logging] (MSC service thread 1-14) JBAS010408: Iniciando JCA sub-sistema (IronJacamar 1.0.19.Final-redhat-2)
10:06:00,369 INFO [org.jboss.as.naming] (MSC service thread 1-4) JBAS011802: Iniciando el servicio de nombrado
10:06:00,401 INFO [org.jboss.as.mail.extension] (MSC service thread 1-4) JBAS015400: Sesión de correo enlazada [java:jboss/mail/Default]
10:06:00,463 INFO [org.jboss.ws.common.management] (MSC service thread 1-10) JBWS022052: Starting JBoss Web Services - Stack CXF Server 4.1.4.Final-redhat-7
10:06:00,525 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 29) JBAS010403: Implementación del controlador que cumple con los requerimientos de JDBC class org.h2.Driver (versión 1.3)
10:06:00,525 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 29) JBAS010404: Implementación de controladro que no cumple con los requerimientos de JDBC class org.teiid.jdbc.TeiidDriver (versión 8.2)
10:06:00,525 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 29) JBAS010404: Implementación de controladro que no cumple con los requerimientos de JDBC class org.teiid.jdbc.TeiidDriver (versión 8.2)
10:06:00,666 INFO [org.teiid.SECURITY] (ServerService Thread Pool -- 47) TEIID50011 Security enabled for transport "jdbc" with security-domain set to teiid-security
10:06:00,666 INFO [org.teiid.SECURITY] (ServerService Thread Pool -- 47) TEIID50011 Security enabled for transport "odbc" with security-domain set to teiid-security
10:06:00,728 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "access" added.
10:06:00,728 INFO [org.apache.coyote.http11] (MSC service thread 1-1) JBWEB003001: Coyote HTTP/1.1 initializing on : http-localhost/127.0.0.1:8080
10:06:00,728 INFO [org.apache.coyote.http11] (MSC service thread 1-1) JBWEB003000: Coyote HTTP/1.1 starting on: http-localhost/127.0.0.1:8080
10:06:00,759 INFO [org.infinispan.factories.GlobalComponentRegistry] (ServerService Thread Pool -- 54) ISPN000128: Infinispan version: Infinispan 'Delirium' 5.2.7.Final
10:06:00,759 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "db2" added.
10:06:00,806 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "derby" added.
10:06:00,822 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "file" added.
10:06:00,837 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "google-spreadsheet" added.
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-11) JBAS010400: Fuente de datos enlazados [java:/VirtualBD]
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-11) JBAS010400: Fuente de datos enlazados [java:/bdvirt225]
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-11) JBAS010400: Fuente de datos enlazados [java:/sqlypgV]
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-12) JBAS010400: Fuente de datos enlazados [java:/psgmodelVirtual]
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-3) JBAS010400: Fuente de datos enlazados [java:/BDVPruebaTC]
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-3) JBAS010400: Fuente de datos enlazados [java:jboss/datasources/ExampleDS]
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-9) JBAS010400: Fuente de datos enlazados [java:/dataVirtual]
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-12) JBAS010400: Fuente de datos enlazados [java:/vistapo3]
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-9) JBAS010400: Fuente de datos enlazados [java:/proy2]
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-8) JBAS010400: Fuente de datos enlazados [java:/BDVVisionComp]
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-12) JBAS010400: Fuente de datos enlazados [java:/BDVTablaConjunta]
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-12) JBAS010400: Fuente de datos enlazados [java:/BDVTablaConjunta1]
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-3) JBAS010400: Fuente de datos enlazados [java:/tablaUnica]
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-8) JBAS010400: Fuente de datos enlazados [java:/BDVD]
10:06:00,853 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-9) JBAS010400: Fuente de datos enlazados [java:/virtualBD]
10:06:00,884 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "h2" added.
10:06:00,884 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "hive" added.
10:06:00,915 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "hsql" added.
10:06:00,931 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "infinispan-cache" added.
10:06:00,947 INFO [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 56) ISPN000031: MBeans were successfully registered to the platform MBean server.
10:06:00,947 INFO [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 54) ISPN000031: MBeans were successfully registered to the platform MBean server.
10:06:00,947 INFO [org.infinispan.jmx.CacheJmxRegistration] (ServerService Thread Pool -- 55) ISPN000031: MBeans were successfully registered to the platform MBean server.
10:06:00,947 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 55) JBAS010281: Inició resultset caché del contenedor teiid
10:06:00,947 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 56) JBAS010281: Inició resultset-repl caché del contenedor teiid
10:06:00,947 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 54) JBAS010281: Inició preparedplan caché del contenedor teiid
10:06:00,962 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "informix" added.
10:06:00,978 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "ingres" added.
10:06:01,009 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "ingres93" added.
10:06:01,040 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "intersystems-cache" added.
10:06:01,040 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "jdbc-ansi" added.
10:06:01,040 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "jdbc-simple" added.
10:06:01,040 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "jpa2" added.
10:06:01,056 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "ldap" added.
10:06:01,056 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "loopback" added.
10:06:01,056 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "map-cache" added.
10:06:01,087 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "metamatrix" added.
10:06:01,134 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "modeshape" added.
10:06:01,165 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "mysql" added.
10:06:01,181 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "mysql5" added.
10:06:01,212 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "netezza" added.
10:06:01,212 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "olap" added.
10:06:01,243 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "oracle" added.
10:06:01,243 INFO [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50001 Teiid Engine 8.2.0.Final Started = Wed Apr 19 10:06:01 COT 2017
10:06:01,243 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50038 Teiid Embedded transport enabled. Bound to: teiid/queryengine
10:06:01,275 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "postgresql" added.
10:06:01,275 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "salesforce" added.
10:06:01,291 INFO [org.teiid.RUNTIME] (MSC service thread 1-13) TEIID50012 Teiid JDBC - Host = localhost, Port = 31000, SSL = OFF, security-domains = [teiid-security]
10:06:01,291 INFO [org.teiid.RUNTIME] (MSC service thread 1-10) TEIID50037 Teiid ODBC - Host = localhost, Port = 35432, SSL = OFF, security-domains = [teiid-security]
10:06:01,306 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "sqlserver" added.
10:06:01,322 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "sybase" added.
10:06:01,338 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "teiid" added.
10:06:01,353 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "teradata" added.
10:06:01,369 INFO [org.teiid.RUNTIME] (ServerService Thread Pool -- 47) TEIID50006 Teiid translator "ws" added.
10:06:01,384 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-1) JBAS015012: Inició FileSystemDeploymentService para el directorio C:\Users\fliorti0\Documents\DataVirtualization\jboss-eap-6.1\standalone\deployments
10:06:01,400 INFO [org.jboss.as.remoting] (MSC service thread 1-11) JBAS017100: Escuchando en 127.0.0.1:9999
10:06:01,400 INFO [org.jboss.as.remoting] (MSC service thread 1-3) JBAS017100: Escuchando en 127.0.0.1:4447
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-13) JBAS015876: Iniciando la implementación de teiid-connector-infinispan.rar" (runtime-name: "teiid-connector-infinispan.rar")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Iniciando la implementación de JDBC.4.10.JC8DE.jar" (runtime-name: "JDBC.4.10.JC8DE.jar")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-11) JBAS015876: Iniciando la implementación de VirtualVistaReportes.vdb" (runtime-name: "VirtualVistaReportes.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015876: Iniciando la implementación de bdvirt225.vdb" (runtime-name: "bdvirt225.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-16) JBAS015876: Iniciando la implementación de vistapo3.vdb" (runtime-name: "vistapo3.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-12) JBAS015876: Iniciando la implementación de postgresql-8.4-703.jdbc4.jar" (runtime-name: "postgresql-8.4-703.jdbc4.jar")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-15) JBAS015876: Iniciando la implementación de BDVTablaConjunta1.vdb" (runtime-name: "BDVTablaConjunta1.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-9) JBAS015876: Iniciando la implementación de VirtualBD.vdb" (runtime-name: "VirtualBD.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015876: Iniciando la implementación de psgmodelVirtual.vdb" (runtime-name: "psgmodelVirtual.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015876: Iniciando la implementación de VDBpsg.vdb" (runtime-name: "VDBpsg.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Iniciando la implementación de teiid-connector-ldap.rar" (runtime-name: "teiid-connector-ldap.rar")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) JBAS015876: Iniciando la implementación de teiid-connector-google.rar" (runtime-name: "teiid-connector-google.rar")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Iniciando la implementación de BDVTablaConjunta.vdb" (runtime-name: "BDVTablaConjunta.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) JBAS015876: Iniciando la implementación de proy2.vdb" (runtime-name: "proy2.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-14) JBAS015876: Iniciando la implementación de JDBC.4.10.JC8DE (1).jar" (runtime-name: "JDBC.4.10.JC8DE (1).jar")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Iniciando la implementación de teiid-connector-file.rar" (runtime-name: "teiid-connector-file.rar")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-15) JBAS015876: Iniciando la implementación de setup.jar" (runtime-name: "setup.jar")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015876: Iniciando la implementación de BDVVisionComp.vdb" (runtime-name: "BDVVisionComp.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Iniciando la implementación de sqlypgV.vdb" (runtime-name: "sqlypgV.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015876: Iniciando la implementación de virtualBD.vdb" (runtime-name: "virtualBD.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015876: Iniciando la implementación de BDVD.vdb" (runtime-name: "BDVD.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-14) JBAS015876: Iniciando la implementación de teiid-connector-ws.rar" (runtime-name: "teiid-connector-ws.rar")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) JBAS015876: Iniciando la implementación de sqljdbc4.jar" (runtime-name: "sqljdbc4.jar")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-8) JBAS015876: Iniciando la implementación de teiid-connector-salesforce.rar" (runtime-name: "teiid-connector-salesforce.rar")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Iniciando la implementación de ifxjdbc (1).jar" (runtime-name: "ifxjdbc (1).jar")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-15) JBAS015876: Iniciando la implementación de BDVPruebaTC.vdb" (runtime-name: "BDVPruebaTC.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015876: Iniciando la implementación de jdbc-4.10.6.20151104.jar" (runtime-name: "jdbc-4.10.6.20151104.jar")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-9) JBAS015876: Iniciando la implementación de tablaUnica.vdb" (runtime-name: "tablaUnica.vdb")
10:06:01,400 INFO [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Iniciando la implementación de dataVirtual.vdb" (runtime-name: "dataVirtual.vdb")
10:06:01,681 WARN [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015852: No se pudo poner un índice a la clase com/zerog/ia/designer/wizard/WNewFile.class en /C:/Users/fliorti0/Documents/DataVirtualization/jboss-eap-6.1/bin/content/setup.jar: java.io.IOException: Invalid Magic
at org.jboss.jandex.Indexer.verifyMagic(Indexer.java:389) [jandex-1.0.3.Final-redhat-2.jar:1.0.3.Final-redhat-2]
at org.jboss.jandex.Indexer.index(Indexer.java:630) [jandex-1.0.3.Final-redhat-2.jar:1.0.3.Final-redhat-2]
at org.jboss.as.server.deployment.annotation.ResourceRootIndexer.indexResourceRoot(ResourceRootIndexer.java:100) [jboss-as-server-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
at org.jboss.as.server.deployment.annotation.AnnotationIndexProcessor.deploy(AnnotationIndexProcessor.java:51) [jboss-as-server-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
at org.jboss.as.server.deployment.DeploymentUnitPhaseService.start(DeploymentUnitPhaseService.java:120) [jboss-as-server-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.7.0_79]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.7.0_79]
at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_79]
10:06:01,868 WARN [org.jboss.as.dependency.unsupported] (MSC service thread 1-7) JBAS018568: La implementación "deployment.teiid-connector-infinispan.rar" está utilizando un módulo no soportado ("org.infinispan:main"), el cual se puede cambiar o borrar en versiones futuras sin previo aviso.
10:06:01,868 WARN [org.jboss.as.dependency.private] (MSC service thread 1-7) JBAS018567: La implementación "deployment.teiid-connector-infinispan.rar" está utilizando un módulo privado ("org.infinispan.client.hotrod:main"), el cual se puede cambiar o borrar en versiones futuras sin previo aviso.
10:06:01,868 WARN [org.jboss.as.dependency.private] (MSC service thread 1-7) JBAS018567: La implementación "deployment.teiid-connector-infinispan.rar" está utilizando un módulo privado ("org.infinispan.cachestore.remote:main"), el cual se puede cambiar o borrar en versiones futuras sin previo aviso.
10:06:01,868 WARN [org.jboss.as.dependency.private] (MSC service thread 1-7) JBAS018567: La implementación "deployment.teiid-connector-infinispan.rar" está utilizando un módulo privado ("org.jboss.as.clustering.infinispan:main"), el cual se puede cambiar o borrar en versiones futuras sin previo aviso.
10:06:01,868 WARN [org.jboss.as.dependency.unsupported] (MSC service thread 1-7) JBAS018568: La implementación "deployment.teiid-connector-infinispan.rar" está utilizando un módulo no soportado ("org.infinispan:main"), el cual se puede cambiar o borrar en versiones futuras sin previo aviso.
10:06:01,868 WARN [org.jboss.as.dependency.private] (MSC service thread 1-7) JBAS018567: La implementación "deployment.teiid-connector-infinispan.rar" está utilizando un módulo privado ("org.infinispan.client.hotrod:main"), el cual se puede cambiar o borrar en versiones futuras sin previo aviso.
10:06:01,868 WARN [org.jboss.as.dependency.private] (MSC service thread 1-7) JBAS018567: La implementación "deployment.teiid-connector-infinispan.rar" está utilizando un módulo privado ("org.infinispan.cachestore.remote:main"), el cual se puede cambiar o borrar en versiones futuras sin previo aviso.
10:06:01,868 WARN [org.jboss.as.dependency.private] (MSC service thread 1-7) JBAS018567: La implementación "deployment.teiid-connector-infinispan.rar" está utilizando un módulo privado ("org.jboss.as.clustering.infinispan:main"), el cual se puede cambiar o borrar en versiones futuras sin previo aviso.
10:06:01,962 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-12) JBAS010403: Implementación del controlador que cumple con los requerimientos de JDBC class com.informix.jdbc.IfxDriver (versión 3.70)
10:06:01,962 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-11) JBAS010404: Implementación de controladro que no cumple con los requerimientos de JDBC class org.postgresql.Driver (versión 8.4)
10:06:01,977 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-13) JBAS010403: Implementación del controlador que cumple con los requerimientos de JDBC class com.microsoft.sqlserver.jdbc.SQLServerDriver (versión 3.0)
10:06:02,055 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-2) IJ020001: Required license terms for file:/C:/Users/fliorti0/Documents/DataVirtualization/jboss-eap-6.1/standalone/tmp/vfs/tempdf5845a58b60a3/teiid-connector-ws.rar-df409e2f0f4567b5/contents/
10:06:02,055 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-10) IJ020001: Required license terms for file:/C:/Users/fliorti0/Documents/DataVirtualization/jboss-eap-6.1/standalone/tmp/vfs/tempdf5845a58b60a3/teiid-connector-salesforce.rar-9e0a3cb2fd10f774/contents/
10:06:02,055 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-7) IJ020001: Required license terms for file:/C:/Users/fliorti0/Documents/DataVirtualization/jboss-eap-6.1/standalone/tmp/vfs/tempdf5845a58b60a3/teiid-connector-file.rar-1bbcc113e0606f37/contents/
10:06:02,055 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-8) IJ020001: Required license terms for file:/C:/Users/fliorti0/Documents/DataVirtualization/jboss-eap-6.1/standalone/tmp/vfs/tempdf5845a58b60a3/teiid-connector-google.rar-cc7c9ab8333fb6f3/contents/
10:06:02,055 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-6) IJ020001: Required license terms for file:/C:/Users/fliorti0/Documents/DataVirtualization/jboss-eap-6.1/standalone/tmp/vfs/tempdf5845a58b60a3/teiid-connector-ldap.rar-a32be2b947755709/contents/
10:06:02,055 INFO [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/C:/Users/fliorti0/Documents/DataVirtualization/jboss-eap-6.1/standalone/tmp/vfs/tempdf5845a58b60a3/teiid-connector-infinispan.rar-9742e271cbe8b8fc/contents/
10:06:02,055 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-14) JBAS010400: Fuente de datos enlazados [java:/SQLConnect]
10:06:02,055 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-4) JBAS010400: Fuente de datos enlazados [java:/New_SQL_Server]
10:06:02,055 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-14) JBAS010400: Fuente de datos enlazados [java:/csql1]
10:06:02,071 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-14) JBAS010400: Fuente de datos enlazados [java:/table225]
10:06:02,071 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-14) JBAS010400: Fuente de datos enlazados [java:/ConectividadFuente]
10:06:02,071 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-14) JBAS010400: Fuente de datos enlazados [java:/conexionNuevaInfor]
10:06:02,071 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-14) JBAS010400: Fuente de datos enlazados [java:/table165]
10:06:02,071 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-14) JBAS010400: Fuente de datos enlazados [java:/PREVIEW_3300ae31-c667-48e6-ad88-7bc22250d4bb_TeiidProyecto_sources_conexionNuevaInfor]
10:06:02,071 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-14) JBAS010400: Fuente de datos enlazados [java:/PREVIEW_3300ae31-c667-48e6-ad88-7bc22250d4bb_TeiidProyecto_sources_table225]
10:06:02,071 INFO [org.jboss.osgi.framework] (MSC service thread 1-14) JBOSGI011006: OSGi Framework - 2.1.0.Final-redhat-1
10:06:02,071 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-13) JBAS010400: Fuente de datos enlazados [java:/New_Informix]
10:06:02,071 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-13) JBAS010400: Fuente de datos enlazados [java:/connectInfor01]
10:06:02,071 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-13) JBAS010400: Fuente de datos enlazados [java:/tblapeseg]
10:06:02,102 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-6) JBAS010400: Fuente de datos enlazados [java:/psg2]
10:06:02,102 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Fuente de datos enlazados [java:/pcpg1]
10:06:02,102 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Fuente de datos enlazados [java:/New_PostgreSQL]
10:06:02,102 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Fuente de datos enlazados [java:/myDataBase]
10:06:02,102 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Fuente de datos enlazados [java:/PruebaTrabajador]
10:06:02,102 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Fuente de datos enlazados [java:/post1]
10:06:02,102 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Fuente de datos enlazados [java:/DataBase]
10:06:02,102 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Fuente de datos enlazados [java:/MySegundoProyDecente]
10:06:02,102 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Fuente de datos enlazados [java:/PruebaPersona]
10:06:02,102 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Fuente de datos enlazados [java:/psg1]
10:06:02,102 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Fuente de datos enlazados [java:/PruebaCentralRiesgo]
10:06:02,102 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Fuente de datos enlazados [java:/post2]
10:06:02,102 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020001: Required license terms for file:/C:/Users/fliorti0/Documents/DataVirtualization/jboss-eap-6.1/standalone/tmp/vfs/tempdf5845a58b60a3/teiid-connector-file.rar-1bbcc113e0606f37/contents/
10:06:02,102 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-10) IJ020001: Required license terms for file:/C:/Users/fliorti0/Documents/DataVirtualization/jboss-eap-6.1/standalone/tmp/vfs/tempdf5845a58b60a3/teiid-connector-file.rar-1bbcc113e0606f37/contents/
10:06:02,118 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-10) JBAS010406: Fábrica de conexiones registrada java:/SourceModel
10:06:02,118 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-1) JBAS010406: Fábrica de conexiones registrada java:/PREVIEW_ffe2666e-3f04-415e-bdff-00f7230d5ef3_MyfirstProject_sources_SourceModel
10:06:02,118 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-10) IJ020002: Deployed: file:/C:/Users/fliorti0/Documents/DataVirtualization/jboss-eap-6.1/standalone/tmp/vfs/tempdf5845a58b60a3/teiid-connector-file.rar-1bbcc113e0606f37/contents/
10:06:02,133 INFO [org.jboss.as.connector.deployers.RaXmlDeployer] (MSC service thread 1-1) IJ020002: Deployed: file:/C:/Users/fliorti0/Documents/DataVirtualization/jboss-eap-6.1/standalone/tmp/vfs/tempdf5845a58b60a3/teiid-connector-file.rar-1bbcc113e0606f37/contents/
10:06:02,554 INFO [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50029 VDB BDVTablaConjunta1.1 model "TablaConjunta" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,554 INFO [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50029 VDB BDVTablaConjunta1.1 model "table225" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,554 INFO [org.teiid.RUNTIME] (MSC service thread 1-13) TEIID50029 VDB VirtualBD.1 model "union" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,555 INFO [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50029 VDB BDVTablaConjunta1.1 model "tbcla" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,555 INFO [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50029 VDB BDVTablaConjunta1.1 model "tblapeseg" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,555 INFO [org.teiid.RUNTIME] (MSC service thread 1-5) TEIID50029 VDB BDVTablaConjunta1.1 model "tbape" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,555 INFO [org.teiid.RUNTIME] (MSC service thread 1-11) TEIID50029 VDB BDVPruebaTC.1 model "tbmov" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,555 INFO [org.teiid.RUNTIME] (MSC service thread 1-11) TEIID50029 VDB BDVPruebaTC.1 model "table165" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,587 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-11) JBAS010401: JCA enlazado ConnectionFactory [java:/SourceModel]
10:06:02,587 INFO [org.jboss.as.connector.deployment] (MSC service thread 1-11) JBAS010401: JCA enlazado ConnectionFactory [java:/PREVIEW_ffe2666e-3f04-415e-bdff-00f7230d5ef3_MyfirstProject_sources_SourceModel]
10:06:02,587 INFO [org.teiid.RUNTIME] (MSC service thread 1-13) TEIID50029 VDB VirtualBD.1 model "PruebaCentralRiesgo" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,587 INFO [org.teiid.RUNTIME] (MSC service thread 1-13) TEIID50029 VDB VirtualBD.1 model "PruebaPersona" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,587 INFO [org.teiid.RUNTIME] (MSC service thread 1-13) TEIID50029 VDB VirtualBD.1 model "PruebaTrabajador" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,602 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50029 VDB VDBpsg.1 model "psgmodel4" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,602 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50029 VDB VDBpsg.1 model "psgmodel3" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,602 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50029 VDB VDBpsg.1 model "psg1" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,602 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50029 VDB VDBpsg.1 model "psgmodel1" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,602 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50029 VDB VDBpsg.1 model "psgmodel2" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,602 INFO [org.teiid.RUNTIME] (MSC service thread 1-15) TEIID50029 VDB VDBpsg.1 model "psg2" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,618 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB BDVTablaConjunta.1 model "TablaConjunta" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,618 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB BDVTablaConjunta.1 model "table225" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,618 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB BDVTablaConjunta.1 model "tbcla" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,618 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB BDVTablaConjunta.1 model "tbmov" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,618 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB BDVTablaConjunta.1 model "table165" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,618 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB BDVTablaConjunta.1 model "tbape" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,618 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50029 VDB BDVTablaConjunta.1 model "tblapeseg" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,618 INFO [org.teiid.RUNTIME] (MSC service thread 1-9) TEIID50029 VDB sqlypgV.1 model "pcpg2" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,618 INFO [org.teiid.RUNTIME] (MSC service thread 1-9) TEIID50029 VDB sqlypgV.1 model "csql2" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,618 INFO [org.teiid.RUNTIME] (MSC service thread 1-9) TEIID50029 VDB sqlypgV.1 model "sqlypg" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,618 INFO [org.teiid.RUNTIME] (MSC service thread 1-9) TEIID50029 VDB sqlypgV.1 model "pcpg1" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,618 INFO [org.teiid.RUNTIME] (MSC service thread 1-9) TEIID50029 VDB sqlypgV.1 model "csql1" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,633 INFO [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50029 VDB bdvirt225.1 model "connectInfor01" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,633 INFO [org.teiid.RUNTIME] (MSC service thread 1-7) TEIID50029 VDB bdvirt225.1 model "modelo225" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,633 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB dataVirtual.1 model "New_SQL_Server" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,633 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB dataVirtual.1 model "SQLConnect" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,633 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB dataVirtual.1 model "unit" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,696 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50029 VDB proy2.1 model "myDataBase" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,696 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50029 VDB proy2.1 model "proy2" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,696 INFO [org.teiid.RUNTIME] (MSC service thread 1-10) TEIID50029 VDB vistapo3.1 model "po3" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,696 INFO [org.teiid.RUNTIME] (MSC service thread 1-10) TEIID50029 VDB vistapo3.1 model "po2" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,696 INFO [org.teiid.RUNTIME] (MSC service thread 1-10) TEIID50029 VDB vistapo3.1 model "post1" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,711 INFO [org.teiid.RUNTIME] (MSC service thread 1-10) TEIID50029 VDB vistapo3.1 model "po1" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,711 INFO [org.teiid.RUNTIME] (MSC service thread 1-10) TEIID50029 VDB vistapo3.1 model "post2" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,711 INFO [org.teiid.RUNTIME] (MSC service thread 1-12) TEIID50029 VDB tablaUnica.1 model "tbuso" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,711 INFO [org.teiid.RUNTIME] (MSC service thread 1-12) TEIID50029 VDB tablaUnica.1 model "conexionNuevaInfor" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,711 INFO [org.teiid.RUNTIME] (MSC service thread 1-14) TEIID50029 VDB BDVD.1 model "psgmodel3" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,711 INFO [org.teiid.RUNTIME] (MSC service thread 1-14) TEIID50029 VDB BDVD.1 model "psg1" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,711 INFO [org.teiid.RUNTIME] (MSC service thread 1-14) TEIID50029 VDB BDVD.1 model "psgmodel1" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,711 INFO [org.teiid.RUNTIME] (MSC service thread 1-14) TEIID50029 VDB BDVD.1 model "psgmodel2" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,711 INFO [org.teiid.RUNTIME] (MSC service thread 1-14) TEIID50029 VDB BDVD.1 model "psg2" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,711 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB BDVVisionComp.1 model "ConectividadFuente" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,711 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB BDVVisionComp.1 model "IntegraVistasConectadas" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,711 INFO [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB BDVVisionComp.1 model "ConectividadView" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,727 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50029 VDB psgmodelVirtual.1 model "psgmodel3" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,727 INFO [org.jboss.osgi.framework] (MSC service thread 1-7) JBOSGI011001: Bundle installed: org.apache.felix.configadmin:1.2.8.redhat-2
10:06:02,727 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50029 VDB psgmodelVirtual.1 model "psg1" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,727 INFO [org.jboss.osgi.framework] (MSC service thread 1-9) JBOSGI011001: Bundle installed: jboss-as-osgi-configadmin:7.2.1.Final-redhat-10
10:06:02,727 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50029 VDB psgmodelVirtual.1 model "psgmodel1" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,727 INFO [org.jboss.osgi.framework] (MSC service thread 1-2) JBOSGI011001: Bundle installed: org.jboss.spec.javax.servlet.jboss-servlet-api_2.5_spec:1.0.1.Final-redhat-2
10:06:02,727 INFO [org.jboss.osgi.framework] (MSC service thread 1-4) JBOSGI011001: Bundle installed: jboss-osgi-logging:1.0.0.redhat-2
10:06:02,727 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50029 VDB psgmodelVirtual.1 model "psgmodel2" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,727 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB VirtualVistaReportes.1 model "New_Informix" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,727 INFO [org.teiid.RUNTIME] (MSC service thread 1-8) TEIID50029 VDB psgmodelVirtual.1 model "psg2" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,727 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB VirtualVistaReportes.1 model "vistaReportes" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,727 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB VirtualVistaReportes.1 model "bdviews" metadata is currently being loaded. Start Time: 19/04/17 10:06 AM
10:06:02,743 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-16) MSC000001: Failed to start service jboss.teiid.vdb.virtualBD.1: org.jboss.msc.service.StartException in service jboss.teiid.vdb.virtualBD.1: org.teiid.deployers.VirtualDatabaseException: TEIID40035 VDB with given name and version already exists! virtualBD.1
at org.teiid.jboss.VDBService.start(VDBService.java:186)
at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]
at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.4.GA-redhat-1.jar:1.0.4.GA-redhat-1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.7.0_79]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.7.0_79]
at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_79]
Caused by: org.teiid.deployers.VirtualDatabaseException: TEIID40035 VDB with given name and version already exists! virtualBD.1
at org.teiid.deployers.VDBRepository.addVDB(VDBRepository.java:101)
at org.teiid.jboss.VDBService.start(VDBService.java:184)
... 5 more
10:06:02,743 INFO [org.jboss.osgi.framework] (MSC service thread 1-11) JBOSGI011001: Bundle installed: org.apache.felix.log:1.0.0.redhat-2
10:06:02,836 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID40003 VDB BDVPruebaTC.1 is set to ACTIVE
10:06:02,836 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.VDBpsg.vdb:main
10:06:02,852 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB BDVTablaConjunta1.1 is set to ACTIVE
10:06:02,852 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB VirtualBD.1 is set to ACTIVE
10:06:02,867 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.teiid-connector-google.rar:main
10:06:02,899 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.sqljdbc4.jar:main
10:06:02,930 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.tablaUnica.vdb:main
10:06:02,930 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40003 VDB VDBpsg.1 is set to ACTIVE
10:06:02,945 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.BDVTablaConjunta1.vdb:main
10:06:02,977 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.BDVPruebaTC.vdb:main
10:06:03,008 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.virtualBD.vdb:main
10:06:03,023 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40003 VDB BDVTablaConjunta.1 is set to ACTIVE
10:06:03,023 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.postgresql-8.4-703.jdbc4.jar:main
10:06:03,055 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID40003 VDB sqlypgV.1 is set to ACTIVE
10:06:03,055 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.JDBC.4.10.JC8DE (1).jar:main
10:06:03,070 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB bdvirt225.1 is set to ACTIVE
10:06:03,086 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.sqlypgV.vdb:main
10:06:03,101 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40003 VDB dataVirtual.1 is set to ACTIVE
10:06:03,117 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB proy2.1 is set to ACTIVE
10:06:03,133 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.ifxjdbc (1).jar:main
10:06:03,148 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID40003 VDB vistapo3.1 is set to ACTIVE
10:06:03,164 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB tablaUnica.1 is set to ACTIVE
10:06:03,164 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.VirtualBD.vdb:main
10:06:03,195 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.BDVTablaConjunta.vdb:main
10:06:03,195 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB BDVD.1 is set to ACTIVE
10:06:03,226 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.BDVD.vdb:main
10:06:03,257 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.JDBC.4.10.JC8DE.jar:main
10:06:03,273 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB BDVVisionComp.1 is set to ACTIVE
10:06:03,289 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40003 VDB psgmodelVirtual.1 is set to ACTIVE
10:06:03,289 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.proy2.vdb:main
10:06:03,304 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.bdvirt225.vdb:main
10:06:03,320 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB VirtualVistaReportes.1 is set to ACTIVE
10:06:03,335 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.teiid-connector-file.rar:main
10:06:03,351 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.teiid-connector-ws.rar:main
10:06:03,382 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.teiid-connector-ldap.rar:main
10:06:03,413 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.teiid-connector-salesforce.rar:main
10:06:03,429 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.psgmodelVirtual.vdb:main
10:06:03,445 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.teiid-connector-infinispan.rar:main
10:06:03,460 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.VirtualVistaReportes.vdb:main
10:06:03,476 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.dataVirtual.vdb:main
10:06:03,491 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.vistapo3.vdb:main
10:06:03,491 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.BDVVisionComp.vdb:main
10:06:03,507 INFO [org.jboss.as.osgi] (MSC service thread 1-4) JBAS011907: Registrar el módulo: deployment.setup.jar:main
10:06:03,538 INFO [org.jboss.osgi.framework] (MSC service thread 1-14) JBOSGI011001: Bundle installed: com.informix.jdbc:4.1.0.SNAPSHOT
10:06:03,538 INFO [org.jboss.as.server.deployment] (MSC service thread 1-11) JBAS015970: Defiera FIRST_MODULE_USE por jdbc-4.10.6.20151104.jar haciéndolo NEVER
10:06:03,538 INFO [org.jboss.osgi.framework] (MSC service thread 1-9) JBOSGI011011: Starting bundles for start level: 1
10:06:03,538 INFO [org.jboss.osgi.framework] (MSC service thread 1-9) JBOSGI011002: Bundle started: org.apache.felix.log:1.0.0.redhat-2
10:06:03,554 INFO [org.jboss.osgi.framework] (MSC service thread 1-9) JBOSGI011002: Bundle started: jboss-osgi-logging:1.0.0.redhat-2
10:06:03,569 INFO [org.jboss.osgi.framework] (MSC service thread 1-9) JBOSGI011002: Bundle started: org.apache.felix.configadmin:1.2.8.redhat-2
10:06:03,569 INFO [org.jboss.osgi.framework] (MSC service thread 1-9) JBOSGI011002: Bundle started: jboss-as-osgi-configadmin:7.2.1.Final-redhat-10
10:06:03,569 INFO [org.jboss.osgi.framework] (MSC service thread 1-9) JBOSGI011000: OSGi Framework started
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "tablaUnica.vdb" (runtime-name : "tablaUnica.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "BDVPruebaTC.vdb" (runtime-name : "BDVPruebaTC.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "BDVTablaConjunta1.vdb" (runtime-name : "BDVTablaConjunta1.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "BDVTablaConjunta.vdb" (runtime-name : "BDVTablaConjunta.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "BDVVisionComp.vdb" (runtime-name : "BDVVisionComp.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "bdvirt225.vdb" (runtime-name : "bdvirt225.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "ifxjdbc (1).jar" (runtime-name : "ifxjdbc (1).jar")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "JDBC.4.10.JC8DE (1).jar" (runtime-name : "JDBC.4.10.JC8DE (1).jar")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "JDBC.4.10.JC8DE.jar" (runtime-name : "JDBC.4.10.JC8DE.jar")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "jdbc-4.10.6.20151104.jar" (runtime-name : "jdbc-4.10.6.20151104.jar")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "setup.jar" (runtime-name : "setup.jar")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "VirtualVistaReportes.vdb" (runtime-name : "VirtualVistaReportes.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "VDBpsg.vdb" (runtime-name : "VDBpsg.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "psgmodelVirtual.vdb" (runtime-name : "psgmodelVirtual.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "BDVD.vdb" (runtime-name : "BDVD.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "vistapo3.vdb" (runtime-name : "vistapo3.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "sqlypgV.vdb" (runtime-name : "sqlypgV.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "dataVirtual.vdb" (runtime-name : "dataVirtual.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "sqljdbc4.jar" (runtime-name : "sqljdbc4.jar")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "VirtualBD.vdb" (runtime-name : "VirtualBD.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "virtualBD.vdb" (runtime-name : "virtualBD.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "proy2.vdb" (runtime-name : "proy2.vdb")
10:06:03,617 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Implementado "postgresql-8.4-703.jdbc4.jar" (runtime-name : "postgresql-8.4-703.jdbc4.jar")
10:06:03,617 INFO [org.jboss.as.server] (ServerService Thread Pool -- 30) JBAS018559: Implementado "teiid-connector-ws.rar" (runtime-name : "teiid-connector-ws.rar")
10:06:03,617 INFO [org.jboss.as.server] (ServerService Thread Pool -- 30) JBAS018559: Implementado "teiid-connector-salesforce.rar" (runtime-name : "teiid-connector-salesforce.rar")
10:06:03,617 INFO [org.jboss.as.server] (ServerService Thread Pool -- 30) JBAS018559: Implementado "teiid-connector-ldap.rar" (runtime-name : "teiid-connector-ldap.rar")
10:06:03,617 INFO [org.jboss.as.server] (ServerService Thread Pool -- 30) JBAS018559: Implementado "teiid-connector-infinispan.rar" (runtime-name : "teiid-connector-infinispan.rar")
10:06:03,617 INFO [org.jboss.as.server] (ServerService Thread Pool -- 30) JBAS018559: Implementado "teiid-connector-google.rar" (runtime-name : "teiid-connector-google.rar")
10:06:03,617 INFO [org.jboss.as.server] (ServerService Thread Pool -- 30) JBAS018559: Implementado "teiid-connector-file.rar" (runtime-name : "teiid-connector-file.rar")
10:06:03,617 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Reporte del estatus del servicio
JBAS014777: Servicios que no lograron iniciar: service jboss.teiid.vdb.virtualBD.1: org.jboss.msc.service.StartException in service jboss.teiid.vdb.virtualBD.1: org.teiid.deployers.VirtualDatabaseException: TEIID40035 VDB with given name and version already exists! virtualBD.1
10:06:03,648 INFO [org.jboss.as] (Controller Boot Thread) JBAS015961: Interfaz de administración http escuchando en http://127.0.0.1:9990/management
10:06:03,648 INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Consola de administración escuchando en http://127.0.0.1:9990
10:06:03,648 INFO [org.jboss.as] (Controller Boot Thread) JBAS015874: JBoss EAP 6.1.1.GA (AS 7.2.1.Final-redhat-10) inició en 4699ms - Inició 1098 de 1328 servicios (189 servicios son pasivos o por demanda)
10:12:47,578 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-13) JBAS010400: Fuente de datos enlazados [java:/PruebaConexionInformix]
10:12:47,782 INFO [org.jboss.as.repository] (management-handler-thread - 7) JBAS014900: Contenido añadido al sitio C:\Users\fliorti0\Documents\DataVirtualization\jboss-eap-6.1\standalone\data\content\64\5fbc12c8c47c953ae4a278f6be0416b2bb1234\content
10:12:47,782 INFO [org.jboss.as.server.deployment] (MSC service thread 1-9) JBAS015876: Iniciando la implementación de DBVProof.vdb" (runtime-name: "DBVProof.vdb")
10:12:47,798 INFO [org.jboss.as.osgi] (MSC service thread 1-13) JBAS011907: Registrar el módulo: deployment.DBVProof.vdb:main
10:12:47,813 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB DBVProof.1 model "PruebaConexionInformix" metadata is currently being loaded. Start Time: 19/04/17 10:12 AM
10:12:47,813 INFO [org.teiid.RUNTIME] (MSC service thread 1-6) TEIID50029 VDB DBVProof.1 model "Proof1" metadata is currently being loaded. Start Time: 19/04/17 10:12 AM
10:12:47,844 INFO [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50030 VDB DBVProof.1 model "Proof1" metadata loaded. End Time: 19/04/17 10:12 AM
10:12:47,844 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB DBVProof.1 model "PruebaConexionInformix" metadata loaded. End Time: 19/04/17 10:12 AM
10:12:47,876 INFO [org.jboss.as.server] (management-handler-thread - 7) JBAS018559: Implementado "DBVProof.vdb" (runtime-name : "DBVProof.vdb")
10:12:47,891 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID40003 VDB DBVProof.1 is set to ACTIVE
10:12:50,028 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-16) JBAS010400: Fuente de datos enlazados [java:/DBVProof]
10:12:53,399 INFO [org.teiid.RUNTIME] (MSC service thread 1-3) TEIID50026 VDB "DBVProof.1[PruebaConexionInformix{PruebaConexionInformix=PruebaConexionInformix, informix, PruebaConexionInformix}, Proof1{}]" undeployed.
10:12:53,431 INFO [org.jboss.as.osgi] (MSC service thread 1-7) JBAS011908: Cancelar el registro del módulo: deployment.DBVProof.vdb:main
10:12:53,431 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015877: Se detuvo la implementaciónDBVProof.vdb (runtime-name: DBVProof.vdb) en 36ms
10:12:53,509 INFO [org.jboss.as.repository] (management-handler-thread - 8) JBAS014901: Contenido borrado del sitio C:\Users\fliorti0\Documents\DataVirtualization\jboss-eap-6.1\standalone\data\content\64\5fbc12c8c47c953ae4a278f6be0416b2bb1234\content
10:12:53,509 INFO [org.jboss.as.server] (management-handler-thread - 8) JBAS018558: Implementación borrada "DBVProof.vdb" (runtime-name: "DBVProof.vdb")
10:12:53,556 INFO [org.jboss.as.repository] (management-handler-thread - 6) JBAS014900: Contenido añadido al sitio C:\Users\fliorti0\Documents\DataVirtualization\jboss-eap-6.1\standalone\data\content\64\5fbc12c8c47c953ae4a278f6be0416b2bb1234\content
10:12:53,556 INFO [org.jboss.as.server.deployment] (MSC service thread 1-7) JBAS015876: Iniciando la implementación de DBVProof.vdb" (runtime-name: "DBVProof.vdb")
10:12:53,572 INFO [org.jboss.as.osgi] (MSC service thread 1-13) JBAS011907: Registrar el módulo: deployment.DBVProof.vdb:main
10:12:53,572 INFO [org.teiid.RUNTIME] (MSC service thread 1-11) TEIID50029 VDB DBVProof.1 model "PruebaConexionInformix" metadata is currently being loaded. Start Time: 19/04/17 10:12 AM
10:12:53,572 INFO [org.teiid.RUNTIME] (MSC service thread 1-11) TEIID50029 VDB DBVProof.1 model "Proof1" metadata is currently being loaded. Start Time: 19/04/17 10:12 AM
10:12:53,587 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50030 VDB DBVProof.1 model "PruebaConexionInformix" metadata loaded. End Time: 19/04/17 10:12 AM
10:12:53,587 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50030 VDB DBVProof.1 model "Proof1" metadata loaded. End Time: 19/04/17 10:12 AM
10:12:53,619 INFO [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID40003 VDB DBVProof.1 is set to ACTIVE
10:12:53,634 INFO [org.jboss.as.server] (management-handler-thread - 6) JBAS018559: Implementado "DBVProof.vdb" (runtime-name : "DBVProof.vdb")
10:13:28,319 INFO [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue7) InformixExecutionFactory Commit=true;DatabaseProductName=Informix Dynamic Server;DatabaseProductVersion=11.50.FC6;DriverMajorVersion=3;DriverMajorVersion=70;DriverName=IBM Informix JDBC Driver for IBM Informix Dynamic Server;DriverVersion=3.70.JC2;IsolationLevel=2
10:13:28,334 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue7) Connector worker process failed for atomic-request=gsPwoNI5vaAc.3.1.0: org.teiid.translator.jdbc.JDBCExecutionException: -201 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."sequence", g_0."sequence_ref", g_0."compdate", g_0."movtype", g_0."movtypeori", g_0."appcode", g_0."usercode", g_0."mobile", g_0."emitype", g_0."branch", g_0."policy", g_0."certif", g_0."policycertif", g_0."issuedat", g_0."effecdate", g_0."expirdat", g_0."nullcode", g_0."nulldate", g_0."effecdatef", g_0."expirdatf", g_0."premium", g_0."premiumtar", g_0."formid", g_0."persontyp", g_0."cliename", g_0."doctype", g_0."numdocu", g_0."mailenvio", g_0."phones", g_0."regist", g_0."vehgroup", g_0."vehclass", g_0."zipcode", g_0."motor", g_0."chassis", g_0."vehcode", g_0."vehanio", g_0."vehasiento", g_0."descvehbra", g_0."descvehmod", g_0."statusori", g_0."flagapeseg", g_0."flagnotif", g_0."digitverif", g_0."msgerror", g_0."flagbus", g_0."intermed", g_0."idcanal", g_0."codecanal", g_0."codecont", g_0."codeaseg", g_0."adic_1", g_0."adic_2", g_0."adic_3", g_0."adic_4", g_0."adic_5", g_0."operacionhp", g_0."lastmoveme", g_0."numplan", g_0."email_cda" FROM "insunixdb":"informix":"tblapeseg" AS g_0]
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:88)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:257) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:457) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:177) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:174) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at java.util.concurrent.FutureTask.run(Unknown Source) [rt.jar:1.7.0_79]
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:118) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:250) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [rt.jar:1.7.0_79]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [rt.jar:1.7.0_79]
at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_79]
Caused by: java.sql.SQLException: A syntax error has occurred.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3537)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3853)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2653)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2569)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1388)
at com.informix.jdbc.IfxPreparedStatement.f(IfxPreparedStatement.java:326)
at com.informix.jdbc.IfxPreparedStatement.a(IfxPreparedStatement.java:306)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:176)
at com.informix.jdbc.IfxSqliConnect.h(IfxSqliConnect.java:6698)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:2566)
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:738)
at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:724)
at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:405)
at org.teiid.translator.jdbc.JDBCBaseExecution.getPreparedStatement(JDBCBaseExecution.java:181)
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:82)
... 12 more
Caused by: java.sql.SQLException
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3858)
... 25 more
10:13:28,335 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue8) TEIID30020 Processing exception 'TEIID30504 PruebaConexionInformix: -201 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."sequence", g_0."sequence_ref", g_0."compdate", g_0."movtype", g_0."movtypeori", g_0."appcode", g_0."usercode", g_0."mobile", g_0."emitype", g_0."branch", g_0."policy", g_0."certif", g_0."policycertif", g_0."issuedat", g_0."effecdate", g_0."expirdat", g_0."nullcode", g_0."nulldate", g_0."effecdatef", g_0."expirdatf", g_0."premium", g_0."premiumtar", g_0."formid", g_0."persontyp", g_0."cliename", g_0."doctype", g_0."numdocu", g_0."mailenvio", g_0."phones", g_0."regist", g_0."vehgroup", g_0."vehclass", g_0."zipcode", g_0."motor", g_0."chassis", g_0."vehcode", g_0."vehanio", g_0."vehasiento", g_0."descvehbra", g_0."descvehmod", g_0."statusori", g_0."flagapeseg", g_0."flagnotif", g_0."digitverif", g_0."msgerror", g_0."flagbus", g_0."intermed", g_0."idcanal", g_0."codecanal", g_0."codecont", g_0."codeaseg", g_0."adic_1", g_0."adic_2", g_0."adic_3", g_0."adic_4", g_0."adic_5", g_0."operacionhp", g_0."lastmoveme", g_0."numplan", g_0."email_cda" FROM "insunixdb":"informix":"tblapeseg" AS g_0]' for request gsPwoNI5vaAc.3. Exception type org.teiid.core.TeiidProcessingException thrown from com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413). Enable more detailed logging to see the entire stacktrace.
-
5. Re: Problem displaying date
rareddy Apr 19, 2017 12:16 PM (in response to cristopher.torres)If you are using the Designer to import the metadata from Informix may be do not use "use fully qualified names" on the import wizard and see if that helps.
-
6. Re: Problem displaying date
shawkins Apr 19, 2017 12:40 PM (in response to rareddy)It looks like the table name instead of "insunixdb":"informix":"tblapeseg", should be insunixdb:informix.tblapeseg
A designer issue will likely be needed as even without using the qualified name Designer will still double quote - which is not appropriate for informix.
Importing through Teiid should work as expected.
-
7. Re: Problem displaying date
cristopher.torres Apr 19, 2017 1:15 PM (in response to shawkins)Ramesh tested what you told me and that option was already disabled.
Steven, I'm using the designer, how could I correct that mistake?
-
8. Re: Problem displaying date
rareddy Apr 19, 2017 2:01 PM (in response to cristopher.torres)In the Designer, when you click on the table, there is properties dialog box at bottom left hand corner, find the property that says "Name In Source" and edit it to say insunixdb:informix.tblapeseg (removing all quotes) then save and execute again.
-
9. Re: Problem displaying date
cristopher.torres Apr 19, 2017 2:28 PM (in response to rareddy)First of all thanks for all the support;
I just tried what you mentioned to me, but the same error continues to occur and continues to generate the default ""
-
10. Re: Problem displaying date
rareddy Apr 19, 2017 2:48 PM (in response to cristopher.torres)That tells me that you have not re-deployed the VDB before execution. If you did, if it still failed the error message will be slightly different. Then we need to see that. See if you can attach the error to this.
-
11. Re: Problem displaying date
cristopher.torres Apr 26, 2017 11:33 AM (in response to rareddy)Hello, thank you very much for your support, the solution was to change to the latest version of developer studio and teiid.