February 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3951) Stored procedure in view model from SQL server 2000

by Mirco Marchitiello (JIRA)

Mirco Marchitiello created TEIID-3951: ----------------------------------------- Summary: Stored procedure in view model from SQL server 2000 Key: TEIID-3951 URL: https://issues.jboss.org/browse/TEIID-3951 Project: Teiid Issue Type: Bug Affects Versions: 8.13 Reporter: Mirco Marchitiello Assignee: Steven Hawkins Attachments: testMirco.vdb There are some issues on some procedures developed on a SQL server 2000 when a view model reading the procedures from a source model is created. The source model is connected with the SQL server 2000 via jdts1.3.1 driver. When the source procedure is exteciting it works fine, while running the virtual procedure the stack trace is the following: 2016-02-04 11:59:16,769 WARN [org.teiid.CONNECTOR] (Worker93_QueryProcessorQueue1047) V/FcQRQWrBI2 TEIID30004 Connector returned a 0 row non-last batch: CASALE_GROUP. 2016-02-04 11:59:16,769 WARN [org.teiid.CONNECTOR] (Worker93_QueryProcessorQueue1049) V/FcQRQWrBI2 Connector worker process failed for atomic-request=V/FcQRQWrBI2.7.1.141: org.teiid.core.types.TransformationException: TEIID10072 Invalid integer format in String: Villa, Ground Floor - Tel. 9389 at org.teiid.core.types.basic.StringToIntegerTransform.transformDirect(StringToIntegerTransform.java:43) at org.teiid.core.types.Transform.transform(Transform.java:47) at org.teiid.core.types.DataTypeManager.transformValue(DataTypeManager.java:942) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.correctTypes(ConnectorWorkItem.java:572) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:435) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:226) at sun.reflect.GeneratedMethodAccessor102.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) at com.sun.proxy.$Proxy57.more(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) 2016-02-04 11:59:16,785 WARN [org.teiid.PROCESSOR] (Worker92_QueryProcessorQueue1050) V/FcQRQWrBI2 TEIID30020 Processing exception for request V/FcQRQWrBI2.7 'TEIID10072 Invalid integer format in String: Villa, Ground Floor - Tel. 9389'. Originally TransformationException StringToIntegerTransform.java:43. Enable more detailed logging to see the entire stacktrace. The same procedure, with the same table and data on SQL Server 2008 works fine -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3950) UDFs aren't found when using old function definitions model

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3950?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3950. ----------------------------------- Fix Version/s: 9.0 8.12.5 8.13.1 Resolution: Done Corrected the regression in VDBParserDeployer. > UDFs aren't found when using old function definitions model > ----------------------------------------------------------- > > Key: TEIID-3950 > URL: https://issues.jboss.org/browse/TEIID-3950 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.1 > > > When migrating an old VDB that contains the old functiondefinitions model the server sees it as a Function model[1] but the functions are not found [2]when you try to use them. > [1] [org.teiid.RUNTIME] (MSC service thread 1-7) Model udfTokenFunctions in VDB oldUDF skipped being loaded because of its type FUNCTION > [2] [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue10) org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'getToken('125421', '?', 2)' is an unknown form. Check that the function name and number of arguments is correct. Sending error to client 1trCiU5AkzFn.5 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3950) UDFs aren't found when using old function definitions model

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3950?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3950: ---------------------------------- Attachment: (was: MyOldUDFTest.zip) > UDFs aren't found when using old function definitions model > ----------------------------------------------------------- > > Key: TEIID-3950 > URL: https://issues.jboss.org/browse/TEIID-3950 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > > When migrating an old VDB that contains the old functiondefinitions model the server sees it as a Function model[1] but the functions are not found [2]when you try to use them. > [1] [org.teiid.RUNTIME] (MSC service thread 1-7) Model udfTokenFunctions in VDB oldUDF skipped being loaded because of its type FUNCTION > [2] [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue10) org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'getToken('125421', '?', 2)' is an unknown form. Check that the function name and number of arguments is correct. Sending error to client 1trCiU5AkzFn.5 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3950) UDFs aren't found when using old function definitions model

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3950?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3950: --------------------------------------- We'll also note in our docs that support for the old function model was never added to Teiid Embedded. > UDFs aren't found when using old function definitions model > ----------------------------------------------------------- > > Key: TEIID-3950 > URL: https://issues.jboss.org/browse/TEIID-3950 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Attachments: MyOldUDFTest.zip > > > When migrating an old VDB that contains the old functiondefinitions model the server sees it as a Function model[1] but the functions are not found [2]when you try to use them. > [1] [org.teiid.RUNTIME] (MSC service thread 1-7) Model udfTokenFunctions in VDB oldUDF skipped being loaded because of its type FUNCTION > [2] [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue10) org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'getToken('125421', '?', 2)' is an unknown form. Check that the function name and number of arguments is correct. Sending error to client 1trCiU5AkzFn.5 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3950) UDFs aren't found when using old function definitions model

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3950?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3950: --------------------------------------- [1] - is the expected message There is a regression with TEIID-2645 - the check for function metadata in VDBParserDeployer will only match directories and not regular files. > UDFs aren't found when using old function definitions model > ----------------------------------------------------------- > > Key: TEIID-3950 > URL: https://issues.jboss.org/browse/TEIID-3950 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Attachments: MyOldUDFTest.zip > > > When migrating an old VDB that contains the old functiondefinitions model the server sees it as a Function model[1] but the functions are not found [2]when you try to use them. > [1] [org.teiid.RUNTIME] (MSC service thread 1-7) Model udfTokenFunctions in VDB oldUDF skipped being loaded because of its type FUNCTION > [2] [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue10) org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'getToken('125421', '?', 2)' is an unknown form. Check that the function name and number of arguments is correct. Sending error to client 1trCiU5AkzFn.5 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3950) UDFs aren't found when using old function definitions model

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3950?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3950: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1304743 Bugzilla Update: Perform > UDFs aren't found when using old function definitions model > ----------------------------------------------------------- > > Key: TEIID-3950 > URL: https://issues.jboss.org/browse/TEIID-3950 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Attachments: MyOldUDFTest.zip > > > When migrating an old VDB that contains the old functiondefinitions model the server sees it as a Function model[1] but the functions are not found [2]when you try to use them. > [1] [org.teiid.RUNTIME] (MSC service thread 1-7) Model udfTokenFunctions in VDB oldUDF skipped being loaded because of its type FUNCTION > [2] [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue10) org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'getToken('125421', '?', 2)' is an unknown form. Check that the function name and number of arguments is correct. Sending error to client 1trCiU5AkzFn.5 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3950) UDFs aren't found when using old function definitions model

by Debbie Steigner (JIRA)

[ https://issues.jboss.org/browse/TEIID-3950?page=com.atlassian.jira.plugin... ] Debbie Steigner updated TEIID-3950: ----------------------------------- Attachment: MyOldUDFTest.zip > UDFs aren't found when using old function definitions model > ----------------------------------------------------------- > > Key: TEIID-3950 > URL: https://issues.jboss.org/browse/TEIID-3950 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Attachments: MyOldUDFTest.zip > > > When migrating an old VDB that contains the old functiondefinitions model the server sees it as a Function model[1] but the functions are not found [2]when you try to use them. > [1] [org.teiid.RUNTIME] (MSC service thread 1-7) Model udfTokenFunctions in VDB oldUDF skipped being loaded because of its type FUNCTION > [2] [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue10) org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'getToken('125421', '?', 2)' is an unknown form. Check that the function name and number of arguments is correct. Sending error to client 1trCiU5AkzFn.5 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3950) UDFs aren't found when using old function definitions model

by Debbie Steigner (JIRA)

Debbie Steigner created TEIID-3950: -------------------------------------- Summary: UDFs aren't found when using old function definitions model Key: TEIID-3950 URL: https://issues.jboss.org/browse/TEIID-3950 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.7.2.6_2 Reporter: Debbie Steigner Assignee: Steven Hawkins When migrating an old VDB that contains the old functiondefinitions model the server sees it as a Function model[1] but the functions are not found [2]when you try to use them. [1] [org.teiid.RUNTIME] (MSC service thread 1-7) Model udfTokenFunctions in VDB oldUDF skipped being loaded because of its type FUNCTION [2] [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue10) org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'getToken('125421', '?', 2)' is an unknown form. Check that the function name and number of arguments is correct. Sending error to client 1trCiU5AkzFn.5 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2132) Teiid 8.0 API does not expose boundport in Mbean attribute for Teiid-JDBC

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2132?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2132: ------------------------------------- Since Wildfly is based on Netty version > 4, if we want we can still pursue this. We would have let the WildFly create the socket and create the Netty channel based on it. Not sure how it affects with other SSL settings etc. > Teiid 8.0 API does not expose boundport in Mbean attribute for Teiid-JDBC > ------------------------------------------------------------------------- > > Key: TEIID-2132 > URL: https://issues.jboss.org/browse/TEIID-2132 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.0 > Environment: jboss 7, teiid 8, windows 7 > Reporter: Akshay Harale > Assignee: Ramesh Reddy > Priority: Minor > Labels: jboss, teiid > > When offset is set for jboss from standalone.xml or standalone.conf.bat file, the bound port is not displyed in MBean server. > > For example, > > <socket-binding-group name="standard-sockets" default-interface="public" port-offset="${jboss.socket.binding.port-offset:25}"> > > In above line if I set the value as 25 then that should be added to the default socket port values and exposed as bound port value in MBean server. But in case of teiid the "teiid-jdbc" 's boundPort value is not exposed by the jboss. > > All other boundPorts values are correctly shown in Mbean, except teiid-jdbc -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3932) Upgrade the Olingo library to 4.2.0

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3932?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3932: ------------------------------------- #2 Remove TEIID-3938 related changes from "teiid-olingo-patches" module > Upgrade the Olingo library to 4.2.0 > ----------------------------------- > > Key: TEIID-3932 > URL: https://issues.jboss.org/browse/TEIID-3932 > Project: Teiid > Issue Type: Task > Components: OData > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > > Upgrade the Olingo library to 4.2.0, this will also be used as bucket to all the related issues, patches that needs to be removed when the library is upgraded to 4.2.0 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 11 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues February 2016