November 2019 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5856) Teiid generate wrong request to salesforce

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIID-5856?page=com.atlassian.jira.plugin... ] Renat Eskenin reopened TEIID-5856: ---------------------------------- I try to use import stats <?xml version="1.0" encoding="UTF-8"?> <vdb name="db" version="1"> <connection-type>BY_VERSION</connection-type> <property name="full-ddl" value="CREATE DATABASE db; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true); CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'salesforce'); CREATE SCHEMA sf SERVER salesforce; IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "import.modelAuditFields" 'true', "import.importStatstics" 'true');"/> <model name="sf" type="PHYSICAL" visible="true"> <source connection-jndi-name="salesforce" name="salesforce" translator-name="salesforce"/> <metadata type="DDL"/> </model> <translator name="mysalesforce" type="salesforce"> <property name="supportsOrderBy" value="true"/> </translator> </vdb> But it has no effect, may be i used wrong params? And for another solution please give me example of using OPTIONS for this request. > Teiid generate wrong request to salesforce > ------------------------------------------ > > Key: TEIID-5856 > URL: https://issues.jboss.org/browse/TEIID-5856 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: spring-boot teiid salesforce-connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > When i call request to salesforce teiid get very long wrong request and then OOM, because teiid request all data in salesforce object. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-143) SAP Gateway returns 406

by Steven Hawkins (Jira)

Steven Hawkins created TEIIDSB-143: -------------------------------------- Summary: SAP Gateway returns 406 Key: TEIIDSB-143 URL: https://issues.jboss.org/browse/TEIIDSB-143 Project: Teiid Spring Boot Issue Type: Bug Components: datasource Reporter: Steven Hawkins Fix For: 1.3.0 After the header fix TEIIDSB-134 for some reason SAP responds with a 406 - it doesn't like having multiple accept header values at least when used through our spring boot rest support. Just sending application/xml works as expected. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5856) Teiid generate wrong request to salesforce

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIID-5856?page=com.atlassian.jira.plugin... ] Renat Eskenin edited comment on TEIID-5856 at 11/26/19 9:18 AM: ---------------------------------------------------------------- del was (Author: i3draven): I try to use import stats {code} <?xml version="1.0" encoding="UTF-8"?> <vdb name="db" version="1"> <connection-type>BY_VERSION</connection-type> <property name="full-ddl" value="CREATE DATABASE db; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true); CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'salesforce'); CREATE SCHEMA sf SERVER salesforce; IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "import.modelAuditFields" 'true', "import.importStatstics" 'true');"/> <model name="sf" type="PHYSICAL" visible="true"> <source connection-jndi-name="salesforce" name="salesforce" translator-name="salesforce"/> <metadata type="DDL"/> </model> <translator name="mysalesforce" type="salesforce"> <property name="supportsOrderBy" value="true"/> </translator> </vdb> {code} But it has no effect, may be i used wrong params? And for another solution please give me example of using OPTIONS for this request. > Teiid generate wrong request to salesforce > ------------------------------------------ > > Key: TEIID-5856 > URL: https://issues.jboss.org/browse/TEIID-5856 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: spring-boot teiid salesforce-connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > When i call request to salesforce teiid get very long wrong request and then OOM, because teiid request all data in salesforce object. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5856) Teiid generate wrong request to salesforce

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIID-5856?page=com.atlassian.jira.plugin... ] Renat Eskenin edited comment on TEIID-5856 at 11/26/19 9:18 AM: ---------------------------------------------------------------- I try to use import stats {code} <?xml version="1.0" encoding="UTF-8"?> <vdb name="db" version="1"> <connection-type>BY_VERSION</connection-type> <property name="full-ddl" value="CREATE DATABASE db; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true); CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'salesforce'); CREATE SCHEMA sf SERVER salesforce; IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "import.modelAuditFields" 'true', "import.importStatstics" 'true');"/> <model name="sf" type="PHYSICAL" visible="true"> <source connection-jndi-name="salesforce" name="salesforce" translator-name="salesforce"/> <metadata type="DDL"/> </model> <translator name="mysalesforce" type="salesforce"> <property name="supportsOrderBy" value="true"/> </translator> </vdb> {code} But it has no effect, may be i used wrong params? And for another solution please give me example of using OPTIONS for this request. was (Author: i3draven): I try to use import stats <?xml version="1.0" encoding="UTF-8"?> <vdb name="db" version="1"> <connection-type>BY_VERSION</connection-type> <property name="full-ddl" value="CREATE DATABASE db; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true); CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'salesforce'); CREATE SCHEMA sf SERVER salesforce; IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "import.modelAuditFields" 'true', "import.importStatstics" 'true');"/> <model name="sf" type="PHYSICAL" visible="true"> <source connection-jndi-name="salesforce" name="salesforce" translator-name="salesforce"/> <metadata type="DDL"/> </model> <translator name="mysalesforce" type="salesforce"> <property name="supportsOrderBy" value="true"/> </translator> </vdb> But it has no effect, may be i used wrong params? And for another solution please give me example of using OPTIONS for this request. > Teiid generate wrong request to salesforce > ------------------------------------------ > > Key: TEIID-5856 > URL: https://issues.jboss.org/browse/TEIID-5856 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: spring-boot teiid salesforce-connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > When i call request to salesforce teiid get very long wrong request and then OOM, because teiid request all data in salesforce object. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5856) Teiid generate wrong request to salesforce

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIID-5856?page=com.atlassian.jira.plugin... ] Renat Eskenin commented on TEIID-5856: -------------------------------------- I try to use import stats {code} <?xml version="1.0" encoding="UTF-8"?> <vdb name="db" version="1"> <connection-type>BY_VERSION</connection-type> <property name="full-ddl" value="CREATE DATABASE db; USE DATABASE db; CREATE FOREIGN DATA WRAPPER salesforce; CREATE FOREIGN DATA WRAPPER mysalesforce type salesforce OPTIONS (supportsOrderBy true); CREATE SERVER salesforce FOREIGN DATA WRAPPER salesforce OPTIONS ("resource-name" 'salesforce'); CREATE SCHEMA sf SERVER salesforce; IMPORT FROM SERVER salesforce INTO sf OPTIONS("importer.useFullSchemaName" 'false', "importer.NormalizeNames" 'false', "import.modelAuditFields" 'true', "import.importStatstics" 'true');"/> <model name="sf" type="PHYSICAL" visible="true"> <source connection-jndi-name="salesforce" name="salesforce" translator-name="salesforce"/> <metadata type="DDL"/> </model> <translator name="mysalesforce" type="salesforce"> <property name="supportsOrderBy" value="true"/> </translator> </vdb> {code} But it has no effect, may be i used wrong params? And for another solution please give me example of using OPTIONS for this request. > Teiid generate wrong request to salesforce > ------------------------------------------ > > Key: TEIID-5856 > URL: https://issues.jboss.org/browse/TEIID-5856 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: spring-boot teiid salesforce-connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > When i call request to salesforce teiid get very long wrong request and then OOM, because teiid request all data in salesforce object. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-142) teiid-openshift-examples enhancements

by Bilgin Ibryam (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-142?page=com.atlassian.jira.plugi... ] Bilgin Ibryam commented on TEIIDSB-142: --------------------------------------- But I can see the connection information in the CR directly rather than referring to Secret [here|https://github.com/teiid/teiid-openshift-examples/blob/master/rdbms-...] > teiid-openshift-examples enhancements > ------------------------------------- > > Key: TEIIDSB-142 > URL: https://issues.jboss.org/browse/TEIIDSB-142 > Project: Teiid Spring Boot > Issue Type: Enhancement > Components: examples > Reporter: Bilgin Ibryam > Priority: Optional > > While setting up the example [scenarios|https://github.com/teiid/teiid-openshift-examples/blob/master/r...] the Secret seems unnecessary? Is it really used? > # CREATE SECRET TO CONNECT TO DATABASE (ADJUST TO YOUR VALUES) > oc create -f - <<EOF > apiVersion: v1 > kind: Secret > metadata: > name: postgresql > type: Opaque > stringData: > database-user: user > database-name: sampledb > database-password: mypassword > EOF > Also the following steps can be shortened: > oc get pods > oc rsh postgres-xxxxx > to > oc rsh $(oc get pods -o name -l app=postgresql) -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5856) Teiid generate wrong request to salesforce

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5856?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5856. ----------------------------------- Resolution: Explained Without some additional information the planner doesn't know what style of join to plan. You can either use query hints such as makedep http://teiid.github.io/teiid-documents/master/content/reference/OPTION_Cl..., or tell the importer to import stats from salesforce - see import.importStatstics http://teiid.github.io/teiid-documents/master/content/reference/Salesforc... > Teiid generate wrong request to salesforce > ------------------------------------------ > > Key: TEIID-5856 > URL: https://issues.jboss.org/browse/TEIID-5856 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: spring-boot teiid salesforce-connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > When i call request to salesforce teiid get very long wrong request and then OOM, because teiid request all data in salesforce object. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-142) teiid-openshift-examples enhancements

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIIDSB-142?page=com.atlassian.jira.plugi... ] Steven Hawkins commented on TEIIDSB-142: ---------------------------------------- > Secret seems unnecessary? Is it really used? It should be. It's not a good practice to show the connection information directly in the crd. > teiid-openshift-examples enhancements > ------------------------------------- > > Key: TEIIDSB-142 > URL: https://issues.jboss.org/browse/TEIIDSB-142 > Project: Teiid Spring Boot > Issue Type: Enhancement > Components: examples > Reporter: Bilgin Ibryam > Priority: Optional > > While setting up the example [scenarios|https://github.com/teiid/teiid-openshift-examples/blob/master/r...] the Secret seems unnecessary? Is it really used? > # CREATE SECRET TO CONNECT TO DATABASE (ADJUST TO YOUR VALUES) > oc create -f - <<EOF > apiVersion: v1 > kind: Secret > metadata: > name: postgresql > type: Opaque > stringData: > database-user: user > database-name: sampledb > database-password: mypassword > EOF > Also the following steps can be shortened: > oc get pods > oc rsh postgres-xxxxx > to > oc rsh $(oc get pods -o name -l app=postgresql) -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIIDSB-142) teiid-openshift-examples enhancements

by Bilgin Ibryam (Jira)

Bilgin Ibryam created TEIIDSB-142: ------------------------------------- Summary: teiid-openshift-examples enhancements Key: TEIIDSB-142 URL: https://issues.jboss.org/browse/TEIIDSB-142 Project: Teiid Spring Boot Issue Type: Enhancement Components: examples Reporter: Bilgin Ibryam While setting up the example [scenarios|https://github.com/teiid/teiid-openshift-examples/blob/master/r...] the Secret seems unnecessary? Is it really used? # CREATE SECRET TO CONNECT TO DATABASE (ADJUST TO YOUR VALUES) oc create -f - <<EOF apiVersion: v1 kind: Secret metadata: name: postgresql type: Opaque stringData: database-user: user database-name: sampledb database-password: mypassword EOF Also the following steps can be shortened: oc get pods oc rsh postgres-xxxxx to oc rsh $(oc get pods -o name -l app=postgresql) -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

[JBoss JIRA] (TEIID-5856) Teiid generate wrong request to salesforce

by Renat Eskenin (Jira)

[ https://issues.jboss.org/browse/TEIID-5856?page=com.atlassian.jira.plugin... ] Renat Eskenin updated TEIID-5856: --------------------------------- Steps to Reproduce: Request example: {code:sql} SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.Id as replacementLicenseObjectId FROM Product_License__c originalLicense LEFT OUTER JOIN Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber {code} Teiid retrieveв all data from Product_License__c was: Request example: {code:sql} SELECT originalLicense.Id,originalLicense.Status__c,originalLicense.ReplacementLicenseID__c,originalLicense.LicenseId__c,originalLicense.vlic_Contract_Number__c,replacementLicense.LicenseId__c as replacementLicenseId ,replacementLicense.Id as replacementLicenseObjectId FROM Product_License__c originalLicense LEFT OUTER JOIN Product_License__c replacementLicense ON originalLicense.ReplacementLicenseID__c = replacementLicense.Id where originalLicense.vlic_Contract_Number__c = :contractNumber {code} Teiid retrieve all data from Product_License__c > Teiid generate wrong request to salesforce > ------------------------------------------ > > Key: TEIID-5856 > URL: https://issues.jboss.org/browse/TEIID-5856 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Environment: spring-boot teiid salesforce-connector > Reporter: Renat Eskenin > Assignee: Steven Hawkins > Priority: Major > > When i call request to salesforce teiid get very long wrong request and then OOM, because teiid request all data in salesforce object. -- This message was sent by Atlassian Jira (v7.13.8#713008)

5 years

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2019