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

Transformation exception when parsing time in SAP NW Gateway

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • 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

    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.

      Attachments

        Issue Links

          is caused by

          Bug - A problem that impairs or prevents the functions of the product. TEIID-3543 Complex type values not resolved in translator execution

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: