12 Replies Latest reply on May 5, 2014 8:17 AM by rareddy

    How to create Teiid server instance and preview data

    dgaethofs

      Dear all,

       

      I created the example ClimateZoneVIEW which is about reading the flat file ClimateZone.

       

      However I can not get the Preview Data working . The main reason is that I do not understand what type of JBoss server should be created.

       

      My steps:

       

      Step 1:

       

      In Window > Preferences click Server > Runtime Environment

      Click the button Add


       

      Step 2

      Open the node JBoss Enterprise Middleware

       

      Select JBoss EAP 6.1+

       

      Even when you have installed JBoss EAP 6.2

       

      Step 3

      Select the JBoss EAP in the Home Directory

      Select the standalone.xml in the Configuration File

       

      Step 4

      Now the Server runtime environment is added

      In the Preference window press the button OK


       

      Step 5

      In the Server View, no server is visible - perfect

       

       

      Step 6

      define JBoss Server via Guide Teiid > Configure JBoss Server


       

      Step 7

      Start the server

       

       

       

       

      Step 8

      Configure the Teiid version

       

      Step 9

      NOW WHEN I want to run my ClimateZone the system ask me to create a Teiid instance

       

       

      WHEN I SAY YES IT IS JUST CREATING A NEW JBOSS SERVER

       

       

      HOW SHOULD I CREATE THE TEIID INSTANCE ?

       

      regards

      Danny

        • 1. Re: How to create Teiid server instance and preview data
          dgaethofs

          All,

           

          Alright when I create the JBoss Server runtime, I get - as long as the server is not started - the following nodes:

           

          I now need to start the server to be able to create the Teiid server instance.

           

          When I start the server I get an error message:

          org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: Could not execute "read-attribute" for [{"subsystem" => "teiid"}]. Failure was "JBAS014883: No resource definition is registered for address [(\"subsystem\" => \"teiid\")]".

           

          Can anyone explain what is causing this error ?

           

          regards

          Danny

          • 2. Re: How to create Teiid server instance and preview data
            rareddy

            Danny,

             

            JBoss EAP server does not come with Teiid installed. It is separate install on top of the EAP 6.1.Alpha. I suggest, you down load Teiid runtime from http://teiid.org and overlay the download on top of EAP 6.1.Alpha. Then restart in the Designer. Note that if you are configuring as external server start the server as

             

            ./standalone.sh -c standalone-teiid.xml

             

            or make sure in the above configuration you selected "standalone-teiid.xml" file as the configuration to start.

             

            HTH

             

            Ramesh..

            • 3. Re: How to create Teiid server instance and preview data
              dgaethofs

              Dear Ramesh,

               

              Thanks for responding.

               

              This is how I installed the EAP 6.2 .

               

              I downloaded jboss-eap-6.2.0.zip  and unzipped it to C:\ProgramFiles (x86)\jboss-eap-6.2

              Then I downloaded teiid-8.7.0.Final-jboss-dist.zip and unzipped it to the same directory C:\ProgramFiles (x86)\jboss-eap-6.2

               

              I assume this is what you were advising BUT I already did so.

               

              Should I go for EAP 6.1 ?

               

              regards

              Danny

              • 4. Re: How to create Teiid server instance and preview data
                dgaethofs

                Dear all,

                 

                I installed jboss-eap-6.1.0.Alpha.zip to directory C:\ProgramFiles (x86)\jboss-eap-6.1

                Unzipped teiid-8.7.0.Final-jboss-dist.zip into the directory C:\ProgramFiles (x86)\jboss-eap-6.1


                Installed the JBoss Developer Kit and Integration Stack


                 

                 

                 

                 

                 

                 

                 

                Now I start the Jboss Server

                 

                 

                When I start the server

                 

                What is wrong and can I ignore this error ?

                 

                in the console I see the errors

                 

                 

                12:33:12,981 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41)  JBAS014613: Operation ("activate") failed - address: ([

                    ("subsystem" => "resource-adapters"),

                    ("resource-adapter" => "file")

                ]) - failure description: "rar not yet deployed"

                12:33:13,016 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41)  JBAS014613: Operation ("activate") failed - address: ([

                    ("subsystem" => "resource-adapters"),

                    ("resource-adapter" => "google")

                ]) - failure description: "rar not yet deployed"

                12:33:13,023 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41)  JBAS014613: Operation ("activate") failed - address: ([

                    ("subsystem" => "resource-adapters"),

                    ("resource-adapter" => "infinispan")

                ]) - failure description: "rar not yet deployed"

                12:33:13,027 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41)  JBAS014613: Operation ("activate") failed - address: ([

                    ("subsystem" => "resource-adapters"),

                    ("resource-adapter" => "ldap")

                ]) - failure description: "rar not yet deployed"

                12:33:13,037 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41)  JBAS014613: Operation ("activate") failed - address: ([

                    ("subsystem" => "resource-adapters"),

                    ("resource-adapter" => "salesforce")

                ]) - failure description: "rar not yet deployed"

                12:33:13,051 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41)  JBAS014613: Operation ("activate") failed - address: ([

                    ("subsystem" => "resource-adapters"),

                    ("resource-adapter" => "webservice")

                ]) - failure description: "rar not yet deployed"

                12:33:13,059 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41)  JBAS014613: Operation ("activate") failed - address: ([

                    ("subsystem" => "resource-adapters"),

                    ("resource-adapter" => "mongodb")

                ]) - failure description: "rar not yet deployed"

                12:33:13,073 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41)  JBAS014613: Operation ("activate") failed - address: ([

                    ("subsystem" => "resource-adapters"),

                    ("resource-adapter" => "cassandra")

                ]) - failure description: "rar not yet deployed"

                12:33:13,084 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41)  JBAS014613: Operation ("activate") failed - address: ([

                    ("subsystem" => "resource-adapters"),

                    ("resource-adapter" => "simpledb")

                ]) - failure description: "rar not yet deployed"

                12:33:13,096 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41)  JBAS014613: Operation ("activate") failed - address: ([

                    ("subsystem" => "resource-adapters"),

                    ("resource-adapter" => "accumulo")

                ]) - failure description: "rar not yet deployed"

                12:33:13,142 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 41)  JBAS014613: Operation ("activate") failed - address: ([

                    ("subsystem" => "resource-adapters"),

                    ("resource-adapter" => "solr")

                ]) - failure description: "rar not yet deployed"

                 

                 

                12:33:15,980 INFO  [org.jboss.resteasy.spi.ResteasyDeployment] (ServerService Thread Pool -- 51)  Deploying javax.ws.rs.core.Application: class org.teiid.odata.TeiidODataApplication

                12:33:16,035 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/odata]] (ServerService Thread Pool -- 51)  JBWEB000287: Exception sending context initialized event to listener instance of class org.jboss.resteasy.plugins.server.servlet.ResteasyBootstrap: java.lang.IllegalArgumentException: Illegal group reference

                    at java.util.regex.Matcher.appendReplacement(Matcher.java:713) [rt.jar:1.6.0_45]

                    at org.jboss.resteasy.util.Encode.pathParamReplacement(Encode.java:434) [resteasy-jaxrs-2.3.5.Final.jar:]

                    at org.jboss.resteasy.util.Encode.encodeValue(Encode.java:314) [resteasy-jaxrs-2.3.5.Final.jar:]

                    at org.jboss.resteasy.util.Encode.encodePath(Encode.java:167) [resteasy-jaxrs-2.3.5.Final.jar:]

                    at org.jboss.resteasy.specimpl.UriBuilderImpl.paths(UriBuilderImpl.java:222) [resteasy-jaxrs-2.3.5.Final.jar:]

                    at org.jboss.resteasy.specimpl.UriBuilderImpl.path(UriBuilderImpl.java:295) [resteasy-jaxrs-2.3.5.Final.jar:]

                    at org.jboss.resteasy.core.ResourceMethodRegistry.processMethod(ResourceMethodRegistry.java:262) [resteasy-jaxrs-2.3.5.Final.jar:]

                    at org.jboss.resteasy.core.ResourceMethodRegistry.addResourceFactory(ResourceMethodRegistry.java:124) [resteasy-jaxrs-2.3.5.Final.jar:]

                    at org.jboss.resteasy.core.ResourceMethodRegistry.addResourceFactory(ResourceMethodRegistry.java:106) [resteasy-jaxrs-2.3.5.Final.jar:]

                    at org.jboss.resteasy.core.ResourceMethodRegistry.addResourceFactory(ResourceMethodRegistry.java:83) [resteasy-jaxrs-2.3.5.Final.jar:]

                    at org.jboss.resteasy.core.ResourceMethodRegistry.addPerRequestResource(ResourceMethodRegistry.java:72) [resteasy-jaxrs-2.3.5.Final.jar:]

                    at org.jboss.resteasy.spi.ResteasyDeployment.registration(ResteasyDeployment.java:405) [resteasy-jaxrs-2.3.5.Final.jar:]

                    at org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:233) [resteasy-jaxrs-2.3.5.Final.jar:]

                    at org.jboss.resteasy.plugins.server.servlet.ResteasyBootstrap.contextInitialized(ResteasyBootstrap.java:28) [resteasy-jaxrs-2.3.5.Final.jar:]

                    at org.apache.catalina.core.StandardContext.contextListenerStart(StandardContext.java:3339) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

                    at org.apache.catalina.core.StandardContext.start(StandardContext.java:3777) [jbossweb-7.2.0.Final.jar:7.2.0.Final]

                    at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:156) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]

                    at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]

                    at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93) [jboss-as-web-7.2.0.Alpha1-redhat-4.jar:7.2.0.Alpha1-redhat-4]

                    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) [rt.jar:1.6.0_45]

                    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_45]

                    at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_45]

                    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [rt.jar:1.6.0_45]

                    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [rt.jar:1.6.0_45]

                    at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45]

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

                 

                12:33:16,078 ERROR [org.apache.catalina.core] (ServerService Thread Pool -- 51)  JBWEB001103: Error detected during context /odata start, will stop it

                12:33:16,094 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 51)  MSC00001: Failed to start service jboss.web.deployment.default-host./odata: org.jboss.msc.service.StartException in service jboss.web.deployment.default-host./odata: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context

                    at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:96)

                    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439) [rt.jar:1.6.0_45]

                    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_45]

                    at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_45]

                    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [rt.jar:1.6.0_45]

                    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [rt.jar:1.6.0_45]

                    at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45]

                    at org.jboss.threads.JBossThread.run(JBossThread.java:122) [jboss-threads-2.1.0.Final.jar:2.1.0.Final]

                Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context

                    at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:161)

                    at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60)

                    at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93)

                    ... 7 more

                • 5. Re: How to create Teiid server instance and preview data
                  rareddy

                  Danny,

                   

                  Where it says "configuration file" in above dialog boxes, you need to enter "standalone-teiid.xml" instead of "standalone.xml"

                   

                  Ramesh..

                  • 6. Re: How to create Teiid server instance and preview data
                    dgaethofs

                    Ramesh,

                     

                    Thanks is what I did and it works I have a running Teiid instance. However with errors as mentioned in my reply.

                     

                    regards

                    Danny

                    • 7. Re: How to create Teiid server instance and preview data
                      rareddy

                      Danny,

                       

                      Ignore the JBoss developer studio for a minute, and open a console and try starting the Teiid Server on its own first and lets make sure it is starting correctly. To do that go the directory where the EAP 6.1.Alpha + Teiid 8.7 (or 8.6) installed and execute following

                       

                      standalone.bat -c standalone-teiid.xml

                       

                      see if you have same errors. Note there is RestEasy JAXRS patch you need to install (see Downloads · Teiid) for a library update. If all this works, then proceed to work with JBoss Developer Studio.  Also, with 8.4 Teiid Designer we see issues connecting to Teiid 8.7, so you would need use 8.5.Alpha version or downgrade the Teiid version to 8.6 which is supposed to work with Teiid Designer 8.4.Final.

                       

                      Ramesh..

                      • 8. Re: How to create Teiid server instance and preview data
                        dgaethofs

                        Ramesh,

                         

                        When I open a command window and run standalone.bat -c standalone-teiid.xml

                         

                         

                        Even when I run standalone.bat it does not fire up.

                         

                        Seems to be something wrong because a few days back in my first installation I could fire up JBoss EAP 6.2 via standalone.bat

                         

                        By the way how to I need to install JAXRS patch. Copy the content of the Zip somewhere ?

                         

                        regards

                        Danny

                        • 9. Re: How to create Teiid server instance and preview data
                          rareddy

                          Try installing some where that does not have spaces in the installation path.  We have seen issues with installing in "Program Files (x86)", try something like "c:\testing".  Make sure you are running with Java SDK 6 or 7 not 8.

                           

                          For JAXRS patch, you need to download from link I provided, then inside it there is "resteasy-jboss-modules" file, you need to extract that on "jboss-as/modules/system/layers/base" directory.

                           

                          Ramesh..

                          • 10. Re: How to create Teiid server instance and preview data
                            dgaethofs

                            Alright,

                             

                            Installed JBoss EAP6.1 Alpha with Teiid 8.7 overlayed and the RestEasy JAXRS Patch.

                            Installed it in folder DataJBoss

                             

                            Starting it up in command window works .

                             

                            regards

                            Danny

                            • 11. Re: How to create Teiid server instance and preview data
                              dgaethofs

                              Ramesh,

                               

                              Thanks very much.

                               

                              Steps:

                              Create Folder DataJBoss

                              Download jboss-eap-6.1.0.Alpha.zip

                              Unzip in folder DataJBoss

                              Download teiid-8.7.0.Final-jboss-dist.zip

                              Unzip and overlay in folder DataJBos\jboss-eap-6.1

                              Download resteasy-jaxrs-2.3.6.Final-all.zip

                              Extract the "resteasy-jboss-modules" file on "jboss-as/modules/system/layers/base" directory

                              Open command window and test standalone.bat -c standalone-teiid.xml

                              Stop the server

                              Start Eclipse

                              Open Preferences

                              - Teiid Designer set versio

                               

                              - Server \ Runtime Environment

                               

                               

                              - JAVA

                              Installed JREs > Execution Environment

                               

                              - Create JBoss Server

                               

                              Start the server

                               

                              Create the Flat FIle example

                              Model Flat File Data Source - Teiid Examples - Project Documentation Editor

                               

                              Run the Preview Data AND LOOK IT WORKS

                               

                               

                              regards

                              Danny

                              • 12. Re: How to create Teiid server instance and preview data
                                rareddy

                                Great, so the issue was with spaces in the path then. Also what is version of the JBDS you are using? Can also see what version of Teiid Designer in it? Is it 8.3.2?

                                 

                                Thanks

                                 

                                Ramesh..