getting error while starting server

[pavankvvr]

hi, I'm very new to Teiid. I'm trying to move data from flat file to solr using reference https://developer.jboss.org/wiki/IntegrateApacheSolrWithTeiid?_sscc=t but i'm getting below error while starting teiid server, 09:49:48,702 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 43) JBAS014612: Operation ("add") failed - address: ([     ("subsystem" => "resource-adapters"),     ("resource-adapter" => "file-ds") ]) - failure description: "JBAS010480: RAR 'file-ds' not yet deployed." 09:49:48,704 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 43) JBAS014612: Operation ("add") failed - address: ([     ("subsystem" => "resource-adapters"),     ("resource-adapter" => "solr-ds") ]) - failure description: "JBAS010480: RAR 'solr-ds' not yet deployed." could you pls guide to fix this issue ?

[rareddy]

Pavan,

Welcome Teiid community.

Have you added the data source configurations for your VDB. See Option 2: Data source Flat-File, Data source for Slor, you need to add them before you can use it? If you did, then you may not have installed the Teiid correctly. Download the server here, and unzip.

Ramesh..

[pavankvvr]

Hi Ramesh,

We have added below resource adapter (datasource) in standalone-teiid.xml.

Let use know if any more additional details are required.

   <resource-adapter id="file-ds">

                    <module slot="main" id="org.jboss.teiid.resource-adapter.file"/>

                    <transaction-support>NoTransaction</transaction-support>

                    <connection-definitions>

                        <connection-definition class-name="org.teiid.resource.adapter.file.FileManagedConnectionFactory" jndi-name="java:/file-ds" enabled="true" pool-name="file-ds">

                            <config-property name="ParentDirectory">

                                D:\babynames

                            </config-property>

                        </connection-definition>

                    </connection-definitions>

                </resource-adapter>

                <resource-adapter id="solr-ds">

                    <module slot="main" id="org.jboss.teiid.resource-adapter.solr"/>

                    <transaction-support>XATransaction</transaction-support>

                    <connection-definitions>

                        <connection-definition class-name="org.teiid.resource.adapter.solr.SolrManagedConnectionFactory" jndi-name="java:/solr-ds" enabled="true" pool-name="solr-ds">

                            <config-property name="url">

                                http://localhost:8983/solr/babynames

                            </config-property>

                            <config-property name="CoreName">

                                babynames

                            </config-property>

                            <validation>

                                <background-validation>true</background-validation>

                            </validation>

                        </connection-definition>

                    </connection-definitions>

                </resource-adapter>

                Do we need to add jar or rar dependent files  as part of configuration?

[rareddy]

No RAR files to install. Then the question remains that your Teiid installation is some how not correct. What steps did you follow to install, and how are you starting it?

BTW, you should have added above configuration to "standalone-teiid.xml" file and started the server using

standalone.bat -c standalone-teiid.xml

[pavankvvr]

Thanks Ramesh,

We are trying suggested option.

Parllely we are trying to build VDB using Teiid Designer following below URL.

Integrate Apache Solr with Teiid

We are trying to build VDB for both(flat file and solr) the options.

Firstly following the steps in this URL we are able to build the model from flat file.

But while right clicking on the table to "Preview Data"(Modeling-->Preview Data) the eclipse(Luna 4.4) is hanging.

Same is happening with JBDS(9.0.0).

Secondly when I was trying to build VDB with solr based.

For this when I click on Teiid Designer/Teiid Connection-->Source Model again the eclipse(Luna 4.4) is hanging.

Same is happening with JBDS(9.0.0)

I have googled and tried lot options but no success.

I am using WildFly 8.x version of JBoss.

Kindly help in resolving this issue.

[rareddy]

Pavan,

Teiid does not support any version of WildFly yet, you need to be using JBoss EAP 6.x. Depending upon the Teiid version this may be different. See the downloads page Downloads · Teiid

NOTE: Read bullet points, re-install Teiid ans start over. Use latest version of Teiid Designer.

[pavankvvr]

Thanks Ramesh. Will try and get back to you.

And we have some progress on building using dynamic VDB.

We are able to load the data from flat file to DB using dynamic VDB.

But when trying to load table data from prostgresSQL into Apache Solr we are facing below error.

TEIID31080 postgresdb.names validation error: Group does not exist: postgresqldb.name

Can you show us some light on this.

PFB standalone-teiid.xml and VDB xml which we are using.

standalone-teiid.xml:

<subsystem xmlns="urn:jboss:domain:datasources:1.2">

<datasource jndi-name="java:/postgres-ds" pool-name="postgresDS" enabled="true">

<connection-url>jdbc:postgresql://localhost:5432/TeiidTest</connection-url>

<driver>postgresql-9.3-1100.jdbc3.jar</driver>

<security>

<user-name>postgres</user-name>

<password>postgres</password>

</security>

</datasource>

.....

.....

.....

</subsystem>

<resource-adapter id="solr-ds">

<module slot="main" id="org.jboss.teiid.resource-adapter.solr"/>

<transaction-support>XATransaction</transaction-support>

<connection-definitions>

<connection-definition class-name="org.teiid.resource.adapter.solr.SolrManagedConnectionFactory" jndi-name="java:/solr-ds" enabled="true" pool-name="solr-ds">

<config-property name="CoreName">

p360names

</config-property>

<config-property name="url">

http://localhost:8983/solr

</config-property>

<validation>

<background-validation>true</background-validation>

</validation>

</connection-definition>

</connection-definitions>

</resource-adapter>

VDB xml file:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?> 

<vdb name="p360namesdb" version="1">

    <model name="solr"> 

        <source name="solr" translator-name="solr" connection-jndi-name="java:/solr-ds"/> 

    </model> 

<model name="postgresqldb"> 

        <source name="postgresql" translator-name="postgresql" connection-jndi-name="java:/postgres-ds"/>

    </model> 

    <model name = "postgresdb" visible = "true" type = "VIRTUAL" > 

        <metadata type = "DDL"><![CDATA[

              CREATE VIEW names (

                name1 varchar

                ) AS

SELECT  concat(last_name, concat(',' , first_name))

                  FROM postgresqldb.name ;

         ]]>

         </metadata>

    </model> 

  </vdb>

[shawkins]

Without the virtual model see what tables you are actually pulling in from postgresqldb - You can do this using a query tool like SQuirreL or by directly issuing "select * from system.tables".