Uploaded image for project: 'StreamSets Data Collector'
  1. StreamSets Data Collector
  2. SDC-9078

Large numeric offsets in Salesforce origin are stored in scientific notation

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: P2 (Critical with Workaround)
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.4.0
    • Component/s: None
    • Labels:
      None
    • Doc Impact:
      Yes
    • Doc Impact Details:
      Due to the weirdness of Salesforce, numeric initial offset values that are larger than 2147483647 must include a decimal point - e.g. 2500000000.0
    • Testing Status:
      Required
    • Testing Required Description:
      Test with a large decimal typed field as offset

      Description

      When using a large numeric field - longer than 8 digits, decimal 13 in one report - as the offset field, the offset is stored in scientific notation. That is, when we read `1526394852000`, we store `1.526394852000E12`. This causes the subsequent query to fail.

      See https://ask.streamsets.com/question/1959/salesforce-origin-offset-in-scientific-notation/

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                pat Pat Patterson
                Reporter:
                pat Pat Patterson
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: