Bug 854193

Summary: Exception in TEIID when looking up category_id's
Product: [Other] TCMS Reporter: Chris Ward <cward>
Component: DatabaseAssignee: jianchen <jianchen>
Status: CLOSED NOTABUG QA Contact: tools-bugs <tools-bugs>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 3.0CC: ctang, dli, junzhang, nli, ryang, vchen, yawli
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-09-17 07:04:37 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Chris Ward 2012-09-04 10:05:13 UTC
Description of problem:

This might be a problem in TEIID rather than TCMS, but i'm not entirely sure.

Running the following command in TEIID (ie, VDBD)

SELECT case_id, component_id FROM Testopia.test_case_components
---------------------------------------------------------------------------
DataError                                 Traceback (most recent call last)
... in <module>()
----> 1 "SELECT case_id, component_id FROM Testopia.test_case_components"

DataError: Error Code:22003 Message:TestopiaDS: Error Code:22003 Message:Unexpected exception while translating results: '48790.0' in column '2' is outside valid range for the datatype SMALLINT.
DETAIL:  org.teiid.jdbc.TeiidSQLException: Error Code:22003 Message:TestopiaDS: Error Code:22003 Message:Unexpected exception while translating results: '48790.0' in column '2' is outside valid range for the datatype SMALLINT.


One workaround to get the query to work, is:

SELECT case_id, CONVERT(component_id, integer) FROM Testopia.test_case_components

But ideally, this workaround wouldn't be required...

Comment 1 yawei Li 2012-09-17 07:04:37 UTC
Component_id is int type, no error in tcms Database.