MC2 Release Notes - August 25 2020

New version of Pace ReportService client

New version is available: pace-reportservice-1.0.5.jar
The jar must be installed separately; refer to this page for instructions to install the client jar file:
Installing Pace Report Service

SDP-39375 Allow user to define destination filter expression in RTR

Adding ability to redefine destination filter expression in RTR

The ability to redefine destination filter has been added for python translators. The parameter destinationfilterexpr in RTR for running python translators allows overriding the current destinations filters which were setup in the translator.

SDP-39273 column name "city & state" coming over twice in header

Columns "city & state" coming over twice in header for issuer EDS interface

We adjusted the issuer EDS interface to only return "city" and "state" elements once, while also specifying "leiCity" and "leiState".

SDP-39191 Match mashup fails when comparing datasets with different headers

Match mashup fails when comparing datasets with different headers

When comparison interface was used to compare datasets with different counts of columns in right and left sides then an error was raised. The issue was fixed and run comparison interfaces to compare source file with database directly works fine.

SDP-38546 EDS: Add new t-item for calling SP without out cursor

Added ability to call SP without out cursor for EDS Warehouse Position and Open Lot Inbound

Added ability to call SP without out cursor and get out values using its out parameters.

SDP-38459 EDS: Add new t-item for calling SQL query for delete operation

Added ability to use SQL query for Warehouse Position and Open Lot EDS Inbound

Now in the bind file pure query can be used in addition to SP and tables list.

SDP-38453 EDS Load: Add ability to handle failed record and reprocess it after

EDS Load: Add ability to handle failed record and reprocess it after

We added the ability to handle failed records and reprocess them after loading through new python load framework.

SDP-38063 Add information about loaded data records in MC tables during EDS load

Add information about loaded data records in MC tables during EDS load

We added code that will populate MC tables with details when utilizing EDS Load.

SDP-37065 Add caching parameters to core Ratings data set definition

Caching parameters for rating dataset were added

Now users have the ability to cache only part of the rating data; fromeffectivedate filter was added as mandatory filter in dataset definition; toeffectivedate and source name filters were added as common (optional) filters

SDP-39130 Add Timestamp for extractservice logs

updated Extractservice log file name pattern to include timestamp

Extractservice log file name pattern is now %d{MMddHH}.${LOG_FILE}_${PID}.log
Examples for log files created August 14 at approx. 09:00:081409.extractservice-lb_77369.log081409.extractservice-worker_77393.log081409.extractservice-worker_77415.log

SDP-38605 Split the API docs in swagger-ui for the extract endpoints

Broke out the "EXTRACT" endpoints into separate docs in the swagger-ui

The swagger-ui now has the below selections in "select a definition" drop-down:

EQL

GENERICEXTRACT

PACEREPORT

ACCOUNTING

ACTIONS

ENTITIES

ISSUER

ISSUERROLE

REFERENCES

2PREPORTING

SECURITIES

WAREHOUSE

SDP-38057 Rest Alias does not work

Corrected issue with ReST aliases

Corrected issue with ReST aliases for EagleML parameter names.The ReST aliases were not getting mapped to EagleML parameters.

SDP-39298 EDS: Remove maxrows limit from genericsmf dataset

Removed the maxrows limit from genericsmf dataset

Removed the maxrows limit of 999999 from the genericsmf EDS dataset.The dataset now has no limit on retrieved/cached rows.

SDP-38007 EQL endpoint not returning TSR in case of no data

Corrected issue with EQL endpoint in case of no data

Updated EQL REST endpoint to return a TSR indicating NO_DATA status when no data was found for the request.

SDP-37678 EDS: Modify profiled generic load generator to use stream for load eagle_ml-2-0_default_cm_exec_eds

Modifed profiled generic load generator to use stream for load eagle_ml-2-0_default_cm_exec_eds

Profiled generic load generator has been modified to generate workflow using stream (eagle_ml-2-0_default_cm_exec_eds ) as load step for the files. Therefore, for some cases if EDS interface is available with definition from client file to the SP dialect, we can use this stream to perform load. This is instead of making double step load transformation from client dialect into EagleML dialect, and only after this from EagleML to SP dialect via MC\MC2 stream.

SDP-39787 Change the EDS output to print fractional number with at least one zero after the decimal point

Roll back representation of the float numbers without fractional part

As part of the item https://eagleinvsys.atlassian.net/browse/SDP-36759 we made a change for the EDS query generation to extract float numbers without fractional part like example below:

255 instead on 255.0
0 instead of 0.0 But this change led an error for down streams which expect float number with point.To do this we change query generation and add logic to format all decimal numbers with point, like it was before.For now it is even simpler:CASE WHEN MASTERTABLE.RATING_FLOAT2 IS NULL THEN NULL ELSE TO_CHAR(MASTERTABLE.RATING_FLOAT2, 'FM9999999999999990.099999999999') END RATING_FLOAT2

SDP-39132 Create EDS Object for Corporate Action Activity Report

Added EDS metadata for Corporate Action Activity Report and Income Roll Forward reports.

We created a corporateactionactivity and incomerollforward EDS Interfaces that can be called to extract data from the related Eagle stored procedures.

SDP-38756 Fix generation of main header for EDS extracts to make it valid against schema

Fix generation of main header for EDS extracts

Fixed the following issues in pyrules:

Added the main header: <header></header>
Fixed the root node attributes

SDP-39467 Convert boolean to string type in OLAP REST API Payloads

Payload Parameters of type boolean will also be supported as string

Request Payload of 'adhocReport' endpoint has boolean type tags like 'constituentsAndBenchmarkToComposite' and 'benchmarkToPortfolio'. Support is now extended to accept the tags as string type too. Either as boolean or as string type is accepted.