Document toolboxDocument toolbox

Server-to-Parallel - S2PX Release v1.1

Package Summary

Package name

S2PX Release v1.1

Release Date (yyyy-mm-dd)

2022-12-22

Package Contents

This release was bundled with MettleCI v.1.1.

See this page for detailed release notes for the entire release package.

Change Log

New Features

  • Introduces support for Folder Stage

  • S2PX now converts MettleCI Unit Tests for Server Jobs to their Parallel Job equivalents

  • S2PX Analysis plugin now populates the Hashed File tab of the Excel spreadsheet (previously omitted due to a bug)

Fixes

Issue Reference

Summary

Issue Reference

Summary

HC-47

Some decomposed Parallel Job designs fail to generate required component within Shared Containers.

MCI-4413

Auto generated CREATE TABLE statements affected by Column Nullability

MCI-4560

Determine Server to Parallel Unit Test conversion for Sparse Lookups

MCI-4609

Security vulnerabilities for S2PX analysis plugin

MCI-4612

Added embedded Asset Query to Analysis plugin reporting Merge Stage escape characters won't be supported.

MCI-4635

CustomRoutineTypeProvider does not provide types of existing Parallel routines

MCI-4653

Multi-Reference Lookup produces warnings on Key Columns

MCI-4655

Sequential File missing Conversion Transformer when connected to Stage using SQL Types for Column Metadata

MCI-4666

Shared Container Metadata not propagated to Job

MCI-4671

S2PX Transformer Expression Missing Brackets

MCI-4679

Failure to translate Aggregator with no calculations

MCI-4685

DSPluginStage should not use SQL Types

MCI-4702

Hashed File in Shared Container does not trigger generation of Lookup transformations

MCI-4703

Logical Operator Associativity is Left-to-Right

MCI-4717

Initial Value of Stage Variable does not match Server Job

MCI-4730

Sequential File Errors caused by error in Stage name collision avoidance code

MCI-4731

Parallel Timestamps do not retain microsecond precision

MCI-4735

S2PX generating Sequential File stages with some properties set incorrectly

MCI-4778

Integer divisions not resulting in floating point when called on substituted expressions

MCI-4810

S2PX generating Parallel Job which sorts TimeStamp data differently to Server Job

MCI-4930

Detect when S2PX plugins are used with an incompatible version of MettleCI Command Shell.

MCI-5048,

MCI-5053

S2PX Analysis Spreadsheet - Correct scaled and remove count labels

MCI-5058

S2PX: Parallel jobs failing when containing fixed width sequential files

Upgrade Process

Customers performing an initial installation, or upgrading from a previous version of MettleCI, can follow the instructions included (or linked) from these pages:

Known Issues

Prioritised for fix in the next release.

Issue Reference

Summary

Issue Reference

Summary

MCI-5040

Fix Analysis for Pivot Stages. The current S2PX Analysis process fails with a runtime errors (of the form DerivationHelper$UnderlineListener:xxx - line x:x mismatched input) when a Pivot Stage column derivation contains the columns upon which the pivot is performed.

 

 

 

© 2015-2024 Data Migrators Pty Ltd.