1 2 3 4 5 Previous Next 66 Replies Latest reply on Oct 12, 2012 12:35 PM by rareddy Go to original post Branched to a new discussion.
      • 60. Re: From relational to XML (conforming to xschema)
        tejones

        Luca,

         

        It seems you have hit this: https://issues.jboss.org/browse/TEIIDDES-1420. There is an issue with generating on Windows... other operating systems work fine. I am working this and hope to have a fix soon.. I'll let you know when it is available. If you would like to give me your WAR, I can fix it and send back to you.

         

        Thanks,

        Ted

        • 61. Re: From relational to XML (conforming to xschema)
          rareddy

          Ted,

           

          If there a manual way to fix the issue, I  suggest adding the workaround steps on JIRA.

           

          Thanks

           

          Ramesh..

          • 62. Re: From relational to XML (conforming to xschema)
            tejones

            Luca,

             

            FYI - https://issues.jboss.org/browse/TEIIDDES-1420 has been resolved and is available with the latest JBT update.

             

            Thanks,

            Ted

            • 63. Re: From relational to XML (conforming to xschema)
              gioppoluca

              I'm again on the same problem and here are the results on the new TEIID version:

               

              TEIID 8.1 final

              JBoss 7.1.1 final

              the VDB is the same (to be honest it has been recreated using designer 7.8)

              Here is the error:

               

              10:58:54,906 INFO  [org.jboss.as.connector.deployers.RADeployer] (MSC service thread 1-1) IJ020001: Required license ter

              ms for file:/L:/jboss-as-7.1.1.Final-TEIID-8.1/standalone/tmp/vfs/tempf82d91e9d78316c8/teiid-connector-ws.rar-8d5ece2634

              c92f67/contents/

              10:58:54,969 INFO  [org.jboss.as] (MSC service thread 1-1) JBAS015951: Admin console listening on http://127.0.0.1:9990

              10:58:54,969 INFO  [org.jboss.as] (MSC service thread 1-1) JBAS015874: JBoss AS 7.1.1.Final "Brontes" started in 13422ms

              - Started 315 of 415 services (94 services are passive or on-demand)

              10:58:55,203 INFO  [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB testXML.1 model "BooxEx" metadata is curr

              ently being loaded. Start Time: 14/09/12 10.58

              10:58:55,203 INFO  [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB testXML.1 model "books" metadata is curre

              ntly being loaded. Start Time: 14/09/12 10.58

              10:58:55,375 ERROR [org.jboss.threads.executor] (teiid-async-threads - 2) Task execution failed for task org.teiid.jboss

              .VDBService$6@d8dc2e: org.teiid.metadata.DuplicateRecordException: TEIID60012 Duplicate Schema books

                      at org.teiid.metadata.MetadataStore.addSchema(MetadataStore.java:54) [teiid-api-8.1.0.Final.jar:8.1.0.Final]

                      at org.teiid.deployers.CompositeVDB.getMetadataStore(CompositeVDB.java:219) [teiid-runtime-8.1.0.Final.jar:8.1.0

              .Final]

                      at org.teiid.deployers.CompositeVDB.metadataLoadFinished(CompositeVDB.java:324) [teiid-runtime-8.1.0.Final.jar:8

              .1.0.Final]

                      at org.teiid.deployers.VDBRepository.finishDeployment(VDBRepository.java:287) [teiid-runtime-8.1.0.Final.jar:8.1

              .0.Final]

                      at org.teiid.runtime.AbstractVDBDeployer.metadataLoaded(AbstractVDBDeployer.java:166) [teiid-runtime-8.1.0.Final

              .jar:8.1.0.Final]

                      at org.teiid.jboss.VDBService.access$800(VDBService.java:89) [teiid-jboss-integration-8.1.0.Final.jar:8.1.0.Fina

              l]

                      at org.teiid.jboss.VDBService$6.run(VDBService.java:385) [teiid-jboss-integration-8.1.0.Final.jar:8.1.0.Final]

                      at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)

                      at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:801)

                      at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)

                      at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:821)

                      at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_04]

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

               

              10:58:55,406 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "testXML.vdb"

              10:58:55,406 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-ws.rar"

              10:58:55,406 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559: Deployed "teiid-connector-salesforc

               

              It seems that getting to those XSD is not an easy tasK for teiid

               

              Any idea?

              Luca

              • 64. Re: From relational to XML (conforming to xschema)
                shawkins

                Your next post was accidentially branched to https://community.jboss.org/thread/205377 I'll reply there.

                • 65. Re: From relational to XML (conforming to xschema)
                  gioppoluca

                  Just s a thanks for the support I've posted a short tutorial on how to obtain the object of this thread.

                  You can find it here:

                  http://gioppoluca.blogspot.it/2012/10/teiid-tutorial-part-1.html

                  • 66. Re: From relational to XML (conforming to xschema)
                    rareddy

                    Excellent! We will link this in a blog and tweet about it.

                     

                    Thanks Luca.

                    1 2 3 4 5 Previous Next