MC2 Release Notes - November 17 2020

SDP-41663 Vault MVP Interfaces - New Metadata - issuerrole

Added new metadata for IssuerRole

Added IssuerRole to Ontology for core and history modes.


SDP-41652 Vault MVP Interfaces - New Metadata - issuerrelationship

Created issuerrelationship Ontology

New ontology of issuerrelationship was developed:
estar\tpe\dynamic\metadata\core\ontology\reference issuerrelationship.json
estar\tpe\dynamic\metadata\core\ontology\reference issuerrelationship-models.json
issuerrelationship.json contains sql table joins definition, filters definition, extract and load rules and etc.
issuerrelationship-models.json contains fields mapping definition.


SDP-40807 Vault MVP Interfaces - New Metadata - reportdictionary

Created Ontology for reportdictionary

We created the Ontology for reportdictionary interface. The old reportdictionary interface was split into 4 new interfaces:
reportdictionarysummary reportdictionarydetail reportdictionarylevel reportdictionarylinkedasset
Files added:1) estar\tpe\dynamic\metadata\core\ontology\reference\reportdictionarysummary.jsonestar\tpe\dynamic\metadata\core\ontology\reference\reportdictionarysummary-models.json2) estar\tpe\dynamic\metadata\core\ontology\reference\reportdictionarydetail.jsonestar\tpe\dynamic\metadata\core\ontology\reference\reportdictionarydetail-models.json3) estar\tpe\dynamic\metadata\core\ontology\reference\reportdictionarylevel.jsonestar\tpe\dynamic\metadata\core\ontology\reference\reportdictionarylevel-models.json4) estar\tpe\dynamic\metadata\core\ontology\reference\reportdictionarylinkedasset.jsonestar\tpe\dynamic\metadata\core\ontology\reference\reportdictionarylinkedasset-models.json


SDP-42382 Fix corporateactionactivity Datatset Formatting Issue

Several fields are missing in EDS corporate action activity report extract

We improved the code for EDS stored procedure based extracts, like corporate action activity report, so they return fields that were missing.


SDP-43472 Revise EDS CSV Output to Escape Double Quotes and Commas

Revise EDS CSV Output to Escape Double Quotes and Commas

We revised our CSV output for EDS extracts to make it in accordance with RFC 2048 standard. Changes affect values with separator and double quotes.
Note from RFC 2048:Fields containing line breaks (CRLF), double quotes, and commas should be enclosed in double-quotes.
If a double-quote appearing inside a field, it must be escaped by preceding it with another double quote.
Original:...,"Aeroporti Di Roma S.P.A" In Forma Abbreviata "Adr S.P.A", enumaration(one,two),Note: enumaration(one,two) is a single value
New:...,"""Aeroporti Di Roma S.P.A"" In Forma Abbreviata ""Adr S.P.A""", "enumaration(one,two)",


SDP-43179 client Dataset Joining on CLIENT table Instead of MASTERTABLE

client Dataset Joining on CLIENT table Instead of MASTERTABLE

We adjusted the EDS Bind file for client dataset to use the correct alias of MASTERTABLE in the joins.


SDP-43128 Remove ASOF suffix from the feedname

Remove ASOF suffix from the feedname

We changed the code to correctly reflect the @resourcename in the generic extractor when calling an EDS Resource in history mode. When we were calling the resource with the parameters historyonlyflag & DistributionProfileName in the RTR, we were getting @resourcename like "GENERICENTITYASOF" when we should have been saving the file as "GENERICENTITY".


SDP-42946 Date Rule Filters Not Working for Mashup Datasets in EDS Solution

Date Rule Filters Not Working for Mashup Datasets in EDS Solution

We created code to be able to resolve date rules when using a different date rule for a dataset in a mashup other than the main dataset. In the example below, we can call the main dataset with one date rule and also a mashup (moody2) with a different date rule.
<taskParameter><name>effectivedaterule</name><dataType>S</dataType><value>Previous Business Day</value></taskParameter><taskParameter><name>moody2.effectivedaterule</name><dataType>S</dataType><value>Reporting Prior Quarter End</value></taskParameter>


SDP-42780 EDS: Suppress empty columns in the query result

EDS: Suppress Empty Columns in the Query Result for CSV Output

We changed the default behavior of the EDS CSV output to suppress null columns. If a user wants to see empty columns in CSV, you can use parameter in RTR - includenull = Y. This parameter works for CSV and EagleJSON formats.
Short example:Current output: priceMultiplier,sourceName,securityAlias0.00000001,,0.00001,,188406
After changes, sourceName column has no data, so it is removed: priceMultiplier,securityAlias0.00000001,0.00001,188406


SDP-41624 Refresh Onotology Cache on Install Step

Refresh Ontology Cache on Install Step

We added the refresh of the ontology definition cache to the install of MC2 so that users don't have to have the extra step of running an RTR after install.


SDP-40332 Bloomberg translator - retrieve timestamp from the bb header

Updated date() method to format more complex date values

Updated date() method to format more complex date values. It allows to process such values as "Fri Oct 11 17:27:37 EDT 2019".Example of complex date conversion: ["Convert(date(:varTimeStarted:,'xxx MMM dd xx:xx:xx xxx yyyy'),'yyyymmdd')","",false,null,"","effectiveDate"]


SDP-43220 Workflow issue when both profiled generic load profile and legacy profile exist

Corrected a workflow issue when both profiled generic load and original profiles exist

Corrected an issue where the workflow would fail if both profiled generic load profile and legacy profile existed, by first checking for the existence of a profiled generic load profile.


SDP-43130 All Services deployment restarts Message Center before the deployment is complete on all servers

Corrected potential timing issue in All Services install

Corrected potential timing issue in All Services install, where Message Center could be restarted before the install was complete on all servers.


SDP-43112 Change the EagleML Installer To Use Only The Main Instance AppID

Updated installer to read AppId only from cfg/msgcenter/msgservice.ini

Updated installer to read AppId only from cfg/msgcenter/msgservice.ini,and not from cfg/network/mc/msgcenter/msgservice.ini


SDP-42924 Include pandas openpyxl package with the standard MC2 install

Added openpyxl package to MC2 deployment

Added the openpyxl package to MC2 deployment


SDP-42653 Add support for eHashLogin for Date Rule resolution in EDS

Updated EDS to handle pace appserver login with Eagle v17r2.24

Updated EDS to handle pace appserver login for daterule resolution with Eagle v17r2.24.


SDP-42565 Add support for SASL_SSL security protocol for Kafka Messaging

Enabled SASL SSL security for MC2-kafka messaging


SDP-42524 Enable email delivery of generic extractor output in MC2

Enabled email delivery of output from generic extract worklfow in MC2

Added email delivery of generic extract output to MC2 to match MC Classic.


SDP-41619 MC2 Services Installer: mc2-nodes.txt can have duplicate node names

Updated MC2 Services Installer to prevent duplicate node names under certain conditions


SDP-41436 Issue installing specific versions in EagleAccess regions

Corrected an issue with installing a specific version in an EagleAccess region.


SDP-43513 POST for simple EagleML extract failing

Corrected an issue with POST method for simple EagleML extracts via REST.

Corrected an issue with POST method for simple EagleML extract via REST.


SDP-41950 Correct the list of EDS parameters returned by runparameters API

Updated the list of EDS parameters

Updated the list of EDS parameters.

Removed obsolete parameters.


SDP-32603 extracts swagger has incorrect name and alias for includezerobalances filter

Corrected Swagger for Correct Name and Alias for includezerobalances Filter

We adjusted the Swagger to correctly reflect filter as "includezerobalance".


SDP-42516 Improve KafkaService configuration to minimize impact of incorrect configuration

Improved kafka configuration to better handle errors in configuration.