[JBoss JIRA] (TEIIDDES-1449) Getting Processing Exception - Could not parse query transformation when making a procedure execution
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1449?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1449:
----------------------------------------
The attached Financials VDB contains an XML Document model containing 3 Mapping Classes, but only one of them is fully Indexed
Looks like this may be a MAC issue since I can't break my VDB on Linux?
> 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, 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
[JBoss JIRA] (TEIIDDES-1449) Getting Processing Exception - Could not parse query transformation when making a procedure execution
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1449?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-1449:
------------------------------------------
The _1 renaming is a runtime construct for auto staging table planning. It it not having any affect in this scenario. Can you post your valid vdb to this issue as well?
> 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"><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
[JBoss JIRA] (TEIIDDES-1449) Getting Processing Exception - Could not parse query transformation when making a procedure execution
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1449?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1449:
----------------------------------------
Recommend repeating the test/LAB, documenting steps/actions taken, and if it fails again, attach all artifacts that exist at the the time the execution error occurred.
If the resulting XML Doc model has a mapping class ending in "_1" that's one direction to investigate. If the XML Doc model is OK and the "_1" is being appended at execution time, that's another direction.
> 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"><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
[JBoss JIRA] (TEIIDDES-1449) Getting Processing Exception - Could not parse query transformation when making a procedure execution
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1449?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1449:
----------------------------------------
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"><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
[JBoss JIRA] (TEIIDDES-1449) Getting Processing Exception - Could not parse query transformation when making a procedure execution
by Barry LaFond (JIRA)
[ 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"><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
[JBoss JIRA] (TEIIDDES-1449) Getting Processing Exception - Could not parse query transformation when making a procedure execution
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1449?page=com.atlassian.jira.plu... ]
Barry LaFond edited comment on TEIIDDES-1449 at 7/12/12 10:09 PM:
------------------------------------------------------------------
Added logging to RuntimeAdapter when adding SQL SELECT word
Saving the XML Document model in question results in:
obj =ALLCUSTOMERACCOUNTS_OUTPUT_VIEW.ACCOUNT_OUTPUTVIEW.MAPPINGCLASSES.ACCOUNT_OUTPUT_INSTANCE SQL = SELECT * FROM AllCustomerAccounts.account
obj =ALLCUSTOMERACCOUNTS_OUTPUT_VIEW.ACCOUNTHOLDINGS_OUTPUTVIEW.MAPPINGCLASSES.ACCOUNTHOLDINGS_OUTPUT_INSTANCE* SQL = SELECT * FROM AllCustomerAccounts.accountholdings
obj =*ALLCUSTOMERACCOUNTS_OUTPUT_VIEW.CUSTOMER_OUTPUTVIEW.MAPPINGCLASSES.CUSTOMER_OUTPUT_INSTANCE* SQL = SELECT * FROM AllCustomerAccounts.customer
Note the bolded mapping class in question above and the indexed SQL Statement
So this should be saved in Index file in the VDB
was (Author: blafond):
Added logging to RuntimeAdapter when adding SQL SELECT word
Saving the XML Document model in question results in:
obj =ALLCUSTOMERACCOUNTS_OUTPUT_VIEW.ACCOUNT_OUTPUTVIEW.MAPPINGCLASSES.ACCOUNT_OUTPUT_INSTANCE SQL = SELECT * FROM AllCustomerAccounts.account
obj =*ALLCUSTOMERACCOUNTS_OUTPUT_VIEW.ACCOUNTHOLDINGS_OUTPUTVIEW.MAPPINGCLASSES.ACCOUNTHOLDINGS_OUTPUT_INSTANCE* SQL = SELECT * FROM AllCustomerAccounts.accountholdings
obj =ALLCUSTOMERACCOUNTS_OUTPUT_VIEW.CUSTOMER_OUTPUTVIEW.MAPPINGCLASSES.CUSTOMER_OUTPUT_INSTANCE SQL = SELECT * FROM AllCustomerAccounts.customer
> 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"><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
[JBoss JIRA] (TEIIDDES-1449) Getting Processing Exception - Could not parse query transformation when making a procedure execution
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1449?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-1449:
----------------------------------------
Added logging to RuntimeAdapter when adding SQL SELECT word
Saving the XML Document model in question results in:
obj =ALLCUSTOMERACCOUNTS_OUTPUT_VIEW.ACCOUNT_OUTPUTVIEW.MAPPINGCLASSES.ACCOUNT_OUTPUT_INSTANCE SQL = SELECT * FROM AllCustomerAccounts.account
obj =*ALLCUSTOMERACCOUNTS_OUTPUT_VIEW.ACCOUNTHOLDINGS_OUTPUTVIEW.MAPPINGCLASSES.ACCOUNTHOLDINGS_OUTPUT_INSTANCE* SQL = SELECT * FROM AllCustomerAccounts.accountholdings
obj =ALLCUSTOMERACCOUNTS_OUTPUT_VIEW.CUSTOMER_OUTPUTVIEW.MAPPINGCLASSES.CUSTOMER_OUTPUT_INSTANCE SQL = SELECT * FROM AllCustomerAccounts.customer
> 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"><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
[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 moved TEIID-2099 to TEIIDDES-1449:
----------------------------------------------
Project: Teiid Designer (was: Teiid)
Key: TEIIDDES-1449 (was: TEIID-2099)
Affects Version/s: 7.7
(was: 7.7)
Component/s: VDB & Execution
(was: Query Engine)
> 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: Steven Hawkins
> Priority: Optional
> 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"><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