Prepared statement for SOURCE_NAME in multi-source mode throws exception Message:Unable to evaluate --------------------------------------------------------------------------------------------------- Key: TEIID-1904 URL: https://issues.jboss.org/browse/TEIID-1904 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.3, 7.6 Environment: Windows 7 JDK 1.6.0_23 Jboss 5.1.0.GA Reporter: Ganesh Kumar Assignee: Steven Hawkins Labels: PreparedStatement, multi-source Attachments: emp-vdb.xml, MultisourceModel.java, office-ds.xml, office1-ds.xml I have a VDB which has a multi-source model. I have a prepared statement for which SOURCE_NAME is passed as a parameter. When this prepared statement is executed, I get an exception [TeiidComponentException] ERR.015.006.0033: Error Code:ERR.015.006.0033 Message:Unable to evaluate ?: No value was available This exception does not occur when I specify other conditions in combination with SOURCE_NAME. Also, the query works fine when SOURCE_NAME value is not a parameter, that is, its value is provided in the query.

Prepared statement for SOURCE_NAME in multi-source mode throws exception Message:Unable to evaluate --------------------------------------------------------------------------------------------------- Key: TEIID-1904 URL: https://issues.jboss.org/browse/TEIID-1904 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.3, 7.6 Environment: Windows 7 JDK 1.6.0_23 Jboss 5.1.0.GA Reporter: Ganesh Kumar Assignee: Steven Hawkins Labels: PreparedStatement, multi-source Attachments: emp-vdb.xml, MultisourceModel.java, office-ds.xml, office1-ds.xml I have a VDB which has a multi-source model. I have a prepared statement for which SOURCE_NAME is passed as a parameter. When this prepared statement is executed, I get an exception [TeiidComponentException] ERR.015.006.0033: Error Code:ERR.015.006.0033 Message:Unable to evaluate ?: No value was available This exception does not occur when I specify other conditions in combination with SOURCE_NAME. Also, the query works fine when SOURCE_NAME value is not a parameter, that is, its value is provided in the query.

Prepared statement for SOURCE_NAME in multi-source mode throws exception Message:Unable to evaluate --------------------------------------------------------------------------------------------------- Key: TEIID-1904 URL: https://issues.jboss.org/browse/TEIID-1904 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.3, 7.6 Environment: Windows 7 JDK 1.6.0_23 Jboss 5.1.0.GA Reporter: Ganesh Kumar Assignee: Steven Hawkins Labels: PreparedStatement, multi-source Fix For: 7.6.1, 8.0 Attachments: emp-vdb.xml, MultisourceModel.java, office-ds.xml, office1-ds.xml, server.log I have a VDB which has a multi-source model. I have a prepared statement for which SOURCE_NAME is passed as a parameter. When this prepared statement is executed, I get an exception [TeiidComponentException] ERR.015.006.0033: Error Code:ERR.015.006.0033 Message:Unable to evaluate ?: No value was available This exception does not occur when I specify other conditions in combination with SOURCE_NAME. Also, the query works fine when SOURCE_NAME value is not a parameter, that is, its value is provided in the query.