Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4255

Transformation exception when parsing time in SAP NW Gateway

    Details

    • Steps to Reproduce:
      Hide
      1. create a new resource adapter for the SAP Sample Flight demo ( https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT)
      2. deploy a dynamic vdb using that as datasource
      3. run the following query against the vdb:
        select * from (call Source.GetFlightDetails('AA BB', '0017')) as f
      Show
      create a new resource adapter for the SAP Sample Flight demo ( https://sapes1.sapdevcenter.com/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT ) deploy a dynamic vdb using that as datasource run the following query against the vdb: select * from ( call Source .GetFlightDetails( 'AA BB' , '0017' )) as f
    • Bugzilla Update:
      Perform

      Description

      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  shawkins Steven Hawkins
                  Reporter:
                  asmigala Andrej Smigala
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: