11 Replies Latest reply on Apr 26, 2017 11:33 AM by cristopher.torres

    Problem displaying date

    cristopher.torres

      Hello! I am making a connection to informix, I have managed to connect and extract the data from the sources. I have already prepared the data and even modified the driver to be compatible with JDBC4 to be able to deploy the virtual database, now it happens that when I want to see the stored data does not show me and I get the following error:

       

      TEIDD30504 connectInfor01: -201 TEIID11008: TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: Select g_0.”codgext”, ….

        • 1. Re: Problem displaying date
          shawkins

          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

            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

              Can you provide the full stacktrace?

              • 4. Re: Problem displaying date
                cristopher.torres

                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

                  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

                    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

                      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

                        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

                          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

                            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

                              Hello, thank you very much for your support, the solution was to change to the latest version of developer studio and teiid.