[JBoss JIRA] (TEIIDDES-2935) Teiid designer doesn't generate materialization staging table correctly
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2935?page=com.atlassian.jira.plu... ]
Van Halbert reassigned TEIIDDES-2935:
-------------------------------------
Assignee: Barry LaFond
> Teiid designer doesn't generate materialization staging table correctly
> -----------------------------------------------------------------------
>
> Key: TEIIDDES-2935
> URL: https://issues.jboss.org/browse/TEIIDDES-2935
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Attachments: project.zip
>
>
> I have generated JDG module and materialization table. When I created dynamic vdb and deploy to server, server shows me warning that:
> {code:java}
> TEIID21005 Registered Class not found for table ST_Book1, check table name matches a registered class
> {code}
> I noticed that staging table doesn't contain primary_table parameter in the options.
> I think that Teiid designer should add this parameter automatically after generated this tables.
> Actual ddl:
> {code:java}
> <![CDATA[
> CREATE FOREIGN TABLE Book (
> isbn string(255) NOT NULL,
> title string(255),
> publisher integer OPTIONS(FIXED_LENGTH 'TRUE'),
> publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'),
> edition integer OPTIONS(FIXED_LENGTH 'TRUE'),
> type string(255),
> CONSTRAINT PK_ISBN PRIMARY KEY(isbn)
> )OPTIONS(UPDATABLE 'TRUE')
> CREATE FOREIGN TABLE ST_Book1 (
> isbn string(255) NOT NULL,
> title string(255),
> publisher integer OPTIONS(FIXED_LENGTH 'TRUE'),
> publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'),
> edition integer OPTIONS(FIXED_LENGTH 'TRUE'),
> type string(255),
> CONSTRAINT PK_ISBN PRIMARY KEY(isbn)
> )OPTIONS(UPDATABLE 'TRUE')
> ]]>
> {code}
> Expected ddl:
> {code:java}
> <![CDATA[
> SET NAMESPACE 'http://www.teiid.org/translator/object/2016' AS tns;
> CREATE FOREIGN TABLE Book (
> isbn string(255) NOT NULL,
> title string(255),
> publisher integer OPTIONS(FIXED_LENGTH 'TRUE'),
> publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'),
> edition integer OPTIONS(FIXED_LENGTH 'TRUE'),
> type string(255),
> CONSTRAINT PK_ISBN PRIMARY KEY(isbn)
> )OPTIONS(UPDATABLE 'TRUE')
> CREATE FOREIGN TABLE ST_Book1 (
> isbn string(255) NOT NULL,
> title string(255),
> publisher integer OPTIONS(FIXED_LENGTH 'TRUE'),
> publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'),
> edition integer OPTIONS(FIXED_LENGTH 'TRUE'),
> type string(255),
> CONSTRAINT PK_ISBN PRIMARY KEY(isbn)
> )OPTIONS(UPDATABLE 'TRUE',"tns:primary_table" 'BookCacheSource.Book')
> ]]>
> {code}
--
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:
----------------------------------------
To ST_ table, I noticed that ST_Book1 table should contain 'primary_table' parameter in the options. [TEIIDDES-2935|https://issues.jboss.org/browse/TEIIDDES-2935]
> 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-2935) Teiid designer doesn't generate materialization staging table correctly
by Matej Kralik (JIRA)
Matej Kralik created TEIIDDES-2935:
--------------------------------------
Summary: Teiid designer doesn't generate materialization staging table correctly
Key: TEIIDDES-2935
URL: https://issues.jboss.org/browse/TEIIDDES-2935
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 10.0.2
Environment: Fedora 24
Reporter: Matej Kralik
Attachments: project.zip
I have generated JDG module and materialization table. When I created dynamic vdb and deploy to server, server shows me warning that:
{code:java}
TEIID21005 Registered Class not found for table ST_Book1, check table name matches a registered class
{code}
I noticed that staging table doesn't contain primary_table parameter in the options.
I think that Teiid designer should add this parameter automatically after generated this tables.
Actual ddl:
{code:java}
<![CDATA[
CREATE FOREIGN TABLE Book (
isbn string(255) NOT NULL,
title string(255),
publisher integer OPTIONS(FIXED_LENGTH 'TRUE'),
publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'),
edition integer OPTIONS(FIXED_LENGTH 'TRUE'),
type string(255),
CONSTRAINT PK_ISBN PRIMARY KEY(isbn)
)OPTIONS(UPDATABLE 'TRUE')
CREATE FOREIGN TABLE ST_Book1 (
isbn string(255) NOT NULL,
title string(255),
publisher integer OPTIONS(FIXED_LENGTH 'TRUE'),
publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'),
edition integer OPTIONS(FIXED_LENGTH 'TRUE'),
type string(255),
CONSTRAINT PK_ISBN PRIMARY KEY(isbn)
)OPTIONS(UPDATABLE 'TRUE')
]]>
{code}
Expected ddl:
{code:java}
<![CDATA[
SET NAMESPACE 'http://www.teiid.org/translator/object/2016' AS tns;
CREATE FOREIGN TABLE Book (
isbn string(255) NOT NULL,
title string(255),
publisher integer OPTIONS(FIXED_LENGTH 'TRUE'),
publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'),
edition integer OPTIONS(FIXED_LENGTH 'TRUE'),
type string(255),
CONSTRAINT PK_ISBN PRIMARY KEY(isbn)
)OPTIONS(UPDATABLE 'TRUE')
CREATE FOREIGN TABLE ST_Book1 (
isbn string(255) NOT NULL,
title string(255),
publisher integer OPTIONS(FIXED_LENGTH 'TRUE'),
publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'),
edition integer OPTIONS(FIXED_LENGTH 'TRUE'),
type string(255),
CONSTRAINT PK_ISBN PRIMARY KEY(isbn)
)OPTIONS(UPDATABLE 'TRUE',"tns:primary_table" 'BookCacheSource.Book')
]]>
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months
[JBoss JIRA] (TEIIDDES-2923) Wrong cardinality value in table editor
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2923?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2923:
-----------------------------------
Fix Version/s: 10.0.3
> Wrong cardinality value in table editor
> ---------------------------------------
>
> Key: TEIIDDES-2923
> URL: https://issues.jboss.org/browse/TEIIDDES-2923
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs, Editors
> Affects Versions: 10.0.2
> Reporter: Mario Majernik
> Fix For: 10.0.3
>
> Attachments: Screen1.png, Screen2.png
>
>
> Problem 1 : Cardinality value is not showing as string but as some object in Table Editor(Screen1.png).
> After double click on cell string value shows(Screen2.png).
> It is in Base Tables tab and also in Views tab.
> Problem 2 : After setting cardinality in View dialog value is always -1 in Table Editor.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months
[JBoss JIRA] (TEIIDDES-2923) Wrong cardinality value in table editor
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2923?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2923:
--------------------------------------
Assignee: Dan Florian
> Wrong cardinality value in table editor
> ---------------------------------------
>
> Key: TEIIDDES-2923
> URL: https://issues.jboss.org/browse/TEIIDDES-2923
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs, Editors
> Affects Versions: 10.0.2
> Reporter: Mario Majernik
> Assignee: Dan Florian
> Fix For: 10.0.3
>
> Attachments: Screen1.png, Screen2.png
>
>
> Problem 1 : Cardinality value is not showing as string but as some object in Table Editor(Screen1.png).
> After double click on cell string value shows(Screen2.png).
> It is in Base Tables tab and also in Views tab.
> Problem 2 : After setting cardinality in View dialog value is always -1 in Table Editor.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months
[JBoss JIRA] (TEIIDDES-2874) Oracle Views import with no columns via "JDBC Importer"
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2874?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2874:
----------------------------------------
Still no luck. I can uncheck the v1234 View, do a *< Back*, then *Next >* and when I check the v1234 view, the columns show.... but no clue on what's behind the layout/update issue. Pushing to 10.0.3
> Oracle Views import with no columns via "JDBC Importer"
> -------------------------------------------------------
>
> Key: TEIIDDES-2874
> URL: https://issues.jboss.org/browse/TEIIDDES-2874
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.3, 10.0, 9.0.7
> Reporter: Debbie Steigner
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 10.0.3
>
>
> Tested in Teiid Designer 9.0.3, 9.0.7 and 10
> I see the same behavior, using bqt2 on jdbc:oracle:thin:@englxdbs11.mw.lab.eng.bos.redhat.com:1521:orcl there are 2 views, v1234 and smalla_view, if you import both of them only the smalla_view is complete, the v1234 creates the table with no columns.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months
[JBoss JIRA] (TEIIDDES-2874) Oracle Views import with no columns via "JDBC Importer"
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2874?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2874:
-----------------------------------
Fix Version/s: 10.0.3
(was: 10.0.2)
> Oracle Views import with no columns via "JDBC Importer"
> -------------------------------------------------------
>
> Key: TEIIDDES-2874
> URL: https://issues.jboss.org/browse/TEIIDDES-2874
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.3, 10.0, 9.0.7
> Reporter: Debbie Steigner
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 10.0.3
>
>
> Tested in Teiid Designer 9.0.3, 9.0.7 and 10
> I see the same behavior, using bqt2 on jdbc:oracle:thin:@englxdbs11.mw.lab.eng.bos.redhat.com:1521:orcl there are 2 views, v1234 and smalla_view, if you import both of them only the smalla_view is complete, the v1234 creates the table with no columns.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months
[JBoss JIRA] (TEIIDDES-2755) No Quick fix offered after importing VDB with same models
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2755?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2755:
-----------------------------------
Fix Version/s: 10.0.3
(was: 10.0.2)
> No Quick fix offered after importing VDB with same models
> ---------------------------------------------------------
>
> Key: TEIIDDES-2755
> URL: https://issues.jboss.org/browse/TEIIDDES-2755
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Fix For: 10.0.3
>
> Attachments: QT_Greenplum_Push.vdb, QT_MySql50_Push.vdb, Screen Shot 2016-01-12 at 9.57.25 (2).png, Screen Shot 2016-01-12 at 9.57.48 (2).png, Screen Shot 2016-01-12 at 9.58.00 (2).png
>
>
> I have 2 VDBs with models that have same names. After importing the first one and extracting the models, TD doesn't offer this option for the second VDB in second project.
> I can see that the warning says that models are not in +workspace+, but I think TD should check if models are in the +project folder+ not in workspace.
> In the screenshots, you can see that there is no warning for NewProject2.
> VDBs attached.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 8 months