[JBoss JIRA] (TEIIDDES-2719) DDL for UDF in exported dynamic VDB contains RETURN parameter
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2719?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2719.
------------------------------------
Resolution: Done
master: https://github.com/Teiid-Designer/teiid-designer/commit/3b6ca2f023ea4d6c0...
> DDL for UDF in exported dynamic VDB contains RETURN parameter
> -------------------------------------------------------------
>
> Key: TEIIDDES-2719
> URL: https://issues.jboss.org/browse/TEIIDDES-2719
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Import/Export, Patch Release
> Affects Versions: 9.2
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 9.2.1
>
> Attachments: UdfProject.zip
>
>
> When exporting VDB with a UDF, the resulting DDL contains the RETURN parameter in the parameters list. According to the [Teiid docs|https://docs.jboss.org/author/display/teiid87final/Support+for+User-...], the return parameter should not be specified.
> Generated DDL:
> {code:sql}
> CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000), result string(4000)) RETURNS string
> ) OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')
> {code}
> Expected DDL:
> {code:sql}
> CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000)) RETURNS string
> OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')
> {code}
> (note that the generated DDL also contains an unrelated syntax error due to TEIIDDES-2697)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2731) VDB exported to Dynamic VDB XML, the foreign key relations have erroneous references in the resulting SQL.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2731?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2731.
------------------------------------
Resolution: Done
master: https://github.com/Teiid-Designer/teiid-designer/commit/e03f7c21f69397830...
> VDB exported to Dynamic VDB XML, the foreign key relations have erroneous references in the resulting SQL.
> -------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2731
> URL: https://issues.jboss.org/browse/TEIIDDES-2731
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Import/Export, Patch Release
> Affects Versions: 9.2
> Reporter: Debbie Steigner
> Assignee: Barry LaFond
> Fix For: 9.2.1
>
> Attachments: TestcaseforExport.zip
>
>
> Model:
> • Catalog (ID, SecondID, ThirdID). Primary key: (ID). Unique constraint: (SecondID, ThirdID)
> • CatalogItem(ID,CatalogID, CatalogSecondID, CatalogThirdID)
> Foreign key relation on Unique constraints, spanning two columns: CatalogItem(CatalogSecondID, CatalogThirdID) Catalog(SecondID, ThirdID)
> Expected in metadata DLL for CatalogItem:
> CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(SecondID, ThirdID)
> Actual:
> CONSTRAINT FKI_SECOND_THIRD_ID FOREIGN KEY(CatalogSecondID, CatalogThirdID) REFERENCES Catalog(ID)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2414) Large transformation SQL is not exported to INDEX file.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2414?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2414.
------------------------------------
Resolution: Done
> Large transformation SQL is not exported to INDEX file.
> -------------------------------------------------------
>
> Key: TEIIDDES-2414
> URL: https://issues.jboss.org/browse/TEIIDDES-2414
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export, Patch Release
> Affects Versions: 8.3.4
> Reporter: Hisanobu Okuda
> Assignee: Paul Richardson
> Fix For: 9.2.1
>
> Attachments: reosurce-problem-marker.png, test.csv
>
>
> A large transformation SQL of a view model is not exported to INDEX file.
> I have a large transformation SQL > 8192 bytes in my view model. TDesigner fails to convert the xmi to XXXXXXXXXX.INDEX file. There is no transformation SQL in the INDEX file, therefore, deploying my vdb fails and the vdb is inactivated. When you deploy the vdb, you can see the following message in a log file:-
> {code}
> 17:16:11,632 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31079 View ViewModel.new_table is not defined by a query expression.
> 17:16:11,636 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40073 The metadata for the VDB test.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.
> 17:16:11,637 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB test.1 is set to FAILED
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2711) WS Create Operation - Wrong Label Name For Output Message
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2711?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2711:
-----------------------------------
Fix Version/s: 9.2.1
(was: 10.0)
> WS Create Operation - Wrong Label Name For Output Message
> ---------------------------------------------------------
>
> Key: TEIIDDES-2711
> URL: https://issues.jboss.org/browse/TEIIDDES-2711
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Matus Makovy
> Priority: Minor
> Fix For: 9.2.1
>
> Attachments: Selection_030.png
>
>
> Coppied from BZ:
> Description of problem:
> "Input Message" label is used for both input message and output message
> Version-Release number of selected component (if applicable):
> Teiid Designer 9.0.3.Final-v205 (latest on the customer portal)
> How reproducible:
> Steps to Reproduce:
> 1. Open a webservice model,
> 2. Select one of the interfaces, right click on it and choose create operation from the menu
> See attached screenshot
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2711) WS Create Operation - Wrong Label Name For Output Message
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2711?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2711.
------------------------------------
Resolution: Done
> WS Create Operation - Wrong Label Name For Output Message
> ---------------------------------------------------------
>
> Key: TEIIDDES-2711
> URL: https://issues.jboss.org/browse/TEIIDDES-2711
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Matus Makovy
> Priority: Minor
> Fix For: 9.2.1
>
> Attachments: Selection_030.png
>
>
> Coppied from BZ:
> Description of problem:
> "Input Message" label is used for both input message and output message
> Version-Release number of selected component (if applicable):
> Teiid Designer 9.0.3.Final-v205 (latest on the customer portal)
> How reproducible:
> Steps to Reproduce:
> 1. Open a webservice model,
> 2. Select one of the interfaces, right click on it and choose create operation from the menu
> See attached screenshot
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2685) IllegalArgumentException: server when starting Fuse server
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2685?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2685:
-----------------------------------
Labels: release_notes verified_jbdsis-8.0.4.CR3 (was: verified_jbdsis-8.0.4.CR3)
> IllegalArgumentException: server when starting Fuse server
> ----------------------------------------------------------
>
> Key: TEIIDDES-2685
> URL: https://issues.jboss.org/browse/TEIIDDES-2685
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.4
> Environment: JBDS 8.1.0.GA + JBDS-IS 8.0.4.CR1
> Reporter: Andrej Podhradsky
> Labels: release_notes, verified_jbdsis-8.0.4.CR3
> Fix For: 9.0.4, 9.2.1
>
>
> When starting Fuse server on JBDS with Teiid Designer I usually see the following error
> {code}
> java.lang.IllegalArgumentException: server
> at org.teiid.core.designer.util.CoreArgCheck.isNotNull(CoreArgCheck.java:142)
> at org.teiid.designer.runtime.TeiidServerManager.removeServer(TeiidServerManager.java:544)
> at org.teiid.designer.runtime.TeiidParentServerListener$1.tryConnecting(TeiidParentServerListener.java:253)
> at org.teiid.designer.runtime.TeiidParentServerListener$1.run(TeiidParentServerListener.java:184)
> at java.lang.Thread.run(Thread.java:745)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2685) IllegalArgumentException: server when starting Fuse server
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2685?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2685.
----------------------------------
> IllegalArgumentException: server when starting Fuse server
> ----------------------------------------------------------
>
> Key: TEIIDDES-2685
> URL: https://issues.jboss.org/browse/TEIIDDES-2685
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.4
> Environment: JBDS 8.1.0.GA + JBDS-IS 8.0.4.CR1
> Reporter: Andrej Podhradsky
> Labels: release_notes, verified_jbdsis-8.0.4.CR3
> Fix For: 9.0.4, 9.2.1
>
>
> When starting Fuse server on JBDS with Teiid Designer I usually see the following error
> {code}
> java.lang.IllegalArgumentException: server
> at org.teiid.core.designer.util.CoreArgCheck.isNotNull(CoreArgCheck.java:142)
> at org.teiid.designer.runtime.TeiidServerManager.removeServer(TeiidServerManager.java:544)
> at org.teiid.designer.runtime.TeiidParentServerListener$1.tryConnecting(TeiidParentServerListener.java:253)
> at org.teiid.designer.runtime.TeiidParentServerListener$1.run(TeiidParentServerListener.java:184)
> at java.lang.Thread.run(Thread.java:745)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2685) IllegalArgumentException: server when starting Fuse server
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2685?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2685:
-----------------------------------
Labels: verified_jbdsis-8.0.4.CR3 (was: )
> IllegalArgumentException: server when starting Fuse server
> ----------------------------------------------------------
>
> Key: TEIIDDES-2685
> URL: https://issues.jboss.org/browse/TEIIDDES-2685
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.4
> Environment: JBDS 8.1.0.GA + JBDS-IS 8.0.4.CR1
> Reporter: Andrej Podhradsky
> Labels: verified_jbdsis-8.0.4.CR3
> Fix For: 9.0.4, 9.2.1
>
>
> When starting Fuse server on JBDS with Teiid Designer I usually see the following error
> {code}
> java.lang.IllegalArgumentException: server
> at org.teiid.core.designer.util.CoreArgCheck.isNotNull(CoreArgCheck.java:142)
> at org.teiid.designer.runtime.TeiidServerManager.removeServer(TeiidServerManager.java:544)
> at org.teiid.designer.runtime.TeiidParentServerListener$1.tryConnecting(TeiidParentServerListener.java:253)
> at org.teiid.designer.runtime.TeiidParentServerListener$1.run(TeiidParentServerListener.java:184)
> at java.lang.Thread.run(Thread.java:745)
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years