[JBoss JIRA] (TEIID-1987) Exception Processing Web Service Response
by Ted Jones (JIRA)
Ted Jones created TEIID-1987:
--------------------------------
Summary: Exception Processing Web Service Response
Key: TEIID-1987
URL: https://issues.jboss.org/browse/TEIID-1987
Project: Teiid
Issue Type: Bug
Components: XML Planner/Processor
Affects Versions: 7.7
Reporter: Ted Jones
Assignee: Steven Hawkins
After modeling a web service operation using the Web Service to Source Importer, I previewed the wrapper procedure from Designer and encountered the following error in Teiid:
14:26:03,175 INFO [ReflectionServiceFactoryBean] Creating Service {http://teiid.org}teiid from class org.apache.cxf.jaxws.support.DummyImpl
14:26:03,177 INFO [ConfigurerImpl] Could not determine bean name for instance of class org.apache.cxf.jaxws.DispatchImpl.
14:26:05,681 WARN [PROCESSOR] Processing exception 'Error building Source for context item.' for request 8GKEIB7qIorN.0. Exception type org.teiid.core.TeiidProcessingException thrown from org.teiid.query.processor.relational.XMLTableNode.processRow(XMLTableNode.java:287). Enable more detailed logging to see the entire stacktrace.
The web service WSDL is: http://www.oorsprong.org/websamples.countryinfo/CountryInfoService.wso?WSDL
The operation modelled and executed was "FullCountryInfoAllCountries"
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 4 months
[JBoss JIRA] (TEIID-2053) Various metadata issues
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2053:
-------------------------------------
Summary: Various metadata issues
Key: TEIID-2053
URL: https://issues.jboss.org/browse/TEIID-2053
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.1
1. The default for a proc/function should be virtual and the keyword foreign should be used to indicate a source function.
2. The parser should validate a source procedure has no procedure body defined
3. The parser should validate a function has no function body defined.
4. FunctionMethod.getFullName should not use category qualification.
5. A DDL defined function should be schema scoped when referenced in the getSupportedFunctions list
6. MetadataFactory should not extend Schema to avoid the merge operation and to not serialize MetadataFactory information with the objects created.
7. Schema should not have visibility metadata - that is held on the ModelMetaData.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 4 months
[JBoss JIRA] (TEIID-1776) Ingres as source - Source Error Codes 2118, 2501, and 263071 being returned
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-1776?page=com.atlassian.jira.plugin... ]
Steven Hawkins closed TEIID-1776.
---------------------------------
> Ingres as source - Source Error Codes 2118, 2501, and 263071 being returned
> ---------------------------------------------------------------------------
>
> Key: TEIID-1776
> URL: https://issues.jboss.org/browse/TEIID-1776
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 7.4.1
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
> Fix For: 7.4.1, 7.6
>
>
> EDS Query Testing is getting unexpected results on 4 queries. The queries are
> listed below:
> SELECT TIMEVALUE, BYTENUM, (SELECT B.FLOATNUM FROM BQT1.SMALLA AS B WHERE (B.INTKEY = (SELECT A.INTKEY FROM BQT1.SMALLA AS A WHERE (A.STRINGNUM > 10) AND (A.INTKEY = B.INTKEY))) AND (B.INTKEY = A.INTKEY)) FROM bqt1.smalla AS a
> Error Code:2118 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2118 Message:Source: Error Code:2118 Message:'Invalid qualifier 'g_1'. 'g_1' must be declared in the FROM clause or equivalent. If used in a target list, 'g_1' must be declared at the current scope.' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue, cast(g_0.bytenum AS tinyint), (SELECT g_1.floatnum FROM smalla AS g_1 WHERE g_1.intkey = g_0.intkey AND g_1.intkey = (SELECT g_2.intkey FROM smalla AS g_2 WHERE g_2.stringnum > '10' AND g_2.intkey = g_1.intkey)) FROM smalla AS g_0]
> ********************************************************
> SELECT BQT1.SmallA.TimeValue, BQT2.SmallB.TimestampValue FROM BQT1.SmallA, BQT2.SmallB WHERE BQT1.SmallA.TimeValue = convert(BQT2.SmallB.TimestampValue, time) AND BQT1.SmallA.IntKey >= 0 AND BQT2.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.TimeValue
> Error Code:2501 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2501 Message:Source: Error Code:2501 Message:'line 1, Syntax error on 'with time'. The correct syntax is: SELECT [ALL|DISTINCT] target_list FROM table(s) [WHERE search_cond] [GROUP BY col(s)] [HAVING search_cond] [UNION subselect] [ORDER BY col(s)]' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue AS c_0, g_1.timestampvalue AS c_1 FROM smalla AS g_0, smallb AS g_1 WHERE g_0.timevalue = cast(g_1.timestampvalue AS time with time zone) AND g_0.intkey >= 0 AND g_1.intkey >= 0 ORDER BY c_0]
> ********************************************************
> SELECT BQT1.SmallA.TimeValue, BQT1.SmallB.TimestampValue FROM BQT1.SmallA, BQT1.SmallB WHERE BQT1.SmallA.TimeValue = convert(BQT1.SmallB.TimestampValue, time) AND BQT1.SmallA.IntKey >= 0 AND BQT1.SmallB.IntKey >= 0 ORDER BY BQT1.SmallA.TimeValue
> Error Code:2501 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2501 Message:Source: Error Code:2501 Message:'line 1, Syntax error on 'with time'. The correct syntax is: SELECT [ALL|DISTINCT] target_list FROM table(s) [WHERE search_cond] [GROUP BY col(s)] [HAVING search_cond] [UNION subselect] [ORDER BY col(s)]' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.timevalue AS c_0, g_1.timestampvalue AS c_1 FROM smalla AS g_0, smallb AS g_1 WHERE g_0.timevalue = cast(g_1.timestampvalue AS time with time zone) AND g_0.intkey >= 0 AND g_1.intkey >= 0 ORDER BY c_0]
> *******************************************************
> SELECT intkey, stringkey, floatnum, bytenum, (SELECT bytenum FROM bqt1.smalla AS b WHERE (bytenum = a.longnum) AND (intkey = '10')) AS longnum FROM bqt1.smalla AS a
> Error Code:263071 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:263071 Message:Source: Error Code:263071 Message:'consistency check - all elements of boolean factor do not have same join id' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey, g_0.stringkey, g_0.floatnum, cast(g_0.bytenum AS tinyint), (SELECT cast(g_1.bytenum AS tinyint) FROM smalla AS g_1 WHERE cast(cast(g_1.bytenum AS tinyint) AS bigint) = g_0.longnum AND g_1.intkey = 10) FROM smalla AS g_0]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 4 months
[JBoss JIRA] (TEIID-2043) Dedug query plans can be too large
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-2043:
-------------------------------------
Summary: Dedug query plans can be too large
Key: TEIID-2043
URL: https://issues.jboss.org/browse/TEIID-2043
Project: Teiid
Issue Type: Quality Risk
Components: Query Engine
Affects Versions: 7.0
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.1
As seen in TEIID-2041 debug logs can grow much too large. The two main culprits are full pre-planning of all subqueries and the amount of information shown on each node for each rule. To address the former we should instead only plan project node subqueries after the initial run of RuleAssignOutputElements, since typically not all columns will be used. For the latter we should consider putting a modified marker on a plannode that will get cleared after a toString to truncate the values shown for a node (in some cases we make modifications to objects held on the node, so it's not quite that simple).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 4 months
[JBoss JIRA] (TEIID-2055) Error during using Teiid Local connections.
by Vineela Gampa (JIRA)
Vineela Gampa created TEIID-2055:
------------------------------------
Summary: Error during using Teiid Local connections.
Key: TEIID-2055
URL: https://issues.jboss.org/browse/TEIID-2055
Project: Teiid
Issue Type: Bug
Environment: windows
Reporter: Vineela Gampa
Assignee: Steven Hawkins
Fix For: 7.7.1
Appplication fails with the below exceptions when using Teiid Local connections.Tried "passthroughAuthentication=true" but it fails during getConnection()
our application flow is UI (GWT Layer) -> GWT RPC Services (our service) -> TEIID (translator / database). we are hitting the exception shown above when we launch up our application where GWT is making call to one of the GWT service which internally makes connections to teiid to retrieve the data..
[14:03:37.976][info][talledLocalContainer] 16 May 2012 14:03:37,975 PDT ERROR [CoyoteAdapter] An exception or error occurred in the container during the request processing
[14:03:37.976][info][talledLocalContainer] java.lang.IllegalStateException: Security Context is null
[14:03:37.976][info][talledLocalContainer] at org.jboss.web.tomcat.security.SecurityAssociationActions$PopRunAsRoleAction.run(SecurityAssociationActions.java:156)
[14:03:37.976][info][talledLocalContainer] at java.security.AccessController.doPrivileged(Native Method)
[14:03:37.976][info][talledLocalContainer] at org.jboss.web.tomcat.security.SecurityAssociationActions.popRunAsIdentity(SecurityAssociationActions.java:302)
[14:03:37.976][info][talledLocalContainer] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:193)
[14:03:37.976][info][talledLocalContainer] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
[14:03:37.977][info][talledLocalContainer] at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
[14:03:37.977][info][talledLocalContainer] at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
[14:03:37.977][info][talledLocalContainer] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
[14:03:37.977][info][talledLocalContainer] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
[14:03:37.977][info][talledLocalContainer] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
[14:03:37.977][info][talledLocalContainer] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
[14:03:37.977][info][talledLocalContainer] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
[14:03:37.977][info][talledLocalContainer] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
[14:03:37.977][info][talledLocalContainer] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
[14:03:37.977][info][talledLocalContainer] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
[14:03:37.977][info][talledLocalContainer] at java.lang.Thread.run(Thread.java:722)
[14:03:51.572][info][talledLocalContainer] 16 May 2012 14:03:51,572 PDT WARNING [BrowserLogger] Client side exception: Uncaught exception
[14:03:51.572][info][talledLocalContainer] com.google.gwt.user.client.rpc.InvocationException: from ObjectsService_Proxy.getObjects Unknown.Nm(Unknown Source)
[14:03:51.573][info][talledLocalContainer] Unknown.kFh(Unknown Source)
[14:03:51.573][info][talledLocalContainer] Unknown.KLh(Unknown Source)
[14:03:51.573][info][talledLocalContainer] Unknown.nrg(Unknown Source)
[14:03:51.573][info][talledLocalContainer] Unknown.Prg(Unknown Source)
[14:03:51.573][info][talledLocalContainer] Unknown.anonymous(Unknown Source)
[14:03:51.573][info][talledLocalContainer] Unknown.Beg(Unknown Source)
[14:03:51.573][info][talledLocalContainer] Unknown.Eeg(Unknown Source)
[14:03:51.573][info][talledLocalContainer] Unknown.anonymous(Unknown Source)
[14:03:51.573][info][talledLocalContainer] Unknown.anonymous(Unknown Source)
[14:03:51.573][info][talledLocalContainer]
[14:03:51.573][info][talledLocalContainer]
[14:03:51.612][info][talledLocalContainer] 16 May 2012 14:03:51,612 PDT WARNING [BrowserLogger] Client side exception: Uncaught exception
[14:03:51.612][info][talledLocalContainer] com.google.gwt.user.client.rpc.InvocationException: from ObjectsService_Proxy.getObjects Unknown.Nm(Unknown Source)
[14:03:51.612][info][talledLocalContainer] Unknown.kFh(Unknown Source)
[14:03:51.612][info][talledLocalContainer] Unknown.KLh(Unknown Source)
[14:03:51.612][info][talledLocalContainer] Unknown.nrg(Unknown Source)
[14:03:51.612][info][talledLocalContainer] Unknown.Prg(Unknown Source)
[14:03:51.612][info][talledLocalContainer] Unknown.anonymous(Unknown Source)
[14:03:51.612][info][talledLocalContainer] Unknown.Beg(Unknown Source)
[14:03:51.612][info][talledLocalContainer] Unknown.Eeg(Unknown Source)
[14:03:51.612][info][talledLocalContainer] Unknown.anonymous(Unknown Source)
[14:03:51.613][info][talledLocalContainer] Unknown.anonymous(Unknown Source)
[14:03:51.613][info][talledLocalContainer]
[14:03:51.613][info][talledLocalContainer]
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12 years, 4 months