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

Transformation exception when parsing time in SAP NW Gateway

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Blocker Blocker
    • 9.0, 8.12.5
    • 8.12.x
    • Misc. Connectors
    • None
    • 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

      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.

              rhn-engineering-shawkins Steven Hawkins
              asmigala@redhat.com Andrej Smigala
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: