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

[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

[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..

[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

[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

[rareddy]

Danny,

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

Ramesh..

[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

[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..

[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

[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..

[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

[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

[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..