[JBoss JIRA] (TEIID-5180) Execution of stored procedure with parameters failed on Teiid
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5180?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5180:
---------------------------------------
> Unfortunately there isn't a simple alter statement that can do that
The closest would be to alter the parameter to be nullable.
{code}
<model name="SrcModel_5" type="PHYSICAL" visible="true">
<property name="importer.importKeys" value="false"/>
<property name="importer.useFullSchemaName" value="true"/>
<property name="importer.UseQualifiedName" value="true" />
<property name="importer.TableTypes" value="VIEW" />
<property name="importer.schemapattern" value="%"/>
<property name="importer.importProcedures" value="true" />
<source name="SrcModel_5" translator-name="sybase" connection-jndi-name="java:/dynamicST-DS-6" />
<metadata type="NATIVE">
<metadata type="DDL">alter procedure SrcModel_5.dwhdb.dbo.sp_iqfile alter parameter dbspaceName type string;</metadata>
</model>
{code}
> Execution of stored procedure with parameters failed on Teiid
> -------------------------------------------------------------
>
> Key: TEIID-5180
> URL: https://issues.jboss.org/browse/TEIID-5180
> Project: Teiid
> Issue Type: Bug
> Reporter: Aditi Patel
> Assignee: Steven Hawkins
>
> I have imported SAP IQ stored procedure and trying to execute the same.
>
> Below is the way I have imported the procedures and related views:
>
> {code:java}
> <model name="SrcModel_5" type="PHYSICAL" visible="true">
> <property name="importer.importKeys" value="false"/>
> <property name="importer.useFullSchemaName" value="true"/>
> <property name="importer.UseQualifiedName" value="true" />
> <property name="importer.TableTypes" value="VIEW" />
> <property name="importer.schemapattern" value="%"/>
> <property name="importer.importProcedures" value="true" />
> <source name="SrcModel_5" translator-name="sybase" connection-jndi-name="java:/dynamicST-DS-6" />
> </model>
> {code}
>
> *Execution:*
>
> EXEC SrcModel_5.dwhdb.dbo.sp_iqfile()
>
> *Error Log:*
>
> {color:red}13:12:21,669 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue11) sQOZ5DwTHpU0 TEIID30020 Processing exception for request sQOZ5DwTHpU0.0 'TEIID30089 Required parameter 'SrcModel_5.dwhdb.dbo.sp_iqfile.dbspaceName' has no value was set or is an invalid parameter.'. Originally QueryResolverException ResolverUtil.java:505. Enable more detailed logging to see the entire stacktrace.{color}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months
[JBoss JIRA] (TEIID-4851) Random errors about PostGIS without using it
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4851?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4851.
-----------------------------------
Fix Version/s: 10.1
9.3.6
10.0.2
Resolution: Done
Postgresql will invalidate a connection in a transaction after a query with an error, so a savepoint was added to isolate the failure.
[~mcouliba] Please let cee know if you need this in a product release.
> Random errors about PostGIS without using it
> --------------------------------------------
>
> Key: TEIID-4851
> URL: https://issues.jboss.org/browse/TEIID-4851
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.12.8.6_3
> Environment: Squirrel v3.7
> Teiid JDBC 8.13.1
> JDV 6.3.4
> PostgreSQL 9.6
> Reporter: Madou Coulibaly
> Assignee: Steven Hawkins
> Fix For: 10.1, 9.3.6, 10.0.2
>
> Attachments: server.log
>
>
> When I issue queries using SQuirrel, I get the following error at random whereas I do not use any Geo functions:
> Originally TeiidProcessingException 'ERROR: function postgis_full_version() does not exist
> Hint: No function matches the given name and argument types. You might need to add explicit type casts.
> Position: 8' QueryExecutorImpl.java:2455. Enable more detailed logging to see the entire stacktrace.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months
[JBoss JIRA] (TEIID-5182) OData4 Imported MXD properties have a space
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5182?page=com.atlassian.jira.plugin... ]
Ramesh Reddy updated TEIID-5182:
--------------------------------
Fix Version/s: 10.1
> OData4 Imported MXD properties have a space
> -------------------------------------------
>
> Key: TEIID-5182
> URL: https://issues.jboss.org/browse/TEIID-5182
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 10.1
>
>
> The Metadata Extension Properties that are imported from server for OData4 translator have leading space in the definition, thus it creates a wrong VDB which fails to run during the runtime
> {code}
> <p:property advanced="false" index="true" masked="false" name="Type" required="true" type="string">
> <p:allowedValue>COMPLEX</p:allowedValue>
> <p:allowedValue> NAVIGATION</p:allowedValue>
> <p:allowedValue> COMPLEX_COLLECTION</p:allowedValue>
> <p:allowedValue> ENTITY_COLLECTION</p:allowedValue>
> <p:allowedValue> NAVIGATION_COLLECTION</p:allowedValue>
> <p:allowedValue> ENTITY</p:allowedValue>
> <p:allowedValue> FUNCTION</p:allowedValue>
> <p:allowedValue> ACTION</p:allowedValue>
> </p:property>
> {code}
> see allowed Values with leading white space. I am not sure this is how the server is providing.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months
[JBoss JIRA] (TEIID-5182) OData4 Imported MXD properties have a space
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIID-5182?page=com.atlassian.jira.plugin... ]
Barry LaFond reassigned TEIID-5182:
-----------------------------------
Assignee: Barry LaFond
> OData4 Imported MXD properties have a space
> -------------------------------------------
>
> Key: TEIID-5182
> URL: https://issues.jboss.org/browse/TEIID-5182
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12
> Reporter: Ramesh Reddy
> Assignee: Barry LaFond
> Priority: Critical
>
> The Metadata Extension Properties that are imported from server for OData4 translator have leading space in the definition, thus it creates a wrong VDB which fails to run during the runtime
> {code}
> <p:property advanced="false" index="true" masked="false" name="Type" required="true" type="string">
> <p:allowedValue>COMPLEX</p:allowedValue>
> <p:allowedValue> NAVIGATION</p:allowedValue>
> <p:allowedValue> COMPLEX_COLLECTION</p:allowedValue>
> <p:allowedValue> ENTITY_COLLECTION</p:allowedValue>
> <p:allowedValue> NAVIGATION_COLLECTION</p:allowedValue>
> <p:allowedValue> ENTITY</p:allowedValue>
> <p:allowedValue> FUNCTION</p:allowedValue>
> <p:allowedValue> ACTION</p:allowedValue>
> </p:property>
> {code}
> see allowed Values with leading white space. I am not sure this is how the server is providing.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months
[JBoss JIRA] (TEIID-5182) OData4 Imported MXD properties have a space
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIID-5182?page=com.atlassian.jira.plugin... ]
Barry LaFond reassigned TEIID-5182:
-----------------------------------
Assignee: Steven Hawkins (was: Barry LaFond)
> OData4 Imported MXD properties have a space
> -------------------------------------------
>
> Key: TEIID-5182
> URL: https://issues.jboss.org/browse/TEIID-5182
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
> Priority: Critical
>
> The Metadata Extension Properties that are imported from server for OData4 translator have leading space in the definition, thus it creates a wrong VDB which fails to run during the runtime
> {code}
> <p:property advanced="false" index="true" masked="false" name="Type" required="true" type="string">
> <p:allowedValue>COMPLEX</p:allowedValue>
> <p:allowedValue> NAVIGATION</p:allowedValue>
> <p:allowedValue> COMPLEX_COLLECTION</p:allowedValue>
> <p:allowedValue> ENTITY_COLLECTION</p:allowedValue>
> <p:allowedValue> NAVIGATION_COLLECTION</p:allowedValue>
> <p:allowedValue> ENTITY</p:allowedValue>
> <p:allowedValue> FUNCTION</p:allowedValue>
> <p:allowedValue> ACTION</p:allowedValue>
> </p:property>
> {code}
> see allowed Values with leading white space. I am not sure this is how the server is providing.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months
[JBoss JIRA] (TEIID-5182) OData4 Imported MXD properties have a space
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5182?page=com.atlassian.jira.plugin... ]
Ramesh Reddy moved TEIIDDES-3168 to TEIID-5182:
-----------------------------------------------
Project: Teiid (was: Teiid Designer)
Key: TEIID-5182 (was: TEIIDDES-3168)
Component/s: Misc. Connectors
(was: Import/Export)
Affects Version/s: 8.12
(was: 11.1)
> OData4 Imported MXD properties have a space
> -------------------------------------------
>
> Key: TEIID-5182
> URL: https://issues.jboss.org/browse/TEIID-5182
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 8.12
> Reporter: Ramesh Reddy
> Priority: Critical
>
> The Metadata Extension Properties that are imported from server for OData4 translator have leading space in the definition, thus it creates a wrong VDB which fails to run during the runtime
> {code}
> <p:property advanced="false" index="true" masked="false" name="Type" required="true" type="string">
> <p:allowedValue>COMPLEX</p:allowedValue>
> <p:allowedValue> NAVIGATION</p:allowedValue>
> <p:allowedValue> COMPLEX_COLLECTION</p:allowedValue>
> <p:allowedValue> ENTITY_COLLECTION</p:allowedValue>
> <p:allowedValue> NAVIGATION_COLLECTION</p:allowedValue>
> <p:allowedValue> ENTITY</p:allowedValue>
> <p:allowedValue> FUNCTION</p:allowedValue>
> <p:allowedValue> ACTION</p:allowedValue>
> </p:property>
> {code}
> see allowed Values with leading white space. I am not sure this is how the server is providing.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months
[JBoss JIRA] (TEIID-5164) Infinispan hotrod translator aggregate functions issues
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-5164?page=com.atlassian.jira.plugin... ]
Van Halbert updated TEIID-5164:
-------------------------------
Fix Version/s: 10.x
> Infinispan hotrod translator aggregate functions issues
> -------------------------------------------------------
>
> Key: TEIID-5164
> URL: https://issues.jboss.org/browse/TEIID-5164
> Project: Teiid
> Issue Type: Bug
> Components: JDG Connector, Misc. Connectors
> Affects Versions: 8.12.x-6.4
> Reporter: Jan Stastny
> Assignee: Van Halbert
> Priority: Critical
> Fix For: 8.12.x-6.4, 10.x
>
>
> Aggregate functions doesn't work with infinispan hotrod translator.
> Example:
> {code:sql}
> SELECT AVG(IntnUM) FROM BQT1.SmallA
> {code}
> results in
> {code}
> 12:07:57,882 ERROR [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue70) Connector worker process failed for atomic-request=+VUUR2vieWhT.20.1.10: java.lang.AssertionError: Inproper results returned. Expected 1 columns, but was 0
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:439) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:236) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_151]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_151]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_151]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_151]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at com.sun.proxy.$Proxy79.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_151]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.11.6_4-redhat-64-7.jar:8.12.11.6_4-redhat-64-7]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_151]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_151]
> at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_151]
> 12:07:57,888 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue71) TEIID30020 Processing exception for request +VUUR2vieWhT.20 'TEIID30504 jdg7-source: Inproper results returned. Expected 1 columns, but was 0'. Originally TeiidProcessingException ConnectorWorkItem.java:439. Enable more detailed logging to see the entire stacktrace.
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months
[JBoss JIRA] (TEIID-5180) Execution of stored procedure with parameters failed on Teiid
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5180?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5180:
---------------------------------------
We can add the simple mechanics for this, but it appears that many vendors (including postgresql, jtds, and us TEIID-5181) do not expose the column_def metadata in JDBC databasemetadata.
The workaround is to alter the imported metadata to add an appropriate default or mark the parameter as nullable.
Unfortunately there isn't a simple alter statement that can do that, so you would have to capture all of the source metadata and user/alter that rather than relying upon the import. You can get full metadata snapshot from the Admin.getSchema method.
> Execution of stored procedure with parameters failed on Teiid
> -------------------------------------------------------------
>
> Key: TEIID-5180
> URL: https://issues.jboss.org/browse/TEIID-5180
> Project: Teiid
> Issue Type: Bug
> Reporter: Aditi Patel
> Assignee: Steven Hawkins
>
> I have imported SAP IQ stored procedure and trying to execute the same.
>
> Below is the way I have imported the procedures and related views:
>
> {code:java}
> <model name="SrcModel_5" type="PHYSICAL" visible="true">
> <property name="importer.importKeys" value="false"/>
> <property name="importer.useFullSchemaName" value="true"/>
> <property name="importer.UseQualifiedName" value="true" />
> <property name="importer.TableTypes" value="VIEW" />
> <property name="importer.schemapattern" value="%"/>
> <property name="importer.importProcedures" value="true" />
> <source name="SrcModel_5" translator-name="sybase" connection-jndi-name="java:/dynamicST-DS-6" />
> </model>
> {code}
>
> *Execution:*
>
> EXEC SrcModel_5.dwhdb.dbo.sp_iqfile()
>
> *Error Log:*
>
> {color:red}13:12:21,669 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue11) sQOZ5DwTHpU0 TEIID30020 Processing exception for request sQOZ5DwTHpU0.0 'TEIID30089 Required parameter 'SrcModel_5.dwhdb.dbo.sp_iqfile.dbspaceName' has no value was set or is an invalid parameter.'. Originally QueryResolverException ResolverUtil.java:505. Enable more detailed logging to see the entire stacktrace.{color}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months
[JBoss JIRA] (TEIID-5181) Add column_def to databasemetadata for parameters
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-5181:
-------------------------------------
Summary: Add column_def to databasemetadata for parameters
Key: TEIID-5181
URL: https://issues.jboss.org/browse/TEIID-5181
Project: Teiid
Issue Type: Quality Risk
Components: JDBC Driver, Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 10.1
column_def is not implement on getProcedureColumns because sys.procedureparams does not expose the default value.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months
[JBoss JIRA] (TEIID-5180) Execution of stored procedure with parameters failed on Teiid
by Aditi Patel (JIRA)
[ https://issues.jboss.org/browse/TEIID-5180?page=com.atlassian.jira.plugin... ]
Aditi Patel commented on TEIID-5180:
------------------------------------
Below is the link of the discussion we had on this issue:
[https://developer.jboss.org/thread/276699|http://example.com]
> Execution of stored procedure with parameters failed on Teiid
> -------------------------------------------------------------
>
> Key: TEIID-5180
> URL: https://issues.jboss.org/browse/TEIID-5180
> Project: Teiid
> Issue Type: Bug
> Reporter: Aditi Patel
> Assignee: Steven Hawkins
>
> I have imported SAP IQ stored procedure and trying to execute the same.
>
> Below is the way I have imported the procedures and related views:
>
> {code:java}
> <model name="SrcModel_5" type="PHYSICAL" visible="true">
> <property name="importer.importKeys" value="false"/>
> <property name="importer.useFullSchemaName" value="true"/>
> <property name="importer.UseQualifiedName" value="true" />
> <property name="importer.TableTypes" value="VIEW" />
> <property name="importer.schemapattern" value="%"/>
> <property name="importer.importProcedures" value="true" />
> <source name="SrcModel_5" translator-name="sybase" connection-jndi-name="java:/dynamicST-DS-6" />
> </model>
> {code}
>
> *Execution:*
>
> EXEC SrcModel_5.dwhdb.dbo.sp_iqfile()
>
> *Error Log:*
>
> {color:red}13:12:21,669 WARN [org.teiid.PROCESSOR] (Worker2_QueryProcessorQueue11) sQOZ5DwTHpU0 TEIID30020 Processing exception for request sQOZ5DwTHpU0.0 'TEIID30089 Required parameter 'SrcModel_5.dwhdb.dbo.sp_iqfile.dbspaceName' has no value was set or is an invalid parameter.'. Originally QueryResolverException ResolverUtil.java:505. Enable more detailed logging to see the entire stacktrace.{color}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 3 months