Page Comparison

...

SDP-14318 : Duplicate identifier in DB database after SMF update

The problem was that Duplicated A duplicate identifier was posting to the database during SMF updates. The duplicated Xref Identifiers were added to the same security when the Accounting Validation Flag is set to passed with a value of Y.

In In order to resolve the issue, we had to initialize variables the variables are set to be reinitialized in the rule.

Changed files:
eagle_default\in\xml\include\security_resolution_generic.inc

...

Accounting Trade and Multiple Leg Accounting Trade interfaces were enhanced to support the tagNochangecase element. This element is mapped to the tag 4637 in the Trade panels and specifies which tag elements should maintain their original case.

Files changed:

\dynamic\msgcenter\eagle_default\in\include\csv-buy_columns.inc
\dynamic\msgcenter\eagle_default\in\include\csv-cancel_columns.inc
\dynamic\msgcenter\eagle_default\in\include\csv-capfundinvestments_columns.inc
\dynamic\msgcenter\eagle_default\in\include\csv-conversion_columns.inc
\dynamic\msgcenter\eagle_default\in\include\csv-deliver.inc
\dynamic\msgcenter\eagle_default\in\include\csv-fxfwd_columns.inc
\dynamic\msgcenter\eagle_default\in\include\csv-fxspot.inc
\dynamic\msgcenter\eagle_default\in\include\csv-receive.inc
\dynamic\msgcenter\eagle_default\in\include\csv-sell_columns.inc
\dynamic\msgcenter\eagle_default\in\include\trade_aliases.inc
\dynamic\msgcenter\eagle_default\in\xml\xml-accttrade_multipleleg.xml
\dynamic\msgcenter\eagle_default\in\xml\include\multiplelegtrade_aliases.inc
\dynamic\msgcenter\eagle_default\in\xml\include\multiplelegtrade_common_columns.inc

SDP-10683 : Create new EagleML extract to retrieve a listing of AEW events

A new outbound interface was created for the new ControlCenterEventLog EagleML object.

Feed type: CONTROLCENTEREVENTLOGEXTRACT
Main table: CTRLCTR.EVENT_GROUP
Additional tables: CTRLCTR.EVENT_GROUP_DETAILS, CTRLCTR.QUERY_EVENT_GROUP_TAGS

Supported date filter for extract:
- UpdateDate
Supported own filters for extract:
- eventgroupname (filters on the 'eventGroupName' field, DB field name: EVENT_GROUP.EVENT_NAME)
- eventtaskid (filters on the 'eventTaskId' field, DB field name: EVENT_GROUP.TASK_ID)
- activeflag (filters on the 'activeFlag' field, DB field name: EVENT_GROUP.ACTIVE_FLAG)
- completedflag (filters on the 'completedFlag' field, DB field name: EVENT_GROUP.COMPLETED_FLAG)
- coregroup (filters on the 'coreGroup' field, DB field name: EVENT_GROUP.CORE_GROUP)
- statisticcategory (filters on the 'statisticCategory' field, DB field name: EVENT_GROUP.STATISTICS_CATEGORY)
- statisticname (filters on the 'statisticName' field, DB field name: EVENT_GROUP.STATISTICS_NAME)
- statistictype (filters on the 'statisticType' field, DB field name: EVENT_GROUP.STATISTICS_TYPE)
- businessprocessinggroup (filters on the 'businessProcessingGroup' field, DB field name: EVENT_GROUP.BUS_PROCESS_GRP)

The extract has been added to the eagle_wrf_generic_extract workflow.

Sample RTR:

<EagleML xsi:type="RunTaskRequestSync" eaglemlType="RunTaskRequest" eaglemlVersion="2.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<header>
<messageId>CC59ADD40E1E069</messageId>
<sentBy>http://www.client.com</sentBy>
<sendTo>http://www.eagleinvsys.com/eagle_ml-2-0_default_cm_control_message</sendTo>
<replyTo>http://www.client.com/Eagle Control Messages</replyTo>
</header>
<taskIdentifier>
<correlationId>SDP10683_CCE_EXTRACT_${=import java.text.SimpleDateFormat ; new SimpleDateFormat("YYMMddHHmmssS").format(new Date())}</correlationId>
<businessTaskId>AEW_Extract_SC2</businessTaskId>
</taskIdentifier>
<taskTypeEnum>LOAD</taskTypeEnum>
<synchronousExecution>no</synchronousExecution>
<taskParameters>
<taskParameter>
<name>ActionType</name>
<dataType>S</dataType>
<value>EXTRACT</value>
</taskParameter>
<taskParameter>
<name>StreamName</name>
<dataType>S</dataType>
<value>eagle_ml-2-0_default_out_q</value>
</taskParameter>
<taskParameter>
<name>FeedType</name>
<dataType>S</dataType>
<value>CONTROLCENTEREVENTLOGEXTRACT<Sample RTR:

<EagleML xsi:type="AccountingTransactionMessage" eaglemlVersion="2-0" eaglemlType="AccountingTransactionMessage" xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0">
<header>
<messageId>EML-In_TRADE</messageId>
<sentBy>user</sentBy>
<sendTo>http://www.eagleinvsys.com/eagle_ml-2-0_default_cm_control_message</sendTo>
</header>
<taskIdentifier>
<correlationId>EML-In_Conversion_{GUID}</correlationId>
<businessTaskId>EML-In_TRADE</businessTaskId>
</taskIdentifier>
<accountingTransaction>
<header>
<identifier>
<transactionId>ticket4</transactionId>
</identifier>
<objectType>AccountingTrade</objectType>
</header>
<accountingTrade>
<accountingValidationFlag>Y</accountingValidationFlag>
<buySellIndicator>BUY</buySellIndicator>
<mcModeSwitch>N</mcModeSwitch>
<entityId>SMPLE001</entityId>
<accountingBasis>USTAX</accountingBasis>
<primaryAssetId>EQJNZ5516</primaryAssetId>
<primaryAssetType>INTERNAL</primaryAssetType>
<assetResolutionOption>MATCH_ALL</assetResolutionOption>
<tradeDate>20190102</tradeDate>
<settlementDate>20190102</settlementDate>
<sharesParQuantity>300000.0</sharesParQuantity>
<price>100.00</price>
<brokerCode>EAGLE</brokerCode>
<originalTradeTicketNumber>ticketAaBb</originalTradeTicketNumber>
<longShortIndicator>L</longShortIndicator>
<calculateLocalAmountsFlag>Y</calculateLocalAmountsFlag>
<calculateBaseAmountsFlag>Y</calculateBaseAmountsFlag>
<settleInstructions1>xsettleontrade</settleInstructions1>
<tagNochangecase>5032,26,457</tagNochangecase>
</accountingTrade>
</accountingTransaction>
</EagleML>

Files changed:

\dynamic\msgcenter\eagle_default\in\include\csv-buy_columns.inc
\dynamic\msgcenter\eagle_default\in\include\csv-cancel_columns.inc
\dynamic\msgcenter\eagle_default\in\include\csv-capfundinvestments_columns.inc
\dynamic\msgcenter\eagle_default\in\include\csv-conversion_columns.inc
\dynamic\msgcenter\eagle_default\in\include\csv-deliver.inc
\dynamic\msgcenter\eagle_default\in\include\csv-fxfwd_columns.inc
\dynamic\msgcenter\eagle_default\in\include\csv-fxspot.inc
\dynamic\msgcenter\eagle_default\in\include\csv-receive.inc
\dynamic\msgcenter\eagle_default\in\include\csv-sell_columns.inc
\dynamic\msgcenter\eagle_default\in\include\trade_aliases.inc
\dynamic\msgcenter\eagle_default\in\xml\xml-accttrade_multipleleg.xml
\dynamic\msgcenter\eagle_default\in\xml\include\multiplelegtrade_aliases.inc
\dynamic\msgcenter\eagle_default\in\xml\include\multiplelegtrade_common_columns.inc

SDP-10683 : Create new EagleML extract to retrieve a listing of AEW events

A new outbound interface was created for the new ControlCenterEventLog EagleML object.

Feed type: CONTROLCENTEREVENTLOGEXTRACT
Main table: CTRLCTR.EVENT_GROUP
Additional tables: CTRLCTR.EVENT_GROUP_DETAILS, CTRLCTR.QUERY_EVENT_GROUP_TAGS

Supported date filter for extract:
- UpdateDate
Supported own filters for extract:
- eventgroupname (filters on the 'eventGroupName' field, DB field name: EVENT_GROUP.EVENT_NAME)
- eventtaskid (filters on the 'eventTaskId' field, DB field name: EVENT_GROUP.TASK_ID)
- activeflag (filters on the 'activeFlag' field, DB field name: EVENT_GROUP.ACTIVE_FLAG)
- completedflag (filters on the 'completedFlag' field, DB field name: EVENT_GROUP.COMPLETED_FLAG)
- coregroup (filters on the 'coreGroup' field, DB field name: EVENT_GROUP.CORE_GROUP)
- statisticcategory (filters on the 'statisticCategory' field, DB field name: EVENT_GROUP.STATISTICS_CATEGORY)
- statisticname (filters on the 'statisticName' field, DB field name: EVENT_GROUP.STATISTICS_NAME)
- statistictype (filters on the 'statisticType' field, DB field name: EVENT_GROUP.STATISTICS_TYPE)
- businessprocessinggroup (filters on the 'businessProcessingGroup' field, DB field name: EVENT_GROUP.BUS_PROCESS_GRP)

The extract has been added to the eagle_wrf_generic_extract workflow.

Sample RTR:

<EagleML xsi:type="RunTaskRequestSync" eaglemlType="RunTaskRequest" eaglemlVersion="2.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<header>
<messageId>CC59ADD40E1E069</messageId>
<sentBy>http://www.client.com</sentBy>
<sendTo>http://www.eagleinvsys.com/eagle_ml-2-0_default_cm_control_message</sendTo>
<replyTo>http://www.client.com/Eagle Control Messages</replyTo>
</header>
<taskIdentifier>
<correlationId>SDP10683_CCE_EXTRACT_${=import java.text.SimpleDateFormat ; new SimpleDateFormat("YYMMddHHmmssS").format(new Date())}</correlationId>
<businessTaskId>AEW_Extract_SC_ALL</businessTaskId>
</taskIdentifier>
<taskTypeEnum>LOAD</taskTypeEnum>
<synchronousExecution>no</synchronousExecution>
<taskParameters>
<taskParameter>
<name>ActionType</name>
<dataType>S</dataType>
<value>EXTRACT</value>
</taskParameter>
<taskParameter>
<name>StreamName</name>
<dataType>S</dataType>
<value>eagle_ml-2-0_default_out_q</value>
</taskParameter>
<taskParameter>
<name>FeedType</name>
<dataType>S</dataType>
<value>CONTROLCENTEREVENTLOGEXTRACT</value>
</taskParameter>

<taskParameter>
<name>eventgroupname</name>
<dataType>S</dataType>
<value>CC-COST-INC-CHG-EXCP-PROCESS</value>
</taskParameter>





<taskParameter>
<name>completedflag</name>
<dataType>S</dataType>
<value>Y</value>
</taskParameter>

<taskParameter>
<name>coregroup</name>
<dataType>S</dataType>
<value>N</value>
</taskParameter>

<taskParameter>
<name>statisticcategory</name>
<dataType>S</dataType>
<value>M-ACCT-PD-CLOSE</value>
</taskParameter>

<taskParameter>
<name>statisticname</name>
<dataType>S</dataType>
<value>RATES</value>
</taskParameter>

<taskParameter>
<name>eventgroupname<<name>statistictype</name>
<dataType>S</dataType>
<value>CC-COST-INC-CHG-EXCP-PROCESS<<value>ALL</value>
</taskParameter>

<taskParameter>
<name>coregroup<<name>businessprocessinggroup</name>
<dataType>S</dataType>
<value>Y<<value>ALL</value>
</taskParameter>
</taskParameters>
</EagleML>

...

SDP-14727 : ENTITYENTITLEMENTLISTEXTRACT - Missing ObjectionDescription ObjectDescription in Output for MC Classic

Missing mapping for The objectDescription field has been added in the extract transform rule for EntityEntitlementList.

Changed files:
t_ref_entity_entitlement_list_streaming.xml
t_ref_entity_entitlement_list_streaming.inc

...

SDP-14354 : EntityShareClass, EntityStatistics, EntityRating - fix minor output and grouping issues

The ENTITYSHARECLASSEXTRACT, ENTITYSTATISTICEXTRACT and ENTITYRATINGEXTRACT were all updated to correct identified output and to improve the grouping of the data.

ENTITYSHARECLASSEXTRACT - EntityShareClass:
The EntityShareClass extract contained an empty heldAsset node.
Transform The transform rule has been updated to not output produce an empty node if there is no information inside.EntityRating

ENTITYRATINGEXTRACT - Entity Rating:
The EntityRating extract transform rule didn't did not group records by source, as a result invalid by XSD EagleML could be created against what is defined in the XSD.
Source The source field has been added in the grouping for the EntityRating interface in the extract transform rule.

ENTITYSTATISTICEXTRACT - EntityStatistics
EntityStatistics extract The EntityStatistic extract transform rule didn't did not group records by source, as a result invalid by XSD EagleML could be created against what is defined in the XSD.
Also The effectiveDate field didn't have was updated to include mapping.
Source The source field has been added in the grouping for EntityStatistics the EntityStatistic interface in the extract transform rule and added mapping for effectiveDate field.

Changed files:
t_entity_share_class_streaming.inc
t_entity_rating_streaming.inc
t_entity_statistics_streaming.inc

...

SDP-15920 : Workflow_restart stream isn't failed if underlying workflow is failed

The issue was that the corresponding event and schedule for schedule-based workflow did not get correct status in case when the underlying workflow fails.

The issue has been fixed by setting the overall status of the workflow as FAILED in case when the CreateConsolidatedTSR is defined as Y and the underlying steps have errors.

Changed files:

task_reporter.xmlworkflowxmlworkflow_restart.xml

SDP-10820 : EJM : Adjust eagle_ml-2-0_default_cm_sequencer to have correct out of order logic

...

Versions Compared

Old Version 8

New Version 9

Key