...
SDP-18770: Enhance object type User to allow similar user names usernames to be added
There was a problem with loading the User and User Group if the Username is a part of f another Username that is already loaded. The panel that that checks for the existence of an User uses ‘LIKE’ a wildcard clause instead of an EXACT match resulting in an error about indicating an unsuccessful attempt to update an existing User.
For example: , if a User 1 with the Username 'EAGLEUSER123' already exists existed on the environment , and need there was the potential to load a User 2 with the Username 'EAGLEUSER12'.
The User existence check was updated for resolving the User by an exact match in the User and User Group inbound interfaces. The same problem was fixed for the Center Role existence check.
Option This option to lookup users and center roles by an exact match is supported in panels since starting with the 2017R2.11 version only.
Files changed:
eagle_default\in\xml\include\user_common.inc
eagle_default\in\xml\include\user_group_common.inc
SDP-10367: Enhance the Date format option for naming convention
Added a new expression @DateTimeStampISO for as part of the custom extract name pattern parameter ExtractNamePatternEx to specify the datetime value in the output file name in as YYYYMMDDTHHMMSS format (with the ‘T’ separator between the date and time values).
Files changed:
parse_tp_pattern.inc
...
SDP-18516: Incorrect final WrfStatus
Rule The task reporter rule was modified to make the final workflow status to be consistent with the TaskStatusResponse Status when the CreateConsolidatedTSR was set.
File changed:
task_reporter.xml
...
SDP-18616: Missing mapping for the long_short_ind in SPD DELTA LOG request
Rule The rule for the SPD DELTA LOG file didn't did not delete the Position records as mapping for the longShortIndicator was missing. Mapping The mapping for the longShortIndicator has been fixedwas updated.
Files changed:
xml-dbdirect_wrhs_delete_statement.inc
...
SDP-19773: Realtime: support for acct trade and acct cash single messages within in-memory processing
Added support to load the following EagleML interfaces as single messages within in-memory processing:
...
SDP-14261: Performance improvement in the Warehouse Position query
Logic The logic for the parameter ExcludeCurrentDay has been updated and now sub-query doesn't use OR operator which makes it much fasterto be more specific eliminating the OR clause in the subquery improving throughput.
ExcludeCurrentDay is common logic for used within the WRHSPOSITIONEXTRACT, WRHSCASHACTIVITYEXTRACT, WRHSTRADEEXTRACT.
File changed:
eagle_ml-2-0_cm/extract_where_section.inc
SDP-19775: EagleML: added Added missing links to the installer packages
Installer The installer package had missing links and as a result resulting in some files were not being included in the Installer package, which could cause a problem with a fresh installation.
This issue was fixed.
...
Previously xsd valid IssuerXref objects can't cannot be loaded through the eagle_ml-2-0_default_in_xml_reference.
New A new rule has been added in the stream eagle_ml-2-0_default_in_xml_reference to handle the IssuerXref interface.
File changed:
xml-ref_objects.rsf
xml-ref_issuer_xref_mi.xml
xml-ref_issuer_xref.xml
...
Adding additional Accounting Xreferences to an already existing entity resulted in erroneously changing the existing xrefAccountIdType to the xrefAccountIdType from the incoming file.
Logic The logic for inserting the Accounting Xreferences is fixed.
...
SDP-19204: Omit date rule in the file mask if the daterule was added to the transform_pairs.inc
Now The date rule token that gets to the transform_pairs.inc is omitted.
Date The date rule token is part of the transform pair configuration (file mask and translator that is supposed to translate this file) configuration . If a user creates profiled a profile generic load through the EJM MT and Monitoring Tool an incoming file mask contains date rule token date rule.
Evaluation of date rule on translation distribution is excessive because only files that match date rule will get to translation step because of ndfa_exec logic.
...
SDP-18449: EagleML - IssuerEntityRelationship - Update the load logic to include changes made in the primary key on the issuer_entity_relation table
The following changes were added to accommodate changes made in to the primary key on securitydbo.issuer_entity_relation table which now has includes the fields relationship_type and start_date in addition to the issuer_alias and the entity_id in the primary key.
- Rebuilt the stored procedure for the insert/update issuerEntityRelationship to use the same primary key as in the database.
- Fixed the grouping according to the new primary key. Added the start_date and the relationship_type for grouping to the transformation to EagleML.
- Added missed the missing elements startComments , and endComments to the inbound and outbound interfaces.
- Added the ability to delete the issuerEntityRelationship records.
...
SDP-13632: EJM - In-memory Price Loading should return the Business Task ID in the TSR
Previously The in-memory processing for any interface didn't handle did not support the business task id from incoming RTR or PayLoad file.
Rule The rule for in memory processing was improved to handle the incoming value and output it in the final TSR.
Files changed:
eagle_ml-2-0_cm/in/xml/realtime_rtr.xml
eagle_ml-2-0_cm/out/tagvalue/realtime_ejm_stat.xml
SDP-14813: Update the User interface to insert records about delete in Journal table
Records were not getting added to Journal table on user the ser role delete event.Changed deleting method of user role. Records are added to Changed the process to have records added to the Journal table on the user role delete event.
Files changed:
eagleml_user_group.xml
user_common.inc
SDP-20038: Date Rules doesn't do not work when the environment use uses a HTTPS connection instead of HTTP
The Date Rule logic design always used the http protocol by default . It caused causing an issue when the environment used the https protocol.
Include The include file for the date rule logic was updated with an additional check for the calculation of the appropriate protocol to be used for the SOAP call.
...
Extracts were not working when the Delivery Method = JMS and the logic to check the JMS delivery stream execution status is turned on. This logic was not called in the T Streaming outbound stream due to the incorrect condition.
The variable that was used in condition to run check logic was updated to get the correct value.
Files changed:
eagle_ml-2-0_cm\reporter_dist_methods.inc
...
SDP-15915: In-Memory Process - display execution time of streams correctly in the file statistic
Issue was that for realtime processes the The start and end processing times were equal and did not show real time .Query on when using In-Memory processing.
The query on the reporting step has been improved to get produce the summary and detail information with the correct start and end processing time and display this information it correctly on the file statistic tab.
File changed:
realtime_ejm_stat.xml
SDP-14597: EJM The EJM workflow remains in progress when data load task request is sent with empty Workflowdata
In case when workflow was When the workflow is launched by an RTR with an empty WorkflowData task parameter, the workflow stayed would remain in progress and waited wait for a file.
Added support Support was added to handle the case when the WorkflowData defined in the RTR have has an empty value and can stop the workflow execution with ‘WorkflowData Parameter cannot be empty’ error
...
SDP-20196: Error Executing eml_update_issuer_organization
Rule The rule for the loading the issuer organization interface in XMLDBAPI format produced an error due to an incorrect SUB_MSG_TYPE.
Logic The logic for loading was improved to support prefix for auto generated binds.
File changed:
xml-dbdirect_issuer_common.inc
SDP-9609: Warehouse The Warehouse Nav Multi cannot be loaded into non-default partition
Warehouse Nav Multi inbound interface didn't did not support the load of data to the non -default partition due to issue in the bindprimary partition.
The logic for the bind generation was updated to support non -default partitionprimary partitions.
Files changed:
eagle_ml-2-0_cm/extract_sql_schema_name.inc
eagle_ml-2-0_cm/generate_and_save_bind.inc
...
SDP-20049: Pricing Center - Underlying Price Demand for security is still in progress
When the Pricing Center Event processes data , where the securities have an underlying security, the additional Underlying Price Demand events can be executed. They are launched after Pricing Center rules finished and they are not always catched caught by the logic, which checks Pricing Center event and its rules execution status. In this case, the EJM process is finished with the "Underlying Price Demand for security… is still in progress" error.
The logic with checking Pricing Center sub-events statuses was enhanced firstly to check if all sub-events were started and then to wait their completion.
...
SDP-16418: realtime_rtr.rsf to support unzipped messages for all reference data files - Variable Rates.
SDP-16419: realtime_rtr.rsf to support unzipped messages for all reference data files – Factors.
SDPSDP-16420: realtime_rtr.rsf to support unzipped messages for all reference data files -Schedules
Added support to load the following EagleML interfaces as single messages within in-memory processing:
Generic SMF, IssueVariableRate, Schedule, GenericCA
...
The new elements for mapping to DB table HOLDINGDBO.POSITION_DETAIL_LIQUIDITY were added to the XSD type WarehousePosition (complex element <liquidity>).
The new elements for mapping to DB table PERFORMDBO.PSR_LIQUIDITY were added to the XSD type WarehousePosition (complex element <liquidity>).
The new elements for mapping to DB table RULESDBO.ENTITY_LIQUIDITY were added to the XSD type GenericEntity (new complex element <entityLiquidity>).
Please note: the The new elements were not added to the inbound or outbound interfaces. It This is an XSD change only.
Files changed:
eagleml-entity-2-0.xsd
eagleml-entity-shared-2-0.xsd
eagleml-wh-shared-2-0.xsd
SDP-10090: Improve the XREFEXTRACT to use bind variables
Filters xrefidtype, To optimize throughput, the filters xrefidtype and securitysubtype were updated in order to use bind variables. Filter The filter securitysubtype was added to the common security filters.
Files changed:
eagle_ml-2-0_cm/extract_filter_smf.inc
eagle_ml-2-0_cm/out/tagvalue/extract_smf.inc
eagle_ml-2-0_cm/out/tagvalue/extract_xref.inc
...
SDP-9970: Correct error messages in the security_resolution_generic
Error An error message for security resolution was fixed for case to address when a security was not resolved by the provided incoming identifiers. Updated The updated message contains a list of identifiers that were a part of the resolution and a list of options.
Example of reported error message in the GenericCA:Security Security for the identifier(s) does not exist in Eagle:
99769N108_1/CUSIP, 99769N109_2/SEDOL. Resolution options: Currency: USD.
Also the following changes were done: - added In addition, the information status that displays the actual list of identifiers that were a part of the resolution and a list of options were added.
Example:
Resolution Based On:99769N108_1/CUSIP, 99769N109_2/SEDOL. Resolution options: Currency: USD.
Tag No Change Case: 1952,1955,1958,1961,1964,1967,1970,1973,1976,1979
Added a condition to include into resolution in the First Match mode resolution the 10th pair of identifiers, which contains the Primary Asset Identifier, only in case the value is not empty.
SDP–17647: Support outbound interface for VENDORCASHFLOW
An outbound interface for the VendorCashFlow object was created.
Feed type: VENDORCASHFLOWEXTRACT
Supported EagleML filters:
Date Filter
Sources Filter
Security Master File (SMF) Filter
Held Only Filter
The extract was added to the eagle_wrf_generic_extract workflow.
Files added:
eagle_ml-2-0_cm/out/tagvalue/extract_ref_vendor_cash_flow.inc
eagle_ml-2-0_cm/out/tagvalue/extract_ref_vendor_cash_flow.xml
eagle_ml-2-0_cm/out/xml/t_ref_vendor_cash_flow_streaming.inc
eagle_ml-2-0_cm/out/xml/t_ref_vendor_cash_flow_streaming.xml
Files changed:
changes in the eagle_wrf_generic_extract workflow
eagle_ml-2-0_cm\ w_config.inc
eagle/estar/EAGLE_ML_2_0.pkg
eagle/estar/eagle_ml-2-0_default_out_q.pkg
eagle/estar/eagle_ml-2-0_default_out_streaming_t.pkg
/eagle_ml-2-0_cm/out/tagvalue/extracts.rsf
/eagle_ml-2-0_cm/out/xml/t_eagleml-2-0_streaming.rsf
SDP-19071: The Security Resolution is not using assetCurrency when the PC Price is loaded.
An issue was detected with the assetCurrency missing for Issue PC Price security resolution.
In order to avoid this issue, mapping for assetCurrency (tag85) was added for The issue was resolved by mapping the assetCurrency - tag85 for the Issue PC Price inbound interface.
Files changed:
/eagle_default/in/xml/include/ xml-ref_security_pricing_common.inc
SDP-10341: Entity Enhance the Entity Extract to have an Additional Filter to allow extracting Active Entities only
There was added a A new filter 'activeStatus' for defined as activeStatus was added to the Generic Entity Extract - ENTITYEXTRACT to leverage enable filtering records by the RULESDBO.ENTITY.ACTIVE_STATUS field.
Example:
<taskParameter>
<name>activeStatus</name>
<dataType>S</dataType>
<value>Y</value>
</taskParameter>
A value of Y will only return the entities with an active status. The default will return all entities.
Files changed:
extract_entity.inc
extract_filter_sql.inc
...
SDP-14769: Update logic for tag 2301 in secmastersynthetic.inc for Options
Synthetic Securities logic adjustment. Now Synthetic Security type depends on Updated the synthetic securities logic. The synthetic security type was revised to depend on the Processing Security type.
Files changed:
eagle_default\in\xml\include\secmastersynthetic.inc