[JBoss JIRA] (TEIID-5183) NPE in Swagger translator
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5183?page=com.atlassian.jira.plugin... ]
Work on TEIID-5183 started by Steven Hawkins.
---------------------------------------------
> NPE in Swagger translator
> -------------------------
>
> Key: TEIID-5183
> URL: https://issues.jboss.org/browse/TEIID-5183
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors
> Affects Versions: 9.3.4
> Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
>
> When using the http://api.apis.guru/v2/specs/azure.com/redis/2017-10-01/ link as an endpoint for swagger resource adapter Teiid throws up the following error message (in bootstrapping phase), though with http://petstore.swagger.io/v2 endpoint according to the https://teiid.gitbooks.io/documents/reference/Swagger_Translator.html documentation the translator works:
> {code:noformat}
> 2017-12-18 16:14:43,975 WARN [org.teiid.RUNTIME] (Worker1_async-teiid-threads1) TEIID50036 VDB test.1 model "mswagger" metadata failed to load. Reason:java.lang.NullPointerExceptio
> n: java.lang.NullPointerException
> at org.teiid.metadata.MetadataFactory.setUUID(MetadataFactory.java:155)
> at org.teiid.metadata.MetadataFactory.addProcedureParameter(MetadataFactory.java:421)
> at org.teiid.translator.swagger.SwaggerMetadataProcessor.addProcedureParameters(SwaggerMetadataProcessor.java:560)
> at org.teiid.translator.swagger.SwaggerMetadataProcessor.addProcedure(SwaggerMetadataProcessor.java:261)
> at org.teiid.translator.swagger.SwaggerMetadataProcessor.process(SwaggerMetadataProcessor.java:206)
> at org.teiid.translator.swagger.SwaggerMetadataProcessor.process(SwaggerMetadataProcessor.java:74)
> at org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:961)
> at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96)
> at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62)
> at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
> at org.teiid.jboss.VDBService$6.run(VDBService.java:341)
> at org.teiid.jboss.VDBService$7.run(VDBService.java:392)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284)
> 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)
> {code}
> The http://api.apis.guru/v2/specs/azure.com/redis/2017-10-01/ endpoint supports swagger API according to the https://apis.guru/browse-apis/ link and I can see json output when requesting the http://api.apis.guru/v2/specs/azure.com/redis/2017-10-01/swagger.json link. Probably the NPE appears because of RefParameter type which is not handled in SwaggerMetadataProcessor.addProcedureParameters method which leads to name = null.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 5 months
[JBoss JIRA] (TEIID-5161) Push down rand() function
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5161?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5161:
---------------------------------------
It's corrected now. Thanks for catching that.
> Push down rand() function
> -------------------------
>
> Key: TEIID-5161
> URL: https://issues.jboss.org/browse/TEIID-5161
> Project: Teiid
> Issue Type: Quality Risk
> Components: JDBC Connector, Query Engine
> Affects Versions: 9.3.4
> Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Fix For: 10.1
>
> Attachments: mssql_rand_function.jpg
>
>
> As per discussion within TEIID-5153 we should push down rand() function where ever it seems to be missing. But first of all the function should be pushed down for at least PostgreSQL, MySQL, MSSQL and Oracle databases.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 5 months
[JBoss JIRA] (TEIID-5161) Push down rand() function
by dalex dalex (JIRA)
[ https://issues.jboss.org/browse/TEIID-5161?page=com.atlassian.jira.plugin... ]
dalex dalex commented on TEIID-5161:
------------------------------------
[~shawkins]
> This isn't an issue with Teiid other than I missed that SQL Server doesn't treat the rand function as non-deterministic. It is evaluated only once per query.
Thx, that's interesting...
> So it's probably safest to just not push to SQL Server.
let's remove then the:
{code:noformat}
if (getVersion().compareTo(TEN_0) >= 0) {
supportedFunctions.add("RAND"); //$NON-NLS-1$
}
{code}
in SQLServerExecutionFactory.getSupportedFunctions method
> Push down rand() function
> -------------------------
>
> Key: TEIID-5161
> URL: https://issues.jboss.org/browse/TEIID-5161
> Project: Teiid
> Issue Type: Quality Risk
> Components: JDBC Connector, Query Engine
> Affects Versions: 9.3.4
> Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Fix For: 10.1
>
> Attachments: mssql_rand_function.jpg
>
>
> As per discussion within TEIID-5153 we should push down rand() function where ever it seems to be missing. But first of all the function should be pushed down for at least PostgreSQL, MySQL, MSSQL and Oracle databases.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 5 months
[JBoss JIRA] (TEIID-5183) NPE in Swagger translator
by dalex dalex (JIRA)
dalex dalex created TEIID-5183:
----------------------------------
Summary: NPE in Swagger translator
Key: TEIID-5183
URL: https://issues.jboss.org/browse/TEIID-5183
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 9.3.4
Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final)
Reporter: dalex dalex
Assignee: Steven Hawkins
When using the http://api.apis.guru/v2/specs/azure.com/redis/2017-10-01/ link as an endpoint for swagger resource adapter Teiid throws up the following error message (in bootstrapping phase), though with http://petstore.swagger.io/v2 endpoint according to the https://teiid.gitbooks.io/documents/reference/Swagger_Translator.html documentation the translator works:
{code:noformat}
2017-12-18 16:14:43,975 WARN [org.teiid.RUNTIME] (Worker1_async-teiid-threads1) TEIID50036 VDB test.1 model "mswagger" metadata failed to load. Reason:java.lang.NullPointerExceptio
n: java.lang.NullPointerException
at org.teiid.metadata.MetadataFactory.setUUID(MetadataFactory.java:155)
at org.teiid.metadata.MetadataFactory.addProcedureParameter(MetadataFactory.java:421)
at org.teiid.translator.swagger.SwaggerMetadataProcessor.addProcedureParameters(SwaggerMetadataProcessor.java:560)
at org.teiid.translator.swagger.SwaggerMetadataProcessor.addProcedure(SwaggerMetadataProcessor.java:261)
at org.teiid.translator.swagger.SwaggerMetadataProcessor.process(SwaggerMetadataProcessor.java:206)
at org.teiid.translator.swagger.SwaggerMetadataProcessor.process(SwaggerMetadataProcessor.java:74)
at org.teiid.translator.ExecutionFactory.getMetadata(ExecutionFactory.java:961)
at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96)
at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62)
at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
at org.teiid.jboss.VDBService$6.run(VDBService.java:341)
at org.teiid.jboss.VDBService$7.run(VDBService.java:392)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:284)
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)
{code}
The http://api.apis.guru/v2/specs/azure.com/redis/2017-10-01/ endpoint supports swagger API according to the https://apis.guru/browse-apis/ link and I can see json output when requesting the http://api.apis.guru/v2/specs/azure.com/redis/2017-10-01/swagger.json link. Probably the NPE appears because of RefParameter type which is not handled in SwaggerMetadataProcessor.addProcedureParameters method which leads to name = null.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 5 months
[JBoss JIRA] (TEIID-5161) Push down rand() function
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5161?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5161:
---------------------------------------
> I don't know what we can do here, maybe it's better just not to push down rand function for MSSQL or maybe there is a problem on teiid core...
This isn't an issue with Teiid other than I missed that SQL Server doesn't treat the rand function as non-deterministic. It is evaluated only once per query. We can still push it down, but will have to resort to effectively passing a random seed - https://stackoverflow.com/questions/1045138/how-do-i-generate-random-numb...
So it's probably safest to just not push to SQL Server.
> Push down rand() function
> -------------------------
>
> Key: TEIID-5161
> URL: https://issues.jboss.org/browse/TEIID-5161
> Project: Teiid
> Issue Type: Quality Risk
> Components: JDBC Connector, Query Engine
> Affects Versions: 9.3.4
> Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Fix For: 10.1
>
> Attachments: mssql_rand_function.jpg
>
>
> As per discussion within TEIID-5153 we should push down rand() function where ever it seems to be missing. But first of all the function should be pushed down for at least PostgreSQL, MySQL, MSSQL and Oracle databases.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 5 months
[JBoss JIRA] (TEIID-5161) Push down rand() function
by dalex dalex (JIRA)
[ https://issues.jboss.org/browse/TEIID-5161?page=com.atlassian.jira.plugin... ]
dalex dalex updated TEIID-5161:
-------------------------------
Attachment: mssql_rand_function.jpg
> Push down rand() function
> -------------------------
>
> Key: TEIID-5161
> URL: https://issues.jboss.org/browse/TEIID-5161
> Project: Teiid
> Issue Type: Quality Risk
> Components: JDBC Connector, Query Engine
> Affects Versions: 9.3.4
> Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Fix For: 10.1
>
> Attachments: mssql_rand_function.jpg
>
>
> As per discussion within TEIID-5153 we should push down rand() function where ever it seems to be missing. But first of all the function should be pushed down for at least PostgreSQL, MySQL, MSSQL and Oracle databases.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 5 months
[JBoss JIRA] (TEIID-5161) Push down rand() function
by dalex dalex (JIRA)
[ https://issues.jboss.org/browse/TEIID-5161?page=com.atlassian.jira.plugin... ]
dalex dalex commented on TEIID-5161:
------------------------------------
Hi [~shawkins], I've just applied all these changes for my teiid 9.3.4 and got one strange problem related to MSSQL, all values were the same. How to reproduce the problem:
1. create in MSSQL table_a table:
{code:sql}
CREATE TABLE public.test_a
(
a integer,
b integer
);
INSERT INTO public.test_a(a, b) VALUES (1, 1);
INSERT INTO public.test_a(a, b) VALUES (1, 2);
INSERT INTO public.test_a(a, b) VALUES (2, 1);
INSERT INTO public.test_a(a, b) VALUES (2, 2);
INSERT INTO public.test_a(a, b) VALUES (3, 2);
INSERT INTO public.test_a(a, b) VALUES (3, 10);
{code}
2. add MSSQL as a source to Teiid:
{code:xml}
<datasource jndi-name="java:/mssql-test-tables" pool-name="mssql-test-tables" enabled="true" use-java-context="true">
<connection-url>jdbc:sqlserver://localhost:1433;databaseName=test_tables</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<driver>com.microsoft.sqlserver</driver>
<new-connection-sql>SET ANSI_WARNINGS OFF</new-connection-sql>
<pool>
<min-pool-size>2</min-pool-size>
<max-pool-size>70</max-pool-size>
</pool>
<security>
<user-name>****</user-name>
<password>****</password>
</security>
<validation>
<check-valid-connection-sql>select 1</check-valid-connection-sql>
</validation>
<timeout>
<blocking-timeout-millis>120000</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-timeout-minutes>
</timeout>
</datasource>
{code}
3. add ms model:
{code:xml}
<model name="ms">
<property name="importer.useFullSchemaName" value="false"/>
<property name="importer.tableTypes" value="TABLE,VIEW"/>
<property name="importer.importKeys" value="false"/>
<property name="importer.schemaPattern" value="dbo"/>
<source name="test_tables_ms" translator-name="sqlserver" connection-jndi-name="java:/mssql-test-tables"/>
</model>
{code}
4. run the following query:
{code:sql}
select rand() from ms.test_a;;
{code}
as a result I can see six rand function values which are absolutely the same, something like this:
{code:noformat}
0.62444
0.62444
0.62444
0.62444
0.62444
0.62444
{code}
but running the same query through PostgreSQL, for example:
{code:sql}
select rand() from test_pg.test_a;;
{code}
I'm getting absolutely different six values:
{code:noformat}
0.90137
0.57251
0.68237
0.28293
0.16568
0.73541
{code}
I don't know what we can do here, maybe it's better just not to push down rand function for MSSQL or maybe there is a problem on teiid core...
> Push down rand() function
> -------------------------
>
> Key: TEIID-5161
> URL: https://issues.jboss.org/browse/TEIID-5161
> Project: Teiid
> Issue Type: Quality Risk
> Components: JDBC Connector, Query Engine
> Affects Versions: 9.3.4
> Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final)
> Reporter: dalex dalex
> Assignee: Steven Hawkins
> Fix For: 10.1
>
>
> As per discussion within TEIID-5153 we should push down rand() function where ever it seems to be missing. But first of all the function should be pushed down for at least PostgreSQL, MySQL, MSSQL and Oracle databases.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
6 years, 5 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 resolved TEIID-5180.
-----------------------------------
Fix Version/s: 10.1
Resolution: Partially Completed
Marking as partially completed. The import code has been added to infer defaults - but it doesn't appear that most vendors provide that. The meaning of the omit value for the default handling extension metadata property was expanded so that regardless of the database provides as a default Teiid will not attempt to resolve or use it.
For now the workaround is to mark the parameter as nullable as shown in the previous comment.
> 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
> Fix For: 10.1
>
>
> 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)
6 years, 5 months
[JBoss JIRA] (TEIID-5164) Infinispan hotrod translator aggregate functions issues
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5164?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-5164:
----------------------------------
Fix Version/s: 10.1
9.3.6
10.0.2
(was: 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.1, 9.3.6, 10.0.2
>
>
> 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)
6 years, 5 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:
---------------------------------------
> 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)
6 years, 5 months