[JBoss JIRA] (TEIID-3145) GroovyCastException when starting adminshell
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3145?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3145.
---------------------------------
> GroovyCastException when starting adminshell
> --------------------------------------------
>
> Key: TEIID-3145
> URL: https://issues.jboss.org/browse/TEIID-3145
> Project: Teiid
> Issue Type: Bug
> Components: Tools
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Van Halbert
>
> When I run adminshell.sh, admishell will throw following exception:
> Exception in thread "main" org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object 'org.codehaus.groovy.tools.shell.util.HelpFormatter@3004baef' with class 'org.codehaus.groovy.tools.shell.util.HelpFormatter' to class 'org.apache.commons.cli.HelpFormatter'
> at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.castToType(DefaultTypeTransformation.java:360)
> at groovy.lang.MetaClassImpl.setProperty(MetaClassImpl.java:2394)
> at groovy.lang.MetaClassImpl.setProperty(MetaClassImpl.java:3335)
> at groovy.lang.MetaClassImpl.setProperties(MetaClassImpl.java:1497)
> at org.codehaus.groovy.runtime.callsite.ConstructorSite$NoParamSite.callConstructor(ConstructorSite.java:122)
> at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:57)
> at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:182)
> at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:190)
> at org.codehaus.groovy.tools.shell.Main.main(Main.groovy:50)
> at org.teiid.adminshell.GroovyAdminShell.main(GroovyAdminShell.java:30)
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
8 years, 11 months
[JBoss JIRA] (TEIID-3401) OData layer generates incorrect alias names in orderby
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3401?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3401.
---------------------------------
> OData layer generates incorrect alias names in orderby
> ------------------------------------------------------
>
> Key: TEIID-3401
> URL: https://issues.jboss.org/browse/TEIID-3401
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Reporter: Sanjeev Gour
> Assignee: Steven Hawkins
> Fix For: 8.7
>
>
> When a table has large number of columns, a request like the following http://localhost:8080/odata/VDB.1/objectName generates a query like SELECT col1 as c_1, col2 as c2.....col23 as c_23...col35 as c_35 ..FROM objectName ORDER BY "c_0", "c_1", "c_2", "c_3", "c_2"3, "c_3"5. Here c_0, c_1, c_2, c_3, c_23, c_35 happen to be the primary key columns. As seen in the query, the quotes around the column alias are incorrect for c_23 and c_35 which results into an invalid query.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
8 years, 11 months
[JBoss JIRA] (TEIID-3478) A malformed query is generated by Salesforce translator when a view model made over Salesforce tables, which have primarykey-foreignkey relationship, is queried with a where clause.
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3478?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3478.
---------------------------------
> A malformed query is generated by Salesforce translator when a view model made over Salesforce tables, which have primarykey-foreignkey relationship, is queried with a where clause.
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3478
> URL: https://issues.jboss.org/browse/TEIID-3478
> Project: Teiid
> Issue Type: Bug
> Components: Salesforce Connector
> Reporter: Pranav K
> Assignee: Steven Hawkins
>
> A malformed query is generated by Salesforce translator when a view model made over Salesforce tables, which have primarykey-foreignkey relationship, is queried with a where clause. (See steps to reproduce)
> Log:
> Caused by: javax.resource.ResourceException: [MalformedQueryFault [ApiQueryFault [ApiFault exceptionCode='MALFORMED_QUERY'
> exceptionMessage='
> FROM Case WHERE Case.AccountId != NULLAccount.Name = 'LYCEE AGRICOLE
> ^
> ERROR at Row:1:Column:93
> Bind variables only allowed in Apex code'
> ]
> row='1'
> column='93'
> ]
> ]
>
> at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:177) ~[connector-salesforce-8.10.0.Final-lib.jar:8.10.0.Final]
> at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:138) ~[translator-salesforce-8.10.0.Final.jar:8.10.0.Final]
> ... 18 common frames omitted
> Caused by: com.sforce.soap.partner.fault.MalformedQueryFault: null
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_60-ea]
> at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_60-ea]
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_60-ea]
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_60-ea]
> at java.lang.Class.newInstance(Class.java:374) ~[na:1.7.0_60-ea]
> at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:627) ~[force-wsc-22.0.0.jar:na]
> at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:504) ~[force-wsc-22.0.0.jar:na]
> at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.java:229) ~[force-wsc-22.0.0.jar:na]
> at com.sforce.ws.transport.SoapConnection.createException(SoapConnection.java:203) ~[force-wsc-22.0.0.jar:na]
> at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:149) ~[force-wsc-22.0.0.jar:na]
> at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:98) ~[force-wsc-22.0.0.jar:na]
> at com.sforce.soap.partner.PartnerConnection.query(PartnerConnection.java:1335) ~[force-partner-api-22.0.0.jar:na]
> at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:172) ~[connector-salesforce-8.10.0.Final-lib.jar:8.10.0.Final]
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
8 years, 11 months
[JBoss JIRA] (TEIID-3079) Security domain associated with data source is not getting deleted while deleting the data source, post server restart.
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3079?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3079.
---------------------------------
> Security domain associated with data source is not getting deleted while deleting the data source,post server restart.
> -----------------------------------------------------------------------------------------------------------------------
>
> Key: TEIID-3079
> URL: https://issues.jboss.org/browse/TEIID-3079
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7
> Reporter: Haifen Bi
> Assignee: Ramesh Reddy
> Labels: Beta1
> Fix For: 8.7.1, 8.9
>
>
> We are migrating from Teiid 8.4 final to teiid 8.7 final.
> We have custom security domain for our data sources.
> We use JBoss DMR api to delete the datasource and the security domain while deleting a data source.
> With Teiid 8.4 this was working fine and both the datasource and the custom security domain used to get deleted , but with teiid 8.7 it gives following exception:
>
> {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-2" => "JBAS014762: Removing services has lead to unsatisfied dependencies: Service jboss.security.security-domain.edmsqlSecurityDomain was depended upon by service jboss.teiid.transport.embedded, service jboss.teiid.transport.jdbc, service jboss.teiid.transport.odbc"}}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
8 years, 11 months
[JBoss JIRA] (TEIID-2461) Better determine when to block on the output buffer
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2461?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-2461.
---------------------------------
> Better determine when to block on the output buffer
> ---------------------------------------------------
>
> Key: TEIID-2461
> URL: https://issues.jboss.org/browse/TEIID-2461
> Project: Teiid
> Issue Type: Quality Risk
> Components: Query Engine
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.4
>
>
> The output buffer size limitation helps prevent forward only results from unnecessarily consuming resources, but it also may slow down the processing of otherwise already buffered results - which will hold those and other downstream resources unnecessarily. We should examine the plan to see if this is possible before allowing the output buffer to be size limited.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
8 years, 11 months
[JBoss JIRA] (TEIID-3052) Error on using MAKEDEP hint within union
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3052?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-3052.
---------------------------------
> Error on using MAKEDEP hint within union
> ----------------------------------------
>
> Key: TEIID-3052
> URL: https://issues.jboss.org/browse/TEIID-3052
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 8.7
> Reporter: Mark Addleman
> Assignee: Steven Hawkins
> Fix For: 8.9
>
>
> The following anon proc block fails with error TEIID30226 Remote org.teiid.api.exception.query.QueryProcessingException: TEIID30226 Temporary table "table_spaces_v6" does not exist
> BEGIN
> create local temporary table ssid_version (sysplex varchar, lpar varchar, ssid varchar, version varchar);
> insert into ssid_version(sysplex, lpar, ssid, version) values ('plex1', 'ca11', 'd91a', 'v5');
> insert into ssid_version(sysplex, lpar, ssid, version) values ('plex1', 'ca11', 'd91b', 'v6');
>
>
> create local temporary table table_spaces_v5 (sysplex varchar, lpar varchar, ssid varchar, table_space_id varchar);
> insert into table_spaces_v5 (sysplex, lpar, ssid, table_space_id) values ('plex1', 'ca11', 'd91a', 'ts1');
>
>
> create local temporary table table_spaces_v6 (sysplex varchar, lpar varchar, ssid varchar, table_space_id varchar);
> insert into table_spaces_v6 (sysplex, lpar, ssid, table_space_id) values ('plex1', 'ca11', 'd91b', 'ts2');
>
>
> select table_space_id from
> (
> select * from (select v.sysplex, v.lpar, v.ssid, t.table_space_id from ssid_version v join table_spaces_v5 t on t.sysplex=v.sysplex and t.lpar=v.lpar and t.ssid=v.ssid option makedep table_spaces_v5) t
> union all
> select * from (select v.sysplex, v.lpar, v.ssid, t.table_space_id from ssid_version v join table_spaces_v6 t on t.sysplex=v.sysplex and t.lpar=v.lpar and t.ssid=v.ssid option makedep table_spaces_v6) t
> ) t
> where ssid='d91a';
> END
> It also fails when the /*+ MAKEDEP */ form is used instead of "option makedep"
> I don't believe there should be any failure
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
8 years, 11 months