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
Updated workflow generator to check for PROFILED_GENERIC_LOAD profile first
Corrected an issue where the workflow would fail if both profiled generic load profile and legacy profile existed.
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
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.
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".