[JBoss JIRA] (TEIIDDES-1388) Improve Flat File importer
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-1388:
--------------------------------------
Summary: Improve Flat File importer
Key: TEIIDDES-1388
URL: https://issues.jboss.org/browse/TEIIDDES-1388
Project: Teiid Designer
Issue Type: Enhancement
Components: Import/Export
Affects Versions: 7.7, 7.7.1
Reporter: Barry LaFond
The Flat File importer still lacks simplicity. Need to spend another cycle improving usability
PAUL NITTEL wrote:
I'm tinkering with this thing and have a few suggestions. (The problem with coming up with cool wizardly things is they spark other synapses thereby creating an endless flow of work.)
The Create Teiid Flat File Connection action seems to be a mixture of building the data source connection and laying the groundwork for the transformation (like where are the column name and types). Moving this to the Create Source Model wizard might make it easier and flow better for the user.
Rather than checkboxes that presume much about how flat file data may be constructed, how about allowing the user to tell you which lines are contain heading and type info (if any, of course)? In the case of my weird data file, there a comment in line 1, line 2 is blank, line 3 have column names and line 4 has types. Data starts in line 5.
I realize my case is atypical, but might be worth consideration. ;-)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 3 months
[JBoss JIRA] (TEIIDDES-1449) Getting Processing Exception - Could not parse query transformation when making a procedure execution
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1449?page=com.atlassian.jira.plu... ]
Van Halbert closed TEIIDDES-1449.
---------------------------------
Resolution: Rejected
The problem was that when I updated JBDS and Designer to the latest (JBDS early access and latest Designer) there was no issue. Was able to perform this scenario with no issue. So rejecting this issue for the Designer folks.
> Getting Processing Exception - Could not parse query transformation when making a procedure execution
> -----------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-1449
> URL: https://issues.jboss.org/browse/TEIIDDES-1449
> Project: Teiid Designer
> Issue Type: Bug
> Components: VDB & Execution
> Affects Versions: 7.7
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Priority: Critical
> Attachments: 0009_ReationalWSModeling.pdf, Financials_Linux.vdb, Financial_VDB.vdb, Lab-008.zip, Lab-008_w_error.zip
>
>
> Trying to issue the command:
> EXEC AllCustomerAccounts_WS.AllCustomerAccounts_customer.getcustomer('<?xml version="1.0" encoding="UTF-8"?><customer_Input xmlns="http://www.metamatrix.com/account_Input"><customerid>CST01010</customerid></customer_Input>')
> and getting:
> 14:01:29,316 WARN [PROCESSOR] Processing exception 'Could not parse query transformation for ALLCUSTOMERACCOUNTS_OUTPUT_VIEW.CUSTOMER_OUTPUTVIEW.MAPPINGCLASSES.CUSTOMER_OUTPUT_INSTANCE_1: null' for request SrNmZbySl22E.5. Exception type org.teiid.api.exception.query.QueryPlannerException thrown from org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:133). Enable more detailed logging to see the entire stacktrace.
> It says its a warning, but no results are returned.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 3 months