[JBoss JIRA] (TEIIDDES-2782) Copy paste sql to the transformation editor is not parsable
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2782?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2782:
-----------------------------------
Fix Version/s: 10.0.3
(was: 10.0.2)
> Copy paste sql to the transformation editor is not parsable
> -----------------------------------------------------------
>
> Key: TEIIDDES-2782
> URL: https://issues.jboss.org/browse/TEIIDDES-2782
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors, Transformations
> Affects Versions: 10.0.1
> Environment: Windows 10 Pro N
> Reporter: Matej Kralik
> Assignee: Ted Jones
> Priority: Critical
> Fix For: 10.0.3
>
> Attachments: endOfFile.mkv, XmlStagingProject.zip
>
>
> When I copy a sql query from any source (notepad, web browser ...) and paste it to the transformation editor show me that "The query is not parsable.Error in parsing of sql - null ."
> When I deleted all newlines from sql query or I wrote it myself to the editor, sql query was validated.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months
[JBoss JIRA] (TEIIDDES-2749) Cache hint removed from transformation when importing dynamic VDB
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2749?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2749.
------------------------------------
Resolution: Done
10.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/68af260373f4722c1...
> Cache hint removed from transformation when importing dynamic VDB
> -----------------------------------------------------------------
>
> Key: TEIIDDES-2749
> URL: https://issues.jboss.org/browse/TEIIDDES-2749
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 10.0.2
>
>
> When importing a dynamic VDB, cache hints are removed from the transformation.
> {code:xml}
> <?xml version="1.0" encoding="UTF-8"?>
> <vdb name="MatViewsVdb" version="1">
> <description>For testing of materialized views</description>
> <model name="Source">
> <source name="Source" translator-name="h2-override"
> connection-jndi-name="java:/mat-views-ds" />
> <metadata type="DDL"><![CDATA[
>
> CREATE FOREIGN TABLE customers (
> id integer,
> name string(4000),
> address string(4000),
> CONSTRAINT PK_ID PRIMARY KEY(id)
> ) OPTIONS(NAMEINSOURCE 'customer')
>
> CREATE FOREIGN TABLE orders (
> id integer,
> customer_id integer,
> amount integer,
> CONSTRAINT PK_ID PRIMARY KEY(id),
> CONSTRAINT FK_CUST FOREIGN KEY(customer_id) REFERENCES customers(id)
> ) OPTIONS(NAMEINSOURCE 'order')
> ]]>
> </metadata>
> </model>
> <model name="ViewModel" type="VIRTUAL">
> <metadata type="DDL"><![CDATA[
> CREATE VIEW internal_short_ttl (
> customer_id integer NOT NULL,
> total_amount integer
> ) OPTIONS (MATERIALIZED 'TRUE',
> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,before_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE before_load=before_load+1;'');',
> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute Source.native(''INSERT INTO check_table(id,after_load) VALUES (''internal_short_ttl'',1) ON DUPLICATE KEY UPDATE after_load=after_load+1;'')'
> )
> AS /*+ cache(ttl:100)*/SELECT c.id AS customer_id, CONVERT(SUM(o.amount),biginteger) AS total_amount FROM customers c INNER JOIN orders o ON c.id = o.customer_id GROUP BY c.id;
> ]]>
> </metadata>
> </model>
> <translator name="h2-override" type="h2">
> <property name="SupportsDirectQueryProcedure" value="true" />
> </translator>
> </vdb>
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months
[JBoss JIRA] (TEIIDDES-2934) Generated JDG modul have required in annotation for each of getters
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2934?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2934:
-----------------------------------
Fix Version/s: 10.0.2
> Generated JDG modul have required in annotation for each of getters
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2934
> URL: https://issues.jboss.org/browse/TEIIDDES-2934
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 10.0.2
>
> Attachments: jdgTestComplete.zip, screenshot.png
>
>
> When I deploy dynamic VDB, server shows error that:
> {code:java}
> org.teiid.core.TeiidException: Required field must not be null : subtitle
> {code}
> I noticed that generated JDG class have all getters to required but in the model have set nullable to 'no_nulls' only one column(screenshot). Source db contains some row which have subtitle columns set to null. In the attachment is the project.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months
[JBoss JIRA] (TEIIDDES-2934) Generated JDG modul have required in annotation for each of getters
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2934?page=com.atlassian.jira.plu... ]
Van Halbert commented on TEIIDDES-2934:
---------------------------------------
the ProtobufAnnotation.getGetterMethodAnnotation method needs to be checked:
return "\t" + PROTOFIELD + "(number = " + col.getOrder() + ", required = " + (col.isRequired() ? col.isRequired() : col.isMandatory()) + ")";
Is seems the condition of (col.IsRequired() or col.isMandatory()) is always resulting in true. That maybe the issue.
> Generated JDG modul have required in annotation for each of getters
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2934
> URL: https://issues.jboss.org/browse/TEIIDDES-2934
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Critical
> Attachments: jdgTestComplete.zip, screenshot.png
>
>
> When I deploy dynamic VDB, server shows error that:
> {code:java}
> org.teiid.core.TeiidException: Required field must not be null : subtitle
> {code}
> I noticed that generated JDG class have all getters to required but in the model have set nullable to 'no_nulls' only one column(screenshot). Source db contains some row which have subtitle columns set to null. In the attachment is the project.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months
[JBoss JIRA] (TEIIDDES-2934) Generated JDG modul have required in annotation for each of getters
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2934?page=com.atlassian.jira.plu... ]
Van Halbert reassigned TEIIDDES-2934:
-------------------------------------
Assignee: Barry LaFond
> Generated JDG modul have required in annotation for each of getters
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2934
> URL: https://issues.jboss.org/browse/TEIIDDES-2934
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Critical
> Attachments: jdgTestComplete.zip, screenshot.png
>
>
> When I deploy dynamic VDB, server shows error that:
> {code:java}
> org.teiid.core.TeiidException: Required field must not be null : subtitle
> {code}
> I noticed that generated JDG class have all getters to required but in the model have set nullable to 'no_nulls' only one column(screenshot). Source db contains some row which have subtitle columns set to null. In the attachment is the project.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months
[JBoss JIRA] (TEIIDDES-2933) No such accessible property/method in the class after deploy vdb
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2933?page=com.atlassian.jira.plu... ]
Matej Kralik commented on TEIIDDES-2933:
----------------------------------------
[~van.halbert] Set pkField with all lowercase is not enough. I had to set lowercase for all column in the BookCacheSource and BooksViewMat too.
Next, I noticed that PUBLISH_YEAR column has a problem too. When I deployed VDB, server showed error that
{code:java}
TEIID21010 Did not find a corresponding write method on entity Book with name PUBLISH_YEAR
{code}
When I removed underscore (_) from BookCacheSource and BooksViewMat , generate new JDG module, deployed was successful.
Next, I noticed that when I have mat table with all lowercase (book) and I create JDG materialization and generated JDG module, shows me error that
{code:java}
TEIID30504 BookCacheSource: TEIID21005 Registered Class not found for table book, check table name matches a registered class
{code}
I noticed that generated JDG module contains Book.class but the table is 'book' so that the class should be book.class . I think that this will be resolved by https://issues.jboss.org/browse/TEIIDDES-2925
[~van.halbert] To your comment about ST_ table.
When I create my project with JDG materialization I proceeded according to JDG materialization quick start. But I had to set staging table in the "teiid_rel:MATVIEW_LOAD_SCRIPT" to Book because when I set ST_Book1 which the designer generated on the server shows me error that
{code:java}
org.teiid.jdbc.TeiidSQLException: TEIID30504 BookCacheSource: TEIID21005 Registered Class not found for table ST_Book1, check table name matches a registered class
{code}
This same error shows me when I set "teiid_rel:MATERIALIZED_STAGE_TABLE" 'BookCacheSource.ST_Book1' instead of "teiid_rel:MATVIEW_LOAD_SCRIPT"
It is an issue or I do something wrong ?
> No such accessible property/method in the class after deploy vdb
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2933
> URL: https://issues.jboss.org/browse/TEIIDDES-2933
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0.2
> Reporter: Matej Kralik
> Assignee: Van Halbert
> Attachments: jdgTest.zip
>
>
> When I want to deploy dynamic VDB with JDG materialization, the server shows me : TEIID31111 No such accessible property/method ISBN on class org.teiid.jdg.pojo.Book.
> I looked at Book.java and ISBN is there.
> The class is generated in the teiid designer. In the attachment is the project with dynamicVDB and generated JDG module.
> Stacktrace:
> {code:java}
> 12:34:07,140 WARN [org.teiid.CONNECTOR] (Worker0_QueryProcessorQueue223) Connector worker process failed for atomic-request=e3xcwoJghvNm.0.69.131: org.teiid.translator.TranslatorException: TEIID31111 No such accessible property/method ISBN on class org.teiid.jdg.pojo.Book.
> at org.teiid.translator.object.ObjectUpdateExecution.evaluate(ObjectUpdateExecution.java:524) [translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.translator.object.ObjectUpdateExecution.handleInsert(ObjectUpdateExecution.java:219) [translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.translator.object.ObjectUpdateExecution.executeUpdate(ObjectUpdateExecution.java:150) [translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.translator.object.ObjectUpdateExecution.execute(ObjectUpdateExecution.java:108) [translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem$1.execute(ConnectorWorkItem.java:402) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:364) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source) [:1.8.0_91]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_91]
> at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_91]
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:211) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at com.sun.proxy.$Proxy46.execute(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:142) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.ProjectIntoNode.checkExitConditions(ProjectIntoNode.java:264) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.ProjectIntoNode.nextBatchDirect(ProjectIntoNode.java:164) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:608) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.proc.ExecDynamicSqlInstruction$1.process(ExecDynamicSqlInstruction.java:218) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:389) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:298) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:270) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:145) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_91]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_91]
> at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_91]
> Caused by: javax.script.ScriptException: TEIID31111 No such accessible property/method ISBN on class org.teiid.jdg.pojo.Book.
> at org.teiid.query.eval.TeiidScriptEngine$1.eval(TeiidScriptEngine.java:132) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> at org.teiid.translator.object.ObjectUpdateExecution.evaluate(ObjectUpdateExecution.java:521) [translator-object-8.12.5.redhat-8.jar:8.12.5.redhat-8]
> ... 47 more
> 12:34:07,146 WARN [org.teiid.MATVIEWS] (Worker0_QueryProcessorQueue225) org.teiid.jdbc.TeiidSQLException: TEIID30504 BookCacheSource: TEIID31111 No such accessible property/method ISBN on class org.teiid.jdg.pojo.Book.
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months
[JBoss JIRA] (TEIIDDES-2934) Generated JDG modul have required in annotation for each of getters
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2934?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2934:
-----------------------------------
Summary: Generated JDG modul have required in annotation for each of getters (was: Generated JDG modul have required annotation for each of getters)
> Generated JDG modul have required in annotation for each of getters
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2934
> URL: https://issues.jboss.org/browse/TEIIDDES-2934
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Reporter: Matej Kralik
> Priority: Critical
> Attachments: jdgTestComplete.zip, screenshot.png
>
>
> When I deploy dynamic VDB, server shows error that:
> {code:java}
> org.teiid.core.TeiidException: Required field must not be null : subtitle
> {code}
> I noticed that generated JDG class have all getters to required but in the model have set nullable to 'no_nulls' only one column(screenshot). Source db contains some row which have subtitle columns set to null. In the attachment is the project.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months
[JBoss JIRA] (TEIIDDES-2934) Generated JDG modul have required anotation for each of getters
by Matej Kralik (JIRA)
Matej Kralik created TEIIDDES-2934:
--------------------------------------
Summary: Generated JDG modul have required anotation for each of getters
Key: TEIIDDES-2934
URL: https://issues.jboss.org/browse/TEIIDDES-2934
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 10.0.2
Reporter: Matej Kralik
Priority: Critical
Attachments: jdgTestComplete.zip, screenshot.png
When I deploy dynamic VDB, server shows error that:
{code:java}
org.teiid.core.TeiidException: Required field must not be null : subtitle
{code}
I noticed that generated JDG class have all getters to required but in the model have set nullable to 'no_nulls' only one column(screenshot). Source db contains some row which have subtitle columns set to null. In the attachment is the project.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months
[JBoss JIRA] (TEIIDDES-2934) Generated JDG modul have required annotation for each of getters
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2934?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2934:
-----------------------------------
Summary: Generated JDG modul have required annotation for each of getters (was: Generated JDG modul have required anotation for each of getters)
> Generated JDG modul have required annotation for each of getters
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2934
> URL: https://issues.jboss.org/browse/TEIIDDES-2934
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Reporter: Matej Kralik
> Priority: Critical
> Attachments: jdgTestComplete.zip, screenshot.png
>
>
> When I deploy dynamic VDB, server shows error that:
> {code:java}
> org.teiid.core.TeiidException: Required field must not be null : subtitle
> {code}
> I noticed that generated JDG class have all getters to required but in the model have set nullable to 'no_nulls' only one column(screenshot). Source db contains some row which have subtitle columns set to null. In the attachment is the project.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months