7 Replies Latest reply: Sep 19, 2017 2:44 PM by Fábio Ribeiro RSS

    SAP Connector migration error

    Fernando Suzuki

      Hello everyone,

       

      We are trying to upgrade the SAP Connector from v6.0 to v6.2 (could be v6.3 but we heard that it has some bugs...), but we noticed that some fields, that once were interpreted as numbers, are now being interpreted as texts.

       

      We discovered that starting from v6.1, Qlik has modified the behavior of the query engine and the resulting dataset: "The SAP data types CHAR (character) and NUMC (numeric character) were previously interpreted (in the Qlik script) as ‘numeric’ if they contained only digits. Leading zeroes were removed. (0000141000 became 141000). Now they are always interpreted as ‘text’. Leading zeroes are kept. These data types are not often used in calculations, but if they are the new behavior might require script changes since calculations expects numeric values" (extracted from Release Notes v6.1).

       

      I've attached a QVW comparing the resulting QVDs from VBAP table. The production environment is on v6.0 and test on v6.2.

       

      We have a big 3-tier (extraction, transformation and viz apps) environment, and until now identified two options:

      1. Isolate the solution in the extract layer, applying the number interpretation function in the sql queries so that the resulting QVDs remain the same as the old QVDs from v6.0: we consider this as a workaround, but easier to measure the effort. All the new queries would have to have this interpretation workaround to match with the rest of the data.

       

      2. Assume that the query results are now "correct", and adjust all the transform and viz apps tiers to reflect this change: this option is "cleaner" (conceptually there would be no workaround involved), but more difficult to measure the effort. Probably we would have to do this by trial and error, adjusting the problems as they are identified.

       

      Now we have to decide which way to go.

       

       

       

      Can you share your thoughts? Any help appreciated.

       

       

      Thanks in advance

      Fernando Suzuki

        • Re: SAP Connector migration error
          Daniel Martinsson

          Hi Fernando,

           

          I suggest that you wait for the 6.3.2 release of the SAP Connectors. It is planned to be released this week. The new version has two new flags that can be used to maintain compatibility with load scripts developed before version 6.1 of the connectors.

           

          The following description is from the release notes:

           

          MixedMode (0 or false / 1 or true. Default/off = 0 or false.)

          When MixedMode is enabled, the NUMC and CHAR data types are sent as UNKNOWN instead of ASCII, and it is up to Qlik to decide what their content is. A numeric string with a maximum length of 14 characters will be interpreted as numeric in Qlik (the same behavior as in the legacy connector).

           

          NulldateLegacy (0 or false / 1 or true. Default/off = 0 or false.)

          When NulldateLegacy is enabled, the property Nulldate behaves as it did in the legacy connector, returning an empty value when Nulldate is enabled and returning "0000-00-00" when Nulldate is disabled.

          When NulldateLegacy is disabled, null is returned when Nulldate is enabled and 0 (displays as 1899-12-30) is returned when Nulldate is disabled.

           

          It is recommended that you do not use NulldateLegacy for new development.

           

          Best regards,

           

          Daniel Martinsson