[JBoss JIRA] (TEIIDDES-3075) teiid designer fails to import excel file
by Michael Echevarria (JIRA)
Michael Echevarria created TEIIDDES-3075:
--------------------------------------------
Summary: teiid designer fails to import excel file
Key: TEIIDDES-3075
URL: https://issues.jboss.org/browse/TEIIDDES-3075
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 11.0.1
Environment: JBoss Developer Studio 10.3.0 with teiid designer 11.0.1 on Linux
Reporter: Michael Echevarria
After importing an excel file, attempting to preview the data results in the following error:
Connector worker process failed for atomic-request=9241FCRcB/yA.0.0.1: org.teiid.translator.TranslatorException: TEIID23007 OPTIONS property CELL_NUMBER is required and it not defined on column ROW_ID
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years
[JBoss JIRA] (TEIIDDES-2919) When multiple resource-adapters are defined for the same type, incorrect info is seen in Teiid Conn. Impoter
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2919?page=com.atlassian.jira.plu... ]
Van Halbert commented on TEIIDDES-2919:
---------------------------------------
I don't have that installation any longer, but just cut-n-paste the above into a Teiid server configuration and restart server, should get you what you need.
> When multiple resource-adapters are defined for the same type, incorrect info is seen in Teiid Conn. Impoter
> ------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2919
> URL: https://issues.jboss.org/browse/TEIIDDES-2919
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 10.0.1
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 11.0.2
>
> Attachments: Screenshot from 2016-09-21 17-00-51.png
>
>
> Setup:
> Configured 2 resource-adapters of the same type.
> {code}
> <resource-adapter id="infinispanRemQSDSL">
> <module slot="main" id="org.jboss.teiid.resource-adapter.infinispan.dsl"/>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory" jndi-name="java:/infinispanRemoteDSL" enabled="true" use-java-context="true" pool-name="infinispanRemoteDSL">
> <config-property name="MessageDescriptor">
> quickstart.Person
> </config-property>
> <config-property name="Module">
> com.client.quickstart.addressbook.pojos
> </config-property>
> <config-property name="MessageMarshallers">
> com.client.quickstart.addressbook.pojos.domain.Person:com.client.quickstart.addressbook.pojos.marshallers.PersonMarshaller,com.client.quickstart.addressbook.pojos.domain.PhoneNumber:com.client.quickstart.addressbook.pojos.marshallers.PhoneNumberMarshaller,com.client.quickstart.addressbook.pojos.domain.Address:com.client.quickstart.addressbook.pojos.marshallers.AddressMarshaller
> </config-property>
> <config-property name="ProtobufDefinitionFile">
> /quickstart/addressbook.proto
> </config-property>
> <config-property name="RemoteServerList">
> 127.0.0.1:11322
> </config-property>
> <config-property name="CacheTypeMap">
> addressbook_indexed:com.client.quickstart.addressbook.pojos.domain.Person;id
> </config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> <resource-adapter id="infinispanQSDSLTest">
> <module slot="main" id="org.jboss.teiid.resource-adapter.infinispan.dsl"/>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory" jndi-name="java:/infinispanRemoteDSLTest" enabled="true" use-java-context="true" pool-name="infinispanRemoteDSLTest">
> <config-property name="MessageDescriptor">
> quickstart.Person
> </config-property>
> <config-property name="Module">
> com.client.quickstart.addressbook.pojos
> </config-property>
> <config-property name="MessageMarshallers">
> com.client.quickstart.addressbook.pojos.domain.Person:com.client.quickstart.addressbook.pojos.marshallers.PersonMarshaller,com.client.quickstart.addressbook.pojos.domain.PhoneNumber:com.client.quickstart.addressbook.pojos.marshallers.PhoneNumberMarshaller,com.client.quickstart.addressbook.pojos.domain.Address:com.client.quickstart.addressbook.pojos.marshallers.AddressMarshaller
> </config-property>
> <config-property name="ProtobufDefinitionFile">
> /quickstart/addressbook.proto
> </config-property>
> <config-property name="RemoteServerList">
> 127.0.0.1:11322
> </config-property>
> <config-property name="CacheTypeMap">
> addressbook_indexed:com.client.quickstart.addressbook.pojos.domain.Person;id
> </config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> and when using Teiid Connection importer, the driver information (which corresponds to the "ID") is the same.
> Tried with 2 file resource-adapters and similar behavior.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years
[JBoss JIRA] (TEIIDDES-2919) When multiple resource-adapters are defined for the same type, incorrect info is seen in Teiid Conn. Impoter
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2919?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2919:
----------------------------------------
[~van.halbert] Could you send attach the standalone.sh from this test?
> When multiple resource-adapters are defined for the same type, incorrect info is seen in Teiid Conn. Impoter
> ------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2919
> URL: https://issues.jboss.org/browse/TEIIDDES-2919
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 10.0.1
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 11.0.2
>
> Attachments: Screenshot from 2016-09-21 17-00-51.png
>
>
> Setup:
> Configured 2 resource-adapters of the same type.
> {code}
> <resource-adapter id="infinispanRemQSDSL">
> <module slot="main" id="org.jboss.teiid.resource-adapter.infinispan.dsl"/>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory" jndi-name="java:/infinispanRemoteDSL" enabled="true" use-java-context="true" pool-name="infinispanRemoteDSL">
> <config-property name="MessageDescriptor">
> quickstart.Person
> </config-property>
> <config-property name="Module">
> com.client.quickstart.addressbook.pojos
> </config-property>
> <config-property name="MessageMarshallers">
> com.client.quickstart.addressbook.pojos.domain.Person:com.client.quickstart.addressbook.pojos.marshallers.PersonMarshaller,com.client.quickstart.addressbook.pojos.domain.PhoneNumber:com.client.quickstart.addressbook.pojos.marshallers.PhoneNumberMarshaller,com.client.quickstart.addressbook.pojos.domain.Address:com.client.quickstart.addressbook.pojos.marshallers.AddressMarshaller
> </config-property>
> <config-property name="ProtobufDefinitionFile">
> /quickstart/addressbook.proto
> </config-property>
> <config-property name="RemoteServerList">
> 127.0.0.1:11322
> </config-property>
> <config-property name="CacheTypeMap">
> addressbook_indexed:com.client.quickstart.addressbook.pojos.domain.Person;id
> </config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> <resource-adapter id="infinispanQSDSLTest">
> <module slot="main" id="org.jboss.teiid.resource-adapter.infinispan.dsl"/>
> <connection-definitions>
> <connection-definition class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory" jndi-name="java:/infinispanRemoteDSLTest" enabled="true" use-java-context="true" pool-name="infinispanRemoteDSLTest">
> <config-property name="MessageDescriptor">
> quickstart.Person
> </config-property>
> <config-property name="Module">
> com.client.quickstart.addressbook.pojos
> </config-property>
> <config-property name="MessageMarshallers">
> com.client.quickstart.addressbook.pojos.domain.Person:com.client.quickstart.addressbook.pojos.marshallers.PersonMarshaller,com.client.quickstart.addressbook.pojos.domain.PhoneNumber:com.client.quickstart.addressbook.pojos.marshallers.PhoneNumberMarshaller,com.client.quickstart.addressbook.pojos.domain.Address:com.client.quickstart.addressbook.pojos.marshallers.AddressMarshaller
> </config-property>
> <config-property name="ProtobufDefinitionFile">
> /quickstart/addressbook.proto
> </config-property>
> <config-property name="RemoteServerList">
> 127.0.0.1:11322
> </config-property>
> <config-property name="CacheTypeMap">
> addressbook_indexed:com.client.quickstart.addressbook.pojos.domain.Person;id
> </config-property>
> </connection-definition>
> </connection-definitions>
> </resource-adapter>
> {code}
> and when using Teiid Connection importer, the driver information (which corresponds to the "ID") is the same.
> Tried with 2 file resource-adapters and similar behavior.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
7 years