[JBoss JIRA] (TEIIDDES-2502) Incorrect transformation reconciliation
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2502?page=com.atlassian.jira.plu... ]
Van Halbert reassigned TEIIDDES-2502:
-------------------------------------
Assignee: Barry LaFond
> Incorrect transformation reconciliation
> ---------------------------------------
>
> Key: TEIIDDES-2502
> URL: https://issues.jboss.org/browse/TEIIDDES-2502
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling, Transformations
> Affects Versions: 9.0.1
> Environment: 9.0.1.Final-v20150211-1407-B643
> JBDS / Designer on Windows
> Reporter: Tom Johnston
> Assignee: Barry LaFond
>
> SELECT
> proj.*, act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num
> FROM
> ((Table1 AS act LEFT OUTER JOIN Table2 AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN Table4 AS cm ON cm.Contract_ID = f.Contract_ID
> ORDER BY act.Crop_Year
> "resolves"
> to:
> SELECT
> Table2 AS proj.*,
> Table1 AS act.*, cm.Field_Num, cm.Identity_Token,
> f.Plant_Num
> FROM
> ((Table1 AS act LEFT OUTER JOIN
> Table2 AS proj ON proj.Field_ID = act.Field_ID)
> LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN
> Table4 AS cm ON cm.Contract_ID = f.Contract_ID
> ORDER BY act.Crop_Year
> with error:
> ERROR: Error in parsing of sql - Encountered " <ALL_IN_GROUP> "proj.* "" at
> line 2, column 54.
> Was expecting one of:
> "instead" ...
> "enabled" ...
> "disabled" ...
> "view" ...
> "key" ...
> "serial" ...
> "textagg" ...
> "count" ...
> "row_number" ...
> "rank" ...
> "dense_rank" ...
> "sum" ...
> "avg" ...
> "min" ...
> "max" ...
> "every" ...
> "stddev_pop" ...
> "stddev_samp" ...
> "var_samp" ...
> "var_pop" ...
> "document" ...
> "content" ...
> "trim" ...
> "empty" ...
> "ordinality" ...
> "path" ...
> "first" ...
> "last" ...
> "next" ...
> "substring" ...
> "extract" ...
> "to_chars" ...
> "to_bytes" ...
> "timestampadd" ...
> "timestampdiff" ...
> "querystring" ...
> "namespace" ...
> "result" ...
> "index" ...
> "accesspattern" ...
> "auto_increment" ...
> "wellformed" ...
> "sql_tsi_frac_second" ...
> "sql_tsi_second" ...
> "sql_tsi_minute" ...
> "sql_tsi_hour" ...
> "sql_tsi_day" ...
> "sql_tsi_week" ...
> "sql_tsi_month" ...
> "sql_tsi_quarter" ...
> "sql_tsi_year" ...
> "texttable" ...
> "arraytable" ...
> "selector" ...
> "skip" ...
> "width" ...
> "passing" ...
> "name" ...
> "encoding" ...
> "columns" ...
> "delimiter" ...
> "quote" ...
> "header" ...
> "nulls" ...
> "objecttable" ...
> "version" ...
> "including" ...
> "excluding" ...
> "xmldeclaration" ...
> "variadic" ...
> "exception" ...
> "raise" ...
> "chain" ...
> "jsonarray_agg" ...
> "jsonobject" ...
> <ID> ...
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2502) Incorrect transformation reconciliation
by Tom Johnston (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2502?page=com.atlassian.jira.plu... ]
Tom Johnston updated TEIIDDES-2502:
-----------------------------------
Component/s: Modeling
> Incorrect transformation reconciliation
> ---------------------------------------
>
> Key: TEIIDDES-2502
> URL: https://issues.jboss.org/browse/TEIIDDES-2502
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling, Transformations
> Affects Versions: 9.0.1
> Environment: 9.0.1.Final-v20150211-1407-B643
> JBDS / Designer on Windows
> Reporter: Tom Johnston
>
> SELECT
> proj.*, act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num
> FROM
> ((Table1 AS act LEFT OUTER JOIN Table2 AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN Table4 AS cm ON cm.Contract_ID = f.Contract_ID
> ORDER BY act.Crop_Year
> "resolves"
> to:
> SELECT
> Table2 AS proj.*,
> Table1 AS act.*, cm.Field_Num, cm.Identity_Token,
> f.Plant_Num
> FROM
> ((Table1 AS act LEFT OUTER JOIN
> Table2 AS proj ON proj.Field_ID = act.Field_ID)
> LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN
> Table4 AS cm ON cm.Contract_ID = f.Contract_ID
> ORDER BY act.Crop_Year
> with error:
> ERROR: Error in parsing of sql - Encountered " <ALL_IN_GROUP> "proj.* "" at
> line 2, column 54.
> Was expecting one of:
> "instead" ...
> "enabled" ...
> "disabled" ...
> "view" ...
> "key" ...
> "serial" ...
> "textagg" ...
> "count" ...
> "row_number" ...
> "rank" ...
> "dense_rank" ...
> "sum" ...
> "avg" ...
> "min" ...
> "max" ...
> "every" ...
> "stddev_pop" ...
> "stddev_samp" ...
> "var_samp" ...
> "var_pop" ...
> "document" ...
> "content" ...
> "trim" ...
> "empty" ...
> "ordinality" ...
> "path" ...
> "first" ...
> "last" ...
> "next" ...
> "substring" ...
> "extract" ...
> "to_chars" ...
> "to_bytes" ...
> "timestampadd" ...
> "timestampdiff" ...
> "querystring" ...
> "namespace" ...
> "result" ...
> "index" ...
> "accesspattern" ...
> "auto_increment" ...
> "wellformed" ...
> "sql_tsi_frac_second" ...
> "sql_tsi_second" ...
> "sql_tsi_minute" ...
> "sql_tsi_hour" ...
> "sql_tsi_day" ...
> "sql_tsi_week" ...
> "sql_tsi_month" ...
> "sql_tsi_quarter" ...
> "sql_tsi_year" ...
> "texttable" ...
> "arraytable" ...
> "selector" ...
> "skip" ...
> "width" ...
> "passing" ...
> "name" ...
> "encoding" ...
> "columns" ...
> "delimiter" ...
> "quote" ...
> "header" ...
> "nulls" ...
> "objecttable" ...
> "version" ...
> "including" ...
> "excluding" ...
> "xmldeclaration" ...
> "variadic" ...
> "exception" ...
> "raise" ...
> "chain" ...
> "jsonarray_agg" ...
> "jsonobject" ...
> <ID> ...
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2512) Problems with starting DV server from Teiid Designer 9.0.2.Beta1
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2512?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2512:
----------------------------------------
Which version of DV was this? (6.1GA?)
Can you verify the Teiid Version in your DV?
The exception indicated "incorrect security credentials". Are you starting via command-line first, then setting up a New Server or creating New Server and starting from JBDS?
> Problems with starting DV server from Teiid Designer 9.0.2.Beta1
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2512
> URL: https://issues.jboss.org/browse/TEIIDDES-2512
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.2 Beta1
> Reporter: Matus Makovy
> Priority: Minor
> Attachments: Screen Shot 2015-05-06 at 2.36.38 PM.png
>
>
> When I try to start DV server from JBDS it starts normaly, but following exception occures (screenshot attached) :
> org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: Could not execute "read-children-names" for undefined. Failure was "JBAS013493: System boot is in process; execution of remote management operations is not currently available".
> at org.jboss.ide.eclipse.as.internal.management.as71.AS71Manager.execute(AS71Manager.java:342)
> at org.jboss.ide.eclipse.as.internal.management.as71.JBoss71ManagerService.execute(JBoss71ManagerService.java:171)
> at org.jboss.ide.eclipse.as.management.core.JBoss7ManagerServiceProxy.execute(JBoss7ManagerServiceProxy.java:87)
> at org.teiid.designer.runtime.adapter.JBoss7ServerUtil.executeRequest(JBoss7ServerUtil.java:66)
> at org.teiid.designer.runtime.adapter.JBoss7ServerUtil.isTeiidServer(JBoss7ServerUtil.java:192)
> at org.teiid.designer.runtime.adapter.TeiidServerAdapterFactory.adaptJBoss7Server(TeiidServerAdapterFactory.java:181)
> at org.teiid.designer.runtime.adapter.TeiidServerAdapterFactory.adaptServer(TeiidServerAdapterFactory.java:82)
> at org.teiid.designer.runtime.TeiidParentServerListener$1.tryConnecting(TeiidParentServerListener.java:208)
> at org.teiid.designer.runtime.TeiidParentServerListener$1.run(TeiidParentServerListener.java:177)
> at java.lang.Thread.run(Thread.java:744)
> Caused by: org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: Could not execute "read-children-names" for undefined. Failure was "JBAS013493: System boot is in process; execution of remote management operations is not currently available".
> at org.jboss.ide.eclipse.as.internal.management.as71.AS71Manager.execute(AS71Manager.java:333)
> ... 9 more
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2512) Problems with starting DV server from Teiid Designer 9.0.2.Beta1
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2512?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration updated TEIIDDES-2512:
----------------------------------------------
Bugzilla Update: Perform
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1219036
> Problems with starting DV server from Teiid Designer 9.0.2.Beta1
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2512
> URL: https://issues.jboss.org/browse/TEIIDDES-2512
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.2 Beta1
> Reporter: Matus Makovy
> Priority: Minor
> Attachments: Screen Shot 2015-05-06 at 2.36.38 PM.png
>
>
> When I try to start DV server from JBDS it starts normaly, but following exception occures (screenshot attached) :
> org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: Could not execute "read-children-names" for undefined. Failure was "JBAS013493: System boot is in process; execution of remote management operations is not currently available".
> at org.jboss.ide.eclipse.as.internal.management.as71.AS71Manager.execute(AS71Manager.java:342)
> at org.jboss.ide.eclipse.as.internal.management.as71.JBoss71ManagerService.execute(JBoss71ManagerService.java:171)
> at org.jboss.ide.eclipse.as.management.core.JBoss7ManagerServiceProxy.execute(JBoss7ManagerServiceProxy.java:87)
> at org.teiid.designer.runtime.adapter.JBoss7ServerUtil.executeRequest(JBoss7ServerUtil.java:66)
> at org.teiid.designer.runtime.adapter.JBoss7ServerUtil.isTeiidServer(JBoss7ServerUtil.java:192)
> at org.teiid.designer.runtime.adapter.TeiidServerAdapterFactory.adaptJBoss7Server(TeiidServerAdapterFactory.java:181)
> at org.teiid.designer.runtime.adapter.TeiidServerAdapterFactory.adaptServer(TeiidServerAdapterFactory.java:82)
> at org.teiid.designer.runtime.TeiidParentServerListener$1.tryConnecting(TeiidParentServerListener.java:208)
> at org.teiid.designer.runtime.TeiidParentServerListener$1.run(TeiidParentServerListener.java:177)
> at java.lang.Thread.run(Thread.java:744)
> Caused by: org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: Could not execute "read-children-names" for undefined. Failure was "JBAS013493: System boot is in process; execution of remote management operations is not currently available".
> at org.jboss.ide.eclipse.as.internal.management.as71.AS71Manager.execute(AS71Manager.java:333)
> ... 9 more
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2512) Problems with starting DV server from Teiid Designer 9.0.2.Beta1
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2512?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2512:
-----------------------------------
Attachment: Screen Shot 2015-05-06 at 2.36.38 PM.png
> Problems with starting DV server from Teiid Designer 9.0.2.Beta1
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2512
> URL: https://issues.jboss.org/browse/TEIIDDES-2512
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.2 Beta1
> Reporter: Matus Makovy
> Priority: Minor
> Attachments: Screen Shot 2015-05-06 at 2.36.38 PM.png
>
>
> When I try to start DV server from JBDS it starts normaly, but following exception occures (screenshot attached) :
> org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: Could not execute "read-children-names" for undefined. Failure was "JBAS013493: System boot is in process; execution of remote management operations is not currently available".
> at org.jboss.ide.eclipse.as.internal.management.as71.AS71Manager.execute(AS71Manager.java:342)
> at org.jboss.ide.eclipse.as.internal.management.as71.JBoss71ManagerService.execute(JBoss71ManagerService.java:171)
> at org.jboss.ide.eclipse.as.management.core.JBoss7ManagerServiceProxy.execute(JBoss7ManagerServiceProxy.java:87)
> at org.teiid.designer.runtime.adapter.JBoss7ServerUtil.executeRequest(JBoss7ServerUtil.java:66)
> at org.teiid.designer.runtime.adapter.JBoss7ServerUtil.isTeiidServer(JBoss7ServerUtil.java:192)
> at org.teiid.designer.runtime.adapter.TeiidServerAdapterFactory.adaptJBoss7Server(TeiidServerAdapterFactory.java:181)
> at org.teiid.designer.runtime.adapter.TeiidServerAdapterFactory.adaptServer(TeiidServerAdapterFactory.java:82)
> at org.teiid.designer.runtime.TeiidParentServerListener$1.tryConnecting(TeiidParentServerListener.java:208)
> at org.teiid.designer.runtime.TeiidParentServerListener$1.run(TeiidParentServerListener.java:177)
> at java.lang.Thread.run(Thread.java:744)
> Caused by: org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: Could not execute "read-children-names" for undefined. Failure was "JBAS013493: System boot is in process; execution of remote management operations is not currently available".
> at org.jboss.ide.eclipse.as.internal.management.as71.AS71Manager.execute(AS71Manager.java:333)
> ... 9 more
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2512) Problems with starting DV server from Teiid Designer 9.0.2.Beta1
by Matus Makovy (JIRA)
Matus Makovy created TEIIDDES-2512:
--------------------------------------
Summary: Problems with starting DV server from Teiid Designer 9.0.2.Beta1
Key: TEIIDDES-2512
URL: https://issues.jboss.org/browse/TEIIDDES-2512
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 9.0.2 Beta1
Reporter: Matus Makovy
Priority: Minor
Attachments: Screen Shot 2015-05-06 at 2.36.38 PM.png
When I try to start DV server from JBDS it starts normaly, but following exception occures (screenshot attached) :
org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: Could not execute "read-children-names" for undefined. Failure was "JBAS013493: System boot is in process; execution of remote management operations is not currently available".
at org.jboss.ide.eclipse.as.internal.management.as71.AS71Manager.execute(AS71Manager.java:342)
at org.jboss.ide.eclipse.as.internal.management.as71.JBoss71ManagerService.execute(JBoss71ManagerService.java:171)
at org.jboss.ide.eclipse.as.management.core.JBoss7ManagerServiceProxy.execute(JBoss7ManagerServiceProxy.java:87)
at org.teiid.designer.runtime.adapter.JBoss7ServerUtil.executeRequest(JBoss7ServerUtil.java:66)
at org.teiid.designer.runtime.adapter.JBoss7ServerUtil.isTeiidServer(JBoss7ServerUtil.java:192)
at org.teiid.designer.runtime.adapter.TeiidServerAdapterFactory.adaptJBoss7Server(TeiidServerAdapterFactory.java:181)
at org.teiid.designer.runtime.adapter.TeiidServerAdapterFactory.adaptServer(TeiidServerAdapterFactory.java:82)
at org.teiid.designer.runtime.TeiidParentServerListener$1.tryConnecting(TeiidParentServerListener.java:208)
at org.teiid.designer.runtime.TeiidParentServerListener$1.run(TeiidParentServerListener.java:177)
at java.lang.Thread.run(Thread.java:744)
Caused by: org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: Could not execute "read-children-names" for undefined. Failure was "JBAS013493: System boot is in process; execution of remote management operations is not currently available".
at org.jboss.ide.eclipse.as.internal.management.as71.AS71Manager.execute(AS71Manager.java:333)
... 9 more
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2511) Import from SOAP WS problems with View model
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2511?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration updated TEIIDDES-2511:
----------------------------------------------
Bugzilla Update: Perform
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1219010
> Import from SOAP WS problems with View model
> --------------------------------------------
>
> Key: TEIIDDES-2511
> URL: https://issues.jboss.org/browse/TEIIDDES-2511
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.2 Beta1
> Reporter: Matus Makovy
> Priority: Blocker
> Attachments: screen.png
>
>
> After finishing import from SOAP WS, View model reports problem.
> Some SWTException -> See attachment
> Also, I am importing two procedures "FullCountryInfo()" and "FullCountryInfoAllCountries()" and I see only one procedure in the View model.
> Lastly, I think that there is one part missing. For example after import of procedure "FullCountryInfo" I should have in the view model 3 procedures: "FullCountryInfo_request" , "FullCountryInfo_response" and "FullCountryInfo" and there are only 2 of them. See screenshot
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2511) Import from SOAP WS problems with View model
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2511?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2511:
-----------------------------------
Attachment: screen.png
> Import from SOAP WS problems with View model
> --------------------------------------------
>
> Key: TEIIDDES-2511
> URL: https://issues.jboss.org/browse/TEIIDDES-2511
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.2 Beta1
> Reporter: Matus Makovy
> Priority: Blocker
> Attachments: screen.png
>
>
> After finishing import from SOAP WS, View model reports problem.
> Some SWTException -> See attachment
> Also, I am importing two procedures "FullCountryInfo()" and "FullCountryInfoAllCountries()" and I see only one procedure in the View model.
> Lastly, I think that there is one part missing. For example after import of procedure "FullCountryInfo" I should have in the view model 3 procedures: "FullCountryInfo_request" , "FullCountryInfo_response" and "FullCountryInfo" and there are only 2 of them. See screenshot
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months