October 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4469) Insert with query expression does not apply source hint to target

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4469?page=com.atlassian.jira.plugin... ] Lucie Fabrikova commented on TEIID-4469: ---------------------------------------- I added the vdb. > Insert with query expression does not apply source hint to target > ----------------------------------------------------------------- > > Key: TEIID-4469 > URL: https://issues.jboss.org/browse/TEIID-4469 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.5, 8.7.10_6.2 > > Attachments: oracledba-vdb.xml > > > "INSERT INTO ... SELECT ..." statements result in a ProjectIntoNode which seems to prevent any source hints from being passed down to the relevant source. These work correctly with an "INSERT INTO ... VALUES ..." statement. I've included example user and final query plan data below for the non-working [1] and working [2] insert statements. > [1] source hint not applied to ProjectIntoNode: > USER COMMAND: > INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") SELECT X.id AS ID, X."value" AS "VALUE" FROM (SELECT bqt.SMALLA.INTKEY AS id, bqt.SMALLA.INTNUM AS "value" FROM bqt.SMALLA WHERE bqt.SMALLA.INTKEY = 0) AS X > ... > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > ProjectIntoNode(0) output=[Count] test.TEST > AccessNode(1) output=[bqt.SMALLA.INTKEY AS ID, bqt.SMALLA.INTNUM AS "VALUE"] SELECT /*+sh test:'append' */ g_0.INTKEY, g_0.INTNUM FROM bqt.SMALLA AS g_0 WHERE g_0.INTKEY = 0 > [2] source hint applied to AccessNode: > USER COMMAND: > INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") VALUES ('-1', '-1') > ... > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > AccessNode(0) output=[Count] INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") VALUES ('-1', '-1') -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

by sameer P (JIRA)

[ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin... ] sameer P commented on TEIID-4284: --------------------------------- Got it. Thanks for the explanation Steven. Yeah looks like the *Completed* state is never reached. Unfortunately it happened the same with other tables too. > Implement Salesforce Bulk API for SELECTS to Salesforce Connector > ----------------------------------------------------------------- > > Key: TEIID-4284 > URL: https://issues.jboss.org/browse/TEIID-4284 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Affects Versions: 8.13.5 > Environment: With Salesforce datasource > Reporter: sameer P > Assignee: Steven Hawkins > Fix For: 9.1 > > > There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT. > The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy... . -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4469) Insert with query expression does not apply source hint to target

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4469?page=com.atlassian.jira.plugin... ] Lucie Fabrikova updated TEIID-4469: ----------------------------------- Attachment: oracledba-vdb.xml > Insert with query expression does not apply source hint to target > ----------------------------------------------------------------- > > Key: TEIID-4469 > URL: https://issues.jboss.org/browse/TEIID-4469 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.5, 8.7.10_6.2 > > Attachments: oracledba-vdb.xml > > > "INSERT INTO ... SELECT ..." statements result in a ProjectIntoNode which seems to prevent any source hints from being passed down to the relevant source. These work correctly with an "INSERT INTO ... VALUES ..." statement. I've included example user and final query plan data below for the non-working [1] and working [2] insert statements. > [1] source hint not applied to ProjectIntoNode: > USER COMMAND: > INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") SELECT X.id AS ID, X."value" AS "VALUE" FROM (SELECT bqt.SMALLA.INTKEY AS id, bqt.SMALLA.INTNUM AS "value" FROM bqt.SMALLA WHERE bqt.SMALLA.INTKEY = 0) AS X > ... > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > ProjectIntoNode(0) output=[Count] test.TEST > AccessNode(1) output=[bqt.SMALLA.INTKEY AS ID, bqt.SMALLA.INTNUM AS "VALUE"] SELECT /*+sh test:'append' */ g_0.INTKEY, g_0.INTNUM FROM bqt.SMALLA AS g_0 WHERE g_0.INTKEY = 0 > [2] source hint applied to AccessNode: > USER COMMAND: > INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") VALUES ('-1', '-1') > ... > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > AccessNode(0) output=[Count] INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") VALUES ('-1', '-1') -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4284: --------------------------------------- > And the only concern is that the query runs for a really long time (never stopped on its own still) with the below statements in the log After the initial blocking, the connector will retry the getBatchInfo https://github.com/teiid/teiid/blob/master/connectors/connector-salesforc... operation on a fixed interval. So you should see those logs repeated correct? Following https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy... and with my local testing the code expects salesforce to return a state of Completed. What you are seeing suggests that you are never reaching that state. > Implement Salesforce Bulk API for SELECTS to Salesforce Connector > ----------------------------------------------------------------- > > Key: TEIID-4284 > URL: https://issues.jboss.org/browse/TEIID-4284 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Affects Versions: 8.13.5 > Environment: With Salesforce datasource > Reporter: sameer P > Assignee: Steven Hawkins > Fix For: 9.1 > > > There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT. > The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy... . -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

by sameer P (JIRA)

[ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin... ] sameer P edited comment on TEIID-4284 at 10/10/16 11:16 AM: ------------------------------------------------------------ I got your point [~shawkins], here, the query should be {code:java} SELECT /*+ sh sf:'bulk' */ * FROM "source"."test_table_vz__c" {code} Correct? . I ran it . And the only concern is that the query runs for a really long time (never stopped on its own still) with the below statements in the log: {code:java} 17:15:51,743 DEBUG [org.teiid.BUFFER_MGR] (Worker4_QueryProcessorQueue1010) gL9WQ/EygEZA gL9WQ/EygEZA.10.0.2 Blocking on DataNotAvailableException gL9WQ/EygEZA.10.0.2 17:15:51,744 DEBUG [org.teiid.BUFFER_MGR] (Worker4_QueryProcessorQueue1010) gL9WQ/EygEZA gL9WQ/EygEZA.10 Blocking on source request(s). 17:15:51,744 DEBUG [org.teiid.PROCESSOR] (Worker4_QueryProcessorQueue1010) gL9WQ/EygEZA Request Thread gL9WQ/EygEZA.10 - processor blocked {code} was (Author: sameerp): I got your point [~shawkins], here, the query should be {code:java} SELECT /*+ sh sf:'bulk' */ * FROM "source"."test_table_vz__c" {code} Correct? . I ran it . And the only concern is that the query runs for a really long time (never stopped on its own still) with the below statements in the log: {code:java} 17:12:59,116 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue578) gL9WQ/EygEZA gL9WQ/EygEZA.9 Blocking on source request(s). 17:12:59,116 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue578) gL9WQ/EygEZA Request Thread gL9WQ/EygEZA.9 - processor blocke {code} > Implement Salesforce Bulk API for SELECTS to Salesforce Connector > ----------------------------------------------------------------- > > Key: TEIID-4284 > URL: https://issues.jboss.org/browse/TEIID-4284 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Affects Versions: 8.13.5 > Environment: With Salesforce datasource > Reporter: sameer P > Assignee: Steven Hawkins > Fix For: 9.1 > > > There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT. > The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy... . -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4284: --------------------------------------- Please revert any changes you have and use the query: SELECT /*+ sh sf:'bulk' */ * FROM "source"."test_table_vz__c" Unfortunately to accommodate multi-source scenarios, we expect the source hint to match the source name, not the model name. > Implement Salesforce Bulk API for SELECTS to Salesforce Connector > ----------------------------------------------------------------- > > Key: TEIID-4284 > URL: https://issues.jboss.org/browse/TEIID-4284 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Affects Versions: 8.13.5 > Environment: With Salesforce datasource > Reporter: sameer P > Assignee: Steven Hawkins > Fix For: 9.1 > > > There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT. > The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy... . -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4469) Insert with query expression does not apply source hint to target

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4469?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4469: --------------------------------------- Please provide your vdb or confirm what the source names are for the Oracle sources. As I see the source hint being applied to the Source model query: SELECT /*+sh Source2:'append' */ g_0.intkey, g_0.intnum FROM Source.smalla AS g_0 WHERE g_0.intkey = 1 > Insert with query expression does not apply source hint to target > ----------------------------------------------------------------- > > Key: TEIID-4469 > URL: https://issues.jboss.org/browse/TEIID-4469 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.5, 8.7.10_6.2 > > > "INSERT INTO ... SELECT ..." statements result in a ProjectIntoNode which seems to prevent any source hints from being passed down to the relevant source. These work correctly with an "INSERT INTO ... VALUES ..." statement. I've included example user and final query plan data below for the non-working [1] and working [2] insert statements. > [1] source hint not applied to ProjectIntoNode: > USER COMMAND: > INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") SELECT X.id AS ID, X."value" AS "VALUE" FROM (SELECT bqt.SMALLA.INTKEY AS id, bqt.SMALLA.INTNUM AS "value" FROM bqt.SMALLA WHERE bqt.SMALLA.INTKEY = 0) AS X > ... > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > ProjectIntoNode(0) output=[Count] test.TEST > AccessNode(1) output=[bqt.SMALLA.INTKEY AS ID, bqt.SMALLA.INTNUM AS "VALUE"] SELECT /*+sh test:'append' */ g_0.INTKEY, g_0.INTNUM FROM bqt.SMALLA AS g_0 WHERE g_0.INTKEY = 0 > [2] source hint applied to AccessNode: > USER COMMAND: > INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") VALUES ('-1', '-1') > ... > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > AccessNode(0) output=[Count] INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") VALUES ('-1', '-1') -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

by sameer P (JIRA)

[ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin... ] sameer P commented on TEIID-4284: --------------------------------- I got your point [~shawkins], here, the query should be {code:java} SELECT /*+ sh sf:'bulk' */ * FROM "source"."test_table_vz__c" {code} Correct? . I ran it . And the only concern is that the query runs for a really long time (never stopped on its own still) with the below statements in the log: {code:java} 17:12:59,116 DEBUG [org.teiid.BUFFER_MGR] (Worker3_QueryProcessorQueue578) gL9WQ/EygEZA gL9WQ/EygEZA.9 Blocking on source request(s). 17:12:59,116 DEBUG [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue578) gL9WQ/EygEZA Request Thread gL9WQ/EygEZA.9 - processor blocke {code} > Implement Salesforce Bulk API for SELECTS to Salesforce Connector > ----------------------------------------------------------------- > > Key: TEIID-4284 > URL: https://issues.jboss.org/browse/TEIID-4284 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Affects Versions: 8.13.5 > Environment: With Salesforce datasource > Reporter: sameer P > Assignee: Steven Hawkins > Fix For: 9.1 > > > There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT. > The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy... . -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4469) Insert with query expression does not apply source hint to target

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4469?page=com.atlassian.jira.plugin... ] Lucie Fabrikova commented on TEIID-4469: ---------------------------------------- I was testing DV 6.2.9, I also checked the source code delivered together with it and it contained the fixes. > Insert with query expression does not apply source hint to target > ----------------------------------------------------------------- > > Key: TEIID-4469 > URL: https://issues.jboss.org/browse/TEIID-4469 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.5, 8.7.10_6.2 > > > "INSERT INTO ... SELECT ..." statements result in a ProjectIntoNode which seems to prevent any source hints from being passed down to the relevant source. These work correctly with an "INSERT INTO ... VALUES ..." statement. I've included example user and final query plan data below for the non-working [1] and working [2] insert statements. > [1] source hint not applied to ProjectIntoNode: > USER COMMAND: > INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") SELECT X.id AS ID, X."value" AS "VALUE" FROM (SELECT bqt.SMALLA.INTKEY AS id, bqt.SMALLA.INTNUM AS "value" FROM bqt.SMALLA WHERE bqt.SMALLA.INTKEY = 0) AS X > ... > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > ProjectIntoNode(0) output=[Count] test.TEST > AccessNode(1) output=[bqt.SMALLA.INTKEY AS ID, bqt.SMALLA.INTNUM AS "VALUE"] SELECT /*+sh test:'append' */ g_0.INTKEY, g_0.INTNUM FROM bqt.SMALLA AS g_0 WHERE g_0.INTKEY = 0 > [2] source hint applied to AccessNode: > USER COMMAND: > INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") VALUES ('-1', '-1') > ... > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > AccessNode(0) output=[Count] INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") VALUES ('-1', '-1') -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

by sameer P (JIRA)

[ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin... ] sameer P commented on TEIID-4284: --------------------------------- here, *source* itself is the name of the datasource configured as shown below: {code:java} <vdb name="test" version="1"> <description>Test VDB</description>  <property name="UseConnectorMetadata" value="true" />  <model visible="true" name="source"> <source name="sf" translator-name="salesforce-34" connection-jndi-name="java:/salesforce34"/> </model> </vdb> {code} And by infinite loop, I meant to say a long running non stop query (sorry for the non-precise word) . And it runs continously and won't come out. > Implement Salesforce Bulk API for SELECTS to Salesforce Connector > ----------------------------------------------------------------- > > Key: TEIID-4284 > URL: https://issues.jboss.org/browse/TEIID-4284 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Affects Versions: 8.13.5 > Environment: With Salesforce datasource > Reporter: sameer P > Assignee: Steven Hawkins > Fix For: 9.1 > > > There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT. > The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy... . -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4284: --------------------------------------- > where source is the Salesforce Datasource source is the source name (not translator nor model name) in the vdb? {code} <model ...> <source name="source" ... </model> {code} > And about changing the source, I just removed this condition from the if block. I do not see how the behavior you are describing would arise. Where is an infinite loop coming into play? > Implement Salesforce Bulk API for SELECTS to Salesforce Connector > ----------------------------------------------------------------- > > Key: TEIID-4284 > URL: https://issues.jboss.org/browse/TEIID-4284 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Affects Versions: 8.13.5 > Environment: With Salesforce datasource > Reporter: sameer P > Assignee: Steven Hawkins > Fix For: 9.1 > > > There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT. > The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy... . -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4500) Make documents to capable of building outside the GitBooks

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4500?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4500: --------------------------------------- Just to clarify a couple these points, the short comings may be more of a misunderstanding than an issue with gitbook. The main takeaways though of having more control over pdf generation, having more than 2 published books, etc. remain valid. > There is no way to check the documentation formatting external to the GitBook. You can follow the local build instructions and use "gitbook serve" - https://github.com/teiid/teiid-documents > I am sure there is way to export, but that may need human to do that? The appropriate export is just a link. > I do also like Infinispans style sheets better than the current default GitBook's, we should adapt them too. The style isn't really due to GitBook per se other than it's mostly the default. You mainly need to configure the book.json with whatever additional themes and options you want. > Make documents to capable of building outside the GitBooks > ---------------------------------------------------------- > > Key: TEIID-4500 > URL: https://issues.jboss.org/browse/TEIID-4500 > Project: Teiid > Issue Type: Task > Components: Documentation > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Fix For: 9.2 > > > Currently Teiid documentation is only built by automated process by GitBooks. However, this causes couple issues > * There is no way to check the documentation formatting external to the GitBook. > * Documents need to be always hosted by the Gitbook. I am sure there is way to export, but that may need human to do that? Going forward we would need a automated way if one wants to bundle the documents. > * Gitbook only allows two books for free, we already against this limit with no resolution with the paid route. > Thus it may be better we also have alternative ways to generate final documents, and be able to host on teiid.org. I find an example with Infinispan documents, we just need to mimic what they are doing > >> We have also implemented generation of PDFs via the > > > asciidoctor-maven-plugin with optimized post-processing via GhostScript > > > (which shrinks the size of the PDFs to a 1/4 of the size). > > > Look at [2] and [3] to see how that is done. > > > > > > Tristan > > > > > > [1] http://infinispan.org/docs/dev/user_guide/user_guide.html > > > [2] > > > https://github.com/infinispan/infinispan/blob/master/documentation/pom.xml > > > [3] > > > https://github.com/infinispan/infinispan/blob/master/documentation/optimi... > also look at their google-analytics stuff, that is very useful to have. I do also like Infinispans style sheets better than the current default GitBook's, we should adapt them too. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4500) Make documents to capable of building outside the GitBooks

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-4500: ----------------------------------- Summary: Make documents to capable of building outside the GitBooks Key: TEIID-4500 URL: https://issues.jboss.org/browse/TEIID-4500 Project: Teiid Issue Type: Task Components: Documentation Reporter: Ramesh Reddy Assignee: Steven Hawkins Fix For: 9.2 Currently Teiid documentation is only built by automated process by GitBooks. However, this causes couple issues * There is no way to check the documentation formatting external to the GitBook. * Documents need to be always hosted by the Gitbook. I am sure there is way to export, but that may need human to do that? Going forward we would need a automated way if one wants to bundle the documents. * Gitbook only allows two books for free, we already against this limit with no resolution with the paid route. Thus it may be better we also have alternative ways to generate final documents, and be able to host on teiid.org. I find an example with Infinispan documents, we just need to mimic what they are doing >> We have also implemented generation of PDFs via the > > asciidoctor-maven-plugin with optimized post-processing via GhostScript > > (which shrinks the size of the PDFs to a 1/4 of the size). > > Look at [2] and [3] to see how that is done. > > > > Tristan > > > > [1] http://infinispan.org/docs/dev/user_guide/user_guide.html > > [2] > > https://github.com/infinispan/infinispan/blob/master/documentation/pom.xml > > [3] > > https://github.com/infinispan/infinispan/blob/master/documentation/optimi... also look at their google-analytics stuff, that is very useful to have. I do also like Infinispans style sheets better than the current default GitBook's, we should adapt them too. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

by sameer P (JIRA)

[ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin... ] sameer P edited comment on TEIID-4284 at 10/10/16 9:12 AM: ----------------------------------------------------------- Hi [~shawkins], regarding the query I submitted, Its exactly {code:java} SELECT /*+ sh source:'bulk' */ * FROM "source"."test_table_vz__c" {code} where source is the Salesforce Datasource. This I happened to notice because there was not much difference with the Bulk API with the huge data. So, I tried to debug the teiid code and I noticed that *(context.getSourceHints() != null && context.getSourceHints().contains("bulk")* condition fails. And about changing the source, I just removed this condition from the if block. was (Author: sameerp): Hi [~shawkins], regarding the query I submitted, Its exactly {code:java} SELECT /*+ sh source:'bulk' */ * FROM "source"."test_table_vz__c" {code} where source is the Salesforce Datasource. This I happened to notice because there was not much difference with the Bulk API with the huge data. So, I tried to debug the teiid code and I noticed that * (context.getSourceHints() != null && context.getSourceHints().contains("bulk") * condition fails. And about changing the source, I just removed this condition from the if block. > Implement Salesforce Bulk API for SELECTS to Salesforce Connector > ----------------------------------------------------------------- > > Key: TEIID-4284 > URL: https://issues.jboss.org/browse/TEIID-4284 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Affects Versions: 8.13.5 > Environment: With Salesforce datasource > Reporter: sameer P > Assignee: Steven Hawkins > Fix For: 9.1 > > > There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT. > The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy... . -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

by sameer P (JIRA)

[ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin... ] sameer P commented on TEIID-4284: --------------------------------- Hi [~shawkins], regarding the query I submitted, Its exactly {code:java} SELECT /*+ sh source:'bulk' */ * FROM "source"."test_table_vz__c" {code} where source is the Salesforce Datasource. This I happened to notice because there was not much difference with the Bulk API with the huge data. So, I tried to debug the teiid code and I noticed that * (context.getSourceHints() != null && context.getSourceHints().contains("bulk") * condition fails. And about changing the source, I just removed this condition from the if block. > Implement Salesforce Bulk API for SELECTS to Salesforce Connector > ----------------------------------------------------------------- > > Key: TEIID-4284 > URL: https://issues.jboss.org/browse/TEIID-4284 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Affects Versions: 8.13.5 > Environment: With Salesforce datasource > Reporter: sameer P > Assignee: Steven Hawkins > Fix For: 9.1 > > > There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT. > The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy... . -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4284: --------------------------------------- > As I debugged and checked, the source hint will not be considered at all by the QueryExecutionImpl More than likely there's an issue with your user query. What are you submitting? > like bulk is not a keyword yet in the query parser As a hint, it is not expected to be. > And, when I removed this condition at all which checks the source hint, it goes in an infinite loop for the second query, with huge many requests and it does not return from it. Am I missing something here? or am I doing something wrong? You mean you are modifying the source? I can't really say without fully say what you are seeing without seeing the full change you are making. > Implement Salesforce Bulk API for SELECTS to Salesforce Connector > ----------------------------------------------------------------- > > Key: TEIID-4284 > URL: https://issues.jboss.org/browse/TEIID-4284 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Affects Versions: 8.13.5 > Environment: With Salesforce datasource > Reporter: sameer P > Assignee: Steven Hawkins > Fix For: 9.1 > > > There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT. > The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy... . -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4499) OData Kerberos cannot access VDB

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4499?page=com.atlassian.jira.plugin... ] Ramesh Reddy reassigned TEIID-4499: ----------------------------------- Assignee: Ramesh Reddy (was: Steven Hawkins) > OData Kerberos cannot access VDB > -------------------------------- > > Key: TEIID-4499 > URL: https://issues.jboss.org/browse/TEIID-4499 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.12.6.6_3 > Reporter: Jan Stastny > Assignee: Ramesh Reddy > Priority: Critical > > When configured odata war for Kerberos using https://teiid.gitbooks.io/documents/content/security/Kerberos_support_thr... an error occurs when accessing a vdb, which is also secured by Kerberos. > The error is following: > {code:plain} > 11:44:53,360 WARN [org.teiid.ODATA] (http-127.0.0.1:8080-1) TEIID16047 Could not process OData 4 request: 08001 TEIID40055 org.teiid.core.TeiidException: TEIID40055 org.teiid.net.ConnectionException: TEIID40055 Wrong logon method is being used. Server is not set up for GSS based authentication.: org.teiid.core.TeiidProcessingException: 08001 TEIID40055 org.teiid.core.TeiidException: TEIID40055 org.teiid.net.ConnectionException: TEIID40055 Wrong logon method is being used. Server is not set up for GSS based authentication. > at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:233) [teiid-olingo-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] > at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:100) [teiid-olingo-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.jboss.security.negotiation.NegotiationAuthenticator$WrapperValve.invoke(NegotiationAuthenticator.java:492) [jboss-negotiation-common-2.3.11.Final-redhat-1.jar:2.3.11.Final-redhat-1] > at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.9.Final-redhat-2.jar:7.5.9.Final-redhat-2] > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:654) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_102] > Caused by: org.teiid.jdbc.TeiidSQLException: TEIID40055 org.teiid.core.TeiidException: TEIID40055 org.teiid.net.ConnectionException: TEIID40055 Wrong logon method is being used. Server is not set up for GSS based authentication. > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) > at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:55) > at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:105) > at org.teiid.olingo.service.LocalClient.buildConnection(LocalClient.java:119) [teiid-olingo-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] > at org.teiid.olingo.service.LocalClient.open(LocalClient.java:89) [teiid-olingo-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] > at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:226) [teiid-olingo-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] > ... 16 more > Caused by: org.teiid.core.TeiidException: TEIID40055 org.teiid.core.TeiidException: TEIID40055 org.teiid.net.ConnectionException: TEIID40055 Wrong logon method is being used. Server is not set up for GSS based authentication. > at org.teiid.core.util.ReflectionHelper.create(ReflectionHelper.java:308) [teiid-common-core-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] > at org.teiid.jdbc.ModuleHelper.createFromModule(ModuleHelper.java:53) > at org.teiid.jdbc.EmbeddedProfile.createServerConnection(EmbeddedProfile.java:60) > at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:50) > ... 20 more > Caused by: org.teiid.core.TeiidException: TEIID40055 org.teiid.net.ConnectionException: TEIID40055 Wrong logon method is being used. Server is not set up for GSS based authentication. > at org.teiid.core.util.ReflectionHelper.create(ReflectionHelper.java:345) [teiid-common-core-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] > at org.teiid.core.util.ReflectionHelper.create(ReflectionHelper.java:306) [teiid-common-core-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] > ... 23 more > Caused by: org.teiid.net.ConnectionException: TEIID40055 Wrong logon method is being used. Server is not set up for GSS based authentication. > at org.teiid.transport.LocalServerConnection.authenticate(LocalServerConnection.java:146) > at org.teiid.transport.LocalServerConnection.<init>(LocalServerConnection.java:106) > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.8.0_102] > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [rt.jar:1.8.0_102] > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.8.0_102] > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [rt.jar:1.8.0_102] > at org.teiid.core.util.ReflectionHelper.create(ReflectionHelper.java:343) [teiid-common-core-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] > ... 24 more > Caused by: org.teiid.client.security.LogonException: TEIID40055 Wrong logon method is being used. Server is not set up for GSS based authentication. > at org.teiid.transport.LogonImpl.logon(LogonImpl.java:119) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_102] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_102] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_102] > at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_102] > at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:180) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_102] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260) > at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:178) > at com.sun.proxy.$Proxy81.logon(Unknown Source) > at org.teiid.transport.LocalServerConnection.authenticate(LocalServerConnection.java:142) > ... 30 more > {code} > Authentication of the user succeeded: > {code:plain} > principal is dv(a)EXAMPLE.COM > Will use keytab > Commit Succeeded > {code} > Authentication of the server succeeded: > {code:plain} > 11:44:52,873 INFO [stdout] (http-127.0.0.1:8080-1) Acquire TGT from Cache > 11:44:52,874 INFO [stdout] (http-127.0.0.1:8080-1) Principal is HTTP/localhost(a)EXAMPLE.COM > 11:44:52,874 INFO [stdout] (http-127.0.0.1:8080-1) null credentials from Ticket Cache > 11:44:53,234 INFO [stdout] (http-127.0.0.1:8080-1) principal is HTTP/localhost(a)EXAMPLE.COM > 11:44:53,234 INFO [stdout] (http-127.0.0.1:8080-1) Will use keytab > 11:44:53,236 INFO [stdout] (http-127.0.0.1:8080-1) Commit Succeeded > {code} > Initial request: > {code:plain} > 12:44:52,325 DEBUG [MainClientExec] Opening connection {}->http://localhost:8080 > 12:44:52,327 DEBUG [DefaultHttpClientConnectionOperator] Connecting to localhost/127.0.0.1:8080 > 12:44:52,328 DEBUG [DefaultHttpClientConnectionOperator] Connection established 127.0.0.1:47980<->127.0.0.1:8080 > 12:44:52,328 DEBUG [MainClientExec] Executing request GET /odata4/kerberos_teiid/BQT1/smalla HTTP/1.1 > 12:44:52,328 DEBUG [MainClientExec] Target auth state: UNCHALLENGED > 12:44:52,329 DEBUG [MainClientExec] Proxy auth state: UNCHALLENGED > 12:44:52,330 DEBUG [headers] http-outgoing-0 >> GET /odata4/kerberos_teiid/BQT1/smalla HTTP/1.1 > 12:44:52,330 DEBUG [headers] http-outgoing-0 >> Host: localhost:8080 > 12:44:52,330 DEBUG [headers] http-outgoing-0 >> Connection: Keep-Alive > 12:44:52,330 DEBUG [headers] http-outgoing-0 >> User-Agent: Apache-HttpClient/4.5.2 (Java/1.8.0_51) > 12:44:52,330 DEBUG [headers] http-outgoing-0 >> Accept-Encoding: gzip,deflate > 12:44:52,330 DEBUG [wire] http-outgoing-0 >> "GET /odata4/kerberos_teiid/BQT1/smalla HTTP/1.1[\r][\n]" > 12:44:52,330 DEBUG [wire] http-outgoing-0 >> "Host: localhost:8080[\r][\n]" > 12:44:52,331 DEBUG [wire] http-outgoing-0 >> "Connection: Keep-Alive[\r][\n]" > 12:44:52,331 DEBUG [wire] http-outgoing-0 >> "User-Agent: Apache-HttpClient/4.5.2 (Java/1.8.0_51)[\r][\n]" > 12:44:52,331 DEBUG [wire] http-outgoing-0 >> "Accept-Encoding: gzip,deflate[\r][\n]" > 12:44:52,331 DEBUG [wire] http-outgoing-0 >> "[\r][\n]" > {code} > Negotiate request from server: > {code:plain} > 12:44:52,457 DEBUG [wire] http-outgoing-0 << "HTTP/1.1 401 Unauthorized[\r][\n]" > 12:44:52,457 DEBUG [wire] http-outgoing-0 << "Server: Apache-Coyote/1.1[\r][\n]" > 12:44:52,457 DEBUG [wire] http-outgoing-0 << "Pragma: No-cache[\r][\n]" > 12:44:52,457 DEBUG [wire] http-outgoing-0 << "Cache-Control: no-cache[\r][\n]" > 12:44:52,457 DEBUG [wire] http-outgoing-0 << "Expires: Thu, 01 Jan 1970 01:00:00 GMT+01:00[\r][\n]" > 12:44:52,457 DEBUG [wire] http-outgoing-0 << "WWW-Authenticate: Negotiate[\r][\n]" > 12:44:52,457 DEBUG [wire] http-outgoing-0 << "Content-Type: text/html;charset=utf-8[\r][\n]" > 12:44:52,457 DEBUG [wire] http-outgoing-0 << "Content-Length: 996[\r][\n]" > 12:44:52,457 DEBUG [wire] http-outgoing-0 << "Date: Mon, 10 Oct 2016 10:44:52 GMT[\r][\n]" > 12:44:52,457 DEBUG [wire] http-outgoing-0 << "[\r][\n]" > 12:44:52,457 DEBUG [wire] http-outgoing-0 << "<html><head><title>JBWEB000065: HTTP Status 401 - </title><style></style> </head><body><h1>JBWEB000065: HTTP Status 401 - </h1><HR size="1" noshade="noshade"><p><b>JBWEB000309: type</b> JBWEB000067: Status report</p><p><b>JBWEB000068: message</b> <u></u></p><p><b>JBWEB000069: description</b> <u>JBWEB000121: This request requires HTTP authentication.</u></p><HR size="1" noshade="noshade"></body></html>" > 12:44:52,459 DEBUG [headers] http-outgoing-0 << HTTP/1.1 401 Unauthorized > 12:44:52,459 DEBUG [headers] http-outgoing-0 << Server: Apache-Coyote/1.1 > 12:44:52,459 DEBUG [headers] http-outgoing-0 << Pragma: No-cache > 12:44:52,460 DEBUG [headers] http-outgoing-0 << Cache-Control: no-cache > 12:44:52,460 DEBUG [headers] http-outgoing-0 << Expires: Thu, 01 Jan 1970 01:00:00 GMT+01:00 > 12:44:52,460 DEBUG [headers] http-outgoing-0 << WWW-Authenticate: Negotiate > 12:44:52,460 DEBUG [headers] http-outgoing-0 << Content-Type: text/html;charset=utf-8 > 12:44:52,460 DEBUG [headers] http-outgoing-0 << Content-Length: 996 > 12:44:52,460 DEBUG [headers] http-outgoing-0 << Date: Mon, 10 Oct 2016 10:44:52 GMT > {code} > Response to auth server: > {code:plain} > Found ticket for dv(a)EXAMPLE.COM to go to krbtgt/EXAMPLE.COM(a)EXAMPLE.COM expiring on Mon Oct 10 20:44:52 CEST 2016 > Entered Krb5Context.initSecContext with state=STATE_NEW > Service ticket not found in the subject > 12:44:52,846 DEBUG [SPNegoScheme] Sending response 'YIIEjgYGKwYBBQUCoIIEgjCCBH6gDTALBgkqhkiG9xIBAgKhBAMCAfaiggRlBIIEYWCCBF0GCSqGSIb3EgECAgEAboIETDCCBEigAwIBBaEDAgEOogcDBQAgAAAAo4IBBmGCAQIwgf+gAwIBBaEbGxlNVy5MQUIuRU5HLkJPUy5SRURIQVQuQ09NohwwGqADAgEAoRMwERsESFRUUBsJbG9jYWxob3N0o4G8MIG5oAMCARGhAwIBBKKBrASBqdJuL2wF7+W0MD1qISt66VAyhitq77SR6vLKWJnpc/Yx60ch80GepVlYdoYxee0qW+d4u6aw3p0BaOWSgSMRoDnr9bSUn+tQXNevIfKE+oUM+5lC4afhAF0PB4dcJC7z6/wLZ9drDImvyhntm9lq/yv5LW76gSbVd9SjO58ZvD3cYRJnuF3CaFhm5ol0ce84ojZdX5mVvVBUU3+Vo1rh6SSEKda+xoBkK/ykggMnMIIDI6ADAgERooIDGgSCAxaG8huKFUf6vR0wVfeI1caKfIPtGC9rDSw5DYTz1dz43F8GI9we3YG9NC6kEi1zPdA4A2dxfBqgUl+/YkBdQco4udBCwLXNmziHCS5ypypBJsFdgFzRi/9hXukmqofSGIlKVJWH3ap1ap+37Amfm6LxZuQFDyY526onGXdWoAB0Jbcpsi74Ti5x3sRGZqoF5FTwUqI0pQYI+hLDh2GeBNXBNOHqdMXNfnLFOr+LpnNhl7ROxkWsBxNPv/4MmRLPsF/cGrc924L6R4PQvP7qVjGKUxayEoBPP/go5xb2b2z+TjruspzbJ5dw1wKAOH2RGlDJ5om0PUSqaxe0h2WhL9rXBOGVONTSv7lYQ2pcgaOqR6FutB5PZGP0B73ekwhbRfrt6zxLpHzZFnrSeV9lz1U4r8Bkyxuze3cuQGcL/cNTBbhE83cbNY8VJlu4E+6LmZ9ll3vpjNq3735S6gFArsOJ38FcLO0Kqj1rZr7/r9TRsV9f8agDnWusc5lQzZc+4H0BIeAPD34ApJxGogA63/8yF1Pl3uc1Rp+a6blQHLLCRZthIpi8LVF8rSizTkTDWUrTw+X5wGDunjslrUmClW25qzGeLTZpELrJXkKFstUnL4blaPboyPk8qDecaRed+dIjteVS9CgF51AtHrO9vhWgrr41TL+H8akHfjI6Q9GIgravWLSkNrVMsrNyVAlc1hdUAovLXJFfxS3Mg0OugjG3rJhSCiQqLCuhIRL8OB4Fz4Pa24fpBG0G/Rv1RrhuQaKoxNsZxuR67zzF+v7+4PRKK39y0cqFWBf95YV4SWz7qzXmZYcaDcVhrFzp723ecWunVa6Qt5YUZ3+pkKV+NGGb95PjS7HtvXZo4ko5tJX1QI+ke4I3j3cThrWlV5y3rNC2IKiE8eRNI6rKRGdvpYLwkL0B5AkJleqGjdiqZVy6Q2w/YdHN2oTOs8qUgIVgPHJMyRLUTT872ZOWdmmHWJuIe3sVkr1RLFDV2csmYggSZCbjCczFvlmKrcn6OLqVRGN3sNm6a9Q45wZimLvIkxePHag3vvtp' back to the auth server > 12:44:52,846 DEBUG [MainClientExec] Proxy auth state: UNCHALLENGED > 12:44:52,846 DEBUG [headers] http-outgoing-0 >> GET /odata4/kerberos_teiid/BQT1/smalla HTTP/1.1 > 12:44:52,846 DEBUG [headers] http-outgoing-0 >> Host: localhost:8080 > 12:44:52,846 DEBUG [headers] http-outgoing-0 >> Connection: Keep-Alive > 12:44:52,846 DEBUG [headers] http-outgoing-0 >> User-Agent: Apache-HttpClient/4.5.2 (Java/1.8.0_51) > 12:44:52,846 DEBUG [headers] http-outgoing-0 >> Accept-Encoding: gzip,deflate > 12:44:52,846 DEBUG [headers] http-outgoing-0 >> Authorization: Negotiate YIIEjgYGKwYBBQUCoIIEgjCCBH6gDTALBgkqhkiG9xIBAgKhBAMCAfaiggRlBIIEYWCCBF0GCSqGSIb3EgECAgEAboIETDCCBEigAwIBBaEDAgEOogcDBQAgAAAAo4IBBmGCAQIwgf+gAwIBBaEbGxlNVy5MQUIuRU5HLkJPUy5SRURIQVQuQ09NohwwGqADAgEAoRMwERsESFRUUBsJbG9jYWxob3N0o4G8MIG5oAMCARGhAwIBBKKBrASBqdJuL2wF7+W0MD1qISt66VAyhitq77SR6vLKWJnpc/Yx60ch80GepVlYdoYxee0qW+d4u6aw3p0BaOWSgSMRoDnr9bSUn+tQXNevIfKE+oUM+5lC4afhAF0PB4dcJC7z6/wLZ9drDImvyhntm9lq/yv5LW76gSbVd9SjO58ZvD3cYRJnuF3CaFhm5ol0ce84ojZdX5mVvVBUU3+Vo1rh6SSEKda+xoBkK/ykggMnMIIDI6ADAgERooIDGgSCAxaG8huKFUf6vR0wVfeI1caKfIPtGC9rDSw5DYTz1dz43F8GI9we3YG9NC6kEi1zPdA4A2dxfBqgUl+/YkBdQco4udBCwLXNmziHCS5ypypBJsFdgFzRi/9hXukmqofSGIlKVJWH3ap1ap+37Amfm6LxZuQFDyY526onGXdWoAB0Jbcpsi74Ti5x3sRGZqoF5FTwUqI0pQYI+hLDh2GeBNXBNOHqdMXNfnLFOr+LpnNhl7ROxkWsBxNPv/4MmRLPsF/cGrc924L6R4PQvP7qVjGKUxayEoBPP/go5xb2b2z+TjruspzbJ5dw1wKAOH2RGlDJ5om0PUSqaxe0h2WhL9rXBOGVONTSv7lYQ2pcgaOqR6FutB5PZGP0B73ekwhbRfrt6zxLpHzZFnrSeV9lz1U4r8Bkyxuze3cuQGcL/cNTBbhE83cbNY8VJlu4E+6LmZ9ll3vpjNq3735S6gFArsOJ38FcLO0Kqj1rZr7/r9TRsV9f8agDnWusc5lQzZc+4H0BIeAPD34ApJxGogA63/8yF1Pl3uc1Rp+a6blQHLLCRZthIpi8LVF8rSizTkTDWUrTw+X5wGDunjslrUmClW25qzGeLTZpELrJXkKFstUnL4blaPboyPk8qDecaRed+dIjteVS9CgF51AtHrO9vhWgrr41TL+H8akHfjI6Q9GIgravWLSkNrVMsrNyVAlc1hdUAovLXJFfxS3Mg0OugjG3rJhSCiQqLCuhIRL8OB4Fz4Pa24fpBG0G/Rv1RrhuQaKoxNsZxuR67zzF+v7+4PRKK39y0cqFWBf95YV4SWz7qzXmZYcaDcVhrFzp723ecWunVa6Qt5YUZ3+pkKV+NGGb95PjS7HtvXZo4ko5tJX1QI+ke4I3j3cThrWlV5y3rNC2IKiE8eRNI6rKRGdvpYLwkL0B5AkJleqGjdiqZVy6Q2w/YdHN2oTOs8qUgIVgPHJMyRLUTT872ZOWdmmHWJuIe3sVkr1RLFDV2csmYggSZCbjCczFvlmKrcn6OLqVRGN3sNm6a9Q45wZimLvIkxePHag3vvtp > 12:44:52,846 DEBUG [wire] http-outgoing-0 >> "GET /odata4/kerberos_teiid/BQT1/smalla HTTP/1.1[\r][\n]" > 12:44:52,846 DEBUG [wire] http-outgoing-0 >> "Host: localhost:8080[\r][\n]" > 12:44:52,847 DEBUG [wire] http-outgoing-0 >> "Connection: Keep-Alive[\r][\n]" > 12:44:52,847 DEBUG [wire] http-outgoing-0 >> "User-Agent: Apache-HttpClient/4.5.2 (Java/1.8.0_51)[\r][\n]" > 12:44:52,847 DEBUG [wire] http-outgoing-0 >> "Accept-Encoding: gzip,deflate[\r][\n]" > 12:44:52,847 DEBUG [wire] http-outgoing-0 >> "Authorization: Negotiate YIIEjgYGKwYBBQUCoIIEgjCCBH6gDTALBgkqhkiG9xIBAgKhBAMCAfaiggRlBIIEYWCCBF0GCSqGSIb3EgECAgEAboIETDCCBEigAwIBBaEDAgEOogcDBQAgAAAAo4IBBmGCAQIwgf+gAwIBBaEbGxlNVy5MQUIuRU5HLkJPUy5SRURIQVQuQ09NohwwGqADAgEAoRMwERsESFRUUBsJbG9jYWxob3N0o4G8MIG5oAMCARGhAwIBBKKBrASBqdJuL2wF7+W0MD1qISt66VAyhitq77SR6vLKWJnpc/Yx60ch80GepVlYdoYxee0qW+d4u6aw3p0BaOWSgSMRoDnr9bSUn+tQXNevIfKE+oUM+5lC4afhAF0PB4dcJC7z6/wLZ9drDImvyhntm9lq/yv5LW76gSbVd9SjO58ZvD3cYRJnuF3CaFhm5ol0ce84ojZdX5mVvVBUU3+Vo1rh6SSEKda+xoBkK/ykggMnMIIDI6ADAgERooIDGgSCAxaG8huKFUf6vR0wVfeI1caKfIPtGC9rDSw5DYTz1dz43F8GI9we3YG9NC6kEi1zPdA4A2dxfBqgUl+/YkBdQco4udBCwLXNmziHCS5ypypBJsFdgFzRi/9hXukmqofSGIlKVJWH3ap1ap+37Amfm6LxZuQFDyY526onGXdWoAB0Jbcpsi74Ti5x3sRGZqoF5FTwUqI0pQYI+hLDh2GeBNXBNOHqdMXNfnLFOr+LpnNhl7ROxkWsBxNPv/4MmRLPsF/cGrc924L6R4PQvP7qVjGKUxayEoBPP/go5xb2b2z+TjruspzbJ5dw1wKAOH2RGlDJ5om0PUSqaxe0h2WhL9rXBOGVONTSv7lYQ2pcgaOqR6FutB5PZGP0B73ekwhbRfrt6zxLpHzZFnrSeV9lz1U4r8Bkyxuze3cuQGcL/cNTBbhE83cbNY8VJlu4E+6LmZ9ll3vpjNq3735S6gFArsOJ38FcLO0Kqj1rZr7/r9TRsV9f8agDnWusc5lQzZc+4H0BIeAPD34ApJxGogA63/8yF1Pl3uc1Rp+a6blQHLLCRZthIpi8LVF8rSizTkTDWUrTw+X5wGDunjslrUmClW25qzGeLTZpELrJXkKFstUnL4blaPboyPk8qDecaRed+dIjteVS9CgF51AtHrO9vhWgrr41TL+H8akHfjI6Q9GIgravWLSkNrVMsrNyVAlc1hdUAovLXJFfxS3Mg0OugjG3rJhSCiQqLCuhIRL8OB4Fz4Pa24fpBG0G/Rv1RrhuQaKoxNsZxuR67zzF+v7+4PRKK39y0cqFWBf95YV4SWz7qzXmZYcaDcVhrFzp723ecWunVa6Qt5YUZ3+pkKV+NGGb95PjS7HtvXZo4ko5tJX1QI+ke4I3j3cThrWlV5y3rNC2IKiE8eRNI6rKRGdvpYLwkL0B5AkJleqGjdiqZVy6Q2w/YdHN2oTOs8qUgIVgPHJMyRLUTT872ZOWdmmHWJuIe3sVkr1RLFDV2csmYggSZCbjCczFvlmKrcn6OLqVRGN3sNm6a9Q45wZimLvIkxePHag3vvtp[\r][\n]" > 12:44:52,847 DEBUG [wire] http-outgoing-0 >> "[\r][\n]" > {code} > Last server logs before error: > {code:plain} > 11:44:53,246 DEBUG [org.jboss.security.auth.spi.AbstractServerLoginModule] (http-127.0.0.1:8080-1) Logged in 'host' LoginContext > 11:44:53,247 DEBUG [org.jboss.security.auth.spi.AbstractServerLoginModule] (http-127.0.0.1:8080-1) Creating new GSSContext. > 11:44:53,283 DEBUG [org.jboss.security.auth.spi.AbstractServerLoginModule] (http-127.0.0.1:8080-1) context.getCredDelegState() = true > 11:44:53,284 DEBUG [org.jboss.security.auth.spi.AbstractServerLoginModule] (http-127.0.0.1:8080-1) context.getMutualAuthState() = true > 11:44:53,284 DEBUG [org.jboss.security.auth.spi.AbstractServerLoginModule] (http-127.0.0.1:8080-1) context.getSrcName() = dv(a)EXAMPLE.COM > 11:44:53,284 INFO [stdout] (http-127.0.0.1:8080-1) [Krb5LoginModule]: Entering logout > 11:44:53,285 INFO [stdout] (http-127.0.0.1:8080-1) [Krb5LoginModule]: logged out Subject > 11:44:53,285 DEBUG [org.jboss.security.auth.spi.AbstractServerLoginModule] (http-127.0.0.1:8080-1) Storing username 'dv(a)EXAMPLE.COM' and empty password > 11:44:53,304 DEBUG [org.jboss.security.negotiation.NegotiationAuthenticator] (http-127.0.0.1:8080-1) authenticated principal = GenericPrincipal[5tV-f1mRV7tGghx2rk4krdFH_1476096292858(odata,user,)] > {code} > VDB used: > {code:xml} > <vdb name="kerberos_teiid" version="1"> > <property name="security-domain" value="EXAMPLE.COM"/> > <property name="authentication-type" value="GSS"/> > . > . > . > </vdb> > {code} > Request URL: > {code:plain} > http://localhost:8080/odata4/kerberos_teiid/BQT1/smalla > {code} > Server configuration: > {code:xml} > <security-domain name="host"> > <authentication> > <login-module code="Kerberos" flag="required" module="org.jboss.security.negotiation"> > <module-option name="storeKey" value="true"/> > <module-option name="useKeyTab" value="true"/> > <module-option name="keyTab" value="${jboss.home.dir}/HTTP_localhost"/> > <module-option name="principal" value="HTTP/localhost(a)EXAMPLE.COM"/> > <module-option name="doNotPrompt" value="true"/> > <module-option name="useTicketCache" value="true"/> > <module-option name="debug" value="true"/> > <module-option name="refreshKrb5Config" value="false"/> > <module-option name="isInitiator" value="true"/> > <module-option name="addGSSCredential" value="true"/> > <module-option name="delegationCredential" value="USE"/> > <module-option name="ticketCache" value="/tmp/krb5cc_1000"/> > </login-module> > </authentication> > </security-domain> > <security-domain name="EXAMPLE.COM"> > <authentication> > <login-module code="SPNEGO" flag="requisite" module="org.jboss.security.negotiation"> > <module-option name="password-stacking" value="useFirstPass"/> > <module-option name="serverSecurityDomain" value="host"/> > </login-module> > </authentication> > <mapping> > <mapping-module code="SimpleRoles" type="role"> > <module-option name="dv(a)EXAMPLE.COM" value="user,odata"/> > </mapping-module> > </mapping> > </security-domain> > {code} > Kerberos client configuration: > {code:plain} > ClientDV { > com.sun.security.auth.module.Krb5LoginModule required > storeKey="true" > useKeyTab="true" > keyTab="${dv.test.krb.dir}/dv.keytab" > principal="dv(a)EXAMPLE.COM" > doNotPrompt="true" > refreshKrb5Config="false" > useTicketCache="true" > ticketCache="/tmp/krb5cc_1000" > debug="true"; > }; > {code} > KRB5 configuration file is passed to server by setting system-property java.security.krb5.conf: > {code:xml} > <system-properties> > <property name="java.security.krb5.conf" value="${jboss.home.dir}/krb5.conf"/> > <property name="java.security.krb5.debug" value="true"/> > </system-properties> > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4284) Implement Salesforce Bulk API for SELECTS to Salesforce Connector

by sameer P (JIRA)

[ https://issues.jboss.org/browse/TEIID-4284?page=com.atlassian.jira.plugin... ] sameer P commented on TEIID-4284: --------------------------------- Hi [~shawkins], [~rareddy]. I tried with the latest salesforce v34 and looks like there is something wrong. As I debugged and checked, the source hint will not be considered at all by the *QueryExecutionImpl* as *(context.getSourceHints() != null && context.getSourceHints().contains("bulk")* is false always irrespective of the source hint I specify (looks like *bulk* is not a keyword yet in the query parser). And, when I removed this condition at all which checks the source hint, it goes in an infinite loop for the second query, with huge many requests and it does not return from it. Am I missing something here? or am I doing something wrong? . > Implement Salesforce Bulk API for SELECTS to Salesforce Connector > ----------------------------------------------------------------- > > Key: TEIID-4284 > URL: https://issues.jboss.org/browse/TEIID-4284 > Project: Teiid > Issue Type: Feature Request > Components: Salesforce Connector > Affects Versions: 8.13.5 > Environment: With Salesforce datasource > Reporter: sameer P > Assignee: Steven Hawkins > Fix For: 9.1 > > > There is some huge data (many GBs) in the Salesforce which has around 1.5 million rows and doing some simple select * on it fails with QUERY_TIMEOUT. > The salesforce guys suggested to try Bulk API for select with PK chunking as stated in https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asy... . -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4469) Insert with query expression does not apply source hint to target

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4469?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4469: --------------------------------------- Which branch were you testing? > Insert with query expression does not apply source hint to target > ----------------------------------------------------------------- > > Key: TEIID-4469 > URL: https://issues.jboss.org/browse/TEIID-4469 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.5, 8.7.10_6.2 > > > "INSERT INTO ... SELECT ..." statements result in a ProjectIntoNode which seems to prevent any source hints from being passed down to the relevant source. These work correctly with an "INSERT INTO ... VALUES ..." statement. I've included example user and final query plan data below for the non-working [1] and working [2] insert statements. > [1] source hint not applied to ProjectIntoNode: > USER COMMAND: > INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") SELECT X.id AS ID, X."value" AS "VALUE" FROM (SELECT bqt.SMALLA.INTKEY AS id, bqt.SMALLA.INTNUM AS "value" FROM bqt.SMALLA WHERE bqt.SMALLA.INTKEY = 0) AS X > ... > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > ProjectIntoNode(0) output=[Count] test.TEST > AccessNode(1) output=[bqt.SMALLA.INTKEY AS ID, bqt.SMALLA.INTNUM AS "VALUE"] SELECT /*+sh test:'append' */ g_0.INTKEY, g_0.INTNUM FROM bqt.SMALLA AS g_0 WHERE g_0.INTKEY = 0 > [2] source hint applied to AccessNode: > USER COMMAND: > INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") VALUES ('-1', '-1') > ... > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > AccessNode(0) output=[Count] INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") VALUES ('-1', '-1') -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4489) Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4489?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4489: ------------------------------------ If the RAM and core sizes don't correlate to what is being recommended, then there are 2 choices: - if the formula is right, then the sizing recommendations have to be changed - change the formula > Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size > --------------------------------------------------------------------------- > > Key: TEIID-4489 > URL: https://issues.jboss.org/browse/TEIID-4489 > Project: Teiid > Issue Type: Enhancement > Components: Sizing Application > Affects Versions: 9.x > Reporter: Van Halbert > Assignee: Kylin Soong > > Based on recommendations: > small : 16 cores, with at least 32 GB RAM. 2 DV instances. (small means may be 5 ~10 sources, rows into millions, YMMV) > medium : 32 cores with 64 GB RAM, 4 DV instances. (medium means may be 10 ~ 20 sources, rows into multi-millions, YMMV) > Large: custom > The defaults in the sizing applications, along with selecting 1 to 10 data sources, should result in the SMALL recommendation. It should be clear to indicate the number of instances and the size recommendation per instance. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4489) Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4489?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4489: ------------------------------------ Regarding: if sources are 10-20, federated query rows are in multi-millions then recommend large(32 cores with 64 GB RAM, 4 DV instances) assuming no changes, other than selecting the number of data sources, this should correlate to a medium size recommendation. > Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size > --------------------------------------------------------------------------- > > Key: TEIID-4489 > URL: https://issues.jboss.org/browse/TEIID-4489 > Project: Teiid > Issue Type: Enhancement > Components: Sizing Application > Affects Versions: 9.x > Reporter: Van Halbert > Assignee: Kylin Soong > > Based on recommendations: > small : 16 cores, with at least 32 GB RAM. 2 DV instances. (small means may be 5 ~10 sources, rows into millions, YMMV) > medium : 32 cores with 64 GB RAM, 4 DV instances. (medium means may be 10 ~ 20 sources, rows into multi-millions, YMMV) > Large: custom > The defaults in the sizing applications, along with selecting 1 to 10 data sources, should result in the SMALL recommendation. It should be clear to indicate the number of instances and the size recommendation per instance. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4499) OData Kerberos cannot access VDB

by Jan Stastny (JIRA)

Jan Stastny created TEIID-4499: ---------------------------------- Summary: OData Kerberos cannot access VDB Key: TEIID-4499 URL: https://issues.jboss.org/browse/TEIID-4499 Project: Teiid Issue Type: Bug Components: OData Affects Versions: 8.12.6.6_3 Reporter: Jan Stastny Assignee: Steven Hawkins Priority: Critical When configured odata war for Kerberos using https://teiid.gitbooks.io/documents/content/security/Kerberos_support_thr... an error occurs when accessing a vdb, which is also secured by Kerberos. The error is following: {code:plain} 11:44:53,360 WARN [org.teiid.ODATA] (http-127.0.0.1:8080-1) TEIID16047 Could not process OData 4 request: 08001 TEIID40055 org.teiid.core.TeiidException: TEIID40055 org.teiid.net.ConnectionException: TEIID40055 Wrong logon method is being used. Server is not set up for GSS based authentication.: org.teiid.core.TeiidProcessingException: 08001 TEIID40055 org.teiid.core.TeiidException: TEIID40055 org.teiid.net.ConnectionException: TEIID40055 Wrong logon method is being used. Server is not set up for GSS based authentication. at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:233) [teiid-olingo-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:100) [teiid-olingo-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] at org.jboss.security.negotiation.NegotiationAuthenticator$WrapperValve.invoke(NegotiationAuthenticator.java:492) [jboss-negotiation-common-2.3.11.Final-redhat-1.jar:2.3.11.Final-redhat-1] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.9.Final-redhat-2.jar:7.5.9.Final-redhat-2] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:654) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.17.Final-redhat-1.jar:7.5.17.Final-redhat-1] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_102] Caused by: org.teiid.jdbc.TeiidSQLException: TEIID40055 org.teiid.core.TeiidException: TEIID40055 org.teiid.net.ConnectionException: TEIID40055 Wrong logon method is being used. Server is not set up for GSS based authentication. at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:55) at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:105) at org.teiid.olingo.service.LocalClient.buildConnection(LocalClient.java:119) [teiid-olingo-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] at org.teiid.olingo.service.LocalClient.open(LocalClient.java:89) [teiid-olingo-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:226) [teiid-olingo-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] ... 16 more Caused by: org.teiid.core.TeiidException: TEIID40055 org.teiid.core.TeiidException: TEIID40055 org.teiid.net.ConnectionException: TEIID40055 Wrong logon method is being used. Server is not set up for GSS based authentication. at org.teiid.core.util.ReflectionHelper.create(ReflectionHelper.java:308) [teiid-common-core-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] at org.teiid.jdbc.ModuleHelper.createFromModule(ModuleHelper.java:53) at org.teiid.jdbc.EmbeddedProfile.createServerConnection(EmbeddedProfile.java:60) at org.teiid.jdbc.EmbeddedProfile.connect(EmbeddedProfile.java:50) ... 20 more Caused by: org.teiid.core.TeiidException: TEIID40055 org.teiid.net.ConnectionException: TEIID40055 Wrong logon method is being used. Server is not set up for GSS based authentication. at org.teiid.core.util.ReflectionHelper.create(ReflectionHelper.java:345) [teiid-common-core-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] at org.teiid.core.util.ReflectionHelper.create(ReflectionHelper.java:306) [teiid-common-core-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] ... 23 more Caused by: org.teiid.net.ConnectionException: TEIID40055 Wrong logon method is being used. Server is not set up for GSS based authentication. at org.teiid.transport.LocalServerConnection.authenticate(LocalServerConnection.java:146) at org.teiid.transport.LocalServerConnection.<init>(LocalServerConnection.java:106) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.8.0_102] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) [rt.jar:1.8.0_102] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.8.0_102] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) [rt.jar:1.8.0_102] at org.teiid.core.util.ReflectionHelper.create(ReflectionHelper.java:343) [teiid-common-core-8.12.6.6_3-redhat-1.jar:8.12.6.6_3-redhat-1] ... 24 more Caused by: org.teiid.client.security.LogonException: TEIID40055 Wrong logon method is being used. Server is not set up for GSS based authentication. at org.teiid.transport.LogonImpl.logon(LogonImpl.java:119) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_102] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_102] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_102] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_102] at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:180) at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_102] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:178) at com.sun.proxy.$Proxy81.logon(Unknown Source) at org.teiid.transport.LocalServerConnection.authenticate(LocalServerConnection.java:142) ... 30 more {code} Authentication of the user succeeded: {code:plain} principal is dv(a)EXAMPLE.COM Will use keytab Commit Succeeded {code} Authentication of the server succeeded: {code:plain} 11:44:52,873 INFO [stdout] (http-127.0.0.1:8080-1) Acquire TGT from Cache 11:44:52,874 INFO [stdout] (http-127.0.0.1:8080-1) Principal is HTTP/localhost(a)EXAMPLE.COM 11:44:52,874 INFO [stdout] (http-127.0.0.1:8080-1) null credentials from Ticket Cache 11:44:53,234 INFO [stdout] (http-127.0.0.1:8080-1) principal is HTTP/localhost(a)EXAMPLE.COM 11:44:53,234 INFO [stdout] (http-127.0.0.1:8080-1) Will use keytab 11:44:53,236 INFO [stdout] (http-127.0.0.1:8080-1) Commit Succeeded {code} Initial request: {code:plain} 12:44:52,325 DEBUG [MainClientExec] Opening connection {}->http://localhost:8080 12:44:52,327 DEBUG [DefaultHttpClientConnectionOperator] Connecting to localhost/127.0.0.1:8080 12:44:52,328 DEBUG [DefaultHttpClientConnectionOperator] Connection established 127.0.0.1:47980<->127.0.0.1:8080 12:44:52,328 DEBUG [MainClientExec] Executing request GET /odata4/kerberos_teiid/BQT1/smalla HTTP/1.1 12:44:52,328 DEBUG [MainClientExec] Target auth state: UNCHALLENGED 12:44:52,329 DEBUG [MainClientExec] Proxy auth state: UNCHALLENGED 12:44:52,330 DEBUG [headers] http-outgoing-0 >> GET /odata4/kerberos_teiid/BQT1/smalla HTTP/1.1 12:44:52,330 DEBUG [headers] http-outgoing-0 >> Host: localhost:8080 12:44:52,330 DEBUG [headers] http-outgoing-0 >> Connection: Keep-Alive 12:44:52,330 DEBUG [headers] http-outgoing-0 >> User-Agent: Apache-HttpClient/4.5.2 (Java/1.8.0_51) 12:44:52,330 DEBUG [headers] http-outgoing-0 >> Accept-Encoding: gzip,deflate 12:44:52,330 DEBUG [wire] http-outgoing-0 >> "GET /odata4/kerberos_teiid/BQT1/smalla HTTP/1.1[\r][\n]" 12:44:52,330 DEBUG [wire] http-outgoing-0 >> "Host: localhost:8080[\r][\n]" 12:44:52,331 DEBUG [wire] http-outgoing-0 >> "Connection: Keep-Alive[\r][\n]" 12:44:52,331 DEBUG [wire] http-outgoing-0 >> "User-Agent: Apache-HttpClient/4.5.2 (Java/1.8.0_51)[\r][\n]" 12:44:52,331 DEBUG [wire] http-outgoing-0 >> "Accept-Encoding: gzip,deflate[\r][\n]" 12:44:52,331 DEBUG [wire] http-outgoing-0 >> "[\r][\n]" {code} Negotiate request from server: {code:plain} 12:44:52,457 DEBUG [wire] http-outgoing-0 << "HTTP/1.1 401 Unauthorized[\r][\n]" 12:44:52,457 DEBUG [wire] http-outgoing-0 << "Server: Apache-Coyote/1.1[\r][\n]" 12:44:52,457 DEBUG [wire] http-outgoing-0 << "Pragma: No-cache[\r][\n]" 12:44:52,457 DEBUG [wire] http-outgoing-0 << "Cache-Control: no-cache[\r][\n]" 12:44:52,457 DEBUG [wire] http-outgoing-0 << "Expires: Thu, 01 Jan 1970 01:00:00 GMT+01:00[\r][\n]" 12:44:52,457 DEBUG [wire] http-outgoing-0 << "WWW-Authenticate: Negotiate[\r][\n]" 12:44:52,457 DEBUG [wire] http-outgoing-0 << "Content-Type: text/html;charset=utf-8[\r][\n]" 12:44:52,457 DEBUG [wire] http-outgoing-0 << "Content-Length: 996[\r][\n]" 12:44:52,457 DEBUG [wire] http-outgoing-0 << "Date: Mon, 10 Oct 2016 10:44:52 GMT[\r][\n]" 12:44:52,457 DEBUG [wire] http-outgoing-0 << "[\r][\n]" 12:44:52,457 DEBUG [wire] http-outgoing-0 << "<html><head><title>JBWEB000065: HTTP Status 401 - </title><style></style> </head><body><h1>JBWEB000065: HTTP Status 401 - </h1><HR size="1" noshade="noshade"><p><b>JBWEB000309: type</b> JBWEB000067: Status report</p><p><b>JBWEB000068: message</b> <u></u></p><p><b>JBWEB000069: description</b> <u>JBWEB000121: This request requires HTTP authentication.</u></p><HR size="1" noshade="noshade"></body></html>" 12:44:52,459 DEBUG [headers] http-outgoing-0 << HTTP/1.1 401 Unauthorized 12:44:52,459 DEBUG [headers] http-outgoing-0 << Server: Apache-Coyote/1.1 12:44:52,459 DEBUG [headers] http-outgoing-0 << Pragma: No-cache 12:44:52,460 DEBUG [headers] http-outgoing-0 << Cache-Control: no-cache 12:44:52,460 DEBUG [headers] http-outgoing-0 << Expires: Thu, 01 Jan 1970 01:00:00 GMT+01:00 12:44:52,460 DEBUG [headers] http-outgoing-0 << WWW-Authenticate: Negotiate 12:44:52,460 DEBUG [headers] http-outgoing-0 << Content-Type: text/html;charset=utf-8 12:44:52,460 DEBUG [headers] http-outgoing-0 << Content-Length: 996 12:44:52,460 DEBUG [headers] http-outgoing-0 << Date: Mon, 10 Oct 2016 10:44:52 GMT {code} Response to auth server: {code:plain} Found ticket for dv(a)EXAMPLE.COM to go to krbtgt/EXAMPLE.COM(a)EXAMPLE.COM expiring on Mon Oct 10 20:44:52 CEST 2016 Entered Krb5Context.initSecContext with state=STATE_NEW Service ticket not found in the subject 12:44:52,846 DEBUG [SPNegoScheme] Sending response 'YIIEjgYGKwYBBQUCoIIEgjCCBH6gDTALBgkqhkiG9xIBAgKhBAMCAfaiggRlBIIEYWCCBF0GCSqGSIb3EgECAgEAboIETDCCBEigAwIBBaEDAgEOogcDBQAgAAAAo4IBBmGCAQIwgf+gAwIBBaEbGxlNVy5MQUIuRU5HLkJPUy5SRURIQVQuQ09NohwwGqADAgEAoRMwERsESFRUUBsJbG9jYWxob3N0o4G8MIG5oAMCARGhAwIBBKKBrASBqdJuL2wF7+W0MD1qISt66VAyhitq77SR6vLKWJnpc/Yx60ch80GepVlYdoYxee0qW+d4u6aw3p0BaOWSgSMRoDnr9bSUn+tQXNevIfKE+oUM+5lC4afhAF0PB4dcJC7z6/wLZ9drDImvyhntm9lq/yv5LW76gSbVd9SjO58ZvD3cYRJnuF3CaFhm5ol0ce84ojZdX5mVvVBUU3+Vo1rh6SSEKda+xoBkK/ykggMnMIIDI6ADAgERooIDGgSCAxaG8huKFUf6vR0wVfeI1caKfIPtGC9rDSw5DYTz1dz43F8GI9we3YG9NC6kEi1zPdA4A2dxfBqgUl+/YkBdQco4udBCwLXNmziHCS5ypypBJsFdgFzRi/9hXukmqofSGIlKVJWH3ap1ap+37Amfm6LxZuQFDyY526onGXdWoAB0Jbcpsi74Ti5x3sRGZqoF5FTwUqI0pQYI+hLDh2GeBNXBNOHqdMXNfnLFOr+LpnNhl7ROxkWsBxNPv/4MmRLPsF/cGrc924L6R4PQvP7qVjGKUxayEoBPP/go5xb2b2z+TjruspzbJ5dw1wKAOH2RGlDJ5om0PUSqaxe0h2WhL9rXBOGVONTSv7lYQ2pcgaOqR6FutB5PZGP0B73ekwhbRfrt6zxLpHzZFnrSeV9lz1U4r8Bkyxuze3cuQGcL/cNTBbhE83cbNY8VJlu4E+6LmZ9ll3vpjNq3735S6gFArsOJ38FcLO0Kqj1rZr7/r9TRsV9f8agDnWusc5lQzZc+4H0BIeAPD34ApJxGogA63/8yF1Pl3uc1Rp+a6blQHLLCRZthIpi8LVF8rSizTkTDWUrTw+X5wGDunjslrUmClW25qzGeLTZpELrJXkKFstUnL4blaPboyPk8qDecaRed+dIjteVS9CgF51AtHrO9vhWgrr41TL+H8akHfjI6Q9GIgravWLSkNrVMsrNyVAlc1hdUAovLXJFfxS3Mg0OugjG3rJhSCiQqLCuhIRL8OB4Fz4Pa24fpBG0G/Rv1RrhuQaKoxNsZxuR67zzF+v7+4PRKK39y0cqFWBf95YV4SWz7qzXmZYcaDcVhrFzp723ecWunVa6Qt5YUZ3+pkKV+NGGb95PjS7HtvXZo4ko5tJX1QI+ke4I3j3cThrWlV5y3rNC2IKiE8eRNI6rKRGdvpYLwkL0B5AkJleqGjdiqZVy6Q2w/YdHN2oTOs8qUgIVgPHJMyRLUTT872ZOWdmmHWJuIe3sVkr1RLFDV2csmYggSZCbjCczFvlmKrcn6OLqVRGN3sNm6a9Q45wZimLvIkxePHag3vvtp' back to the auth server 12:44:52,846 DEBUG [MainClientExec] Proxy auth state: UNCHALLENGED 12:44:52,846 DEBUG [headers] http-outgoing-0 >> GET /odata4/kerberos_teiid/BQT1/smalla HTTP/1.1 12:44:52,846 DEBUG [headers] http-outgoing-0 >> Host: localhost:8080 12:44:52,846 DEBUG [headers] http-outgoing-0 >> Connection: Keep-Alive 12:44:52,846 DEBUG [headers] http-outgoing-0 >> User-Agent: Apache-HttpClient/4.5.2 (Java/1.8.0_51) 12:44:52,846 DEBUG [headers] http-outgoing-0 >> Accept-Encoding: gzip,deflate 12:44:52,846 DEBUG [headers] http-outgoing-0 >> Authorization: Negotiate YIIEjgYGKwYBBQUCoIIEgjCCBH6gDTALBgkqhkiG9xIBAgKhBAMCAfaiggRlBIIEYWCCBF0GCSqGSIb3EgECAgEAboIETDCCBEigAwIBBaEDAgEOogcDBQAgAAAAo4IBBmGCAQIwgf+gAwIBBaEbGxlNVy5MQUIuRU5HLkJPUy5SRURIQVQuQ09NohwwGqADAgEAoRMwERsESFRUUBsJbG9jYWxob3N0o4G8MIG5oAMCARGhAwIBBKKBrASBqdJuL2wF7+W0MD1qISt66VAyhitq77SR6vLKWJnpc/Yx60ch80GepVlYdoYxee0qW+d4u6aw3p0BaOWSgSMRoDnr9bSUn+tQXNevIfKE+oUM+5lC4afhAF0PB4dcJC7z6/wLZ9drDImvyhntm9lq/yv5LW76gSbVd9SjO58ZvD3cYRJnuF3CaFhm5ol0ce84ojZdX5mVvVBUU3+Vo1rh6SSEKda+xoBkK/ykggMnMIIDI6ADAgERooIDGgSCAxaG8huKFUf6vR0wVfeI1caKfIPtGC9rDSw5DYTz1dz43F8GI9we3YG9NC6kEi1zPdA4A2dxfBqgUl+/YkBdQco4udBCwLXNmziHCS5ypypBJsFdgFzRi/9hXukmqofSGIlKVJWH3ap1ap+37Amfm6LxZuQFDyY526onGXdWoAB0Jbcpsi74Ti5x3sRGZqoF5FTwUqI0pQYI+hLDh2GeBNXBNOHqdMXNfnLFOr+LpnNhl7ROxkWsBxNPv/4MmRLPsF/cGrc924L6R4PQvP7qVjGKUxayEoBPP/go5xb2b2z+TjruspzbJ5dw1wKAOH2RGlDJ5om0PUSqaxe0h2WhL9rXBOGVONTSv7lYQ2pcgaOqR6FutB5PZGP0B73ekwhbRfrt6zxLpHzZFnrSeV9lz1U4r8Bkyxuze3cuQGcL/cNTBbhE83cbNY8VJlu4E+6LmZ9ll3vpjNq3735S6gFArsOJ38FcLO0Kqj1rZr7/r9TRsV9f8agDnWusc5lQzZc+4H0BIeAPD34ApJxGogA63/8yF1Pl3uc1Rp+a6blQHLLCRZthIpi8LVF8rSizTkTDWUrTw+X5wGDunjslrUmClW25qzGeLTZpELrJXkKFstUnL4blaPboyPk8qDecaRed+dIjteVS9CgF51AtHrO9vhWgrr41TL+H8akHfjI6Q9GIgravWLSkNrVMsrNyVAlc1hdUAovLXJFfxS3Mg0OugjG3rJhSCiQqLCuhIRL8OB4Fz4Pa24fpBG0G/Rv1RrhuQaKoxNsZxuR67zzF+v7+4PRKK39y0cqFWBf95YV4SWz7qzXmZYcaDcVhrFzp723ecWunVa6Qt5YUZ3+pkKV+NGGb95PjS7HtvXZo4ko5tJX1QI+ke4I3j3cThrWlV5y3rNC2IKiE8eRNI6rKRGdvpYLwkL0B5AkJleqGjdiqZVy6Q2w/YdHN2oTOs8qUgIVgPHJMyRLUTT872ZOWdmmHWJuIe3sVkr1RLFDV2csmYggSZCbjCczFvlmKrcn6OLqVRGN3sNm6a9Q45wZimLvIkxePHag3vvtp 12:44:52,846 DEBUG [wire] http-outgoing-0 >> "GET /odata4/kerberos_teiid/BQT1/smalla HTTP/1.1[\r][\n]" 12:44:52,846 DEBUG [wire] http-outgoing-0 >> "Host: localhost:8080[\r][\n]" 12:44:52,847 DEBUG [wire] http-outgoing-0 >> "Connection: Keep-Alive[\r][\n]" 12:44:52,847 DEBUG [wire] http-outgoing-0 >> "User-Agent: Apache-HttpClient/4.5.2 (Java/1.8.0_51)[\r][\n]" 12:44:52,847 DEBUG [wire] http-outgoing-0 >> "Accept-Encoding: gzip,deflate[\r][\n]" 12:44:52,847 DEBUG [wire] http-outgoing-0 >> "Authorization: Negotiate YIIEjgYGKwYBBQUCoIIEgjCCBH6gDTALBgkqhkiG9xIBAgKhBAMCAfaiggRlBIIEYWCCBF0GCSqGSIb3EgECAgEAboIETDCCBEigAwIBBaEDAgEOogcDBQAgAAAAo4IBBmGCAQIwgf+gAwIBBaEbGxlNVy5MQUIuRU5HLkJPUy5SRURIQVQuQ09NohwwGqADAgEAoRMwERsESFRUUBsJbG9jYWxob3N0o4G8MIG5oAMCARGhAwIBBKKBrASBqdJuL2wF7+W0MD1qISt66VAyhitq77SR6vLKWJnpc/Yx60ch80GepVlYdoYxee0qW+d4u6aw3p0BaOWSgSMRoDnr9bSUn+tQXNevIfKE+oUM+5lC4afhAF0PB4dcJC7z6/wLZ9drDImvyhntm9lq/yv5LW76gSbVd9SjO58ZvD3cYRJnuF3CaFhm5ol0ce84ojZdX5mVvVBUU3+Vo1rh6SSEKda+xoBkK/ykggMnMIIDI6ADAgERooIDGgSCAxaG8huKFUf6vR0wVfeI1caKfIPtGC9rDSw5DYTz1dz43F8GI9we3YG9NC6kEi1zPdA4A2dxfBqgUl+/YkBdQco4udBCwLXNmziHCS5ypypBJsFdgFzRi/9hXukmqofSGIlKVJWH3ap1ap+37Amfm6LxZuQFDyY526onGXdWoAB0Jbcpsi74Ti5x3sRGZqoF5FTwUqI0pQYI+hLDh2GeBNXBNOHqdMXNfnLFOr+LpnNhl7ROxkWsBxNPv/4MmRLPsF/cGrc924L6R4PQvP7qVjGKUxayEoBPP/go5xb2b2z+TjruspzbJ5dw1wKAOH2RGlDJ5om0PUSqaxe0h2WhL9rXBOGVONTSv7lYQ2pcgaOqR6FutB5PZGP0B73ekwhbRfrt6zxLpHzZFnrSeV9lz1U4r8Bkyxuze3cuQGcL/cNTBbhE83cbNY8VJlu4E+6LmZ9ll3vpjNq3735S6gFArsOJ38FcLO0Kqj1rZr7/r9TRsV9f8agDnWusc5lQzZc+4H0BIeAPD34ApJxGogA63/8yF1Pl3uc1Rp+a6blQHLLCRZthIpi8LVF8rSizTkTDWUrTw+X5wGDunjslrUmClW25qzGeLTZpELrJXkKFstUnL4blaPboyPk8qDecaRed+dIjteVS9CgF51AtHrO9vhWgrr41TL+H8akHfjI6Q9GIgravWLSkNrVMsrNyVAlc1hdUAovLXJFfxS3Mg0OugjG3rJhSCiQqLCuhIRL8OB4Fz4Pa24fpBG0G/Rv1RrhuQaKoxNsZxuR67zzF+v7+4PRKK39y0cqFWBf95YV4SWz7qzXmZYcaDcVhrFzp723ecWunVa6Qt5YUZ3+pkKV+NGGb95PjS7HtvXZo4ko5tJX1QI+ke4I3j3cThrWlV5y3rNC2IKiE8eRNI6rKRGdvpYLwkL0B5AkJleqGjdiqZVy6Q2w/YdHN2oTOs8qUgIVgPHJMyRLUTT872ZOWdmmHWJuIe3sVkr1RLFDV2csmYggSZCbjCczFvlmKrcn6OLqVRGN3sNm6a9Q45wZimLvIkxePHag3vvtp[\r][\n]" 12:44:52,847 DEBUG [wire] http-outgoing-0 >> "[\r][\n]" {code} Last server logs before error: {code:plain} 11:44:53,246 DEBUG [org.jboss.security.auth.spi.AbstractServerLoginModule] (http-127.0.0.1:8080-1) Logged in 'host' LoginContext 11:44:53,247 DEBUG [org.jboss.security.auth.spi.AbstractServerLoginModule] (http-127.0.0.1:8080-1) Creating new GSSContext. 11:44:53,283 DEBUG [org.jboss.security.auth.spi.AbstractServerLoginModule] (http-127.0.0.1:8080-1) context.getCredDelegState() = true 11:44:53,284 DEBUG [org.jboss.security.auth.spi.AbstractServerLoginModule] (http-127.0.0.1:8080-1) context.getMutualAuthState() = true 11:44:53,284 DEBUG [org.jboss.security.auth.spi.AbstractServerLoginModule] (http-127.0.0.1:8080-1) context.getSrcName() = dv(a)EXAMPLE.COM 11:44:53,284 INFO [stdout] (http-127.0.0.1:8080-1) [Krb5LoginModule]: Entering logout 11:44:53,285 INFO [stdout] (http-127.0.0.1:8080-1) [Krb5LoginModule]: logged out Subject 11:44:53,285 DEBUG [org.jboss.security.auth.spi.AbstractServerLoginModule] (http-127.0.0.1:8080-1) Storing username 'dv(a)EXAMPLE.COM' and empty password 11:44:53,304 DEBUG [org.jboss.security.negotiation.NegotiationAuthenticator] (http-127.0.0.1:8080-1) authenticated principal = GenericPrincipal[5tV-f1mRV7tGghx2rk4krdFH_1476096292858(odata,user,)] {code} VDB used: {code:xml} <vdb name="kerberos_teiid" version="1"> <property name="security-domain" value="EXAMPLE.COM"/> <property name="authentication-type" value="GSS"/> . . . </vdb> {code} Request URL: {code:plain} http://localhost:8080/odata4/kerberos_teiid/BQT1/smalla {code} Server configuration: {code:xml} <security-domain name="host"> <authentication> <login-module code="Kerberos" flag="required" module="org.jboss.security.negotiation"> <module-option name="storeKey" value="true"/> <module-option name="useKeyTab" value="true"/> <module-option name="keyTab" value="${jboss.home.dir}/HTTP_localhost"/> <module-option name="principal" value="HTTP/localhost(a)EXAMPLE.COM"/> <module-option name="doNotPrompt" value="true"/> <module-option name="useTicketCache" value="true"/> <module-option name="debug" value="true"/> <module-option name="refreshKrb5Config" value="false"/> <module-option name="isInitiator" value="true"/> <module-option name="addGSSCredential" value="true"/> <module-option name="delegationCredential" value="USE"/> <module-option name="ticketCache" value="/tmp/krb5cc_1000"/> </login-module> </authentication> </security-domain> <security-domain name="EXAMPLE.COM"> <authentication> <login-module code="SPNEGO" flag="requisite" module="org.jboss.security.negotiation"> <module-option name="password-stacking" value="useFirstPass"/> <module-option name="serverSecurityDomain" value="host"/> </login-module> </authentication> <mapping> <mapping-module code="SimpleRoles" type="role"> <module-option name="dv(a)EXAMPLE.COM" value="user,odata"/> </mapping-module> </mapping> </security-domain> {code} Kerberos client configuration: {code:plain} ClientDV { com.sun.security.auth.module.Krb5LoginModule required storeKey="true" useKeyTab="true" keyTab="${dv.test.krb.dir}/dv.keytab" principal="dv(a)EXAMPLE.COM" doNotPrompt="true" refreshKrb5Config="false" useTicketCache="true" ticketCache="/tmp/krb5cc_1000" debug="true"; }; {code} KRB5 configuration file is passed to server by setting system-property java.security.krb5.conf: {code:xml} <system-properties> <property name="java.security.krb5.conf" value="${jboss.home.dir}/krb5.conf"/> <property name="java.security.krb5.debug" value="true"/> </system-properties> {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4441) Add FTP/SFTP based access to the File Resource Adapter

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4441?page=com.atlassian.jira.plugin... ] Kylin Soong reassigned TEIID-4441: ---------------------------------- Assignee: Kylin Soong > Add FTP/SFTP based access to the File Resource Adapter > ------------------------------------------------------ > > Key: TEIID-4441 > URL: https://issues.jboss.org/browse/TEIID-4441 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Kylin Soong > Fix For: Open To Community, 9.2 > > > This has been requested few times in the community, it would be nice to give provide this functionality. Using http://commons.apache.org/proper/commons-net/ seems to be right decision. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4453) Update database logging to semantic versioning and logoninfo

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4453?page=com.atlassian.jira.plugin... ] Kylin Soong reassigned TEIID-4453: ---------------------------------- Assignee: Kylin Soong > Update database logging to semantic versioning and logoninfo > ------------------------------------------------------------ > > Key: TEIID-4453 > URL: https://issues.jboss.org/browse/TEIID-4453 > Project: Teiid > Issue Type: Enhancement > Components: Build/Kits > Reporter: Steven Hawkins > Assignee: Kylin Soong > Fix For: 9.2 > > > The AuditEntity and database mapping needs to be updated to handle a semantic/string vdb version as well as potentially exposing more information from logoninfo events. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4455) Impala Translator - Change planning step for from_unixtime() pushdown

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4455?page=com.atlassian.jira.plugin... ] Kylin Soong reassigned TEIID-4455: ---------------------------------- Assignee: Kylin Soong > Impala Translator - Change planning step for from_unixtime() pushdown > --------------------------------------------------------------------- > > Key: TEIID-4455 > URL: https://issues.jboss.org/browse/TEIID-4455 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Connector > Reporter: Don Krapohl > Assignee: Kylin Soong > Priority: Minor > Labels: Impala_Translator > Fix For: 9.2 > > > Impala and Teiid both have from_unixtime() functions and per the forum reference the mapping to timestampadd() appears to come before the test for pushdown support of the impala native function. > As a query request we require the impala from_unixtime() function be executed instead of the Teiid-native version. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4489) Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4489?page=com.atlassian.jira.plugin... ] Kylin Soong updated TEIID-4489: ------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1383170 > Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size > --------------------------------------------------------------------------- > > Key: TEIID-4489 > URL: https://issues.jboss.org/browse/TEIID-4489 > Project: Teiid > Issue Type: Enhancement > Components: Sizing Application > Affects Versions: 9.x > Reporter: Van Halbert > Assignee: Kylin Soong > > Based on recommendations: > small : 16 cores, with at least 32 GB RAM. 2 DV instances. (small means may be 5 ~10 sources, rows into millions, YMMV) > medium : 32 cores with 64 GB RAM, 4 DV instances. (medium means may be 10 ~ 20 sources, rows into multi-millions, YMMV) > Large: custom > The defaults in the sizing applications, along with selecting 1 to 10 data sources, should result in the SMALL recommendation. It should be clear to indicate the number of instances and the size recommendation per instance. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4489) Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-4489?page=com.atlassian.jira.plugin... ] Kylin Soong commented on TEIID-4489: ------------------------------------ [~van.halbert], If I understand correctly, the following 2 can be used as rules * if sources are 5-10, federated query rows are in millions, then recommend small( 16 cores, with at least 32 GB RAM. 2 DV instance) * if sources are 10-20, federated query rows are in multi-millions then recommend large(32 cores with 64 GB RAM, 4 DV instances) * else base on formula, calculate the results Note that, current RAM size and core size base on formula, if default recommend ( 16 cores, with at least 32 GB RAM. 2 DV instance), it may not accordant with formula. > Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size > --------------------------------------------------------------------------- > > Key: TEIID-4489 > URL: https://issues.jboss.org/browse/TEIID-4489 > Project: Teiid > Issue Type: Enhancement > Components: Sizing Application > Affects Versions: 9.x > Reporter: Van Halbert > Assignee: Kylin Soong > > Based on recommendations: > small : 16 cores, with at least 32 GB RAM. 2 DV instances. (small means may be 5 ~10 sources, rows into millions, YMMV) > medium : 32 cores with 64 GB RAM, 4 DV instances. (medium means may be 10 ~ 20 sources, rows into multi-millions, YMMV) > Large: custom > The defaults in the sizing applications, along with selecting 1 to 10 data sources, should result in the SMALL recommendation. It should be clear to indicate the number of instances and the size recommendation per instance. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4469) Insert with query expression does not apply source hint to target

by Lucie Fabrikova (JIRA)

[ https://issues.jboss.org/browse/TEIID-4469?page=com.atlassian.jira.plugin... ] Lucie Fabrikova commented on TEIID-4469: ---------------------------------------- I simulated the query with two oracle databases on different machines, but the source hint doesn't seem to be applied ProjectIntoNode, contents of teiid-command.log and server.log: 21:03:54,633 DEBUG [org.teiid.COMMAND_LOG] (New I/O worker #4) wMQbVS84H1pO START USER COMMAND: startTime=2016-10-08 21:03:54.633 requestID=wMQbVS84H1pO.0 txID=null sessionID=wMQbVS84H1pO applicationName=JDBC principal=teiidUser@teiid-security vdbName=oracledba vdbVersion=1 sql=INSERT /*+ sh Source2:'append' */ INTO test (ID, myvalue) SELECT X.id AS ID, X.myvalue AS myvalue FROM (SELECT SMALLA.INTKEY AS id, SMALLA.INTNUM AS myvalue FROM SMALLA WHERE SMALLA.INTKEY = 1) AS X 21:03:58,070 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue1) wMQbVS84H1pO START DATA SRC COMMAND: startTime=2016-10-08 21:03:58.069 requestID=wMQbVS84H1pO.0 sourceCommandID=1 executionID=0 txID=null modelName=Source translatorName=oracle sessionID=wMQbVS84H1pO principal=teiidUser@teiid-security sql=SELECT /*+sh Source2:'append' */ g_0.intkey, g_0.intnum FROM Source.smalla AS g_0 WHERE g_0.intkey = 1 21:03:58,567 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue2) wMQbVS84H1pO END SRC COMMAND: endTime=2016-10-08 21:03:58.567 requestID=wMQbVS84H1pO.0 sourceCommandID=1 executionID=0 txID=null modelName=Source translatorName=oracle sessionID=wMQbVS84H1pO principal=teiidUser@teiid-security finalRowCount=1 21:04:01,127 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue3) wMQbVS84H1pO START DATA SRC COMMAND: startTime=2016-10-08 21:04:01.127 requestID=wMQbVS84H1pO.0 sourceCommandID=0 executionID=1 txID=null modelName=Source2 translatorName=oracle sessionID=wMQbVS84H1pO principal=teiidUser@teiid-security sql=INSERT INTO Source2.test (ID, myvalue) VALUES (...) 21:04:01,635 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue4) wMQbVS84H1pO END SRC COMMAND: endTime=2016-10-08 21:04:01.635 requestID=wMQbVS84H1pO.0 sourceCommandID=0 executionID=1 txID=null modelName=Source2 translatorName=oracle sessionID=wMQbVS84H1pO principal=teiidUser@teiid-security finalRowCount=1 21:04:01,697 DEBUG [org.teiid.COMMAND_LOG] (Worker0_QueryProcessorQueue5) wMQbVS84H1pO END USER COMMAND: endTime=2016-10-08 21:04:01.697 requestID=wMQbVS84H1pO.0 txID=null sessionID=wMQbVS84H1pO principal=teiidUser@teiid-security vdbName=oracledba vdbVersion=1 finalRowCount=1 Logging set to DEBUG, server.log: DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue3) wMQbVS84H1pO.0.0.1 Processing NEW request: INSERT INTO Source2.test (ID, myvalue) VALUES (...) 21:03:58,572 DEBUG [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) Request Thread wMQbVS84H1pO.0 - processor blocked 21:04:01,126 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue3) wMQbVS84H1pO.0.0.1 Obtained execution 21:04:01,127 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue3) Source-specific command: INSERT INTO test (ID, myvalue) VALUES (?, ?) 21:04:01,633 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue3) wMQbVS84H1pO.0.0.1 Executed command > Insert with query expression does not apply source hint to target > ----------------------------------------------------------------- > > Key: TEIID-4469 > URL: https://issues.jboss.org/browse/TEIID-4469 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.5, 8.7.10_6.2 > > > "INSERT INTO ... SELECT ..." statements result in a ProjectIntoNode which seems to prevent any source hints from being passed down to the relevant source. These work correctly with an "INSERT INTO ... VALUES ..." statement. I've included example user and final query plan data below for the non-working [1] and working [2] insert statements. > [1] source hint not applied to ProjectIntoNode: > USER COMMAND: > INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") SELECT X.id AS ID, X."value" AS "VALUE" FROM (SELECT bqt.SMALLA.INTKEY AS id, bqt.SMALLA.INTNUM AS "value" FROM bqt.SMALLA WHERE bqt.SMALLA.INTKEY = 0) AS X > ... > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > ProjectIntoNode(0) output=[Count] test.TEST > AccessNode(1) output=[bqt.SMALLA.INTKEY AS ID, bqt.SMALLA.INTNUM AS "VALUE"] SELECT /*+sh test:'append' */ g_0.INTKEY, g_0.INTNUM FROM bqt.SMALLA AS g_0 WHERE g_0.INTKEY = 0 > [2] source hint applied to AccessNode: > USER COMMAND: > INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") VALUES ('-1', '-1') > ... > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > AccessNode(0) output=[Count] INSERT /*+sh test:'append' */ INTO test.TEST (ID, "VALUE") VALUES ('-1', '-1') -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4492) When using annotations, add option that specifies all child classes to register as part of the JDG schema

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4492?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4492. ----------------------------------- Fix Version/s: 9.2 Resolution: Done Merged the pull requests. > When using annotations, add option that specifies all child classes to register as part of the JDG schema > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-4492 > URL: https://issues.jboss.org/browse/TEIID-4492 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 9.2 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.2 > > > When using protobuf annotations, need to specify all the child related (e.g, 1-to-1 relationship or 1-to-many relationship) pojo's that also need to be registered with the JDG schema. When these are registered, JDG will auto generate the .proto file and marshallers used by the schema. Which is the information used by the hot rod translator to create the source models. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3454) Dependent Join optimizations for Netezza and Hive

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3454?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3454: ---------------------------------- Fix Version/s: 9.2 (was: 9.1) Priority: Major (was: Minor) Upping the priority for 9.2. We need to at least get the temp table creation validated, even if there isn't a dialect available. > Dependent Join optimizations for Netezza and Hive > ------------------------------------------------- > > Key: TEIID-3454 > URL: https://issues.jboss.org/browse/TEIID-3454 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.10 > Reporter: John Muller > Assignee: Steven Hawkins > Fix For: 9.2 > > > Currently, dependent joins create 1 or more IN clauses. Many MPP / NoSQL systems can have drastically better performance by creating temp tables that match key distributions. Two examples I know of would be Netezza and Hive. > In Netezza, if the incoming dependent join (small dimension; here "Customer" using Northwind data model concepts) has a key that will be joined to to a big fact table that is DISTRIBUTED ON or ORGANIZED BY 'ed then creating a temp table that matches this distribution will result in ~100x query performance. Sometimes, if the dimension is small enough, this doesn't make a big difference as Netezza will perform a broadcast join, but it's never a bad idea to create the temp table. > Similarly, Hive DDL has both partitions and buckets (pre-sorted). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4403) Refine array_agg support

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4403?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4403. ----------------------------------- Resolution: Done Expanded/corrected sizeutility logic and will allow arrays of up to an 8MB estimated memory footprint. Next steps from here include allowing for a serialized form, which may require extensive changes to ArrayImpl, and the ability for odata or other paths to set a session variable or other mechanism to temporary up the limit. > Refine array_agg support > ------------------------ > > Key: TEIID-4403 > URL: https://issues.jboss.org/browse/TEIID-4403 > Project: Teiid > Issue Type: Sub-task > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > There is currently a hard-coded limit of 1000 items in an array - because it is held fully in memory. This may need to be adjusted depending upon how many children are needed for expand. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4498) Generalize subquery batch processing

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4498: ------------------------------------- Summary: Generalize subquery batch processing Key: TEIID-4498 URL: https://issues.jboss.org/browse/TEIID-4498 Project: Teiid Issue Type: Enhancement Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.2 For subqueries that cannot be unnested, but can be modified to project their correlation, we should have at least batch processing rather than the row by row default. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3660) Add support for unnesting anti semijoins

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3660?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3660: ---------------------------------- Fix Version/s: 9.2 (was: 9.1) > Add support for unnesting anti semijoins > ---------------------------------------- > > Key: TEIID-3660 > URL: https://issues.jboss.org/browse/TEIID-3660 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.2 > > > Currently we won't perform the rewrite if it's the anti case. A subquery used as an anti semijoin can be unnested into a left outer join with a filter on the null rows. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4497) Add upsert support for JDG

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4497: ------------------------------------- Summary: Add upsert support for JDG Key: TEIID-4497 URL: https://issues.jboss.org/browse/TEIID-4497 Project: Teiid Issue Type: Sub-task Components: Misc. Connectors Reporter: Steven Hawkins Fix For: 9.2 The infinispan/JDG/object translator logic should support upsert. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4491) Refine uniqueidentifier support for SQL Server

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-4491?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-4491: --------------------------------- Fix Version/s: 8.7.10_6.2 > Refine uniqueidentifier support for SQL Server > ---------------------------------------------- > > Key: TEIID-4491 > URL: https://issues.jboss.org/browse/TEIID-4491 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Connector > Affects Versions: 7.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.10_6.2 > > > SQL Servers later than 2000 can treat uniqueidentifier as a comparable type - there is no need to always cast. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4495) Salesforce - unable to use CXF configuration with version 34

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4495?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4495. ----------------------------------- Fix Version/s: 9.1 9.0.5 Resolution: Done Created a new version of the cxf transport specific to the 34 implementation. > Salesforce - unable to use CXF configuration with version 34 > ------------------------------------------------------------ > > Key: TEIID-4495 > URL: https://issues.jboss.org/browse/TEIID-4495 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.5 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.5 > > > I am trying to use simple CXF logging feature to log in/outbound messages for Salesforce resource adapter. However, Teiid throws ClassNotFoundException if using translator/connection factory of version 34. > There is no problem with version 22 except one warning: > {code:plain} > 08:16:44WARNING [org.apache.cxf.bus.spring.SpringBusFactory] (Worker1_QueryProcessorQueue11) Initial attempt to create application context was unsuccessful.: org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from class path resource [META-INF/cxf/cxf.xml]; nested exception is java.io.FileNotFoundException: class path resource [META-INF/cxf/cxf.xml] cannot be opened because it does not exist > at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:342) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.internalLoadBeanDefinitions(ControlledValidationXmlBeanDefinitionReader.java:154) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.access$000(ControlledValidationXmlBeanDefinitionReader.java:66) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader$1.run(ControlledValidationXmlBeanDefinitionReader.java:141) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader$1.run(ControlledValidationXmlBeanDefinitionReader.java:139) > at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal] > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.loadBeanDefinitions(ControlledValidationXmlBeanDefinitionReader.java:139) > at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303) > at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174) > at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:123) > at org.apache.cxf.bus.spring.BusApplicationContext.loadBeanDefinitions(BusApplicationContext.java:322) > at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) > at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:539) > at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:451) > at org.apache.cxf.bus.spring.BusApplicationContext$1.run(BusApplicationContext.java:107) > at org.apache.cxf.bus.spring.BusApplicationContext$1.run(BusApplicationContext.java:105) > at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal] > at org.apache.cxf.bus.spring.BusApplicationContext.<init>(BusApplicationContext.java:105) > at org.apache.cxf.bus.spring.SpringBusFactory.createApplicationContext(SpringBusFactory.java:157) > at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:148) > at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:124) > at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:94) > at org.apache.cxf.jaxrs.client.WebClient.getBean(WebClient.java:1221) > at org.apache.cxf.jaxrs.client.WebClient.create(WebClient.java:202) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectRaw(SalesforceCXFTransport.java:123) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectLocal(SalesforceCXFTransport.java:87) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectLocal(SalesforceCXFTransport.java:82) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connect(SalesforceCXFTransport.java:78) > at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:94) [force-wsc-22.0.0.jar:] > at com.sforce.soap.partner.PartnerConnection.delete(PartnerConnection.java:905) [force-partner-api-22.0.0.jar:] > at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.delete(SalesforceConnectionImpl.java:315) > at org.teiid.translator.salesforce.execution.DeleteExecutionImpl.execute(DeleteExecutionImpl.java:52) [translator-salesforce-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:402) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0-internal] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0-internal] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal] > at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) > at com.sun.proxy.$Proxy47.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal] > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal] > Caused by: java.io.FileNotFoundException: class path resource [META-INF/cxf/cxf.xml] cannot be opened because it does not exist > at org.springframework.core.io.ClassPathResource.getInputStream(ClassPathResource.java:171) > at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:329) > ... 50 more > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4495) Salesforce - unable to use CXF configuration with version 34

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4495?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4495: ---------------------------------- Component/s: Misc. Connectors > Salesforce - unable to use CXF configuration with version 34 > ------------------------------------------------------------ > > Key: TEIID-4495 > URL: https://issues.jboss.org/browse/TEIID-4495 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.5 > > > I am trying to use simple CXF logging feature to log in/outbound messages for Salesforce resource adapter. However, Teiid throws ClassNotFoundException if using translator/connection factory of version 34. > There is no problem with version 22 except one warning: > {code:plain} > 08:16:44WARNING [org.apache.cxf.bus.spring.SpringBusFactory] (Worker1_QueryProcessorQueue11) Initial attempt to create application context was unsuccessful.: org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from class path resource [META-INF/cxf/cxf.xml]; nested exception is java.io.FileNotFoundException: class path resource [META-INF/cxf/cxf.xml] cannot be opened because it does not exist > at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:342) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.internalLoadBeanDefinitions(ControlledValidationXmlBeanDefinitionReader.java:154) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.access$000(ControlledValidationXmlBeanDefinitionReader.java:66) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader$1.run(ControlledValidationXmlBeanDefinitionReader.java:141) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader$1.run(ControlledValidationXmlBeanDefinitionReader.java:139) > at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal] > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.loadBeanDefinitions(ControlledValidationXmlBeanDefinitionReader.java:139) > at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303) > at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174) > at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:123) > at org.apache.cxf.bus.spring.BusApplicationContext.loadBeanDefinitions(BusApplicationContext.java:322) > at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) > at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:539) > at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:451) > at org.apache.cxf.bus.spring.BusApplicationContext$1.run(BusApplicationContext.java:107) > at org.apache.cxf.bus.spring.BusApplicationContext$1.run(BusApplicationContext.java:105) > at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal] > at org.apache.cxf.bus.spring.BusApplicationContext.<init>(BusApplicationContext.java:105) > at org.apache.cxf.bus.spring.SpringBusFactory.createApplicationContext(SpringBusFactory.java:157) > at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:148) > at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:124) > at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:94) > at org.apache.cxf.jaxrs.client.WebClient.getBean(WebClient.java:1221) > at org.apache.cxf.jaxrs.client.WebClient.create(WebClient.java:202) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectRaw(SalesforceCXFTransport.java:123) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectLocal(SalesforceCXFTransport.java:87) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectLocal(SalesforceCXFTransport.java:82) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connect(SalesforceCXFTransport.java:78) > at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:94) [force-wsc-22.0.0.jar:] > at com.sforce.soap.partner.PartnerConnection.delete(PartnerConnection.java:905) [force-partner-api-22.0.0.jar:] > at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.delete(SalesforceConnectionImpl.java:315) > at org.teiid.translator.salesforce.execution.DeleteExecutionImpl.execute(DeleteExecutionImpl.java:52) [translator-salesforce-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:402) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0-internal] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0-internal] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal] > at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) > at com.sun.proxy.$Proxy47.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal] > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal] > Caused by: java.io.FileNotFoundException: class path resource [META-INF/cxf/cxf.xml] cannot be opened because it does not exist > at org.springframework.core.io.ClassPathResource.getInputStream(ClassPathResource.java:171) > at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:329) > ... 50 more > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4030) Improve Geometry Type Handling in HANA Translator

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIID-4030?page=com.atlassian.jira.plugin... ] Ted Jones reassigned TEIID-4030: -------------------------------- Assignee: Steven Hawkins (was: Ted Jones) > Improve Geometry Type Handling in HANA Translator > ------------------------------------------------- > > Key: TEIID-4030 > URL: https://issues.jboss.org/browse/TEIID-4030 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.13.1 > Reporter: Ted Jones > Assignee: Steven Hawkins > Fix For: 9.2 > > > The Geometry type logic in the HANA translator should use the new Teiid Geometry type, similar to the postgres translator. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4495) Salesforce - unable to use CXF configuration with version 34

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4495?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4495: --------------------------------------- The issue is that the salesforce jar repackaged some utility classes. I'll look at what makes sense: just forking our own classes, including both versions of the connector jar in the classpath, or introducing some overriding classes in the 34 connector to point the usage to the new classes. > Salesforce - unable to use CXF configuration with version 34 > ------------------------------------------------------------ > > Key: TEIID-4495 > URL: https://issues.jboss.org/browse/TEIID-4495 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.5 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > I am trying to use simple CXF logging feature to log in/outbound messages for Salesforce resource adapter. However, Teiid throws ClassNotFoundException if using translator/connection factory of version 34. > There is no problem with version 22 except one warning: > {code:plain} > 08:16:44WARNING [org.apache.cxf.bus.spring.SpringBusFactory] (Worker1_QueryProcessorQueue11) Initial attempt to create application context was unsuccessful.: org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from class path resource [META-INF/cxf/cxf.xml]; nested exception is java.io.FileNotFoundException: class path resource [META-INF/cxf/cxf.xml] cannot be opened because it does not exist > at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:342) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.internalLoadBeanDefinitions(ControlledValidationXmlBeanDefinitionReader.java:154) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.access$000(ControlledValidationXmlBeanDefinitionReader.java:66) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader$1.run(ControlledValidationXmlBeanDefinitionReader.java:141) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader$1.run(ControlledValidationXmlBeanDefinitionReader.java:139) > at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal] > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.loadBeanDefinitions(ControlledValidationXmlBeanDefinitionReader.java:139) > at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303) > at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174) > at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:123) > at org.apache.cxf.bus.spring.BusApplicationContext.loadBeanDefinitions(BusApplicationContext.java:322) > at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) > at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:539) > at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:451) > at org.apache.cxf.bus.spring.BusApplicationContext$1.run(BusApplicationContext.java:107) > at org.apache.cxf.bus.spring.BusApplicationContext$1.run(BusApplicationContext.java:105) > at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal] > at org.apache.cxf.bus.spring.BusApplicationContext.<init>(BusApplicationContext.java:105) > at org.apache.cxf.bus.spring.SpringBusFactory.createApplicationContext(SpringBusFactory.java:157) > at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:148) > at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:124) > at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:94) > at org.apache.cxf.jaxrs.client.WebClient.getBean(WebClient.java:1221) > at org.apache.cxf.jaxrs.client.WebClient.create(WebClient.java:202) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectRaw(SalesforceCXFTransport.java:123) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectLocal(SalesforceCXFTransport.java:87) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectLocal(SalesforceCXFTransport.java:82) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connect(SalesforceCXFTransport.java:78) > at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:94) [force-wsc-22.0.0.jar:] > at com.sforce.soap.partner.PartnerConnection.delete(PartnerConnection.java:905) [force-partner-api-22.0.0.jar:] > at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.delete(SalesforceConnectionImpl.java:315) > at org.teiid.translator.salesforce.execution.DeleteExecutionImpl.execute(DeleteExecutionImpl.java:52) [translator-salesforce-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:402) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0-internal] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0-internal] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal] > at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) > at com.sun.proxy.$Proxy47.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal] > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal] > Caused by: java.io.FileNotFoundException: class path resource [META-INF/cxf/cxf.xml] cannot be opened because it does not exist > at org.springframework.core.io.ClassPathResource.getInputStream(ClassPathResource.java:171) > at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:329) > ... 50 more > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4271) Consume Teiid OData from Salesforce

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4271?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4271. --------------------------------- > Consume Teiid OData from Salesforce > ----------------------------------- > > Key: TEIID-4271 > URL: https://issues.jboss.org/browse/TEIID-4271 > Project: Teiid > Issue Type: Feature Request > Components: OData > Reporter: Steven Hawkins > Assignee: Johnathon Lee > Fix For: 8.12.x, 8.12.6.6_3 > > > At least when consuming OData 2, Salesforce does not support Collection(Int16|Int32|String). Since we expose our system metadata, including pg metadata, in the OData metadata, this means that Salesforce won't consume. If the pg metadata is disabled and there are not primitive array columns in the rest of the metadata, then Salesforce can consume. > Since this is working around a Salesforce issue, we shouldn't introduce too intrusive of a mechanism for this. And in general we may need to use extension metadata to allow users to exclude objects in a more granular way from being exposed in OData metadata. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4271) Consume Teiid OData from Salesforce

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4271?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4271. ----------------------------------- Resolution: Done Marking as resolved from a project perspective as the change should not be needed on later branches. > Consume Teiid OData from Salesforce > ----------------------------------- > > Key: TEIID-4271 > URL: https://issues.jboss.org/browse/TEIID-4271 > Project: Teiid > Issue Type: Feature Request > Components: OData > Reporter: Steven Hawkins > Assignee: Johnathon Lee > Fix For: 8.12.x, 8.12.6.6_3 > > > At least when consuming OData 2, Salesforce does not support Collection(Int16|Int32|String). Since we expose our system metadata, including pg metadata, in the OData metadata, this means that Salesforce won't consume. If the pg metadata is disabled and there are not primitive array columns in the rest of the metadata, then Salesforce can consume. > Since this is working around a Salesforce issue, we shouldn't introduce too intrusive of a mechanism for this. And in general we may need to use extension metadata to allow users to exclude objects in a more granular way from being exposed in OData metadata. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4496) Add more explicit documentation about out of memory handlng

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4496?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4496. ----------------------------------- Resolution: Done updating the memory / diagnosing issues docs. > Add more explicit documentation about out of memory handlng > ----------------------------------------------------------- > > Key: TEIID-4496 > URL: https://issues.jboss.org/browse/TEIID-4496 > Project: Teiid > Issue Type: Task > Components: Documentation > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > It would be good to have text covering out of memory handling. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4496) Add more explicit documentation about out of memory handlng

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4496: ------------------------------------- Summary: Add more explicit documentation about out of memory handlng Key: TEIID-4496 URL: https://issues.jboss.org/browse/TEIID-4496 Project: Teiid Issue Type: Task Components: Documentation Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1 It would be good to have text covering out of memory handling. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4294) External Materialization MATVIEW_AFTER_LOAD_SCRIPT may not be an atomic operation

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4294?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4294: ---------------------------------- Fix Version/s: 9.2 Summary: External Materialization MATVIEW_AFTER_LOAD_SCRIPT may not be an atomic operation (was: External Materialization MATVIEW_AFTER_LOAD_SCRIPT is not atomic operation) Priority: Major (was: Blocker) > External Materialization MATVIEW_AFTER_LOAD_SCRIPT may not be an atomic operation > --------------------------------------------------------------------------------- > > Key: TEIID-4294 > URL: https://issues.jboss.org/browse/TEIID-4294 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12.5 > Reporter: Jan Stastny > Assignee: Steven Hawkins > Fix For: 9.2 > > Attachments: dv-2016-06-23-mat-view.log, teiid-command.log > > > Firstly, this issue appears even after *TEIID-4283* fix, and is db independent. > When during materialized view's loading there is a query on the view performed, timing issues appear. In MATVIEW_AFTER_LOAD_SCRIPT there might be more commands separated by semicolon, but these commands are not performed as a single operation. In specific timing a query on such view might fail when you have a MATVIEW_AFTER_LOAD_SCRIPT like this: > {code:sql} > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''RENAME TABLE dv_matviews_mat_view_stage TO dv_matviews_mat_view_temp'');exec Source.native(''RENAME TABLE dv_matviews_mat_view TO dv_matviews_mat_view_stage'');exec Source.native(''RENAME TABLE dv_matviews_mat_view_temp TO dv_matviews_mat_view''); > {code} > user might end up querying the view right in the moment, when 'primary' materialized table (dv_matviews_mat_view) was renamed (dv_matviews_mat_view_stage) and thus there's no such table like defined in the materialized view. > {code:xml} > CREATE VIEW external_long_ttl ( > customer_id integer NOT NULL, > total_amount integer > ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE', > MATERIALIZED_TABLE 'Source.JSTASTNY.dv_matviews_mat_view', > "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', > "teiid_rel:MATVIEW_STATUS_TABLE" 'Source.JSTASTNY.dv_matviews_statustable', > "teiid_rel:ON_VDB_START_SCRIPT" 'MERGE INTO dv_matviews_check_table(id,vdb_create) SELECT id, vdb_create+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';', > "teiid_rel:ON_VDB_DROP_SCRIPT" 'MERGE INTO dv_matviews_check_table(id,vdb_drop) SELECT id, vdb_drop+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';', > "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO dv_matviews_mat_view_stage(customer_id,total_amount) SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id;', > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'exec Source.native(''truncate table dv_matviews_mat_view_stage'');MERGE INTO dv_matviews_check_table(id,before_load) SELECT id, before_load+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''RENAME TABLE dv_matviews_mat_view_stage TO dv_matviews_mat_view_temp'');exec Source.native(''RENAME TABLE dv_matviews_mat_view TO dv_matviews_mat_view_stage'');exec Source.native(''RENAME TABLE dv_matviews_mat_view_temp TO dv_matviews_mat_view'');MERGE INTO dv_matviews_check_table(id,after_load) SELECT id, after_load+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';', > "teiid_rel:MATVIEW_ONERROR_ACTION" 'IGNORE', > "teiid_rel:MATVIEW_TTL" 20000) > AS SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id; > {code} > Then for some queries I get: > {code:plain} > 10:40:19,252 WARN [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue130) Connector worker process failed for atomic-request=+k/MyS3sUhQX.14.7.113: org.teiid.translator.jdbc.JDBCExecutionException: 259 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."CUSTOMER_ID", g_0."TOTAL_AMOUNT" FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_MAT_VIEW AS g_0] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.12.5.redhat-5.jar:8.12.5.redhat-5] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364) > at sun.reflect.GeneratedMethodAccessor158.invoke(Unknown Source) [:1.7.0_79] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_79] > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_79] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) > at com.sun.proxy.$Proxy80.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_79] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_79] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_79] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79] > Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259]: invalid table name: Could not find table/view DVQE_X_XJDKY_YDV_MATVIEWS_MAT_VIEW in schema JSTASTNY: line 1 col 62 (at pos 61) > at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:345) > at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:185) > at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:100) > at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1130) > at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:877) > at com.sap.db.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.java:410) > at com.sap.db.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.java:266) > at com.sap.db.jdbc.CallableStatementSapDB.executeQuery(CallableStatementSapDB.java:756) > at com.sap.db.jdbc.trace.PreparedStatement.executeQuery(PreparedStatement.java:161) > at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123) [translator-jdbc-8.12.5.redhat-5.jar:8.12.5.redhat-5] > ... 17 more > {code} > From the logs it seems that the after load script has completed, but probably not in the source db. In logs just before the exception I see: > {code:plain} > 12:34:59,247 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue79) Source-specific command: RENAME TABLE dv_matviews_mat_view_temp TO dv_matviews_mat_view > 12:34:59,663 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue79) ORTEkGreciAL.0.85.84 Executed command > 12:34:59,663 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue79) ORTEkGreciAL.0.85.84 Processing MORE request > 12:34:59,663 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue79) ORTEkGreciAL.0.85.84 Getting results from connector > 12:34:59,663 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue79) ORTEkGreciAL.0.85.84 Obtained last batch, total row count: 1 > 12:34:59,663 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue79) ORTEkGreciAL.0.85.84 Remove State > 12:34:59,664 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue79) ORTEkGreciAL.0.85.84 Processing Close : EXEC Source.native('RENAME TABLE dv_matviews_mat_view_temp TO dv_matviews_mat_view') > {code} > I attached the logs to this issue. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4294) External Materialization MATVIEW_AFTER_LOAD_SCRIPT is not atomic operation

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4294?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-4294: ----------------------------------- Reopening to work on the options listed in the last comment. > External Materialization MATVIEW_AFTER_LOAD_SCRIPT is not atomic operation > -------------------------------------------------------------------------- > > Key: TEIID-4294 > URL: https://issues.jboss.org/browse/TEIID-4294 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12.5 > Reporter: Jan Stastny > Assignee: Steven Hawkins > Priority: Blocker > Attachments: dv-2016-06-23-mat-view.log, teiid-command.log > > > Firstly, this issue appears even after *TEIID-4283* fix, and is db independent. > When during materialized view's loading there is a query on the view performed, timing issues appear. In MATVIEW_AFTER_LOAD_SCRIPT there might be more commands separated by semicolon, but these commands are not performed as a single operation. In specific timing a query on such view might fail when you have a MATVIEW_AFTER_LOAD_SCRIPT like this: > {code:sql} > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''RENAME TABLE dv_matviews_mat_view_stage TO dv_matviews_mat_view_temp'');exec Source.native(''RENAME TABLE dv_matviews_mat_view TO dv_matviews_mat_view_stage'');exec Source.native(''RENAME TABLE dv_matviews_mat_view_temp TO dv_matviews_mat_view''); > {code} > user might end up querying the view right in the moment, when 'primary' materialized table (dv_matviews_mat_view) was renamed (dv_matviews_mat_view_stage) and thus there's no such table like defined in the materialized view. > {code:xml} > CREATE VIEW external_long_ttl ( > customer_id integer NOT NULL, > total_amount integer > ) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'FALSE', > MATERIALIZED_TABLE 'Source.JSTASTNY.dv_matviews_mat_view', > "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', > "teiid_rel:MATVIEW_STATUS_TABLE" 'Source.JSTASTNY.dv_matviews_statustable', > "teiid_rel:ON_VDB_START_SCRIPT" 'MERGE INTO dv_matviews_check_table(id,vdb_create) SELECT id, vdb_create+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';', > "teiid_rel:ON_VDB_DROP_SCRIPT" 'MERGE INTO dv_matviews_check_table(id,vdb_drop) SELECT id, vdb_drop+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';', > "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO dv_matviews_mat_view_stage(customer_id,total_amount) SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id;', > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'exec Source.native(''truncate table dv_matviews_mat_view_stage'');MERGE INTO dv_matviews_check_table(id,before_load) SELECT id, before_load+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'exec Source.native(''RENAME TABLE dv_matviews_mat_view_stage TO dv_matviews_mat_view_temp'');exec Source.native(''RENAME TABLE dv_matviews_mat_view TO dv_matviews_mat_view_stage'');exec Source.native(''RENAME TABLE dv_matviews_mat_view_temp TO dv_matviews_mat_view'');MERGE INTO dv_matviews_check_table(id,after_load) SELECT id, after_load+1 FROM dv_matviews_check_table WHERE id=''external_long_ttl'';', > "teiid_rel:MATVIEW_ONERROR_ACTION" 'IGNORE', > "teiid_rel:MATVIEW_TTL" 20000) > AS SELECT CONVERT(c.id,integer) AS customer_id, CONVERT(SUM(o.amount),integer) AS total_amount FROM dv_matviews_customers c INNER JOIN dv_matviews_orders o ON c.id = o.customer_id GROUP BY c.id; > {code} > Then for some queries I get: > {code:plain} > 10:40:19,252 WARN [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue130) Connector worker process failed for atomic-request=+k/MyS3sUhQX.14.7.113: org.teiid.translator.jdbc.JDBCExecutionException: 259 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."CUSTOMER_ID", g_0."TOTAL_AMOUNT" FROM "JSTASTNY".dvqe_X_XjdkY_YDV_MATVIEWS_MAT_VIEW AS g_0] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.12.5.redhat-5.jar:8.12.5.redhat-5] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364) > at sun.reflect.GeneratedMethodAccessor158.invoke(Unknown Source) [:1.7.0_79] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_79] > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_79] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) > at com.sun.proxy.$Proxy80.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_79] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_79] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_79] > at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_79] > Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259]: invalid table name: Could not find table/view DVQE_X_XJDKY_YDV_MATVIEWS_MAT_VIEW in schema JSTASTNY: line 1 col 62 (at pos 61) > at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:345) > at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:185) > at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:100) > at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1130) > at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:877) > at com.sap.db.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.java:410) > at com.sap.db.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.java:266) > at com.sap.db.jdbc.CallableStatementSapDB.executeQuery(CallableStatementSapDB.java:756) > at com.sap.db.jdbc.trace.PreparedStatement.executeQuery(PreparedStatement.java:161) > at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123) [translator-jdbc-8.12.5.redhat-5.jar:8.12.5.redhat-5] > ... 17 more > {code} > From the logs it seems that the after load script has completed, but probably not in the source db. In logs just before the exception I see: > {code:plain} > 12:34:59,247 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue79) Source-specific command: RENAME TABLE dv_matviews_mat_view_temp TO dv_matviews_mat_view > 12:34:59,663 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue79) ORTEkGreciAL.0.85.84 Executed command > 12:34:59,663 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue79) ORTEkGreciAL.0.85.84 Processing MORE request > 12:34:59,663 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue79) ORTEkGreciAL.0.85.84 Getting results from connector > 12:34:59,663 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue79) ORTEkGreciAL.0.85.84 Obtained last batch, total row count: 1 > 12:34:59,663 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue79) ORTEkGreciAL.0.85.84 Remove State > 12:34:59,664 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue79) ORTEkGreciAL.0.85.84 Processing Close : EXEC Source.native('RENAME TABLE dv_matviews_mat_view_temp TO dv_matviews_mat_view') > {code} > I attached the logs to this issue. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4030) Improve Geometry Type Handling in HANA Translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4030?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4030: ---------------------------------- Fix Version/s: 9.2 (was: 9.1) Ted, do you want this still assigned to you? > Improve Geometry Type Handling in HANA Translator > ------------------------------------------------- > > Key: TEIID-4030 > URL: https://issues.jboss.org/browse/TEIID-4030 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.13.1 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 9.2 > > > The Geometry type logic in the HANA translator should use the new Teiid Geometry type, similar to the postgres translator. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4423) UPDATE command with non-pushdown functions leads to TEIID30253 error

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4423?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4423. ----------------------------------- Resolution: Done Changed the logic to consistently check for non-deterministic expressions - we'll now only deeply check in uncorrelated subqueries. Also add a release note and a doc note. So now: update test.textagg_test_2 set id =(select uuid()) where id = 'xxxx'; will evaluate to a single id value. update test.textagg_test_2 set id =uuid() where id = 'xxxx'; will set an id per row, which in this case without a key will result in an error. > UPDATE command with non-pushdown functions leads to TEIID30253 error > -------------------------------------------------------------------- > > Key: TEIID-4423 > URL: https://issues.jboss.org/browse/TEIID-4423 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12.x > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > teiid-9.0.3 on WildFly Full 9.0.2.Final > Reporter: dalex dalex > Assignee: Steven Hawkins > Fix For: 9.1 > > > Running the following queries: > {code:sql} > update test.textagg_test_2 set id =(select uuid());; > {code} > or > {code:sql} > update test.textagg_test_2 set id =(select rand());; > {code} > leads to the following errors: > {code} > TEIID30253 Source UPDATE or DELETE command "UPDATE test.textagg_test_2 SET id = (SELECT uuid() LIMIT 2)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. > {code} > and > {code} > TEIID30253 Source UPDATE or DELETE command "UPDATE test.textagg_test_2 SET id = convert((SELECT rand() LIMIT 2), string)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. > {code} > though the following query: > {code:sql} > update test.textagg_test_2 set id =(select now());; > {code} > works without errors. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4495) Salesforce - unable to use CXF configuration with version 34

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4495?page=com.atlassian.jira.plugin... ] Juraj Duráni updated TEIID-4495: -------------------------------- Description: I am trying to use simple CXF logging feature to log in/outbound messages for Salesforce resource adapter. However, Teiid throws ClassNotFoundException if using translator/connection factory of version 34. There is no problem with version 22 except one warning: {code:plain} 08:16:44WARNING [org.apache.cxf.bus.spring.SpringBusFactory] (Worker1_QueryProcessorQueue11) Initial attempt to create application context was unsuccessful.: org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from class path resource [META-INF/cxf/cxf.xml]; nested exception is java.io.FileNotFoundException: class path resource [META-INF/cxf/cxf.xml] cannot be opened because it does not exist at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:342) at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.internalLoadBeanDefinitions(ControlledValidationXmlBeanDefinitionReader.java:154) at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.access$000(ControlledValidationXmlBeanDefinitionReader.java:66) at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader$1.run(ControlledValidationXmlBeanDefinitionReader.java:141) at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader$1.run(ControlledValidationXmlBeanDefinitionReader.java:139) at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal] at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.loadBeanDefinitions(ControlledValidationXmlBeanDefinitionReader.java:139) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174) at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:123) at org.apache.cxf.bus.spring.BusApplicationContext.loadBeanDefinitions(BusApplicationContext.java:322) at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:539) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:451) at org.apache.cxf.bus.spring.BusApplicationContext$1.run(BusApplicationContext.java:107) at org.apache.cxf.bus.spring.BusApplicationContext$1.run(BusApplicationContext.java:105) at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal] at org.apache.cxf.bus.spring.BusApplicationContext.<init>(BusApplicationContext.java:105) at org.apache.cxf.bus.spring.SpringBusFactory.createApplicationContext(SpringBusFactory.java:157) at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:148) at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:124) at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:94) at org.apache.cxf.jaxrs.client.WebClient.getBean(WebClient.java:1221) at org.apache.cxf.jaxrs.client.WebClient.create(WebClient.java:202) at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectRaw(SalesforceCXFTransport.java:123) at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectLocal(SalesforceCXFTransport.java:87) at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectLocal(SalesforceCXFTransport.java:82) at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connect(SalesforceCXFTransport.java:78) at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:94) [force-wsc-22.0.0.jar:] at com.sforce.soap.partner.PartnerConnection.delete(PartnerConnection.java:905) [force-partner-api-22.0.0.jar:] at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.delete(SalesforceConnectionImpl.java:315) at org.teiid.translator.salesforce.execution.DeleteExecutionImpl.execute(DeleteExecutionImpl.java:52) [translator-salesforce-8.12.5.redhat-8.jar:8.12.5.redhat-8] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:402) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0-internal] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0-internal] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal] at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal] at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) at com.sun.proxy.$Proxy47.execute(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal] at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal] at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal] Caused by: java.io.FileNotFoundException: class path resource [META-INF/cxf/cxf.xml] cannot be opened because it does not exist at org.springframework.core.io.ClassPathResource.getInputStream(ClassPathResource.java:171) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:329) ... 50 more {code} was: I am trying to use simple CXF logging feature to log in/outbound messages for Salesforce resource adapter. However, Teiid throws ClassNotFoundException if using translator/connection factory of version 34. There is no problem with version 22 except one warning: {code:plain} 08:16:44,652 WARNING [org.apache.cxf.bus.spring.SpringBusFactory] (Worker1_QueryProcessorQueue11) Initial attempt to create application context was unsuccessful.: org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from class path resource [META-INF/cxf/cxf.xml]; nested exception is java.io.FileNotFoundException: class path resource [META-INF/cxf/cxf.xml] cannot be opened because it does not exist 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:342) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.internalLoadBeanDefinitions(ControlledValidationXmlBeanDefinitionReader.java:154) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.access$000(ControlledValidationXmlBeanDefinitionReader.java:66) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader$1.run(ControlledValidationXmlBeanDefinitionReader.java:141) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader$1.run(ControlledValidationXmlBeanDefinitionReader.java:139) 09:16:44,655 INFO [MultiPlatformProcessRunner] at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal] 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.loadBeanDefinitions(ControlledValidationXmlBeanDefinitionReader.java:139) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:123) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.BusApplicationContext.loadBeanDefinitions(BusApplicationContext.java:322) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:539) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:451) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.BusApplicationContext$1.run(BusApplicationContext.java:107) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.BusApplicationContext$1.run(BusApplicationContext.java:105) 09:16:44,655 INFO [MultiPlatformProcessRunner] at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal] 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.BusApplicationContext.<init>(BusApplicationContext.java:105) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.SpringBusFactory.createApplicationContext(SpringBusFactory.java:157) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:148) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:124) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:94) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.apache.cxf.jaxrs.client.WebClient.getBean(WebClient.java:1221) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.apache.cxf.jaxrs.client.WebClient.create(WebClient.java:202) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectRaw(SalesforceCXFTransport.java:123) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectLocal(SalesforceCXFTransport.java:87) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectLocal(SalesforceCXFTransport.java:82) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connect(SalesforceCXFTransport.java:78) 09:16:44,656 INFO [MultiPlatformProcessRunner] at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:94) [force-wsc-22.0.0.jar:] 09:16:44,656 INFO [MultiPlatformProcessRunner] at com.sforce.soap.partner.PartnerConnection.delete(PartnerConnection.java:905) [force-partner-api-22.0.0.jar:] 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.delete(SalesforceConnectionImpl.java:315) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.translator.salesforce.execution.DeleteExecutionImpl.execute(DeleteExecutionImpl.java:52) [translator-salesforce-8.12.5.redhat-8.jar:8.12.5.redhat-8] 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:402) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364) 09:16:44,656 INFO [MultiPlatformProcessRunner] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) 09:16:44,656 INFO [MultiPlatformProcessRunner] at com.sun.proxy.$Proxy47.execute(Unknown Source) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) 09:16:44,656 INFO [MultiPlatformProcessRunner] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) 09:16:44,656 INFO [MultiPlatformProcessRunner] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] Caused by: java.io.FileNotFoundException: class path resource [META-INF/cxf/cxf.xml] cannot be opened because it does not exist 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.springframework.core.io.ClassPathResource.getInputStream(ClassPathResource.java:171) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:329) 09:16:44,656 INFO [MultiPlatformProcessRunner] ... 50 more 09:16:44,656 INFO [MultiPlatformProcessRunner] {code} > Salesforce - unable to use CXF configuration with version 34 > ------------------------------------------------------------ > > Key: TEIID-4495 > URL: https://issues.jboss.org/browse/TEIID-4495 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12.5 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > I am trying to use simple CXF logging feature to log in/outbound messages for Salesforce resource adapter. However, Teiid throws ClassNotFoundException if using translator/connection factory of version 34. > There is no problem with version 22 except one warning: > {code:plain} > 08:16:44WARNING [org.apache.cxf.bus.spring.SpringBusFactory] (Worker1_QueryProcessorQueue11) Initial attempt to create application context was unsuccessful.: org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from class path resource [META-INF/cxf/cxf.xml]; nested exception is java.io.FileNotFoundException: class path resource [META-INF/cxf/cxf.xml] cannot be opened because it does not exist > at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:342) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.internalLoadBeanDefinitions(ControlledValidationXmlBeanDefinitionReader.java:154) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.access$000(ControlledValidationXmlBeanDefinitionReader.java:66) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader$1.run(ControlledValidationXmlBeanDefinitionReader.java:141) > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader$1.run(ControlledValidationXmlBeanDefinitionReader.java:139) > at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal] > at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.loadBeanDefinitions(ControlledValidationXmlBeanDefinitionReader.java:139) > at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303) > at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174) > at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:123) > at org.apache.cxf.bus.spring.BusApplicationContext.loadBeanDefinitions(BusApplicationContext.java:322) > at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) > at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:539) > at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:451) > at org.apache.cxf.bus.spring.BusApplicationContext$1.run(BusApplicationContext.java:107) > at org.apache.cxf.bus.spring.BusApplicationContext$1.run(BusApplicationContext.java:105) > at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal] > at org.apache.cxf.bus.spring.BusApplicationContext.<init>(BusApplicationContext.java:105) > at org.apache.cxf.bus.spring.SpringBusFactory.createApplicationContext(SpringBusFactory.java:157) > at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:148) > at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:124) > at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:94) > at org.apache.cxf.jaxrs.client.WebClient.getBean(WebClient.java:1221) > at org.apache.cxf.jaxrs.client.WebClient.create(WebClient.java:202) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectRaw(SalesforceCXFTransport.java:123) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectLocal(SalesforceCXFTransport.java:87) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectLocal(SalesforceCXFTransport.java:82) > at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connect(SalesforceCXFTransport.java:78) > at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:94) [force-wsc-22.0.0.jar:] > at com.sforce.soap.partner.PartnerConnection.delete(PartnerConnection.java:905) [force-partner-api-22.0.0.jar:] > at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.delete(SalesforceConnectionImpl.java:315) > at org.teiid.translator.salesforce.execution.DeleteExecutionImpl.execute(DeleteExecutionImpl.java:52) [translator-salesforce-8.12.5.redhat-8.jar:8.12.5.redhat-8] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:402) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0-internal] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0-internal] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal] > at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) > at com.sun.proxy.$Proxy47.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal] > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal] > Caused by: java.io.FileNotFoundException: class path resource [META-INF/cxf/cxf.xml] cannot be opened because it does not exist > at org.springframework.core.io.ClassPathResource.getInputStream(ClassPathResource.java:171) > at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:329) > ... 50 more > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4495) Salesforce - unable to use CXF configuration with version 34

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-4495: ----------------------------------- Summary: Salesforce - unable to use CXF configuration with version 34 Key: TEIID-4495 URL: https://issues.jboss.org/browse/TEIID-4495 Project: Teiid Issue Type: Bug Affects Versions: 8.12.5 Reporter: Juraj Duráni Assignee: Steven Hawkins I am trying to use simple CXF logging feature to log in/outbound messages for Salesforce resource adapter. However, Teiid throws ClassNotFoundException if using translator/connection factory of version 34. There is no problem with version 22 except one warning: {code:plain} 08:16:44,652 WARNING [org.apache.cxf.bus.spring.SpringBusFactory] (Worker1_QueryProcessorQueue11) Initial attempt to create application context was unsuccessful.: org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from class path resource [META-INF/cxf/cxf.xml]; nested exception is java.io.FileNotFoundException: class path resource [META-INF/cxf/cxf.xml] cannot be opened because it does not exist 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:342) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.internalLoadBeanDefinitions(ControlledValidationXmlBeanDefinitionReader.java:154) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.access$000(ControlledValidationXmlBeanDefinitionReader.java:66) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader$1.run(ControlledValidationXmlBeanDefinitionReader.java:141) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader$1.run(ControlledValidationXmlBeanDefinitionReader.java:139) 09:16:44,655 INFO [MultiPlatformProcessRunner] at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal] 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.ControlledValidationXmlBeanDefinitionReader.loadBeanDefinitions(ControlledValidationXmlBeanDefinitionReader.java:139) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:174) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:123) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.BusApplicationContext.loadBeanDefinitions(BusApplicationContext.java:322) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:539) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:451) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.BusApplicationContext$1.run(BusApplicationContext.java:107) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.BusApplicationContext$1.run(BusApplicationContext.java:105) 09:16:44,655 INFO [MultiPlatformProcessRunner] at java.security.AccessController.doPrivileged(Native Method) [rt.jar:1.8.0-internal] 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.BusApplicationContext.<init>(BusApplicationContext.java:105) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.SpringBusFactory.createApplicationContext(SpringBusFactory.java:157) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:148) 09:16:44,655 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:124) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.apache.cxf.bus.spring.SpringBusFactory.createBus(SpringBusFactory.java:94) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.apache.cxf.jaxrs.client.WebClient.getBean(WebClient.java:1221) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.apache.cxf.jaxrs.client.WebClient.create(WebClient.java:202) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectRaw(SalesforceCXFTransport.java:123) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectLocal(SalesforceCXFTransport.java:87) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connectLocal(SalesforceCXFTransport.java:82) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.resource.adapter.salesforce.transport.SalesforceCXFTransport.connect(SalesforceCXFTransport.java:78) 09:16:44,656 INFO [MultiPlatformProcessRunner] at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:94) [force-wsc-22.0.0.jar:] 09:16:44,656 INFO [MultiPlatformProcessRunner] at com.sforce.soap.partner.PartnerConnection.delete(PartnerConnection.java:905) [force-partner-api-22.0.0.jar:] 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.delete(SalesforceConnectionImpl.java:315) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.translator.salesforce.execution.DeleteExecutionImpl.execute(DeleteExecutionImpl.java:52) [translator-salesforce-8.12.5.redhat-8.jar:8.12.5.redhat-8] 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:402) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364) 09:16:44,656 INFO [MultiPlatformProcessRunner] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] at java.lang.reflect.Method.invoke(Method.java:483) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) 09:16:44,656 INFO [MultiPlatformProcessRunner] at com.sun.proxy.$Proxy47.execute(Unknown Source) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) 09:16:44,656 INFO [MultiPlatformProcessRunner] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) 09:16:44,656 INFO [MultiPlatformProcessRunner] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal] 09:16:44,656 INFO [MultiPlatformProcessRunner] Caused by: java.io.FileNotFoundException: class path resource [META-INF/cxf/cxf.xml] cannot be opened because it does not exist 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.springframework.core.io.ClassPathResource.getInputStream(ClassPathResource.java:171) 09:16:44,656 INFO [MultiPlatformProcessRunner] at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:329) 09:16:44,656 INFO [MultiPlatformProcessRunner] ... 50 more 09:16:44,656 INFO [MultiPlatformProcessRunner] {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4299) Object translator null values correctly

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4299?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4299. --------------------------------- > Object translator null values correctly > --------------------------------------- > > Key: TEIID-4299 > URL: https://issues.jboss.org/browse/TEIID-4299 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.x, 8.12.5 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Critical > Fix For: 9.1, 8.12.6.6_3 > > > The object translator wasn't handling the setting of null values when its tried to be set on a native attribute (i.e., long, int, boolean). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4423) UPDATE command with non-pushdown functions leads to TEIID30253 error

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4423?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4423: ---------------------------------- Fix Version/s: 9.1 Assigning to 9.1 to resolve the inconsistent handling for the final release. Since it allows more optimization and is consistent with postgresql/oracle, we'll treat uncorrelated subqueries as deterministic. Note that this behavior is inconsistent with h2/mysql (which can treat uncorrelated subqueries as deterministic) - but I don't think that warrants additional handling yet. > UPDATE command with non-pushdown functions leads to TEIID30253 error > -------------------------------------------------------------------- > > Key: TEIID-4423 > URL: https://issues.jboss.org/browse/TEIID-4423 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12.x > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > teiid-9.0.3 on WildFly Full 9.0.2.Final > Reporter: dalex dalex > Assignee: Steven Hawkins > Fix For: 9.1 > > > Running the following queries: > {code:sql} > update test.textagg_test_2 set id =(select uuid());; > {code} > or > {code:sql} > update test.textagg_test_2 set id =(select rand());; > {code} > leads to the following errors: > {code} > TEIID30253 Source UPDATE or DELETE command "UPDATE test.textagg_test_2 SET id = (SELECT uuid() LIMIT 2)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. > {code} > and > {code} > TEIID30253 Source UPDATE or DELETE command "UPDATE test.textagg_test_2 SET id = convert((SELECT rand() LIMIT 2), string)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. > {code} > though the following query: > {code:sql} > update test.textagg_test_2 set id =(select now());; > {code} > works without errors. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4492) When using annotations, add option that specifies all child classes to register as part of the JDG schema

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4492?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4492: ------------------------------- Git Pull Request: https://github.com/teiid/teiid/pull/806, https://github.com/teiid/teiid-documents/pull/71 > When using annotations, add option that specifies all child classes to register as part of the JDG schema > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-4492 > URL: https://issues.jboss.org/browse/TEIID-4492 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 9.2 > Reporter: Van Halbert > Assignee: Van Halbert > > When using protobuf annotations, need to specify all the child related (e.g, 1-to-1 relationship or 1-to-many relationship) pojo's that also need to be registered with the JDG schema. When these are registered, JDG will auto generate the .proto file and marshallers used by the schema. Which is the information used by the hot rod translator to create the source models. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4492) When using annotations, add option that specifies all child classes to register as part of the JDG schema

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4492?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4492: ------------------------------------ Adding property ChildClasses ChildClasses - className[,className,..] contains a comma separated list of class names that indicate the child classes to register in the JDG schema > When using annotations, add option that specifies all child classes to register as part of the JDG schema > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-4492 > URL: https://issues.jboss.org/browse/TEIID-4492 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 9.2 > Reporter: Van Halbert > Assignee: Van Halbert > > When using protobuf annotations, need to specify all the child related (e.g, 1-to-1 relationship or 1-to-many relationship) pojo's that also need to be registered with the JDG schema. When these are registered, JDG will auto generate the .proto file and marshallers used by the schema. Which is the information used by the hot rod translator to create the source models. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4323) Add support for first/last/absolute/relative "FETCH " syntax

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4323?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4323: ------------------------------------------------ Jan Stastny <jstastny(a)redhat.com> changed the Status of [bug 1353933|https://bugzilla.redhat.com/show_bug.cgi?id=1353933] from ON_QA to VERIFIED > Add support for first/last/absolute/relative "FETCH " syntax > ------------------------------------------------------------ > > Key: TEIID-4323 > URL: https://issues.jboss.org/browse/TEIID-4323 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2, 8.12.6.6_3 > > > Add Support for the below FETCH syntax: > FETCH LAST FROM cursor_name > FETCH ABSOLUTE fetch_when FROM cursor_name > FETCH RELATIVE fetch_when FROM cursor_name > FETCH FIRST FROM cursor_name -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4329) Using JDG annotations, unable to provide package name qualification for serialization

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4329?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4329. --------------------------------- > Using JDG annotations, unable to provide package name qualification for serialization > ------------------------------------------------------------------------------------- > > Key: TEIID-4329 > URL: https://issues.jboss.org/browse/TEIID-4329 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.x, 8.12.5 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.1, 8.12.6.6_3 > > > When using the JDG annotations as the means of configuring the cache and serialization, its not specifying the package name qualifier. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4494) Differentiate requests pending close

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4494?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4494. ----------------------------------- Resolution: Done Allowed the requestClose method to transition directly to close, updated the reporting of the state, and corrected the synchronization around state. > Differentiate requests pending close > ------------------------------------ > > Key: TEIID-4494 > URL: https://issues.jboss.org/browse/TEIID-4494 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.5 > > > TestODBCSocketTransport.testImplicitPortalClosing will fail sometimes due to the asynch handling of close. But we should be able to differentiate requests that are pending close. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4396) Missing images in the Admin section of the documentation

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4396?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4396. ----------------------------------- Fix Version/s: 9.1 Resolution: Done Added missing images for the 9.1 release docs. > Missing images in the Admin section of the documentation > -------------------------------------------------------- > > Key: TEIID-4396 > URL: https://issues.jboss.org/browse/TEIID-4396 > Project: Teiid > Issue Type: Bug > Components: Documentation > Affects Versions: 9.0.2 > Reporter: Patrick McElreavy > Assignee: Steven Hawkins > Priority: Minor > Fix For: 9.1 > > > Section "Profile View" links to image "images/author/download/attachments/18646076/webconsole2.png" > Section "Runtime View" links to image "images/author/download/attachments/18646076/webconsole1.png" > Both these images are missing. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4494) Differentiate requests pending close

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4494: ------------------------------------- Summary: Differentiate requests pending close Key: TEIID-4494 URL: https://issues.jboss.org/browse/TEIID-4494 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1, 9.0.5 TestODBCSocketTransport.testImplicitPortalClosing will fail sometimes due to the asynch handling of close. But we should be able to differentiate requests that are pending close. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4493) Add support for integration with qgis

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4493: ------------------------------------- Summary: Add support for integration with qgis Key: TEIID-4493 URL: https://issues.jboss.org/browse/TEIID-4493 Project: Teiid Issue Type: Enhancement Components: Documentation, Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.2 Similar to our support for GeoServer, we should support qgis integration if possible. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4491) Refine uniqueidentifier support for SQL Server

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4491?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4491: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1381566, https://bugzilla.redhat.com/show_bug.cgi?id=1381568 Bugzilla Update: Perform > Refine uniqueidentifier support for SQL Server > ---------------------------------------------- > > Key: TEIID-4491 > URL: https://issues.jboss.org/browse/TEIID-4491 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Connector > Affects Versions: 7.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > SQL Servers later than 2000 can treat uniqueidentifier as a comparable type - there is no need to always cast. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4492) When using annotations, add option that specifies all child classes to register as part of the JDG schema

by Van Halbert (JIRA)

Van Halbert created TEIID-4492: ---------------------------------- Summary: When using annotations, add option that specifies all child classes to register as part of the JDG schema Key: TEIID-4492 URL: https://issues.jboss.org/browse/TEIID-4492 Project: Teiid Issue Type: Enhancement Components: Misc. Connectors Affects Versions: 9.2 Reporter: Van Halbert Assignee: Steven Hawkins When using protobuf annotations, need to specify all the child related (e.g, 1-to-1 relationship or 1-to-many relationship) pojo's that also need to be registered with the JDG schema. When these are registered, JDG will auto generate the .proto file and marshallers used by the schema. Which is the information used by the hot rod translator to create the source models. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4492) When using annotations, add option that specifies all child classes to register as part of the JDG schema

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4492?page=com.atlassian.jira.plugin... ] Van Halbert reassigned TEIID-4492: ---------------------------------- Assignee: Van Halbert (was: Steven Hawkins) > When using annotations, add option that specifies all child classes to register as part of the JDG schema > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-4492 > URL: https://issues.jboss.org/browse/TEIID-4492 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 9.2 > Reporter: Van Halbert > Assignee: Van Halbert > > When using protobuf annotations, need to specify all the child related (e.g, 1-to-1 relationship or 1-to-many relationship) pojo's that also need to be registered with the JDG schema. When these are registered, JDG will auto generate the .proto file and marshallers used by the schema. Which is the information used by the hot rod translator to create the source models. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4487) NPE if using multi-value prepared INSERT

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4487?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-4487: ------------------------------------- In my test, I am testing both ways: - using _(?,?),(?,?),..._ construct - here, prepared statement is probably not needed, simple Statement should work as well - using batch (_addBatch ()_ and _executeBatch()_) > NPE if using multi-value prepared INSERT > ---------------------------------------- > > Key: TEIID-4487 > URL: https://issues.jboss.org/browse/TEIID-4487 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 9.1 > > > If user issues multi-value insert, Teiid throws NPE. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4491) Refine uniqueidentifier support for SQL Server

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4491?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4491. ----------------------------------- Resolution: Done Made the use of the cast version dependent. > Refine uniqueidentifier support for SQL Server > ---------------------------------------------- > > Key: TEIID-4491 > URL: https://issues.jboss.org/browse/TEIID-4491 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Connector > Affects Versions: 7.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > SQL Servers later than 2000 can treat uniqueidentifier as a comparable type - there is no need to always cast. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4491) Refine uniqueidentifier support for SQL Server

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4491: ------------------------------------- Summary: Refine uniqueidentifier support for SQL Server Key: TEIID-4491 URL: https://issues.jboss.org/browse/TEIID-4491 Project: Teiid Issue Type: Quality Risk Components: JDBC Connector Affects Versions: 7.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1 SQL Servers later than 2000 can treat uniqueidentifier as a comparable type - there is no need to always cast. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4117) Add explicit empty handling for array values in xmltable

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4117?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4117. ----------------------------------- Fix Version/s: (was: 9.1) Resolution: Rejected While a logical change, this doesn't warrant modifying the already non-standard handling of array types - as it can easily be worked around in the projection above by using ifnull/nvl. > Add explicit empty handling for array values in xmltable > -------------------------------------------------------- > > Key: TEIID-4117 > URL: https://issues.jboss.org/browse/TEIID-4117 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > > Currently we default to null on empty behavior, but it would be good to allow empty on empty as well: > xmltable('/a' passing convert('<a></a>', xml) columns x string[] path 'b') > will produce a null value, but in some cases you'd want to produce an empty array. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3660) Add support for unnesting anti semijoins

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3660?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3660: ---------------------------------- Description: Currently we won't perform the rewrite if it's the anti case. A subquery used as an anti semijoin can be unnested into a left outer join with a filter on the null rows. (was: Currently we won't perform the rewrite if it's the anit case. A subquery used as an anti semijoin can be unnested into a left outer join with a filter on the null rows. ) > Add support for unnesting anti semijoins > ---------------------------------------- > > Key: TEIID-3660 > URL: https://issues.jboss.org/browse/TEIID-3660 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > Currently we won't perform the rewrite if it's the anti case. A subquery used as an anti semijoin can be unnested into a left outer join with a filter on the null rows. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4490) Insert with multiple values doesn't allow subqueries

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4490?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4490: ---------------------------------- Fix Version/s: 9.1 > Insert with multiple values doesn't allow subqueries > ---------------------------------------------------- > > Key: TEIID-4490 > URL: https://issues.jboss.org/browse/TEIID-4490 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > Since multiple values are converted into a union all at parsing time, the validator will not allow subqueries. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4490) Insert with multiple values doesn't allow subqueries

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4490?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4490. ----------------------------------- Resolution: Done Added a check to see if a row value was being used. > Insert with multiple values doesn't allow subqueries > ---------------------------------------------------- > > Key: TEIID-4490 > URL: https://issues.jboss.org/browse/TEIID-4490 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > > Since multiple values are converted into a union all at parsing time, the validator will not allow subqueries. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4490) Insert with multiple values doesn't allow subqueries

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4490: ------------------------------------- Summary: Insert with multiple values doesn't allow subqueries Key: TEIID-4490 URL: https://issues.jboss.org/browse/TEIID-4490 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 8.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Since multiple values are converted into a union all at parsing time, the validator will not allow subqueries. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4487) NPE if using multi-value prepared INSERT

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4487?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4487. ----------------------------------- Resolution: Done Updated the handling in the setquery resolver to not throw an npe and the insert logic to re-resolve so that the expected types are set. > NPE if using multi-value prepared INSERT > ---------------------------------------- > > Key: TEIID-4487 > URL: https://issues.jboss.org/browse/TEIID-4487 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 9.1 > > > If user issues multi-value insert, Teiid throws NPE. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4487) NPE if using multi-value prepared INSERT

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4487?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4487: ---------------------------------- Component/s: Query Engine > NPE if using multi-value prepared INSERT > ---------------------------------------- > > Key: TEIID-4487 > URL: https://issues.jboss.org/browse/TEIID-4487 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 9.1 > > > If user issues multi-value insert, Teiid throws NPE. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4487) NPE if using multi-value prepared INSERT

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4487?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4487: ---------------------------------- Component/s: (was: Salesforce Connector) Fix Version/s: 9.1 Summary: NPE if using multi-value prepared INSERT (was: Salesfroce - NPE if using multi-value INSERT) Affects Version/s: 8.7 (was: 8.12.5) > NPE if using multi-value prepared INSERT > ---------------------------------------- > > Key: TEIID-4487 > URL: https://issues.jboss.org/browse/TEIID-4487 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 9.1 > > > If user issues multi-value insert, Teiid throws NPE. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4487) Salesfroce - NPE if using multi-value INSERT

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4487?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4487: --------------------------------------- It is not the proper way, but it should still work. The issue is that for multiple values our under the covers handling is to use a union all query, which doesn't handle the resolving well. > Salesfroce - NPE if using multi-value INSERT > -------------------------------------------- > > Key: TEIID-4487 > URL: https://issues.jboss.org/browse/TEIID-4487 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.12.5 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > If user issues multi-value insert, Teiid throws NPE. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4487) Salesfroce - NPE if using multi-value INSERT

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4487?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4487: ------------------------------------- I do not think the above is correct way to call the prepared statement, see this for example http://stackoverflow.com/questions/4355046/java-insert-multiple-rows-into... > Salesfroce - NPE if using multi-value INSERT > -------------------------------------------- > > Key: TEIID-4487 > URL: https://issues.jboss.org/browse/TEIID-4487 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.12.5 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > If user issues multi-value insert, Teiid throws NPE. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4487) Salesfroce - NPE if using multi-value INSERT

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4487?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4487: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1381229 Bugzilla Update: Perform > Salesfroce - NPE if using multi-value INSERT > -------------------------------------------- > > Key: TEIID-4487 > URL: https://issues.jboss.org/browse/TEIID-4487 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.12.5 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > If user issues multi-value insert, Teiid throws NPE. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4485) import-vdb VDB name case-sensitive

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4485?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4485. ----------------------------------- Resolution: Done Changing service names to not be case sensitive > import-vdb VDB name case-sensitive > ---------------------------------- > > Key: TEIID-4485 > URL: https://issues.jboss.org/browse/TEIID-4485 > Project: Teiid > Issue Type: Bug > Components: VDB > Affects Versions: 8.7 > Reporter: Chandra Akkinepalli > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.5 > > > I have built couple of VDBs using designer, their names are all CAPS and wanted to import these 2 VDBs as views in my 3rd VDB. As the VDB name is cases insensitive in connect string i used lower case to connect to the VDB to do JDBC import. After i completed my 3rd VDB when i tried to deploy the VDB onto the server it is going into INACTIVE state, after changing my connection string to upper case and reimporting the VDB i was able to deploy the 3rd VDB and it state turned to ACTIVE. > The VDB import definition seem's to be case sensitive and this may be the cause of the errors. > I haven't tested this in Dynamic VDB. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4488) Add a more localized way to set the default escape

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4488?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4488. ----------------------------------- Resolution: Done added and documented using the session variable backslashMatchDefaultEscape > Add a more localized way to set the default escape > -------------------------------------------------- > > Key: TEIID-4488 > URL: https://issues.jboss.org/browse/TEIID-4488 > Project: Teiid > Issue Type: Quality Risk > Components: ODBC > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > To support geoserver and ODBC integration in general we should provide a more localized way of setting the default escape for like predicates. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4357) Add documentation on exposing Teiid as a GeoServer data source

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4357?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4357. ----------------------------------- Resolution: Done Added the basic integration steps to the client dev guide covering any Teiid specific nuances. Also added TEIID-4488 so that the backslash handling could be localized. > Add documentation on exposing Teiid as a GeoServer data source > -------------------------------------------------------------- > > Key: TEIID-4357 > URL: https://issues.jboss.org/browse/TEIID-4357 > Project: Teiid > Issue Type: Enhancement > Components: Documentation > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 9.1 > > > Based on the details in TEIID-3869, need to document how Teiid can be exposed as a GeoServer data source -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4489) Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4489?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4489: ------------------------------------ And it needs to be checked that, if the defaults are selected and 10 to 20 data sources are selected, it recommends the MEDIUM size, and then the LARGE is recommended when 21 or above is selected. > Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size > --------------------------------------------------------------------------- > > Key: TEIID-4489 > URL: https://issues.jboss.org/browse/TEIID-4489 > Project: Teiid > Issue Type: Enhancement > Components: Sizing Application > Affects Versions: 9.x > Reporter: Van Halbert > Assignee: Kylin Soong > > Based on recommendations: > small : 16 cores, with at least 32 GB RAM. 2 DV instances. (small means may be 5 ~10 sources, rows into millions, YMMV) > medium : 32 cores with 64 GB RAM, 4 DV instances. (medium means may be 10 ~ 20 sources, rows into multi-millions, YMMV) > Large: custom > The defaults in the sizing applications, along with selecting 1 to 10 data sources, should result in the SMALL recommendation. It should be clear to indicate the number of instances and the size recommendation per instance. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4489) Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4489?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4489: ------------------------------------ I say clear, because I'm not sure if whats stated: 16 cores, with at least 32 GB RAM. 2 DV instances. (small means may be 5 ~10 sources, rows into millions, YMMV) means each instance to be 16 cores/32GB or split it to be 8 cores/16GB per instance.. > Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size > --------------------------------------------------------------------------- > > Key: TEIID-4489 > URL: https://issues.jboss.org/browse/TEIID-4489 > Project: Teiid > Issue Type: Enhancement > Components: Sizing Application > Affects Versions: 9.x > Reporter: Van Halbert > Assignee: Kylin Soong > Priority: Minor > > Based on recommendations: > small : 16 cores, with at least 32 GB RAM. 2 DV instances. (small means may be 5 ~10 sources, rows into millions, YMMV) > medium : 32 cores with 64 GB RAM, 4 DV instances. (medium means may be 10 ~ 20 sources, rows into multi-millions, YMMV) > Large: custom > The defaults in the sizing applications, along with selecting 1 to 10 data sources, should result in the SMALL recommendation. It should be clear to indicate the number of instances and the size recommendation per instance. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4489) Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4489?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4489: ------------------------------- Priority: Major (was: Minor) > Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size > --------------------------------------------------------------------------- > > Key: TEIID-4489 > URL: https://issues.jboss.org/browse/TEIID-4489 > Project: Teiid > Issue Type: Enhancement > Components: Sizing Application > Affects Versions: 9.x > Reporter: Van Halbert > Assignee: Kylin Soong > > Based on recommendations: > small : 16 cores, with at least 32 GB RAM. 2 DV instances. (small means may be 5 ~10 sources, rows into millions, YMMV) > medium : 32 cores with 64 GB RAM, 4 DV instances. (medium means may be 10 ~ 20 sources, rows into multi-millions, YMMV) > Large: custom > The defaults in the sizing applications, along with selecting 1 to 10 data sources, should result in the SMALL recommendation. It should be clear to indicate the number of instances and the size recommendation per instance. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4489) Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size

by Van Halbert (JIRA)

Van Halbert created TEIID-4489: ---------------------------------- Summary: Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size Key: TEIID-4489 URL: https://issues.jboss.org/browse/TEIID-4489 Project: Teiid Issue Type: Enhancement Components: Sizing Application Affects Versions: 9.x Reporter: Van Halbert Assignee: Kylin Soong Priority: Minor Based on recommendations: small : 16 cores, with at least 32 GB RAM. 2 DV instances. (small means may be 5 ~10 sources, rows into millions, YMMV) medium : 32 cores with 64 GB RAM, 4 DV instances. (medium means may be 10 ~ 20 sources, rows into multi-millions, YMMV) Large: custom The defaults in the sizing applications, along with selecting 1 to 10 data sources, should result in the SMALL recommendation. It should be clear to indicate the number of instances and the size recommendation per instance. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4488) Add a more localized way to set the default escape

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4488: ------------------------------------- Summary: Add a more localized way to set the default escape Key: TEIID-4488 URL: https://issues.jboss.org/browse/TEIID-4488 Project: Teiid Issue Type: Quality Risk Components: ODBC Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1 To support geoserver and ODBC integration in general we should provide a more localized way of setting the default escape for like predicates. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4486) Improve performance of st_extent

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4486?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4486: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1381258 Bugzilla Update: Perform > Improve performance of st_extent > -------------------------------- > > Key: TEIID-4486 > URL: https://issues.jboss.org/browse/TEIID-4486 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Affects Versions: 9.0, 8.12.5 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.5 > > > The implementation of st_extent is very costly. It should instead be based upon the Envelope class. Also it is not being pushed to pg. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4487) Salesfroce - NPE if using multi-value INSERT

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-4487: ----------------------------------- Summary: Salesfroce - NPE if using multi-value INSERT Key: TEIID-4487 URL: https://issues.jboss.org/browse/TEIID-4487 Project: Teiid Issue Type: Bug Components: Salesforce Connector Affects Versions: 8.12.5 Reporter: Juraj Duráni Assignee: Steven Hawkins If user issues multi-value insert, Teiid throws NPE. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3862) Documentation in kit for certain datasources missing

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3862?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3862. ----------------------------------- Resolution: Done Marking as resolved. > Documentation in kit for certain datasources missing > ---------------------------------------------------- > > Key: TEIID-3862 > URL: https://issues.jboss.org/browse/TEIID-3862 > Project: Teiid > Issue Type: Quality Risk > Components: Documentation > Reporter: Ramesh Reddy > Assignee: Van Halbert > Fix For: 8.12.5 > > > The following data sources do not have documentation under > "docs/teiid/datasources" > where typically a standalone.xml changes and/or CLI scripts are provided. > access > hana > hsql > informix > modeshape > netezza > sybase > teradata > excel > hbase > odata > odata4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4204) Examples dynamicvdb-restservice - rest client returns always empty body

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4204?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4204: ---------------------------------- Fix Version/s: 9.1 (was: 9.0) (was: 8.12.5) > Examples dynamicvdb-restservice - rest client returns always empty body > ------------------------------------------------------------------------ > > Key: TEIID-4204 > URL: https://issues.jboss.org/browse/TEIID-4204 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Affects Versions: 8.12.5 > Reporter: Van Halbert > Assignee: Kylin Soong > Priority: Minor > Fix For: 9.1 > > > Description of problem: > rest-client returns always empty body for every request like follows: > [jdurani@localhost resteasy-client]$ java -cp target/dependency/*:target/dynamicvdb-resteasy-client.jar org.jboss.teiid.quickstart.PortfolioClient > JAX-RS 2.0 Client API -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2016