May 2015 - teiid-designer-issues - Jboss List Archives

[JBoss JIRA] (TEIIDDES-2511) Import from SOAP WS problems with View model

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2511?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2511: ----------------------------------- Fix Version/s: 9.1 9.0.2 > 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 > Assignee: Barry LaFond > Priority: Blocker > Fix For: 9.1, 9.0.2 > > 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

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2506) NPE when attempting to finish REST import

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2506?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2506: ----------------------------------- Fix Version/s: 9.1 9.0.2 > NPE when attempting to finish REST import > ----------------------------------------- > > Key: TEIIDDES-2506 > URL: https://issues.jboss.org/browse/TEIIDDES-2506 > Project: Teiid Designer > Issue Type: Bug > Components: Web Services Support > Affects Versions: 9.0 > Environment: Mac > JBDS Version: 8.0.0.GA > Build id: GA-v20141020-1042-B317 > Teiid Designer version: 9.0.1.Final-v20150211-1407-B643 > Reporter: Marc Shirley > Assignee: Ted Jones > Fix For: 9.1, 9.0.2 > > > Popup dialog when finishing REST import wizard with content: > "Error creating view model ViewModel.xmi" with error text "Failed to execute runnable (org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NullPointerException))" -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2507) XSDWildcard handling SOAP reponse wrongly

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2507?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2507: ----------------------------------- Fix Version/s: 9.1 9.0.2 > XSDWildcard handling SOAP reponse wrongly > ----------------------------------------- > > Key: TEIIDDES-2507 > URL: https://issues.jboss.org/browse/TEIIDDES-2507 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 9.0 > Reporter: Kylin Soong > Assignee: Ted Jones > Fix For: 9.1, 9.0.2 > > > As TEIIDDES-2487 L3 comments, this issue be created -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2507) XSDWildcard handling SOAP reponse wrongly

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2507?page=com.atlassian.jira.plu... ] Barry LaFond reassigned TEIIDDES-2507: -------------------------------------- Assignee: Ted Jones > XSDWildcard handling SOAP reponse wrongly > ----------------------------------------- > > Key: TEIIDDES-2507 > URL: https://issues.jboss.org/browse/TEIIDDES-2507 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 9.0 > Reporter: Kylin Soong > Assignee: Ted Jones > Fix For: 9.1, 9.0.2 > > > As TEIIDDES-2487 L3 comments, this issue be created -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2506) NPE when attempting to finish REST import

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2506?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2506: ---------------------------------------- [~mshirley] Can you attach a full stack trace from log file? > NPE when attempting to finish REST import > ----------------------------------------- > > Key: TEIIDDES-2506 > URL: https://issues.jboss.org/browse/TEIIDDES-2506 > Project: Teiid Designer > Issue Type: Bug > Components: Web Services Support > Affects Versions: 9.0 > Environment: Mac > JBDS Version: 8.0.0.GA > Build id: GA-v20141020-1042-B317 > Teiid Designer version: 9.0.1.Final-v20150211-1407-B643 > Reporter: Marc Shirley > Assignee: Ted Jones > > Popup dialog when finishing REST import wizard with content: > "Error creating view model ViewModel.xmi" with error text "Failed to execute runnable (org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NullPointerException))" -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2487) Teidd Designer Import SOAP Relational Model Mapping No Columns defined

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2487?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2487: ----------------------------------- Fix Version/s: 9.1 (was: 9.0.1) (was: 9.0.2 Beta1) > Teidd Designer Import SOAP Relational Model Mapping No Columns defined > ---------------------------------------------------------------------- > > Key: TEIIDDES-2487 > URL: https://issues.jboss.org/browse/TEIIDDES-2487 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Affects Versions: 9.0 > Reporter: Kylin Soong > Assignee: Ted Jones > Fix For: 9.1, 9.0.2 > > Attachments: StateService.jar, teiid-designer-ws-1.png, teiid-designer-ws-2.png, teiid-designer-ws-3.png, teiid-designer-ws-4.png > > > issue > ==== > Create Relational Model from SOAP service validation failed with "No Columns defined error" > Reproduce > ======== > 1. deploy attached StateService to JBoss DV 6.1(assume it DV run on localhost), WSDL File can be viewed via [2] > 2. Use attached 4 pics to import SOAP Web Service will reproduce the issue(teiid-designer-ws-3.png and teiid-designer-ws-4.png show validation errors) > Enhancement > ========== > 1. Simplify the import wizard - from a user's perspective, I think the main obstacle is the wizard is too complex, especially SOAP, federation related wizard, it's very difficult to operate without a step by step documents. > 2. Simplify XML document modeling related operation - current wizard not user-friendly, web should do some enhancement in request/response xml document modeling. > 3. Simplify vdb archive structure - the Designer generated vdb is more complexed compared with dynamic vdb, it have more definition files(sources.xmi, views.xmi, vdb.xml), there also some metamatrix link like [2] exist in .xmi, actually these links not really exist, if we remove these kinds of things, the designer wizard logic may be more easier. > [1] http://localhost:8080/StateService/stateService/StateServiceImpl?WSDL > [2] http://www.metamatrix.com/metamodels/SimpleDatatypes-instance#XMLLiteral -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2501) Modify dialogs that are deemed too large to use on lower-resolution screens

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2501?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2501: ----------------------------------- Attachment: jdbc_import_4_tab_2.png jdbc_import_4_tab_1.png jdbc_import_3.png jdbc_import_2.png jdbc_import_1.png > Modify dialogs that are deemed too large to use on lower-resolution screens > --------------------------------------------------------------------------- > > Key: TEIIDDES-2501 > URL: https://issues.jboss.org/browse/TEIIDDES-2501 > Project: Teiid Designer > Issue Type: Bug > Components: Dialogs > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 9.1, 9.0.2, 8.6.2 > > Attachments: create-web-service-resized-with-scollbars.png, create-web-service-smaller.png, jdbc_import_1.png, jdbc_import_2.png, jdbc_import_3.png, jdbc_import_4_tab_1.png, jdbc_import_4_tab_2.png > > > Several of Designer's dialogs and wizards are too large to successfully demo on lower-resolution screens. There's a request to modify some of these to reduce the size of the panels/dialogs. Some of this could involve adding scrolling of the outer panel. Others might require re-arranging widgets/sub-panels, adding tab'd panels, etc. > * Transformation's Reconciler Dialog > * Create Web Services dialog > * Salesforce Importer (maybe JDBC Importer) > * ... (TBD) -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2501) Modify dialogs that are deemed too large to use on lower-resolution screens

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2501?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-2501 at 5/6/15 3:44 PM: ---------------------------------------------------------------- Created a DefaultScrolledComposite class that can be used in place of a top-level panel in a dialog or page. Initializes with some more desireable default scrolling values, sets the control to an inner composite/panel. Instantiated classes need to use DefaultScrolledComposite.getPanel() as the main container for their page/widgets AND call DefaultScrolledComposite.sizeScrolledPanel() at the end of creating their control. This will set inner panel size so resizing to smaller dialog will start showing scroll bars. See attached screenshots for first implementation * Create Web Services dialog * Generate REST Virtual Procedures dialog (master and 9.0.x) * Create Data Source dialog * Generate REST War dialog * New Child/Sibling relational object dialogs (Table..., Procedure..., View...., etc) * Select SQL Template dialog master: https://github.com/Teiid-Designer/teiid-designer/commit/ecce9ec0ad16adbdc... 9.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/f28c49b8dafe2a735... 8.6.x: https://github.com/Teiid-Designer/teiid-designer/commit/4c3c68b2c2eb23aba... JDBC Import Wizard master: https://github.com/Teiid-Designer/teiid-designer/commit/217e352afc357079e... 9.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/b2dac8e5bab2f960c... 8.6.x: https://github.com/Teiid-Designer/teiid-designer/commit/d748c2e6c003d8a28... was (Author: blafond): Created a DefaultScrolledComposite class that can be used in place of a top-level panel in a dialog or page. Initializes with some more desireable default scrolling values, sets the control to an inner composite/panel. Instantiated classes need to use DefaultScrolledComposite.getPanel() as the main container for their page/widgets AND call DefaultScrolledComposite.sizeScrolledPanel() at the end of creating their control. This will set inner panel size so resizing to smaller dialog will start showing scroll bars. See attached screenshots for first implementation * Create Web Services dialog * Generate REST Virtual Procedures dialog (master and 9.0.x) * Create Data Source dialog * Generate REST War dialog * New Child/Sibling relational object dialogs (Table..., Procedure..., View...., etc) * Select SQL Template dialog master: https://github.com/Teiid-Designer/teiid-designer/commit/ecce9ec0ad16adbdc... 9.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/f28c49b8dafe2a735... 8.6.x: https://github.com/Teiid-Designer/teiid-designer/commit/4c3c68b2c2eb23aba... > Modify dialogs that are deemed too large to use on lower-resolution screens > --------------------------------------------------------------------------- > > Key: TEIIDDES-2501 > URL: https://issues.jboss.org/browse/TEIIDDES-2501 > Project: Teiid Designer > Issue Type: Bug > Components: Dialogs > Reporter: Barry LaFond > Assignee: Barry LaFond > Fix For: 9.1, 9.0.2, 8.6.2 > > Attachments: create-web-service-resized-with-scollbars.png, create-web-service-smaller.png, jdbc_import_1.png, jdbc_import_2.png, jdbc_import_3.png, jdbc_import_4_tab_1.png, jdbc_import_4_tab_2.png > > > Several of Designer's dialogs and wizards are too large to successfully demo on lower-resolution screens. There's a request to modify some of these to reduce the size of the panels/dialogs. Some of this could involve adding scrolling of the outer panel. Others might require re-arranging widgets/sub-panels, adding tab'd panels, etc. > * Transformation's Reconciler Dialog > * Create Web Services dialog > * Salesforce Importer (maybe JDBC Importer) > * ... (TBD) -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2502) Incorrect transformation reconciliation

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2502?page=com.atlassian.jira.plu... ] Steven Hawkins updated TEIIDDES-2502: ------------------------------------- Description: 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> ... was: 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> ... Steps to Reproduce: create view add transformation: 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 VALIDATE query gets changed and error occurs. was: create view add transformation: 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 VALIDATE query gets changed and error occurs. What Tom was referring to is that JIRA seemed to mess up on copy paste, but that has now been corrected with some backslash escapes. > 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

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2502) Incorrect transformation reconciliation

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2502?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2502: ---------------------------------------- So is this a Copy/Paste issue rather than a reconcile issue? I'm able to use column1.*, column2.* in my SQL. Can you create a simple SQL to test or include your project set containing the source and view models in question? > 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

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues May 2015