September 2015 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-1765) StateInfo example does not succeed

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1765?page=com.atlassian.jira.plu... ] Ted Jones resolved TEIIDDES-1765. --------------------------------- Resolution: Done Fixed with https://issues.jboss.org/browse/TEIIDDES-2185. > StateInfo example does not succeed > ---------------------------------- > > Key: TEIIDDES-1765 > URL: https://issues.jboss.org/browse/TEIIDDES-1765 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling > Affects Versions: 8.2 > Reporter: Van Halbert > Assignee: Ted Jones > Fix For: 9.0.4 > > > Walked thru the StateInfo example, and when I went to execute > 12:55:47,190 WARNING [org.apache.cxf.phase.PhaseInterceptorChain] (http-/127.0.0.1:8080-1) Interceptor for {http://www.teiid.org/stateService/}stateService#{http://www.teiid.org/stateService/}GetAllStateInfo has thrown exception, unwinding now: org.apache.cxf.interceptor.Fault: Unexpected wrapper element GetAllStateInfo found. Expected {http://www.teiid.org/stateService/}GetAllStateInfo. > at org.apache.cxf.interceptor.DocLiteralInInterceptor.handleMessage(DocLiteralInInterceptor.java:106) > at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262) > at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) > at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:237) > at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:95) > at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:156) > at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87) > at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:225) > at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:145) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1] > at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135) > at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.1.2.Final-redhat-1.jar:2.1.2.Final-redhat-1] > at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1] > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1] > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1] > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1] > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1] > at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8] > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1] > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1] > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1] > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1] > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1] > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1] > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1] > at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_13] > 12:55:47,195 WARN [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue27) Connector worker process failed for atomic-request=VUNHCCMa+sUf.0.9.3: org.teiid.translator.TranslatorException: Unexpected wrapper element GetAllStateInfo found. Expected {http://www.teiid.org/stateService/}GetAllStateInfo. > at org.teiid.translator.ws.WSProcedureExecution.execute(WSProcedureExecution.java:139) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:254) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:446) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:159) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:156) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_13] > at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_13] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.0.Final.jar:8.4.0.Final] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_13] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_13] > at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_13] > Caused by: javax.xml.ws.soap.SOAPFaultException: Unexpected wrapper element GetAllStateInfo found. Expected {http://www.teiid.org/stateService/}GetAllStateInfo. > at org.apache.cxf.jaxws.DispatchImpl.mapException(DispatchImpl.java:287) > at org.apache.cxf.jaxws.DispatchImpl.invoke(DispatchImpl.java:392) > at org.apache.cxf.jaxws.DispatchImpl.invoke(DispatchImpl.java:243) > at org.teiid.translator.ws.WSProcedureExecution.execute(WSProcedureExecution.java:135) > ... 13 more > Caused by: org.apache.cxf.binding.soap.SoapFault: Unexpected wrapper element GetAllStateInfo found. Expected {http://www.teiid.org/stateService/}GetAllStateInfo. > at org.apache.cxf.binding.soap.interceptor.Soap11FaultInInterceptor.unmarshalFault(Soap11FaultInInterceptor.java:75) > at org.apache.cxf.binding.soap.interceptor.Soap11FaultInInterceptor.handleMessage(Soap11FaultInInterceptor.java:46) > at org.apache.cxf.binding.soap.interceptor.Soap11FaultInInterceptor.handleMessage(Soap11FaultInInterceptor.java:35) > at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262) > at org.apache.cxf.interceptor.AbstractFaultChainInitiatorObserver.onMessage(AbstractFaultChainInitiatorObserver.java:114) > at org.apache.cxf.binding.soap.interceptor.CheckFaultInterceptor.handleMessage(CheckFaultInterceptor.java:69) > at org.apache.cxf.binding.soap.interceptor.CheckFaultInterceptor.handleMessage(CheckFaultInterceptor.java:34) > at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262) > at org.apache.cxf.endpoint.ClientImpl.onMessage(ClientImpl.java:800) > at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponseInternal(HTTPConduit.java:1696) > at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponse(HTTPConduit.java:1532) > at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.close(HTTPConduit.java:1440) > at org.apache.cxf.transport.AbstractConduit.close(AbstractConduit.java:56) > at org.apache.cxf.transport.http.HTTPConduit.close(HTTPConduit.java:659) > at org.apache.cxf.interceptor.MessageSenderInterceptor$MessageSenderEndingInterceptor.handleMessage(MessageSenderInterceptor.java:62) > at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262) > at org.apache.cxf.endpoint.ClientImpl.doInvoke(ClientImpl.java:530) > at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:463) > at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:366) > at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:319) > at org.apache.cxf.endpoint.ClientImpl.invokeWrapped(ClientImpl.java:354) > at org.apache.cxf.jaxws.DispatchImpl.invoke(DispatchImpl.java:385) > ... 15 more > 12:55:47,199 WARN [org.teiid.PROCESSOR] (Worker6_QueryProcessorQueue28) TEIID30020 Processing exception for request VUNHCCMa+sUf.0 'TEIID30504 stateService: Unexpected wrapper element GetAllStateInfo found. Expected {http://www.teiid.org/stateService/}GetAllStateInfo.'. Originally TeiidProcessingException Soap11FaultInInterceptor.java:75. Enable more detailed logging to see the entire stacktrace. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2185) Update the States Web Service Example

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2185?page=com.atlassian.jira.plu... ] Ted Jones resolved TEIIDDES-2185. --------------------------------- Resolution: Done Updated the States service example here: https://developer.jboss.org/wiki/SOAPServiceAsASource-ExampleIncludingMod... and checked in the source here: https://github.com/tejones/teiid-soap-example. This was forked from [~phantomjinx]'s repo. We should probably have an official repo in teiid-designer github for these sort of examples. > Update the States Web Service Example > ------------------------------------- > > Key: TEIIDDES-2185 > URL: https://issues.jboss.org/browse/TEIIDDES-2185 > Project: Teiid Designer > Issue Type: Task > Components: Web Services Support > Affects Versions: 8.3.2 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 9.0.4 > > > The States Web Service example is missing the "stream" parameter in the invoke() procedure. Need to recreate to include this parameter. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the Model update flag

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2624: ---------------------------------------- [~van.halbert] We currently don't have an *updateable* property for a model in Designer, (_only at the table/column level_) and it's not an existing OPTION() for a <model> entry for Teiid. > When importing via Teiid Connection, no way to set(change) the Model update flag > -------------------------------------------------------------------------------- > > Key: TEIIDDES-2624 > URL: https://issues.jboss.org/browse/TEIIDDES-2624 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Reporter: Van Halbert > Assignee: Mark Drilling > Fix For: 9.0.4, 9.2 > > > When using Teiid Connection importer, need the ability to change the default model updatable flag. The default is "true". Would like to be able to change to "false". -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the Model update flag

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ] Van Halbert edited comment on TEIIDDES-2624 at 9/4/15 9:50 AM: --------------------------------------------------------------- I would think as long as the model is not updatable, it shouldn't matter what the columns have. But yes, if the updatable option is set to false, then all imported tables are set to false. was (Author: van.halbert): I would think as long as the model is not updatable, it shouldn't matter what the columns have. But yet, the updatable is set to false, then all imported tables are set to false. > When importing via Teiid Connection, no way to set(change) the Model update flag > -------------------------------------------------------------------------------- > > Key: TEIIDDES-2624 > URL: https://issues.jboss.org/browse/TEIIDDES-2624 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Reporter: Van Halbert > Assignee: Mark Drilling > Fix For: 9.0.4, 9.2 > > > When using Teiid Connection importer, need the ability to change the default model updatable flag. The default is "true". Would like to be able to change to "false". -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2624) When importing via Teiid Connection, no way to set(change) the Model update flag

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2624?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-2624: --------------------------------------- I would think as long as the model is not updatable, it shouldn't matter what the columns have. But yet, the updatable is set to false, then all imported tables are set to false. > When importing via Teiid Connection, no way to set(change) the Model update flag > -------------------------------------------------------------------------------- > > Key: TEIIDDES-2624 > URL: https://issues.jboss.org/browse/TEIIDDES-2624 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Reporter: Van Halbert > Assignee: Mark Drilling > Fix For: 9.0.4, 9.2 > > > When using Teiid Connection importer, need the ability to change the default model updatable flag. The default is "true". Would like to be able to change to "false". -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2494) Cancel on Teiid Connection Import Not Working

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2494?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2494: ---------------------------------------- master: https://github.com/Teiid-Designer/teiid-designer/commit/b0c528a6b3d48bf3a... 9.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/3f8c985ad0436d4ce... > Cancel on Teiid Connection Import Not Working > --------------------------------------------- > > Key: TEIIDDES-2494 > URL: https://issues.jboss.org/browse/TEIIDDES-2494 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 9.0.1 > Reporter: Ted Jones > Assignee: Mark Drilling > Fix For: 9.0.4, 9.2 > > > Clicking cancel when importing a Teiid connection is has no affect. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2636) Provide all the available OPTIONS that Teiid defines as optional options on tables and columns

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2636?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2636: ---------------------------------------- The properties panel was designed based on a certain modeling paradigm that fits into Eclipse. We also added the MED (model extension definition) to simplify adding extension metadata like Teiid OPTIONS. This eliminated to need to update/hack the EMF ecore metamodels. * The Properties View exposes all of the object properties except UUID which I think are UUIDs corresponding to the EMF uuuid's . * The Description is exposed via a separate view and represents an ANNOTATION. * Teiid extends the DDL properties via OPTIONS() statement/clause. This is a DDL construct which the current Teiid Designer does't currently expose in that form.... but could. We could provide another editor tab or DDL-based editor view that viewed a table/view/column as a DDL-based object where OPTIONS() would be treated/referred to from a Teiid DDL perspective. That's a different/alternate paradigm and would require substantial work. With the work going on in Komodo I'm not sure it makes sense to add this functionality in Designer. > Provide all the available OPTIONS that Teiid defines as optional options on tables and columns > ---------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2636 > URL: https://issues.jboss.org/browse/TEIIDDES-2636 > Project: Teiid Designer > Issue Type: Enhancement > Components: Modeling > Reporter: Van Halbert > > Provide all all the available OPTIONS that TEIID defines as optional OPTIONS for a table and column. Looking in the properties panel, under Misc section, its missing UUID and ANNOTATION. > And for columns, I see some missing too. > Using this page as a reference for options: https://docs.jboss.org/author/display/TEIID/DDL+Metadata -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2636) Provide all the available OPTIONS that Teiid defines as optional options on tables and columns

by Van Halbert (JIRA)

Van Halbert created TEIIDDES-2636: ------------------------------------- Summary: Provide all the available OPTIONS that Teiid defines as optional options on tables and columns Key: TEIIDDES-2636 URL: https://issues.jboss.org/browse/TEIIDDES-2636 Project: Teiid Designer Issue Type: Enhancement Components: Modeling Reporter: Van Halbert Provide all all the available OPTIONS that TEIID defines as optional OPTIONS for a table and column. Looking in the properties panel, under Misc section, its missing UUID and ANNOTATION. And for columns, I see some missing too. Using this page as a reference for options: https://docs.jboss.org/author/display/TEIID/DDL+Metadata -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2601) Provide ability to do Model Update in Teiid Connection Importer

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2601?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-2601: --------------------------------------- Maybe as a first step, ask for the following options: - add new tables to an existing model - replace existing tables in an existing model But don't worry about updating a table, just replace it. But that may cause issues in designer if the table is already referenced by a view. > Provide ability to do Model Update in Teiid Connection Importer > --------------------------------------------------------------- > > Key: TEIIDDES-2601 > URL: https://issues.jboss.org/browse/TEIIDDES-2601 > Project: Teiid Designer > Issue Type: Feature Request > Reporter: Tom Johnston > > I imported a Teiid Model connection but saw no way to update the model. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2554) Import of REST service with columns set to 'integer' type results in "Expected biginteger, but was integer."

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2554?page=com.atlassian.jira.plu... ] Ted Jones updated TEIIDDES-2554: -------------------------------- Component/s: Import/Export Web Services Support Git Pull Request: https://github.com/Teiid-Designer/teiid-designer/pull/493 > Import of REST service with columns set to 'integer' type results in "Expected biginteger, but was integer." > ------------------------------------------------------------------------------------------------------------ > > Key: TEIIDDES-2554 > URL: https://issues.jboss.org/browse/TEIIDDES-2554 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export, Web Services Support > Affects Versions: 9.0.1 > Reporter: Marc Shirley > Assignee: Ted Jones > Fix For: 9.0.4, 9.2 > > > Importing posts service from http://jsonplaceholder.typicode.com results in "Expected biginteger, but was integer." runtime error when previewing procedure. This appears to be an issue with the type assignments on the model as a dynamic VDB using the same invocation executes properly. Also seems similar to the issue described in TEIIDDES-2438. > Full error is: > org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30492 TEIID31121 The expected result set of the procedure ViewModel.postById does not match the result set from returnable statement SELECT A.id AS id, A.userId AS userId, A.title AS title, A.body AS body FROM (EXEC SourceModel.invokeHttp(action => 'GET', endpoint => VARIABLES.qp, stream => 'TRUE')) AS f, XMLTABLE('/response' PASSING JSONTOXML('response', f.result) COLUMNS id integer PATH 'id/text()', userId integer PATH 'userId/text()', title string PATH 'title/text()', body string PATH 'body/text()') AS A; use WITHOUT RETURN to indicate the statement should not be returned - The definition for ViewModel.postById has the wrong type for column 1. Expected biginteger, but was integer. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 9 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues September 2015