[
https://issues.jboss.org/browse/TEIIDDES-1449?page=com.atlassian.jira.plu...
]
Barry LaFond edited comment on TEIIDDES-1449 at 7/13/12 8:02 AM:
-----------------------------------------------------------------
Verified that the Index file for the XML Doc model contained the correct SQL statement AND
when placed in a VDB, the Index file still contained the expeced SQL statement:
MAPPING CLASS:
CUSTOMER_OUTPUTVIEW.MAPPINGCLASSES.CUSTOMER_OUTPUT_INSTANCE
SQL:
SELECT * FROM AllCustomerAccounts.customer
So from a set-up standpoint, this looks OK.
The fact that the log showed a mapping class appended with an "_1" is
concerning.
(ALLCUSTOMERACCOUNTS_OUTPUT_VIEW.CUSTOMER_OUTPUTVIEW.MAPPINGCLASSES.CUSTOMER_OUTPUT_INSTANCE_1)
Not sure how that would happen and where?
was (Author: blafond):
Verified that the Index file for the XML Doc model contained the correct SQL statement
AND when placed in a VDB, the Index file still contained the expeced SQL statement:
MAPPING CLASS:
CUSTOMER_OUTPUTVIEW.MAPPINGCLASSES.CUSTOMER_OUTPUT_INSTANCE
SQL:
SELECT * FROM AllCustomerAccounts.customer
So from a set-up standpoint, this looks OK.
The fact that the log showed a mapping class appended with an "_1" is
concerning.
(ALLCUSTOMERACCOUNTS_OUTPUT_VIEW.CUSTOMER_OUTPUTVIEW.MAPPINGCLASSES.CUSTOMER_OUTPUT_INSTANCE*_1*)
Not sure how that would happen and where?
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: Financial_VDB.vdb, Lab-008.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"><customer...)
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