Bug 1343827

Summary:	Transformation exception when parsing time in SAP NW Gateway
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	Andrej Smigala <asmigala>
Component:	Teiid	Assignee:	Van Halbert <vhalbert>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Andrej Smigala <asmigala>
Severity:	high	Docs Contact:
Priority:	high
Version:	6.3.0	CC:	aszczucz, blafond, jolee, lfabriko, mbaluch, thauser, vhalbert
Target Milestone:	ER5
Target Release:	6.3.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-08-24 11:50:01 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 Andrej Smigala 2016-06-08 06:35:58 UTC

When querying the SAP Sample Flight demo web service using the sap-nw-gateway, the following error is logged when the response contains time value in the form "PT11H00M00S"

org.teiid.jdbc.TeiidSQLException: TEIID10068 Failed to transform String to Time.  Expected format = hh:mm:ss for PT11H00M00S         at org.jboss.qe.dvqe.reproducers.Teiid3841Test.runTest(Teiid3841Test.java:61) Caused by: org.teiid.core.types.TransformationException: TEIID10068 Failed to transform String to Time.  Expected format = hh:mm:ss for PT11H00M00S

This is likely a regression as that query works in DV 6.2 with latest patch.

Steps to Reproduce:
see linked jira

Comment 1 JBoss JIRA Server 2016-06-08 14:19:32 UTC

Steven Hawkins <shawkins> updated the status of jira TEIID-4255 to Resolved

Comment 2 JBoss JIRA Server 2016-07-08 13:29:26 UTC

Steven Hawkins <shawkins> updated the status of jira TEIID-4255 to Closed