October 2016 - teiid-issues - Jboss List Archives

[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/27/16 8:11 AM: ----------------------------------------------------------- Hi [~shawkins], As I tested it on my salesforce Account. looks like there is some critical problem when there are many batches (more than 4) which get created when the number of rows in the table are huge (pretty large than the Maximum Chunk Size or something). When I do a simple select * from such a table multiple times in a row (sometimes even on first query), I get the following error : {code:java} Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 TEIID30020 Processing exception for request IR8UKFQnuXi4.17 'TEIID30504 dssSOU: null'. Originally TeiidProcessingException SalesforceConnectionImpl.java:570. SQLState: TEIID30504 ErrorCode: 0 {code} I got it when I had to query the table multiple times. I hope you will be able to reproduce this issue :) was (Author: sameerp): Hi [~shawkins], As I tested it on my salesforce Account. looks like there is some critical problem when there are many batches (more than 4) which get created when the number of rows in the table are huge (pretty large than the Maximum Chunk Size or something). When I do a simple select * from such a table multiple times in a row (sometimes even on first query), I get the following error : {code:java} Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 TEIID30020 Processing exception for request IR8UKFQnuXi4.17 'TEIID30504 dssSOU: null'. Originally TeiidProcessingException SalesforceConnectionImpl.java:570. SQLState: TEIID30504 ErrorCode: 0 {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.2 > > > 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 (v7.2.2#72004)

7 years, 8 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 updated TEIID-4492: ---------------------------------- Fix Version/s: 8.12.7.6_3 (was: 8.12.6.6_3) Bugzilla References: (was: https://bugzilla.redhat.com/show_bug.cgi?id=1381557) Ok, it came in as part of a larger pull request and lost the association to the JIRA. Updating to 8.12.7_6.3 > 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, 8.12.7.6_3 > > Attachments: jdg-remote-cache-pojos.jar, jdg-remote-cache-vdb.xml, standalone.xml > > > 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 (v7.2.2#72004)

7 years, 8 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 closed TEIID-4492. --------------------------------- Resolution: Done > 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, 8.12.7.6_3 > > Attachments: jdg-remote-cache-pojos.jar, jdg-remote-cache-vdb.xml, standalone.xml > > > 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 (v7.2.2#72004)

7 years, 8 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: ------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1381557 > 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, 8.12.6.6_3 > > Attachments: jdg-remote-cache-pojos.jar, jdg-remote-cache-vdb.xml, standalone.xml > > > 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 (v7.2.2#72004)

7 years, 8 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 reopened TEIID-4492: ----------------------------------- > 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, 8.12.6.6_3 > > Attachments: jdg-remote-cache-pojos.jar, jdg-remote-cache-vdb.xml, standalone.xml > > > 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 (v7.2.2#72004)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4327) Provide arche-type for creating UDF

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4327?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-4327: ----------------------------------- > Provide arche-type for creating UDF > ----------------------------------- > > Key: TEIID-4327 > URL: https://issues.jboss.org/browse/TEIID-4327 > Project: Teiid > Issue Type: Feature Request > Components: Quick Starts > Affects Versions: 8.12.x, 9.x > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.0, 8.12.5 > > > Provide an arche-type for creating UDF's. > This will include: > - java project ready to build using maven > - a java class that contains one static method > - options for deploying the UDF > a. a compilable project that will package for deployment as a module > b. a CLI script for deploying -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4327) Provide arche-type for creating UDF

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4327?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4327: ---------------------------------- Fix Version/s: 8.12.5 9.0 (was: 8.12.x) > Provide arche-type for creating UDF > ----------------------------------- > > Key: TEIID-4327 > URL: https://issues.jboss.org/browse/TEIID-4327 > Project: Teiid > Issue Type: Feature Request > Components: Quick Starts > Affects Versions: 8.12.x, 9.x > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.0, 8.12.5 > > > Provide an arche-type for creating UDF's. > This will include: > - java project ready to build using maven > - a java class that contains one static method > - options for deploying the UDF > a. a compilable project that will package for deployment as a module > b. a CLI script for deploying -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4327) Provide arche-type for creating UDF

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4327?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4327. --------------------------------- Resolution: Done > Provide arche-type for creating UDF > ----------------------------------- > > Key: TEIID-4327 > URL: https://issues.jboss.org/browse/TEIID-4327 > Project: Teiid > Issue Type: Feature Request > Components: Quick Starts > Affects Versions: 8.12.x, 9.x > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.12.5, 9.0 > > > Provide an arche-type for creating UDF's. > This will include: > - java project ready to build using maven > - a java class that contains one static method > - options for deploying the UDF > a. a compilable project that will package for deployment as a module > b. a CLI script for deploying -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4025) Web admin console typo when setting time-slice-in-milliseconds attribute

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4025?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4025: ---------------------------------- Fix Version/s: 8.12.5 (was: 8.12.x) > Web admin console typo when setting time-slice-in-milliseconds attribute > ------------------------------------------------------------------------ > > Key: TEIID-4025 > URL: https://issues.jboss.org/browse/TEIID-4025 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 8.12.5 > Reporter: Filip Elias > Assignee: Van Halbert > Fix For: 9.0, 8.12.5 > > > Admin console prints error when editing Threading attributes. > Typo in attribute name: time-slice-in-millseconds > {code} > Unknown error > Unexpected HTTP response: 500 > Request > { > "operation" => "composite", > "address" => [], > "steps" => [{ > "address" => [("subsystem" => "teiid")], > "operation" => "write-attribute", > "name" => "time-slice-in-millseconds", > "value" => 10000 > }] > } > Response > Internal Server Error > { > "outcome" => "failed", > "result" => {"step-1" => { > "outcome" => "failed", > "failure-description" => "JBAS014792: Unknown attribute time-slice-in-millseconds", > "rolled-back" => true > }}, > "failure-description" => {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-1" => "JBAS014792: Unknown attribute time-slice-in-millseconds"}}, > "rolled-back" => true, > "response-headers" => {"process-state" => "reload-required"} > } > {code} -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4050) database logging doesn't add command and audit loggers for domain mode

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4050?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-4050: ----------------------------------- > database logging doesn't add command and audit loggers for domain mode > ---------------------------------------------------------------------- > > Key: TEIID-4050 > URL: https://issues.jboss.org/browse/TEIID-4050 > Project: Teiid > Issue Type: Bug > Components: Tooling > Affects Versions: 8.12.x > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Critical > Fix For: 9.0, 8.12.5 > > > When installing database logging, than no org.teiid.COMMAND_LOG or org.teiid.AUDIT_LOG category loggers are present in domain.xml for ha and full-ha profile. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2016