October 2016 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2819) Add HTTP Digest Authentication Support for SOAP Web Services as a Source

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2819?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2819. ---------------------------------- > Add HTTP Digest Authentication Support for SOAP Web Services as a Source > ------------------------------------------------------------------------ > > Key: TEIIDDES-2819 > URL: https://issues.jboss.org/browse/TEIIDDES-2819 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export, Patch Release, Web Services Support > Affects Versions: 9.0.3, 9.2.1 > Reporter: Ted Jones > Assignee: Ted Jones > Priority: Blocker > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > > Need to support importing REST web services that use HTTP Digest authentication -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2819) Add HTTP Digest Authentication Support for SOAP Web Services as a Source

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2819?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2819: ----------------------------------- Labels: release_notes verified_jbdsis-9.0.3 (was: ) > Add HTTP Digest Authentication Support for SOAP Web Services as a Source > ------------------------------------------------------------------------ > > Key: TEIIDDES-2819 > URL: https://issues.jboss.org/browse/TEIIDDES-2819 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export, Patch Release, Web Services Support > Affects Versions: 9.0.3, 9.2.1 > Reporter: Ted Jones > Assignee: Ted Jones > Priority: Blocker > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > > Need to support importing REST web services that use HTTP Digest authentication -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2788) Access Pattern not generated when exporting dynamic VDB

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2788?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-2788: ----------------------------------- Labels: release_notes verified_jbdsis-9.0.3 (was: ) > Access Pattern not generated when exporting dynamic VDB > ------------------------------------------------------- > > Key: TEIIDDES-2788 > URL: https://issues.jboss.org/browse/TEIIDDES-2788 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > Attachments: APproj.zip > > > When exporting a dynamic VDB, access pattern constrains on model tables are not exported. > Actual DDL: > {code:sql} > CREATE FOREIGN TABLE s1 ( > newColumn_1 string(4000), > newColumn_2 string(4000) > ) > {code} > Expected DDL: > {code:sql} > CREATE FOREIGN TABLE s1 ( > newColumn_1 string(4000), > newColumn_2 string(4000), > CONSTRAINT NewAccessPattern ACCESSPATTERN (newColumn_1) > ) > {code} -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2851) Warning shown during generation of dynamic VDB with UDF has wrong title

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2851?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2851: ----------------------------------- Labels: release_notes verified_jbdsis-9.0.3 (was: ) > Warning shown during generation of dynamic VDB with UDF has wrong title > ----------------------------------------------------------------------- > > Key: TEIIDDES-2851 > URL: https://issues.jboss.org/browse/TEIIDDES-2851 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.1 > Environment: MAC OS > Reporter: Matus Makovy > Assignee: Matus Makovy > Priority: Minor > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > Attachments: Screen Shot 2016-06-06 at 8.52.46.png > > > Warning shown during generation of dynamic VDB has wrong title. The title is: +Generate Dynamic VDB Status{color:red}",{color}+. The {color:red}",{color} shouldn't be there. > See screenshot -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2851) Warning shown during generation of dynamic VDB with UDF has wrong title

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2851?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2851. ---------------------------------- > Warning shown during generation of dynamic VDB with UDF has wrong title > ----------------------------------------------------------------------- > > Key: TEIIDDES-2851 > URL: https://issues.jboss.org/browse/TEIIDDES-2851 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 10.0.1 > Environment: MAC OS > Reporter: Matus Makovy > Assignee: Matus Makovy > Priority: Minor > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > Attachments: Screen Shot 2016-06-06 at 8.52.46.png > > > Warning shown during generation of dynamic VDB has wrong title. The title is: +Generate Dynamic VDB Status{color:red}",{color}+. The {color:red}",{color} shouldn't be there. > See screenshot -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2951) Designer haven't set password to datasource which is created before preview.

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2951?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2951. ------------------------------------ Resolution: Done 10.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/cbf972bea16eb48e7... > Designer haven't set password to datasource which is created before preview. > ---------------------------------------------------------------------------- > > Key: TEIIDDES-2951 > URL: https://issues.jboss.org/browse/TEIIDDES-2951 > Project: Teiid Designer > Issue Type: Bug > Components: Data Preview > Affects Versions: 10.0.2 > Environment: Fedora 24 > Reporter: Matej Kralik > Assignee: Barry LaFond > Priority: Critical > Fix For: 10.0.2 > > Attachments: screenshot1.png, screenshot2.png > > > I generated source model from a database (SQL Server) via JDBC. When I go through wizard I haven't started server so the data source haven't been set (screenshot1). I started a server and I wanted to preview data, shows me dialog ([TEIIDDES-2904|https://issues.jboss.org/browse/TEIIDDES-2904]) if I had wanted to create DS. I clicked yes and ok but server shows error: > {code:java} > org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for SQL_Server_2008_Books were not available. The command could not be planned properly. > {code} > I tried to create the data source (with the same name) manually but the error is still there [TEIIDDES-2950|https://issues.jboss.org/browse/TEIIDDES-2950]. I had to delete data source from the server and create it again or set another name of the datasource. > I deleted datasource. > When I generated a model from a database via JDBC again (but a server was running) and I checked Auto-create Data Source (screenshot2), preview worked fine. > So I notice that datasource haven't set a password when DS is created before the preview. > I looked to standalone.xml > Datasource which is created before preview: > {code:java} > datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true"> > <connection-url>connection url</connection-url> > <driver>sqljdbc4.jar</driver> > <security> > <user-name>books</user-name> > </security> > </datasource> > {code} > Datasource which is created in the import wizard: > {code:java} > <datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true"> > <connection-url>connection url</connection-url> > <driver>sqljdbc4.jar</driver> > <security> > <user-name>books</user-name> > <password>**</password> > </security> > </datasource> > {code} -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2930) Dynamic VDB should contain full path to the materialized table

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2930?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2930: ---------------------------------------- The generated vdb.xml below shows the following 2 table references which I looks correct? "OBJECT_NS:primary_table" 'CustomerMatCache.Customer' in *CustomerMatCache* source model MATERIALIZED_TABLE 'CustomerMatCache.Customer' property in the *CustomerViewMat* view model {code} <?xml version="1.0" encoding="UTF-8" standalone="no"?> <vdb name="MyVDB" version="1"> <description/> <property name="validationDateTime" value="Wed Oct 26 15:20:03 CDT 2016"/> <property name="validationVersion" value="8.12.4"/> <model name="CustomerMatCache"> <source connection-jndi-name="CustomerMatCache" name="CustomerMatCache" translator-name="infinspan1"/> <metadata type="DDL"><![CDATA[ SET NAMESPACE 'http://www.teiid.org/translator/object/2016' AS OBJECT_NS; CREATE FOREIGN TABLE Customer ( id integer NOT NULL OPTIONS(FIXED_LENGTH 'TRUE'), name string(100) NOT NULL, email string(100) NOT NULL, male boolean NOT NULL OPTIONS(FIXED_LENGTH 'TRUE'), CONSTRAINT pk_id PRIMARY KEY(id) ) OPTIONS(UPDATABLE 'TRUE') CREATE FOREIGN TABLE ST_Customer ( id integer NOT NULL OPTIONS(FIXED_LENGTH 'TRUE'), name string(100) NOT NULL, email string(100) NOT NULL, male boolean NOT NULL OPTIONS(FIXED_LENGTH 'TRUE'), CONSTRAINT pk_id PRIMARY KEY(id) ) OPTIONS(UPDATABLE 'TRUE', "OBJECT_NS:primary_table" 'CustomerMatCache.Customer') ]]></metadata> </model> <model name="sourceMSQmodel"> <source connection-jndi-name="New_MySQL_DS" name="sourceMSQmodel" translator-name="mysql5"/> <metadata type="DDL"><![CDATA[ CREATE FOREIGN TABLE testJDG.customers ( id integer NOT NULL OPTIONS(NAMEINSOURCE '`id`', NATIVE_TYPE 'INT', FIXED_LENGTH 'TRUE'), name string(100) NOT NULL OPTIONS(NAMEINSOURCE '`name`', NATIVE_TYPE 'VARCHAR'), e_mail string(100) NOT NULL OPTIONS(NAMEINSOURCE '`e-mail`', NATIVE_TYPE 'VARCHAR'), male boolean NOT NULL OPTIONS(NAMEINSOURCE '`male`', NATIVE_TYPE 'BIT', FIXED_LENGTH 'TRUE'), CONSTRAINT "PRIMARY" PRIMARY KEY(id) ) OPTIONS(NAMEINSOURCE '`testJDG`.`customers`', UPDATABLE 'TRUE') CREATE FOREIGN TABLE testJDG.status ( VDBName string(50) NOT NULL OPTIONS(NAMEINSOURCE '`VDBName`', NATIVE_TYPE 'VARCHAR'), VDBVersion integer NOT NULL OPTIONS(NAMEINSOURCE '`VDBVersion`', NATIVE_TYPE 'INT', FIXED_LENGTH 'TRUE'), SchemaName string(50) NOT NULL OPTIONS(NAMEINSOURCE '`SchemaName`', NATIVE_TYPE 'VARCHAR'), Name string(256) NOT NULL OPTIONS(NAMEINSOURCE '`Name`', NATIVE_TYPE 'VARCHAR'), TargetSchemaName string(50) OPTIONS(NAMEINSOURCE '`TargetSchemaName`', NATIVE_TYPE 'VARCHAR'), TargetName string(256) NOT NULL OPTIONS(NAMEINSOURCE '`TargetName`', NATIVE_TYPE 'VARCHAR'), Valid boolean NOT NULL OPTIONS(NAMEINSOURCE '`Valid`', NATIVE_TYPE 'BIT', FIXED_LENGTH 'TRUE'), LoadState string(25) NOT NULL OPTIONS(NAMEINSOURCE '`LoadState`', NATIVE_TYPE 'VARCHAR'), Cardinality long OPTIONS(NAMEINSOURCE '`Cardinality`', NATIVE_TYPE 'BIGINT', FIXED_LENGTH 'TRUE'), Updated timestamp NOT NULL DEFAULT 'CURRENT_TIMESTAMP' OPTIONS(NAMEINSOURCE '`Updated`', NATIVE_TYPE 'TIMESTAMP', FIXED_LENGTH 'TRUE'), LoadNumber long NOT NULL OPTIONS(NAMEINSOURCE '`LoadNumber`', NATIVE_TYPE 'BIGINT', FIXED_LENGTH 'TRUE'), CONSTRAINT "PRIMARY" PRIMARY KEY(VDBName, VDBVersion, SchemaName, Name) ) OPTIONS(NAMEINSOURCE '`testJDG`.`status`', UPDATABLE 'TRUE') ]]></metadata> </model> <model name="CustomerViewModel" type="VIRTUAL"> <property name="imports" value="sourceMSQmodel"/> <metadata type="DDL"><![CDATA[ CREATE VIEW viewCustomer ( id integer NOT NULL OPTIONS(FIXED_LENGTH 'TRUE'), name string(100) NOT NULL, email string(100) NOT NULL, male boolean NOT NULL OPTIONS(FIXED_LENGTH 'TRUE') ) OPTIONS(UPDATABLE 'TRUE') AS SELECT sourceMSQmodel.testJDG.customers.id, sourceMSQmodel.testJDG.customers.name, sourceMSQmodel.testJDG.customers.e_mail AS email, sourceMSQmodel.testJDG.customers.male FROM sourceMSQmodel.testJDG.customers; ]]></metadata> </model> <model name="CustomerViewMat" type="VIRTUAL"> <property name="imports" value="sourceMSQmodel"/> <metadata type="DDL"><![CDATA[ CREATE VIEW Customer ( id integer NOT NULL OPTIONS(FIXED_LENGTH 'TRUE'), name string(100) NOT NULL, email string(100) NOT NULL, male boolean NOT NULL OPTIONS(FIXED_LENGTH 'TRUE'), CONSTRAINT pk_id PRIMARY KEY(id) ) OPTIONS(MATERIALIZED 'TRUE', UPDATABLE 'TRUE', MATERIALIZED_TABLE 'CustomerMatCache.Customer', "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'TRUE', "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute CustomerMatCache.native(''swap cache names'');', "teiid_rel:MATVIEW_STATUS_TABLE" 'sourceMSQmodel.testJDG.status', "teiid_rel:MATVIEW_TTL" '60000', "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute CustomerMatCache.native(''truncate cache'');', "teiid_rel:MATVIEW_LOAD_SCRIPT" 'insert into CustomerMatCache.Customer (name, id, email, male) SELECT name, id, email, male FROM CustomerViewModel.viewCustomer') AS SELECT * FROM CustomerViewModel.viewCustomer ; ]]></metadata> </model> </vdb> {code} > Dynamic VDB should contain full path to the materialized table > -------------------------------------------------------------- > > Key: TEIIDDES-2930 > URL: https://issues.jboss.org/browse/TEIIDDES-2930 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs > Affects Versions: 10.0.2 > Environment: Fedora 24 > Reporter: Matej Kralik > Assignee: Barry LaFond > Fix For: 10.0.2 > > Attachments: completeJDGproject.zip, customer-cache-table-info.png, customer-view-info.png, jdgCustomer.zip, screenshot1.png, screenshotProp.png > > > I have a table (CustomerViewMat.Customer) and I set materialized table to another model (CustomerMatCache.Customer) (screenshot1) .I create VDB and dynamic VDB. When I want to deploy this dynamic VDB to the server, server shows me error: > TEIID31088 The materialization table Customer defined on view CustomerViewMat.Customer, must be defined with "schema" qualifier that represents PHYSICAL model. > I noticed that in the dynamicVDB in the CustomerViewMat model is: > {code:java} > OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'Customer', "teiid_rel: ... > {code} > I think that this happens because Customer table is in the CustomerViewMat and CustomerMatCache too. But in the properties (Screenshot1) is set correctly model. (CustomerMatCache) > When I set full path, vdb was deployed sucessfully > {code:java} > OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'CustomerMatCache.Customer', "teiid_rel: ... > {code} -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2887) Unable to edit the admin port on the Teiid Instance Tab

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2887?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2887: ----------------------------------- Fix Version/s: 10.0.3 (was: 10.0.2) > Unable to edit the admin port on the Teiid Instance Tab > ------------------------------------------------------- > > Key: TEIIDDES-2887 > URL: https://issues.jboss.org/browse/TEIIDDES-2887 > Project: Teiid Designer > Issue Type: Bug > Components: Usability > Affects Versions: 10.0.2 > Reporter: Van Halbert > Assignee: Barry LaFond > Priority: Critical > Fix For: 10.0.3 > > > When the DV server is started with port offsets means that in Teiid Designer, the Teiid Instance tab, the admin port needs to be adjusted accordingly. However, its not editable and doesn't pull its info from the Overview tab when port offsets are configured. This issue arises in cases where the server is externally administered and you don't wan to have to install a local EAP instance in order to manage it. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2887) Unable to edit the admin port on the Teiid Instance Tab

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2887?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2887: ---------------------------------------- Appears that JBIDE-22008 is probablty the culprit and isn't fixed in the Mars JBoss target platform. This issue is preventing connecting via http-remote connection using port offset. * Paul Richardson has updated Designer's master branch to the Neon target platform and already verified that it works. But 10.0.2 is releasing against Mars. Pushing to 10.0.3 for now. > Unable to edit the admin port on the Teiid Instance Tab > ------------------------------------------------------- > > Key: TEIIDDES-2887 > URL: https://issues.jboss.org/browse/TEIIDDES-2887 > Project: Teiid Designer > Issue Type: Bug > Components: Usability > Affects Versions: 10.0.2 > Reporter: Van Halbert > Assignee: Barry LaFond > Priority: Critical > Fix For: 10.0.2 > > > When the DV server is started with port offsets means that in Teiid Designer, the Teiid Instance tab, the admin port needs to be adjusted accordingly. However, its not editable and doesn't pull its info from the Overview tab when port offsets are configured. This issue arises in cases where the server is externally administered and you don't wan to have to install a local EAP instance in order to manage it. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2881) Sizing issue in Teiid designer

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2881?page=com.atlassian.jira.plu... ] Matus Makovy reopened TEIIDDES-2881: ------------------------------------ This is still an issue with TD 10.0.2. I can still completely hide the sort button on the right side and partially hide the type resolver button. > Sizing issue in Teiid designer > ------------------------------ > > Key: TEIIDDES-2881 > URL: https://issues.jboss.org/browse/TEIIDDES-2881 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 10.0.1 > Reporter: Harshul Madan > Assignee: Barry LaFond > Fix For: 10.0.2 > > Attachments: Screen Shot 2016-07-22 at 9.01.00 AM.png, Screen Shot 2016-07-22 at 9.01.16 AM-1.png > > > When we click on “Reconciler” icon in Transformation editor. The components in the window which opens is not programmed to support different screen size (i.e. doesn’t scale adequately). > Details: > MacBook Pro (Retina, 13.3-inch (2560 x 1600)) > Teiid Designer 9.0 -- This message was sent by Atlassian JIRA (v7.2.2#72004)

7 years, 7 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues October 2016