|
---|
Anchor |
---|
| w_eagleml_streaming |
---|
| w_eagleml_streaming |
---|
| w_eagleml_streaming | Y, N |
Code Block |
---|
| <CODE>
:w_eagleml_streaming: := 'Y';
</CODE> |
| Toggles using streaming extracts in an environment. Please note, that this parameter was introduced in June 2016 EagleML Release. Its alternative obsolete version is w_eagleml_streaming_t which is strongly not recommended for newer environments. |
Anchor |
---|
| w_eagleml_streaming_t_feeds |
---|
| w_eagleml_streaming_t_feeds |
---|
| w_eagleml_streaming_t_feeds | formatted list of feedtypes |
Code Block |
---|
| <CODE>
:w_eagleml_streaming_t_feeds: := '||ENTITYEXTRACT|GENCORPACTIONSEXTRACT|
WRHSPENDINGTRADESEXTRACT|ENTITYSHARECLASSEXTRACT|
ACCRUEDINCOMEEXTRACT|WRHSCSTDBALANCEEXTRACT|';
</CODE> |
| Sets the list of feedtypes that will utilize streaming extracts, if such exist. Default value: all feedtypes (the list may vary for different EagleML versions). Please note, that this parameter was introduced in June 2016 EagleML Release. Its alternative obsolete version is w_eagleml_streaming_t which is strongly not recommended for newer environments |
Anchor |
---|
| W_KEEP_ORIGINAL_FN_STREAMING |
---|
| W_KEEP_ORIGINAL_FN_STREAMING |
---|
| W_KEEP_ORIGINAL_FN_STREAMING | N, Y (default) |
Code Block |
---|
| <CODE>
CreateVariable('W_KEEP_ORIGINAL_FN_STREAMING','Y');
</CODE> |
| If you create a custom streaming transformation step using IWS, the generated code will contain a link to core EJM file (/eagle_ml-2-0_cm/streaming_task_getinfo.inc). After publish if you drop any file into this process, the code inside core include file will overwrite the original incoming file name by simple CorrId value and cause errors. This parameter by default has Y (or empty) value – in this case original file name will be kept in the TSR. If set to N – then only CorrID value will be in the processed file name in TSR. |
Anchor |
---|
| W_FORCE_EMPTY_EXTRACTFILE |
---|
| W_FORCE_EMPTY_EXTRACTFILE |
---|
| W_FORCE_EMPTY_EXTRACTFILE | Y, N |
Code Block |
---|
| <CODE>
CreateVariable('W_FORCE_EMPTY_EXTRACTFILE','Y');
</CODE> |
| Generates an empty extraction file in case you get NO_DATA. Its task parameter version for RTR is ForceExtractFileCreation |
Anchor |
---|
| DEFAULT_EAGLEML_EXTRACT_COMPRESS |
---|
| DEFAULT_EAGLEML_EXTRACT_COMPRESS |
---|
| DEFAULT_EAGLEML_EXTRACT_COMPRESS | Y, N |
Code Block |
---|
| <COL TAG="DEFAULT_EAGLEML_EXTRACT_COMPRESS" EXPRESSION="'N'" USERDESCRIPTION="Compress extract file to zip/gz archive"/> |
| Toggle extract file compression (zip/gz archive). |
Anchor |
---|
| COMPRESS_WITH_CORR_ID |
---|
| COMPRESS_WITH_CORR_ID |
---|
| COMPRESS_WITH_CORR_ID | Y, N |
Code Block |
---|
| <COL TAG="COMPRESS_WITH_CORR_ID" EXPRESSION="'N'"/> |
| Extraction with 'compress' parameter. |
Anchor |
---|
| W_AUTOADDBASIS |
---|
| W_AUTOADDBASIS |
---|
| W_AUTOADDBASIS | Y, N |
Code Block |
---|
| <COL TAG="W_AUTOADDBASIS" EXPRESSION="'N'"/> |
| Entity Accounting Periods extract option. If W_AUTOADDBASIS = Y the extract will contain <autoAddBasis>Y</autoAddBasis> node. If such extracted file is sent for load afterwards, the inbound rule will load a new Accounting Basis (a row in RULESDBO.ENTITY_ACCT_BASIS) if it cannot find the Account Basis set in the inbound rule for the Portfolio Acct (Entity Id) in DB. This option is especially useful for ETL processes in which the extract is sent for load at once. |
Anchor |
---|
| EXCLUDE_SECURITY_ALIAS |
---|
| EXCLUDE_SECURITY_ALIAS |
---|
| EXCLUDE_SECURITY_ALIAS | Y or empty (default) |
| Exclude Security Alias from all extracts. |
Anchor |
---|
| W_INCLUDE_SECALIAS_FORWHS |
---|
| W_INCLUDE_SECALIAS_FORWHS |
---|
| W_INCLUDE_SECALIAS_FORWHS | Y or empty (default) |
| Enable adding Security Alias for Warehouse extracts. Has a higher priority than EXCLUDE_SECURITY_ALIAS for Warehouse objects. |
Anchor |
---|
| W_INCLUDE_ENTITY_INFO |
---|
| W_INCLUDE_ENTITY_INFO |
---|
| W_INCLUDE_ENTITY_INFO | N (default), Y, ALL |
Code Block |
---|
| <COL TAG="W_INCLUDE_ENTITY_INFO" EXPRESSION="'Y'"/> |
| A setting for extracts with Entity fields (such as Entity Id, Name, Xref etc). N: The following fileds are extracted: Entity Id, Entity Name, Entity Type, Xref Account Id, Xref Account Id Type, Xref Class Code Y: These fields are extracted along with ones above: Long Entity Name, Legal Entity Name, Total Count Share Class, Partition Number ALL: Physical Partition fields are extracted along with all fields above: PPTRADES, PPHOLDING, PPCASH, PPPERFORM, PPLEDGER See a more detailed description of these fields. |
Anchor |
---|
| W_INCLUDE_ALL_ENT_XREF |
---|
| W_INCLUDE_ALL_ENT_XREF |
---|
| W_INCLUDE_ALL_ENT_XREF | Y (default), N |
| This parameter works for all EagleML objects with Entity fields except for Warehouse. If set to Y, all Entity Xref identifiers existing in DB for the Entity Id are extracted. If set to N, only one set of Entity Xref identifiers is extracted. |
Anchor |
---|
| W_USE_NUMERATION_FOR_XREFS |
---|
| W_USE_NUMERATION_FOR_XREFS |
---|
| W_USE_NUMERATION_FOR_XREFS | N (default), Y |
Code Block |
---|
| <COL TAG="W_USE_NUMERATION_FOR_XREFS="'Y'"/> |
| When set to Y, numeration is added for entity and security xref elements: Code Block |
---|
| <entityXrefs>
<entityXref1>
<xrefAccountId>BT3903IU_TYPE2</xrefAccountId>
<xrefAccountIdType>TST</xrefAccountIdType>
</entityXref1>
<entityXref2>
<xrefAccountId>BT3903IU_TYPE3</xrefAccountId>
<xrefAccountIdType>TST</xrefAccountIdType>
</entityXref2>
</entityXrefs> |
This can also be applied to a single extract by using task parameter UseNumerationForXrefs. |
Anchor |
---|
| W_INCLUDE_REPORT_DETAILS |
---|
| W_INCLUDE_REPORT_DETAILS |
---|
| W_INCLUDE_REPORT_DETAILS | N (default), Y |
| If set to Y, the following fields are added to the extract inside the <navReportDetails> complex node. - Prior NAV (NAV for the previous Valuation Date),
- Mkt Value Cash (elements from the Position Detail table in case Base Currency = Local Currency or sum of elements in case Base Currency != Local Currency),
- Share Class Level (elements of ARCH_CTRLCTR.NAV_DETAILS table linked with main table via Valuation Date, Entity Id, Share Class),
- Total Fund Level (elements of ARCH_CTRLCTR.NAV_DETAILS сtable linked with main table via Valuation Date, Entity Id for Share Class = 'TF')
- Distribution Log Level
Works only with WRHSNAVMONTHENDEXTRACT feedtype Alternative for a single extract event is the RTR parameter includeReportDetails |
Anchor |
---|
| W_INCLUDE_REPORT_DETAILS |
---|
| W_INCLUDE_REPORT_DETAILS |
---|
| W_INCLUDE_CUSTOM_REPORT_DETAILS | N (default), Y |
| If set to Y, the following fields are added to the extract inside the <navReportDetails> complex node. - Prior NAV (NAV for the previous Valuation Date),
- Mkt Value Cash (elements from the Position Detail table in case Base Currency = Local Currency or sum of elements in case Base Currency != Local Currency),
- Share Class Level (elements of ARCH_CTRLCTR.NAV_DETAILS table linked with main table via Valuation Date, Entity Id, Share Class),
- Total Fund Level (elements of ARCH_CTRLCTR.NAV_DETAILS сtable linked with main table via Valuation Date, Entity Id for Share Class = 'TF')
Works only with WRHSNAVMULTIEXTRACT feedtype Alternative for a single extract event is the RTR parameter includeCustomReportDetails |
Anchor |
---|
| W_INCLUDE_ASSET_PROPERTIES |
---|
| W_INCLUDE_ASSET_PROPERTIES |
---|
| W_INCLUDE_ASSET_PROPERTIES | N (default), Y |
Code Block |
---|
| <COL TAG="W_INCLUDE_ASSET_PROPERTIES" EXPRESSION="'Y'"/> |
| If set to Y, the Asset Properties model is added to the extract. |
Anchor |
---|
| W_FORWARD_SINGLE_LEG_MODE |
---|
| W_FORWARD_SINGLE_LEG_MODE |
---|
| W_FORWARD_SINGLE_LEG_MODE | N (default), Y |
Code Block |
---|
| <COL TAG="W_FORWARD_SINGLE_LEG_MODE" EXPRESSION="'Y'"/> |
| Setting to Y adds singleLegLoadFlag = Y element to all SMFEXTRACT. RTR parameter version is SetSingleLegLoadFlagValue |
Anchor |
---|
| w_[FeedType]_profile |
---|
| w_[FeedType]_profile |
---|
| w_[FeedType]_profile | QueryProfileName |
Code Block |
---|
| <COL TAG="W_INCLUDE_ASSET_PROPERTIES" EXPRESSION="'Y'"/> |
| Applies an element reduction profile to all extracts of the feedtype. |
Anchor |
---|
| W_EXTRACTS_EXCLUDE_0 |
---|
| W_EXTRACTS_EXCLUDE_0 |
---|
| W_EXTRACTS_EXCLUDE_0 | N (default), Y |
Code Block |
---|
| <COL TAG="W_EXTRACTS_EXCLUDE_0" EXPRESSION="'Y'"/> |
| Toggles removing numeric fields with zero values from the extract to decrease its volume. Valid only for Warehouse objects. Supported with regular extracts as well as with the Generic Extract workflow. Please note, that this parameter was introduced in June 2016 EagleML Release. Its alternative obsolete version is EXTRACTS_EXCLUDE_0 which is strongly not recommended for newer environments |
wa_DateRule | parameters declared in specific format |
Code Block |
---|
| <COL TAG="wa_DateRule" EXPRESSION="'url;http://localhost:9001!user;username!password;
EXPR#:wa_DateRulePass:!soapaction;!'"/> |
| Enables date rules for extracts. One of the parameters is the username you use in the environment. |
Anchor |
---|
| wa_DateRulePass |
---|
| wa_DateRulePass |
---|
| wa_DateRulePass | password | Example before encryption: Code Block |
---|
| <COL TAG="wa_DateRulePass" EXPRESSION="'eaglepassword'"/> |
Example after encryption: Code Block |
---|
| <COL TAG="wa_DateRulePass" EXPRESSION="'base64aes~esC4Vn7jf6jjf0/SXstfjdw46mufgl0k/t'" ENCRYPTED="YES"/> |
| The password for the user name in the environment you specified in wa_DateRule parameter. Encryption is mandatory. |
Anchor |
---|
| W_REMOVE_ENTITY_DUPLICATES |
---|
| W_REMOVE_ENTITY_DUPLICATES |
---|
| W_REMOVE_ENTITY_DUPLICATES | N (default), Y |
Code Block |
---|
| <COL TAG="W_REMOVE_ENTITY_DUPLICATES" EXPRESSION="'Y'"/> |
| Enables/disables extraction of duplicate entities for entityselectiontype = ENTITYID filter. You do not get duplicate entities if set to 'Y'. |
Anchor |
---|
| W_ENTITY_UPDATE_DEEP |
---|
| W_ENTITY_UPDATE_DEEP |
---|
| W_ENTITY_UPDATE_DEEP | N (default), Y |
Code Block |
---|
| <COL TAG="W_ENTITY_UPDATE_DEEP" EXPRESSION="'Y'"/> |
| Switch to Y, if you want to use XREF and LEI tables to filter records by update_date. E.g., you have an entity with update date 1/1/2012 with a linked XREF of 1/1/2014. Using update date filter by 1/1/2013 with W_ENTITY_UPDATE_DEEP option will return. |
Anchor |
---|
| W_INCREASE_LAST_RUN_DATE_TIME |
---|
| W_INCREASE_LAST_RUN_DATE_TIME |
---|
| W_INCREASE_LAST_RUN_DATE_TIME | ALWAYS (default), NEVER, ONLY_DATA_EXTRACTED |
Code Block |
---|
| <COL TAG="W_INCREASE_LAST_RUN_DATE_TIME" EXPRESSION="'ONLY_DATA_EXTRACTED'"/> |
| This parameter works only with delta-based extracts. ALWAYS - always rewrite the last run date value after delta-based extraction NEVER - switches off rewriting last run date ONLY_DATA_EXTRACTED - change last run date only if some data has been extracted |
Anchor |
---|
| W_LINKED_ASSET_ONLY_DELTA |
---|
| W_LINKED_ASSET_ONLY_DELTA |
---|
| W_LINKED_ASSET_ONLY_DELTA | N (default), Y |
Code Block |
---|
| <COL TAG="W_LINKED_ASSET_ONLY_DELTA" EXPRESSION="'Y'"/> |
| This parameter works only with ReportDictionary extracts. If this parameter is set to Y, then whenever we do a delta based dictionary extract, we should only look at SECURITY_DICTIONARY_LINK.SECURITY_DATE to determine the linked assets (and their corresponding dict detail) records to extract. There is no need to check dict detail update_date for delta based dictionary extracts in the selection criteria if that flag is set to Y. Available as an RTR task parameter. |
Anchor |
---|
| W_TAKE_BASE_CURRENCY_FROM_WRHS_POS_DET |
---|
| W_TAKE_BASE_CURRENCY_FROM_WRHS_POS_DET |
---|
| W_TAKE_BASE_CURRENCY_FROM_WRHS_POS_DET | N (default), Y |
Code Block |
---|
| <COL TAG="W_TAKE_BASE_CURRENCY_FROM_WRHS_POS_DET" EXPRESSION="'Y'"/> |
| A parameter exclusively for Warehouse Position extracts. Forces taking the value for baseCurrency from HOLDINGDBO.POSITION_DETAIL.BASE_CURRENCY instead of HOLDINGDBO.POSITION.BASE_CURRENCY field. Also available as a task parameter in the RTR TakeBaseCurrencyFromWRHSPosDet |
Anchor |
---|
| W_ADD_BUSINESSTASKID_EXTRACTS |
---|
| W_ADD_BUSINESSTASKID_EXTRACTS |
---|
| W_ADD_BUSINESSTASKID_EXTRACTS | Y(default), N |
Code Block |
---|
| <COL TAG="W_ADD_BUSINESSTASKID_EXTRACTS" EXPRESSION="'Y'"/> |
| By default, businessTaskId element (inside taskIdentifier root node, next to the correlationId node) is extracted. Setting W_ADD_BUSINESSTASKID_EXTRACTS to N removes businessTaskId from the extract. This parameter is available since July 2017 EagleML release |
Anchor |
---|
| W_INCLUDE_COMMON_TRANSACTIONS_INFO |
---|
| W_INCLUDE_COMMON_TRANSACTIONS_INFO |
---|
| W_INCLUDE_COMMON_TRANSACTIONS_INFO | formatted list of feedtypes |
Code Block |
---|
| <CODE>
:W_INCLUDE_COMMON_TRANSACTIONS_INFO: := 'CODEVALEXTRACT,ENTITYEXTRACT';
</CODE> |
| Adds a commonTransactionsInformation model with values of dates you have used in your Date filter (please note, that not all date filters are supported by your specific feedtype, refer to the table for date filters). Available as an RTR task parameter - IncludeCommonTransactionsInfo |
Anchor |
---|
| W_INCLUDE_EXTRACT_STATS |
---|
| W_INCLUDE_EXTRACT_STATS |
---|
| W_INCLUDE_EXTRACT_STATS | N (default), Y |
Code Block |
---|
| <COL TAG="W_INCLUDE_EXTRACT_STATS" EXPRESSION="'Y'"/> |
| Setting to Y adds extractStats model to TSRs for all extracts on the region. Currently supported for the following interfaces: Schedule, GenericSMF, WarehouseCashActivity, WarehouseCashFlowProjection, WarehouseCloseLot, CustodyRestrictionActivity, CustodyRestrictionBalance, WarehouseDisclosureStatus, WarehouseGLBalances, WarehouseNAVMonthEnd, WarehouseNAVMulti, WarehouseNAV, WarehouseOpenLot, WarehousePendingTrade, WarehousePerformance, WarehousePosition, WarehouseTrade, WarehouseWashSaleTrade |
Anchor |
---|
| W_RECORD_COUNT_PER_NUGGET |
---|
| W_RECORD_COUNT_PER_NUGGET |
---|
| W_RECORD_COUNT_PER_NUGGET | number |
Code Block |
---|
| <COL TAG="W_RECORD_COUNT_PER_NUGGET" EXPRESSION="'5'"/> |
| Sets the amount of records per batch. Task parameter version is MicroBatchKeyRecordCount |
Anchor |
---|
| W_SAVE_SQL_QUERY |
---|
| W_SAVE_SQL_QUERY |
---|
| W_SAVE_SQL_QUERY | Y(default), N |
Code Block |
---|
| :W_SAVE_SQL_QUERY: := 'N'; |
| When set to N removes query file *_Q.txt during extract process. |
Anchor |
---|
| W_DELETE_EXTRACT_DAT_FILE |
---|
| W_DELETE_EXTRACT_DAT_FILE |
---|
| W_DELETE_EXTRACT_DAT_FILE | N (default), Y |
Code Block |
---|
| :W_DELETE_EXTRACT_DAT_FILE: := 'Y'; |
| When set to Y deletes tag value *.dat file during extract process. |
Anchor |
---|
| W_ENABLE_S2P_REMAPPING_FLAG |
---|
| W_ENABLE_S2P_REMAPPING_FLAG |
---|
| W_ENABLE_S2P_REMAPPING_FLAG |
|
| Works only with WRHSTRADEEXTRACT Setting to Y enables S2P remaping for the following fields: 'secFee' is mapped into 'otherFee' 'secFeesBase' is mapped into 'otherFeeBase' 'exchangeFee' is mapped into 'secFee' 'exchangeFeeBase' is mapped into 'secFeeBase' 'otherFee' is mapped into 'exchangeFee' 'otherFeeBase' is mapped into 'exchangeFeeBase'. RTR parameter is EnableS2PReMappingFlag |
Anchor |
---|
| W_WRHS_EXECUTE_ROLLBACK_SWITCH |
---|
| W_WRHS_EXECUTE_ROLLBACK_SWITCH |
---|
| W_WRHS_EXECUTE_ROLLBACK_SWITCH | Y(default), N |
Code Block |
---|
| <COL TAG="W_WRHS_EXECUTE_ROLLBACK_SWITCH" EXPRESSION="'N'"/> |
| Setting to N disables the rollback in xmldbapi format. Works with WRHSOPENLOTEXTRACT and WRHSPOSITIONEXTRACT. |
Anchor |
---|
| EAGLEML_WRHS_EXTRACT_BATCH_MODE |
---|
| EAGLEML_WRHS_EXTRACT_BATCH_MODE |
---|
| EAGLEML_WRHS_EXTRACT_BATCH_MODE | Y(default), N |
Code Block |
---|
| :EAGLEML_WRHS_EXTRACT_BATCH_MODE: := 'N'; |
| Setting to N removes the Batch key added to Warehouse extracts in delta mode. RTR analog is BatchMode = N |
Anchor |
---|
| W_PRICINGREPORTEXTRACT_ACTIVE_FLAG |
---|
| W_PRICINGREPORTEXTRACT_ACTIVE_FLAG |
---|
| W_PRICINGREPORTEXTRACT_ACTIVE_FLAG | Y(default), N |
Code Block |
---|
| <CODE>
:W_PRICINGREPORTEXTRACT_ACTIVE_FLAG: = 'N';
</CODE> |
| Setting to Y allows bringing back pricing records only when the price validation rule has an Active status. The alternative for a single extract is pricingactiveflag RTR parameter. |
Delivery Methods |
FILE_IN_LOCATION
FILE_EXTRACT_LOCATION
FILE_REPLY_LOCATION
FILE_ACK_LOCATION |
Please refer to Configure Delivery Method Options page for a complete guide. |
FTP_URL FTP_USER FTP_PWD FTP_FILES_LOCATION FTP_EXTRACT_LOCATION FTP_REPLY_LOCATION FTP_ACK_LOCATION |
SFTP_URL SFTP_USER SFTP_PWD SFTP_PWD_ISENCRYPTED SFTP_FILES_LOCATION SFTP_EXTRACT_LOCATION SFTP_REPLY_LOCATION SFTP_ACK_LOCATION |
W_JMS_DEF_ACK_STREAM
W_JMS_DEF_REPLY_STREAM
W_JMS_DEF_EXTRACT_STREAM |
W_SMTPSERVERW_SMTPPORT
W_SENDMAILFROM
W_SENDMAILTO W_EMAIL_DEF_ACK_STREAM
W_EMAIL_DEF_REPLY_STREAM
W_EMAIL_DEF_EXTRACT_STREAM
W_EMAIL_DEF_ALERT_STREAM |
W_MQS_DEF_ACK_STREAM
W_MQS_DEF_REPLY_STREAM
W_MQS_DEF_EXTRACT_STREAM |
Purge and Archive |
---|
Anchor |
---|
| W_PA_SETTINGS |
---|
| W_PA_SETTINGS |
---|
| W_PA_SETTINGS | formatted value (more details here) |
Code Block |
---|
| <COL TAG="W_PA_SETTINGS" EXPRESSION="'FTP;FOLDER;CMW/inbound;*;ARCHIVE;data/msgcenter/ftp_archive;Y;72;N|
FTP;FOLDER;CMW/outbound;*;PURGE;;;48;N|
FTP;FOLDER;CMW/ack;*;PURGE;;;48;N|
FTP;FOLDER;CMW/control;*;PURGE;;;48;N|
FTP;FOLDER;CMW/extracts;*;PURGE;;;48;N|
FTP;FOLDER;CMW/archive;*;PURGE;;;48;N|
FTP;FOLDER;CMW/reply;*;PURGE;;;48;N|
FILE;ALLMCSTREAMFOLDERS;processing;*;PURGE;;;48;N|
FILE;ALLMCSTREAMFOLDERS;incoming;*;PURGE;;;48;N|'"/> |
| A number of objects to be purged or archived and the parameters of the process in the appropriate format. |
Anchor |
---|
| W_PA_SETTINGS_LOGGING_ENABLED |
---|
| W_PA_SETTINGS_LOGGING_ENABLED |
---|
| W_PA_SETTINGS_LOGGING_ENABLED | Y (default), N |
Code Block |
---|
| <COL TAG="W_PA_SETTINGS_LOGGING_ENABLED" EXPRESSION="'N'"/> |
| Toggle Purge and Archive logging. Available as an RTR task parameter - loggingEnabled. |
Anchor |
---|
| W_PA_SETTINGS_LOG_FILE_PATH |
---|
| W_PA_SETTINGS_LOG_FILE_PATH |
---|
| W_PA_SETTINGS_LOG_FILE_PATH | file path |
Code Block |
---|
| <COL TAG="W_PA_SETTINGS_LOG_FILE_PATH" EXPRESSION="GetDirRoot()+ 'logs/msgcenter/purgeandarchive/pa_log.log'"/> |
| File path for purge and archive log file. |
W_PA_MODE | LISTONLY or STANDARD |
Code Block |
---|
| <COL TAG="W_PA_MODE" EXPRESSION="'LISTONLY'"/> |
| Set purge and archive mode. See more details on this page. |
Anchor |
---|
| W_CONFIG_FTP_CLEANUP_LOCATION_LIST |
---|
| W_CONFIG_FTP_CLEANUP_LOCATION_LIST |
---|
| W_CONFIG_FTP_CLEANUP_LOCATION_LIST | list of folders and time intervals |
Code Block |
---|
| <COL TAG="W_CONFIG_FTP_CLEANUP_LOCATION_LIST" EXPRESSION="'/CMW/outbound/,21\n/CMW/inbound/,21\n/CMW/control/processed/,21\n'" USERDESCRIPTION="List of ftp folder for cleanup and purge intervals for them"/> |
| List of ftp folders to be cleaned up and purge intervals for them. |
Anchor |
---|
| W_CONFIG_FTP_CLEANUP_MODE |
---|
| W_CONFIG_FTP_CLEANUP_MODE |
---|
| W_CONFIG_FTP_CLEANUP_MODE | MOVE, DELETE |
Code Block |
---|
| <COL TAG="W_CONFIG_APP_CLEANUP_MODE" EXPRESSION="'MOVE'" USERDESCRIPTION="Valid values: MOVE or DELETE; if MOVE the variable W_CONFIG_FTP_CLEANUP_MOVE_FOLDER must be specified"/> |
| Cleanup mode: either MOVE or DELETE. If set to MOVE the 251923032 variable must be specified. |
Anchor |
---|
| W_CONFIG_FTP_CLEANUP_MOVE_FOLDER |
---|
| W_CONFIG_FTP_CLEANUP_MOVE_FOLDER |
---|
| W_CONFIG_FTP_CLEANUP_MOVE_FOLDER | folder path |
Code Block |
---|
| <COL TAG="W_CONFIG_FTP_CLEANUP_MOVE_FOLDER" EXPRESSION="'/CMW/archive/'" USERDESCRIPTION="Destination folder for MOVE"/> |
| The folder used in the ftp cleanup process. |
Anchor |
---|
| W_CONFIG_APP_CLEANUP_LOCATION_LIST |
---|
| W_CONFIG_APP_CLEANUP_LOCATION_LIST |
---|
| W_CONFIG_APP_CLEANUP_LOCATION_LIST | folders and time intervals |
Code Block |
---|
| <COL TAG="W_CONFIG_APP_CLEANUP_LOCATION_LIST" EXPRESSION="'CMW/reply'" USERDESCRIPTION="List of ftp folder for cleanup and purge intervals for them"/> |
| List of app folders for cleanup and purge intervals for them. |
Anchor |
---|
| W_CONFIG_APP_CLEANUP_MODE |
---|
| W_CONFIG_APP_CLEANUP_MODE |
---|
| W_CONFIG_APP_CLEANUP_MODE | MOVE, DELETE |
Code Block |
---|
| <COL TAG="W_CONFIG_APP_CLEANUP_MODE" EXPRESSION="'MOVE'" USERDESCRIPTION="Valid values: MOVE or DELETE; if MOVE the variable W_CONFIG_APP_CLEANUP_MOVE_FOLDER must be specified"/> |
| Cleanup mode: either MOVE or DELETE. If set to MOVE the W_CONFIG_APP_CLEANUP_MOVE_FOLDER variable must be specified. |
Anchor |
---|
| W_CONFIG_APP_CLEANUP_MOVE_FOLDER |
---|
| W_CONFIG_APP_CLEANUP_MOVE_FOLDER |
---|
| W_CONFIG_APP_CLEANUP_MOVE_FOLDER | folder path |
Code Block |
---|
| <COL TAG="W_CONFIG_APP_CLEANUP_MOVE_FOLDER" EXPRESSION="'CMW/archive/'" USERDESCRIPTION="Destination folder for MOVE"/> |
| The folder used in the app cleanup process. |
Anchor |
---|
| W_REPLYCM_MODE |
---|
| W_REPLYCM_MODE |
---|
| W_REPLYCM_MODE | N/OFF (default), Y/ON, ONonlyForIWS, ONuseExactFileName |
Code Block |
---|
| <COL TAG="W_REPLYCM_MODE" EXPRESSION="Y"/> |
| Works with IWS workflows - N or OFF - TSR/ASK messages are named by default.
- Y or ON - TSR/ASK messages are named as defined in the IWS solution.
- ONonlyForIWS - If the solution was created via IWS, the TSR/ASK messages are named as defined in the solution. If not defined - default names are assigned.
- ONuseExactFileName - excludes correlationID prefix from the file name when you use ACKStrictPattern or TSRStrictPattern parameters. Read more in EJM Job Notification Overview
Please note, that this option should be handled with care, because in case different processes get the same file patterns, files will be rewritten by the latter process.
You will find more details in the Setting Custom TSR/ACK Names tutorial on IWS wiki. |
Anchor |
---|
| W_REPLY_CUSTOM_LOCATIONS_MODE |
---|
| W_REPLY_CUSTOM_LOCATIONS_MODE |
---|
| W_REPLY_CUSTOM_LOCATIONS_MODE | N/OFF (default), Y/ON, ONonlyForIWS |
Code Block |
---|
| <COL TAG="W_REPLY_CUSTOM_LOCATIONS_MODE" EXPRESSION="Y"/> |
| Works with IWS workflows - Y or ON – TSR messages will be saved in ../cmw/reply/workflowname and ACK messages in ../cmw/ack/workflowname.
- N or OFF – TSR and ACK use default folders as their location.
- ONonlyForIWS – Only IWS created solutions will use custom folders as their location.
CustomReplyLocation and CustomAckLocation parameters override this parameter. Read more in the Setting Custom TSR/ACK Locations tutorial on IWS wiki. |
Generic Load and Generic Extract |
---|
Anchor |
---|
| EAGLE_EXTRACTOR_ZIP_TO_FTP |
---|
| EAGLE_EXTRACTOR_ZIP_TO_FTP |
---|
| EAGLE_EXTRACTOR_ZIP_TO_FTP | 0, 1 |
Code Block |
---|
| <COL TAG="EAGLE_EXTRACTOR_ZIP_TO_FTP" EXPRESSION="'1'" USERDESCRIPTION="Move result ZIP file to FTP yes(1) or no(0)"/> |
| Toggle moving result ZIP file to FTP. |
Anchor |
---|
| GENERIC_LOAD_DP_LOG_INSERT |
---|
| GENERIC_LOAD_DP_LOG_INSERT |
---|
| GENERIC_LOAD_DP_LOG_INSERT | 0, 1 |
Code Block |
---|
| <COL TAG="GENERIC_LOAD_DP_LOG_INSERT" EXPRESSION="'0'" USERDESCRIPTION="Use dp_log insert yes(1) or no(0)"/> |
| Toggle using an additional subprocess (dp_log insert) within Generic Load. |
Anchor |
---|
| W_GEN_EXTRACT_OUTPUT_FORMAT |
---|
| W_GEN_EXTRACT_OUTPUT_FORMAT |
---|
| W_GEN_EXTRACT_OUTPUT_FORMAT | XMLDBAPI (default), EagleML |
Code Block |
---|
| <COL TAG="W_GEN_EXTRACT_OUTPUT_FORMAT" EXPRESSION="'EagleML'"/> |
| Defines the format of Warehouse Position and Warehouse Open Lot extracts. |
Anchor |
---|
| W_ENABLE_VALIDATE_CACHE |
---|
| W_ENABLE_VALIDATE_CACHE |
---|
| W_ENABLE_VALIDATE_CACHE
Anchor |
---|
| W_CACHE_VALIDATION_WORKFLOW |
---|
| W_CACHE_VALIDATION_WORKFLOW |
---|
| W_CACHE_VALIDATION_WORKFLOW
Anchor |
---|
| W_CACHE_RELOAD_PERIOD |
---|
| W_CACHE_RELOAD_PERIOD |
---|
| W_CACHE_RELOAD_PERIOD
| N (default), Y workflow name time in seconds |
Code Block |
---|
| <CODE>
CreateVariable( 'W_ENABLE_VALIDATE_CACHE','Y' );
CreateVariable( 'W_CACHE_VALIDATION_WORKFLOW','any_workflow_name' );
CreateVariable( 'W_CACHE_RELOAD_PERIOD','3000' );
</CODE> |
| These three parameters allow to enable and control CacheValidation sub-process prior to the extract step. EnableValidateCache (RTR) and global parameter W_ENABLE_VALIDATE_CACHE to enable the step prior to extract CacheValidationWorkflow (RTR) and global parameter W_CACHE_VALIDATION_WORKFLOW which specifies the Name of the workflow which will be triggered via the sub-process CacheReloadPeriod (RTR) and global parameter W_CACHE_RELOAD_PERIOD which controls how often cache validation will run. The established setup time is in seconds.
|
Security Resolution |
---|
Anchor |
---|
| CONFIG_BATTING_ORDER |
---|
| CONFIG_BATTING_ORDER |
---|
| CONFIG_BATTING_ORDER | batting order |
Code Block |
---|
| <CODE>
CreateVariable( 'CONFIG_BATTING_ORDER','cusip,isin,sedol,reuters,
bloombergId,sicovmId,valorenId,cedel,internalId,cinsId,ticker');
</CODE> |
| Specify a batting order for all workflows that differs from the default |
Anchor |
---|
| CONFIG_XREF_MAP |
---|
| CONFIG_XREF_MAP |
---|
| CONFIG_XREF_MAP | xref map |
Code Block |
---|
| <CODE>
CreateVariable( 'CONFIG_XREF_MAP','');
</CODE> |
| Specify xref transformations that should occur for all files |
Anchor |
---|
| CONFIG_SEC_RES_OPTION |
---|
| CONFIG_SEC_RES_OPTION |
---|
| CONFIG_SEC_RES_OPTION | security resolution option |
Code Block |
---|
| <CODE>
CreateVariable( 'CONFIG_SEC_RES_OPTION','XREF_EXCHANGE,MATURITY_DATE,ASSET_CURRENCY');
</CODE> |
| Specify security resolution options that are different from default for an entire box (meaning, for all workflows, streams and other processes) Read more about security resolution.. |
Anchor |
---|
| CONFIG_BATTING_ORDER_EXTRACT |
---|
| CONFIG_BATTING_ORDER_EXTRACT |
---|
| CONFIG_BATTING_ORDER_EXTRACT | batting order |
Code Block |
---|
| <CODE>
CreateVariable( 'CONFIG_BATTING_ORDER_EXTRACT',
'cusip,isin,sedol,reuters,bloombergId,sicovmId,valorenId,cedel,internalId,cinsId,ticker');
</CODE> |
| Set a custom batting order for all extracts in the environment. |
Anchor |
---|
| CONFIG_XREF_MAP_EXTRACT |
---|
| CONFIG_XREF_MAP_EXTRACT |
---|
| CONFIG_XREF_MAP_EXTRACT | xref map |
Code Block |
---|
| <CODE>
CreateVariable( 'CONFIG_XREF_MAP_EXTRACT','');
</CODE> |
| Set a custom xref map for all extracts in the environment. |
Anchor |
---|
| CONFIG_SEC_RES_OPTION_EXTRACT |
---|
| CONFIG_SEC_RES_OPTION_EXTRACT |
---|
| CONFIG_SEC_RES_OPTION_EXTRACT | security resolution option |
Code Block |
---|
| <CODE>
CreateVariable( 'CONFIG_SEC_RES_OPTION_EXTRACT','NULL');
</CODE> |
| Set a custom security resolution option for all extracts in the environment. |
Anchor |
---|
| CONFIG_USE_DUMMY_PRIMARY_ASSET_ID_TYPE_EXTRACT |
---|
| CONFIG_USE_DUMMY_PRIMARY_ASSET_ID_TYPE_EXTRACT |
---|
| CONFIG_USE_DUMMY_PRIMARY_ASSET_ID_TYPE_EXTRACT | custom type |
Code Block |
---|
| <CODE>
CreateVariable( 'CONFIG_USE_DUMMY_PRIMARY_ASSET_ID_TYPE_EXTRACT','DUMMYTYPE');
</CODE> |
| Available for Warehouse Position and Warehouse Open Lot. Provides an option to force custom primaryAssetIdType in the extract. |
Anchor |
---|
| W_ALWAYS_USE_XREF |
---|
| W_ALWAYS_USE_XREF |
---|
| W_ALWAYS_USE_XREF | Y (default), N |
Code Block |
---|
| <COL TAG="W_ALWAYS_USE_XREF" EXPRESSION="'N'"/> |
| Toggles using specific SWAP security resolution logic. |
Anchor |
---|
| W_NOOVERRIDE_SEC_RES_OPTION |
---|
| W_NOOVERRIDE_SEC_RES_OPTION |
---|
| W_NOOVERRIDE_SEC_RES_OPTION | ALLOW_DUPL_XREF |
Code Block |
---|
| <COL TAG="W_NOOVERRIDE_SEC_RES_OPTION" EXPRESSION="'ALLOW_DUPL_XREF'"/> |
| Setting this parameter to ALLOW_DUPL_XREF turns off the logic excluding xref duplicates. Can be used for a single message by adding the following element to it: Code Block |
---|
| <assetResolutionOption>ALLOW_DUPL_XREF</assetResolutionOption> |
|
Anchor |
---|
| W_GENERICCA_IGNORE_EDITCHECK302 |
---|
| W_GENERICCA_IGNORE_EDITCHECK302 |
---|
| W_GENERICCA_IGNORE_EDITCHECK302 | Y (default), N |
Code Block |
---|
| <COL TAG="W_GENERICCA_IGNORE_EDITCHECK302" EXPRESSION="'N'"/> |
| For Accounting CA only. By default the message is not failed if tag 302 is not resolved and throws only a WARNING. If tag 302 is not resolved, you can choose to fail such messages by setting either: - global variable W_GENERICCA_IGNORE_EDITCHECK302 with the value ‘N’ or
- element referenceTransaction/header/processingOptions with the value ‘USE_TOASSET_CHECK’
|
Anchor |
---|
| W_PRICE_RESOLVE_SW_BY_XREF |
---|
| W_PRICE_RESOLVE_SW_BY_XREF |
---|
| W_PRICE_RESOLVE_SW_BY_XREF | N(default), Y |
Code Block |
---|
| <COL TAG="W_PRICE_RESOLVE_SW_BY_XREF" EXPRESSION="'Y'"/> |
| For IssuePrice, ExchangePrice and IssuePcPrice. By default SWAP resolution for prices has specific logic based on Processing Security Type and only one leg could be priced. The flag allows to switch on SWAP resolution based on xreferences, ignoring PST. This mode can be enabled for a single message by setting element referenceTransaction/header/processingOptions with the value 'PRICE_RESOLVE_SW_BY_XREF' |
Entity Load Options |
---|
|
|
PERFORM |
FULL |
ENTITY_RES |
PERFORM |
FULL |
ENTITY_RESW_ |
PERFORMSKIP_ |
FULLDELISTED_ |
ENTITY_RESSECURITY | N(default), Y |
|
PERFORM |
FULL |
ENTITY_RES |
YCan be especially useful for Warehouse and Accounting interfaces which have full entity resolution switched off for compatibility reasons |
Setting to Y makes the interface use not only the first entity cross reference in the incoming data, but all xrefs instead to resolve the entity.
|
Indicates that delisted security will be skipped or not. |
|
ENT |
BATTING |
ORDER |
ENT |
BATTING |
ORDERW_ |
ENTDELISTED_SECURITY_ |
BATTINGIDENTIFIER_ |
ORDERbatting orderTYPES | Default value: REUTERS |
Code Block |
---|
| <COL TAG="W_DELISTED_ |
|
ENT |
BATTING |
ORDER |
EML_HUB1,EML_HUB2,EML_HUB3,EML_HUB4 |
Entity Batting Order determines which entity xreference identifiers are used in the security resolution and their order for matching
| Xreference identifier types separated by comma or 'ALL’ (which indicates that all xref identifier types will be checked). |
|
ENT |
RES |
OPTION |
ENT |
RES |
OPTIONW_ |
ENTDELISTED_ |
RESSECURITY_ |
OPTIONentity resolution option:
RESOLVE_ENTITY_BY_XREFS,
SKIP_INCOMING_ENTITY_ID TOKENS | Default value: ^ |
|
ENT |
RES |
OPTION |
RESOLVE_ENTITY_BY_XREFS |
RESOLVE_ENTITY_BY_XREFS switches on entity xref resolution even if the entity id is defined. This mode can be enabled for a single message by setting <entityResolutionOption>RESOLVE_ENTITY_BY_XREFS</entityResolutionOption> in the incoming message.
SKIP_INCOMING_ENTITY_ID allows to skip incoming entity id value and to generate entity id if it was not resolved. This mode can be enabled for a single message by setting <entityResolutionOption>SKIP_INCOMING_ENTITY_ID </entityResolutionOption> in the incoming message
| Tokens are used to indicate that a security is delisted. List of tokens separated by comma. |
Entity Load Options |
---|
Anchor |
---|
| W_PERFORM_FULL_ENTITY_RES |
---|
| W_PERFORM_FULL_ENTITY_RES |
---|
| W_PERFORM_FULL_ENTITY_RES | N(default), Y |
Code Block |
---|
| <COL TAG="W_PERFORM_FULL_ENTITY_RES" EXPRESSION="'Y'"/> |
| Setting to Y makes the interface use not only the first entity cross reference in the incoming data, but all xrefs instead to resolve the entity. Can be especially useful for Warehouse and Accounting interfaces which have full entity resolution switched off for compatibility reasons. |
XREFMAPXREFMAPW_ENT_XREFBATTING_MAPORDER | xref mapbatting order |
Code Block |
---|
| <COL TAG="W_ENT_ |
XREFMAPXREF4XREF4@SentByXREF2XREF2NEW | Sets a custom entity xref map for all loads in the environmentEntity Batting Order determines which entity xreference identifiers are used in the security resolution and their order for matching. |
LOADXREF_OPTIONSLOADXREF_OPTIONSW_ENT_LOADRES_XREF_OPTIONSOPTION | entity load xref options | Sets entity xref options for load. | Anchor | Wresolution option:
RESOLVE_ENTITY_ PARTITIONBY_ MAPPINGXREFS,
| W_ENTITY_PARTITION_MAPPING | WSKIP_INCOMING_ENTITY_
PARTITION_MAPPINGpartition mapping | ID |
Code Block |
---|
| <COL TAG="W_ENTITYENT_PARTITIONRES_MAPPINGOPTION" EXPRESSION="'HUBID|TESTENV_1|PARTITION|1|\n
HUBID|TESTENV_2|PARTITION|2|OVERWRITE|Y|\n
FROMSOURCENAME|TESTSOURCE_1|PARTITION|1|OVERWRITE|N|\n
FROMSOURCENAME|TESTSOURCE_3|PARTITION|2|OVERWRITE|Y|\n
'"/> |
| Sets partition mapping for Generic Entity. |
Xref Load Options |
---|
Anchor |
---|
W_USEDYNAMIC_FOR_XREF | W_USEDYNAMIC_FOR_XREF | W_USEDYNAMIC_FOR_XREF Y (default), N | By default any number of identifiers can be loaded in the <xrefIdentifiers> complex node. Switch to N to return to old logic, limiting this number by 10. | Anchor |
---|
W_LOAD_XREF_OPTIONS | W_LOAD_XREF_OPTIONS | W_LOAD_XREF_OPTIONSstring valueRESOLVE_ENTITY_BY_XREFS'"/> |
| RESOLVE_ENTITY_BY_XREFS switches on entity xref resolution even if the entity id is defined. This mode can be enabled for a single message by setting <entityResolutionOption>RESOLVE_ENTITY_BY_XREFS</entityResolutionOption> in the incoming message. SKIP_INCOMING_ENTITY_ID allows to skip incoming entity id value and to generate entity id if it was not resolved. This mode can be enabled for a single message by setting <entityResolutionOption>SKIP_INCOMING_ENTITY_ID </entityResolutionOption> in the incoming message. |
Anchor |
---|
| W_ENT_XREF_MAP |
---|
| W_ENT_XREF_MAP |
---|
| W_ENT_XREF_MAP | xref map |
|
<CODE>
CreateVariable(‘W_LOAD |
OPTIONS’,‘W_IGNORE_EMPTY_SECXREF,CUSIP’);
</CODE>Set to Y to ignore identifiers with empty id values specified in the <xrefIdentifiers> section. Read more on this pageMAP" EXPRESSION="'XREF4,XREF4_@SentBy,XREF2,XREF2_NEW'"/> |
| Sets a custom entity xref map for all loads in the environment. |
|
_IGNORE_EMPTY_SECXREFW_IGNORE_EMPTY_SECXREF | W_IGNORE_EMPTY_SECXREF | Y, N (default)_ENT_LOAD_XREF_OPTIONS | | W_ENT_LOAD_XREF_OPTIONS |
---|
| W_ENT_LOAD_XREF_OPTIONS | entity load xref options |
| Sets entity xref options for load. |
Anchor |
---|
| W_ENTITY_PARTITION_MAPPING |
---|
| W_ENTITY_PARTITION_MAPPING |
---|
| W_ENTITY_PARTITION_MAPPING | partition mapping |
|
<CODE>
: |
DUP |
XREF_CHECK::PARTITION_MAPPING" EXPRESSION="'HUBID|TESTENV_1|PARTITION|1|\n
HUBID|TESTENV_2|PARTITION|2|OVERWRITE|Y|\n
FROMSOURCENAME|TESTSOURCE_1|PARTITION|1|OVERWRITE|N|\n
FROMSOURCENAME|TESTSOURCE_3|PARTITION|2|OVERWRITE|Y|\n
'"/> |
| Sets partition mapping for Generic Entity. |
Xref Load Options |
---|
Anchor |
---|
| W_USEDYNAMIC_FOR_XREF |
---|
| W_USEDYNAMIC_FOR_XREF |
---|
| W_USEDYNAMIC_FOR_XREF | Y (default), N |
| By default any number of identifiers can be loaded in the <xrefIdentifiers> complex node. Switch to N to return to old logic, limiting this number by 10. |
Anchor |
---|
| W_LOAD_XREF_OPTIONS |
---|
| W_LOAD_XREF_OPTIONS |
---|
| W_LOAD_XREF_OPTIONS | string value |
Code Block |
---|
| <CODE>
CreateVariable(‘W_LOAD_XREF_OPTIONS’,‘W_IGNORE_EMPTY_SECXREF,CUSIP’);
</CODE> |
| Set to Y to ignore identifiers with empty id values specified in the <xrefIdentifiers> section. Read more on this page. |
Anchor |
---|
| W_IGNORE_EMPTY_SECXREF |
---|
| W_IGNORE_EMPTY_SECXREF |
---|
| W_IGNORE_EMPTY_SECXREF |
|
|
|
| Y, N (default) |
Code Block |
---|
| <CODE>
:W_DUP_XREF_CHECK::='Y';
</CODE> |
| Set to Y to check and skip duplicate identifiers in current message. Available only with W_USEDYNAMIC_FOR_XREF flag enabled |
Task Reporter |
---|
Anchor |
---|
| W_COLLECT_DISTRIBUTION_ERRORS |
---|
| W_COLLECT_DISTRIBUTION_ERRORS |
---|
| W_COLLECT_DISTRIBUTION_ERRORS | JMS,MQ,EMAIL |
Code Block |
---|
| <CODE>
:W_COLLECT_DISTRIBUTION_ERRORS::='JMS';
</CODE> |
| Specify the delivery method for which task reporter should be enabled. RTR analog is CollectDistributionErrors. |
Anchor |
---|
| W_CONFIG_JMS_TSR_RE_TRY_CNT |
---|
| W_CONFIG_JMS_TSR_RE_TRY_CNT |
---|
| W_CONFIG_JMS_TSR_RE_TRY_CNT | number |
Code Block |
---|
| <CODE>
:W_CONFIG_JMS_TSR_RE_TRY_CNT::='10';
</CODE> |
| Sets the number of retries for JMS delivery. Default value is 10. |
Anchor |
---|
| TSR_RE_TRY_WAIT |
---|
| TSR_RE_TRY_WAIT |
---|
| TSR_RE_TRY_WAIT | time in seconds |
Code Block |
---|
| <CODE>
:TSR_RE_TRY_WAIT::='1';
</CODE> |
| Sets the wait time between retry attempts. Default value is 1 second. |
Anchor |
---|
| W_CONFIG_CHECK_STATUS_RE_TRY_CNT |
---|
| W_CONFIG_CHECK_STATUS_RE_TRY_CNT |
---|
| W_CONFIG_CHECK_STATUS_RE_TRY_CNT | number |
Code Block |
---|
| <CODE>
:W_CONFIG_CHECK_STATUS_RE_TRY_CNT::='10';
</CODE> |
| Sets the number of retries when the file is sent. |
Anchor |
---|
| W_WAIT_FOR_FILE_UPLOAD_TIME |
---|
| W_WAIT_FOR_FILE_UPLOAD_TIME |
---|
| W_WAIT_FOR_FILE_UPLOAD_TIME | time in seconds |
Code Block |
---|
| <CODE>
:W_WAIT_FOR_FILE_UPLOAD_TIME::='300';
</CODE> |
| Task reported checks the size of received files, - for FILE - once in 5 seconds - for FTP/SFTP - once in 20 seconds By default, if file size remains the same between two checks, the file is taken into further processing. You can make the process perform size checks for an extended time to make sure the file was fully delivered. Default value is 300 seconds. Read more |
Anchor |
---|
| W_FTP_CURL_TIMEOUT_30MIN |
---|
| W_FTP_CURL_TIMEOUT_30MIN |
---|
| W_FTP_CURL_TIMEOUT_30MIN | N (default), Y |
Code Block |
---|
| <CODE> :W_FTP_CURL_TIMEOUT_30MIN::='Y';
</CODE> |
| Y value sets the timeout for curl command execution to 30 minutes (1800s). |
ServiceNow Alerts |
---|
Anchor |
---|
| w_profile_dir |
---|
| w_profile_dir |
---|
| w_profile_dir | folder path |
Code Block |
---|
| <COL TAG="w_profile_dir" EXPRESSION="GetDirRoot() +
'dynamic/msgcenter/eagle_ml-2-0_cm_profiles/'” /> |
| The folder where workflow profiles will be stored (default value is ../estar/tpe/dynamic/msgcenter/eagle_ml-2-0_cm_profiles). |
Anchor |
---|
| W_EAS_CLIENT_ID |
---|
| W_EAS_CLIENT_ID |
---|
| W_EAS_CLIENT_ID | clientId, default value is EAGLE |
Code Block |
---|
| <COL TAG="W_EAS_CLIENT_ID" EXPRESSION="'EAGLE (QA test box, 2017R2, Oracle, 32Gb RAM'"/> |
| Client information added to alerts. Can be used to identify the environment sending alerts and to provide more details about it. |
Anchor |
---|
| W_EAS_MAIL_LIST |
---|
| W_EAS_MAIL_LIST |
---|
| W_EAS_MAIL_LIST | :W_EAS_MAIL_LIST:+ list of emails |
Code Block |
---|
| <COL TAG="W_EAS_MAIL_LIST" EXPRESSION=":W_EAS_MAIL_LIST:+',user@mail.com'"/> |
| Add emails to the default list (:W_EAS_MAIL_LIST: in w_config.inc) to receive EAS alerts. |
Anchor |
---|
| W_EAS_PATERNS |
---|
| W_EAS_PATERNS |
---|
| W_EAS_PATERNS | Patterns separated by ! sign |
Code Block |
---|
| <COL TAG="W_EAS_PATERNS" EXPRESSION="'Job Execution Warning!Missing Files Error!RTR-TSR Matching Error!FTP CM not read!'"/> |
| A filter for EAS alerts. Alerts matching a pattern will be delivered, others will be ignored. |
Anchor |
---|
| W_EAS_SENDMAILFROM |
---|
| W_EAS_SENDMAILFROM |
---|
| W_EAS_SENDMAILFROM | email |
| The sender email in the message. Set by default in w_config. |
W_ENV_NAME | name of environment |
Code Block |
---|
| <COL TAG="W_ENV_NAME" EXPRESSION="'ENVNAME'"/> |
| This parameter is usually resolved automatically in the get_enviroment_name.inc include. But you can set it manually. |
Anchor |
---|
| W_MONITOR_ENABLED |
---|
| W_MONITOR_ENABLED |
---|
| W_MONITOR_ENABLED | Y or N |
Code Block |
---|
| <CODE>
:W_MONITOR_ENABLED::='Y';
</CODE> |
| Enables/disables monitoring stream |
Anchor |
---|
| monHealthTraceLevel |
---|
| monHealthTraceLevel |
---|
| monHealthTraceLevel | number |
Code Block |
---|
| <COL TAG="monHealthTraceLevel" EXPRESSION="'1'"/> |
| Adjust the output of debug messages in the status. Default value is 1, increase it to reduce the amount of debug messages. |
Anchor |
---|
| monHealthTimeout |
---|
| monHealthTimeout |
---|
| monHealthTimeout | time in milliseconds |
Code Block |
---|
| <COL TAG="monHealthTimeout" EXPRESSION="'600'"/> |
| Sets a timeout at the end of the health check cycle to let the workflow return to normal status and avoid false errors. Recommended value is 600, but should be adjusted for a particular environment. |
Anchor |
---|
| monHealthTestList |
---|
| monHealthTestList |
---|
| monHealthTestList | formatted value |
Code Block |
---|
| <COL TAG="monHealthTestList" EXPRESSION="'FILE:EXTRACT,WORKFLOW!FTP:LOAD!FTP_CURL:EXTRACT'"/> |
| This parameter contains delivery methods, separated by “!”. For each delivery method you can (optionally) specify methods for Control Messages. The attempt to send Control Message(s) will take place after trying to write and read a file using the specified method. Delivery method is separated from optional parameters by “:”. Optional parameters are separated by “,”. At least one method for Control Messages should be specified for each Delivery method. The example gives the following instructions: read/write through FILE method, then try to send EXTRACT and WORKFLOW Control Messages, then check read/write for FTP and FTP_CURL. If there is an instruction to send Control Messages, the results will be checked after a timeout. In case the Control Message returns an error or does not return any results, alert will be generated and sent according to the configuration. Available delivery methods: • FILE • FTP • FTP_CURL • SFTP_CURL Available commands for them: • EXTRACT • WORKFLOW • PACE_EVENT • STAR_EVENT • LOAD |
Anchor |
---|
| RTR_JOBS_PARAMS |
---|
| RTR_JOBS_PARAMS |
---|
| RTR_JOBS_PARAMS | formatted value |
Code Block |
---|
| <COL TAG="RTR_JOBS_PARAMS" EXPRESSION="'PACEEventType!test!PACEEventName!test!EventExecTimeout!6000!\n
PACEEventType!test!PACEEventName!test!EventExecTimeout!6000!'"/> |
| Settings for an RTR job. |
Sequencer |
---|
Anchor |
---|
| W_SEQ_TIMEOUT |
---|
| W_SEQ_TIMEOUT |
---|
| w_seq_timeout | time in seconds |
Code Block |
---|
| <COL TAG="w_seq_timeout" EXPRESSION="180"/> |
| Defines the timeout between steps since the last message processed (or queued if W_LAST_SEQUENCE is empty). |
Anchor |
---|
| w_exec_folder |
---|
| w_exec_folder |
---|
| w_exec_folder | :w_mcdata_dir: + folder name |
Code Block |
---|
| <CODE>
:w_seq_folder: := :w_mcdata_dir: + 'out/TAGVALUE/eagle_ml-2-0_default_cm_sequencer/incoming/';
</CODE> |
| Sets the processing folder for Sequencer. Default is out/TAGVALUE/eagle_ml-2-0_default_cm_sequencer/incoming/ |
Nuggetizer |
---|
Anchor |
---|
| W_NGTZR_MASK_CNT |
---|
| W_NGTZR_MASK_CNT |
---|
| W_NGTZR_MASK_CNT | number |
Code Block |
---|
| <CODE>
CreateVariable( 'W_NGTZR_MASK1','STAR_ndfa_1_mask1_' );
CreateVariable( 'W_NGTZR_MASK1_OUT','STAR_ndfa_1_NUGGET_1_' );
CreateVariable( 'W_NGTZR_MASK1_SIZE','10' );
CreateVariable( 'W_NGTZR_MASK1_WAIT','10' );
CreateVariable( 'W_NGTZR_MASK1_FORMAT','EagleML' );
CreateVariable( 'W_NGTZR_MASK1_WKFL','some_workflow' );
CreateVariable( 'W_NGTZR_MASK1_LOADFROMDIR',:W_NGTZR_DIST_FOLDER: );
</CODE>
<CODE>
CreateVariable( 'W_NGTZR_MASK2','STAR_ndfa_1_mask2_' );
CreateVariable( 'W_NGTZR_MASK2_OUT','STAR_ndfa_1_NUGGET_2_' );
CreateVariable( 'W_NGTZR_MASK2_SIZE','2' );
CreateVariable( 'W_NGTZR_MASK2_WAIT','1000' );
CreateVariable( 'W_NGTZR_MASK2_FORMAT','EagleML' );
CreateVariable( 'W_NGTZR_MASK2_WKFL','some_workflow' );
CreateVariable( 'W_NGTZR_MASK2_LOADFROMDIR',:W_NGTZR_DIST_FOLDER: );
</CODE> |
| Number of file masks fed to the nuggetizer. |
W_NGTZR_DIST_FOLDER | folder path | eagle_ml-2-0_default_cm_disribute_to_nuggetizer (if involved into the workflow) puts files into this folder and eagle_ml-2-0_default_cm_nuggetizer can then use these files. |
W_NGTZR_MASK1 | file mask | Expected file mask. |
W_NGTZR_MASK1_OUT | file mask | The file mask for outgoing nuggets. |
W_NGTZR_MASK1_SIZE | number | The number of files matching W_NGTZR_MASK1, 'glued' into one nugget. |
W_NGTZR_MASK1_WAIT | time in seconds | The timout for nugget creation (the nugget is not considered complete till this time runs out). |
W_NGTZR_MASK1_FORMAT | EagleML | File formatting. (Currently only EagleML available). |
W_NGTZR_MASK1_WKFL | workflow name | The workflow to which created nuggets are sent for further processing. |
W_NGTZR_MASK1_LOADFROMDIR | folder path | The folder in which nuggetizer looks for files matching W_NGTZR_MASK1. |
Other masks are configured in a similar way (see the example). |
|
|
Generic Load Enrichment Process |
---|
Anchor |
---|
| CONFIG_GENERICLOAD_SKIPLOAD |
---|
| CONFIG_GENERICLOAD_SKIPLOAD |
---|
| CONFIG_GENERICLOAD_SKIPLOAD | 0, 1 |
Code Block |
---|
| <CODE>
CreateVariable( 'CONFIG_GENERICLOAD_SKIPLOAD','1' );
</CODE> |
| Toggle skipping the load step (generic_load) within generic_load_enrichment workflow. |
Anchor |
---|
| CONFIG_GENERICLOAD_SKIPRDC |
---|
| CONFIG_GENERICLOAD_SKIPRDC |
---|
| CONFIG_GENERICLOAD_SKIPRDC | 0, 1 |
Code Block |
---|
| <CODE>
CreateVariable( 'CONFIG_GENERICLOAD_SKIPRDC','1' );
</CODE> |
| Toggle skipping RDC call (PACE job) within generic_load_enrichment workflow. |
Monitoring Stream |
---|
Anchor |
---|
| W_MONITOR_ENABLED |
---|
| W_MONITOR_ENABLED |
---|
| W_MONITOR_ENABLED | Y, N |
Code Block |
---|
| <CODE>
:W_MONITOR_ENABLED: :='Y';
</CODE> |
| Toggle monitoring stream usage. |
Anchor |
---|
| W_MONITOR_SCH_ENABLED |
---|
| W_MONITOR_SCH_ENABLED |
---|
| W_MONITOR_SCH_ENABLED | Y, N |
Code Block |
---|
| <CODE>
:W_MONITOR_SCH_ENABLED: :='Y';
</CODE> |
| Toggle monitoring sch stream usage - monitoring_sch stream is used to launch monitoring for a separate process. |
Anchor |
---|
| w_monitoring_stream |
---|
| w_monitoring_stream |
---|
| w_monitoring_stream | stream name |
Code Block |
---|
| <CODE>
:w_monitoring_stream: := 'eagle_ml-2-0_default_cm_monitoring';
</CODE> |
| Name of the monitoring stream. |
Anchor |
---|
| W_MONITOR_PROCESS_ID |
---|
| W_MONITOR_PROCESS_ID |
---|
| W_MONITOR_PROCESS_ID | process id |
Code Block |
---|
| <CODE>
:W_MONITOR_PROCESS_ID::='2841284';
</CODE> |
| Process id for your monitoring stream. |
Anchor |
---|
| W_MONITOR_APP_ID |
---|
| W_MONITOR_APP_ID |
---|
| W_MONITOR_APP_ID | application id |
Code Block |
---|
| <CODE>
:W_MONITOR_APP_ID::='2259035154';
</CODE> |
| New application id for your monitoring stream. |
Anchor |
---|
| W_MONITOR_CUR_APP_ID |
---|
| W_MONITOR_CUR_APP_ID |
---|
| W_MONITOR_CUR_APP_ID | application id |
Code Block |
---|
| <CODE>
:W_MONITOR_CUR_APP_ID::='26704';
</CODE> |
| Old application id for your monitoring stream. W_MONITOR_CUR_APP_ID will be replaced with W_MONITOR_APP_ID in the system. |
Anchor |
---|
| W_MON_STREAMS |
---|
| W_MON_STREAMS |
---|
| W_MON_STREAMS | formatted list |
Code Block |
---|
| <CODE>
:W_MON_STREAMS::=’:STREAM:your_stream_name1:FOLDER:your_stream_folder1:\n’+
‘:STREAM:your_stream_name2:FOLDER:your_stream_folder2:\n’;
</CODE> |
| List of streams and folders to be monitored. |
Anchor |
---|
| W_CM_EA_FTP_READER_ENABLED |
---|
| W_CM_EA_FTP_READER_ENABLED |
---|
| W_CM_EA_FTP_READER_ENABLED | Y, N |
Code Block |
---|
| <CODE>
:W_CM_EA_FTP_READER_ENABLED: :='Y';
</CODE> |
| CM_EA_FTP_READER is an alternative for the FTP stream, its main feature is that it takes the list of files from DB sitesee instead of calling FTP It is commonly used to avoid the FTP plugin issue - too frequent FTP pulling. |
Anchor |
---|
| W_EXECUTION_MONITORING_TIMEOUT |
---|
| W_EXECUTION_MONITORING_TIMEOUT |
---|
| W_EXECUTION_MONITORING_TIMEOUT | time in seconds |
Code Block |
---|
| <COL TAG="W_EXECUTION_MONITORING_TIMEOUT" EXPRESSION="'55'"/> |
| Maximum status check timeout. Can be set as a task parameter ExecutionMonitoringTimeout for a single process. |
Anchor |
---|
| W_EXECUTION_MONITORING_PERIOD |
---|
| W_EXECUTION_MONITORING_PERIOD |
---|
| W_EXECUTION_MONITORING_PERIOD | time in seconds |
Code Block |
---|
| <COL TAG="W_EXECUTION_MONITORING_PERIOD" EXPRESSION="'300'"/> |
| Time interval between status checks. Can be set as a task parameter ExecutionMonitoringPeriod for a single process. |
SiteSee |
---|
Anchor |
---|
| SITESEE_DB_TNS |
---|
| SITESEE_DB_TNS |
---|
| SITESEE_DB_TNS | TNS |
| TNS (server alias) for SiteSee. |
Anchor |
---|
| SITESEE_DB_USER |
---|
| SITESEE_DB_USER |
---|
| SITESEE_DB_USER | user name |
| Setting user name for SiteSee. |
Anchor |
---|
| SITESEE_DB_PWD |
---|
| SITESEE_DB_PWD |
---|
| SITESEE_DB_PWD | password |
| Enter the password for SiteSee (encrypted). When you set a new password restart MC to apply changes. |
Anchor |
---|
| SITESEE_FTP_SUBFOLDER |
---|
| SITESEE_FTP_SUBFOLDER |
---|
| SITESEE_FTP_SUBFOLDER | folder path |
| Specifies the folder for SiteSee FTP Reader. Standard setting is CMW/control |
Anchor |
---|
| SITESEE_FTP_CHECK_TIME |
---|
| SITESEE_FTP_CHECK_TIME |
---|
| SITESEE_FTP_CHECK_TIME | time in seconds |
| Sets the timeout for SiteSee FTP Reader. |
Custom XSD Validation File and Schema Location |
---|
Anchor |
---|
| w_xsd_validation_file |
---|
| w_xsd_validation_file |
---|
| w_xsd_validation_file | file path |
Code Block |
---|
| <COL TAG="w_xsd_validation_file" EXPRESSION="'dynamic/eagleml/extension/eagleml-ext-2-0.xsd'"/> |
| Set custom XSD validation file location. |
Anchor |
---|
| w_schema_name |
---|
| w_schema_name |
---|
| w_schema_name | file path |
Code Block |
---|
| <COL TAG="w_schema_name" EXPRESSION="'http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-ext-2-0.xsd'"/> |
| Set custom schema location. |
Instance to Instance (I2I) |
---|
Anchor |
---|
| W_I2I_IS_SPOKE |
---|
| W_I2I_IS_SPOKE |
---|
| W_I2I_IS_SPOKE | YES or empty |
Code Block |
---|
| <COL TAG="W_I2I_IS_SPOKE" EXPRESSION="'YES'"/> |
| Defines if an environment is set as Spoke in an I2I process. |
W_I2I_IS_HUB | YES or empty |
Code Block |
---|
| <COL TAG="W_I2I_IS_HUB" EXPRESSION="'YES'"/> |
| Defines if an environment is set as Hub in an I2I process. |
Anchor |
---|
| I2I_LOAD_IN_HISTORY |
---|
| I2I_LOAD_IN_HISTORY |
---|
| I2I_LOAD_IN_HISTORY | Y or empty |
Code Block |
---|
| <COL TAG="I2I_LOAD_IN_HISTORY" EXPRESSION="'Y'"/> |
| Toggle loading SMF into the history table (equal to forcing <historyOnlyFlag>=Y) within an I2I process, when the data is extracted from the composite table of Hub and then loaded into the history table of Spoke. |
Anchor |
---|
| W_I2I_FORCE_WRHS_TRADE_INS |
---|
| W_I2I_FORCE_WRHS_TRADE_INS |
---|
| W_I2I_FORCE_WRHS_TRADE_INS | Y, N |
Code Block |
---|
| <COL TAG="W_I2I_FORCE_WRHS_TRADE_INS" EXPRESSION="'Y'"/> |
| If set to Y, this parameter forces all Warehouse Trade extracts on the box to have the updatetype of I. This option is also available as a Task Parameter in the control message (especially useful, when you do not want to apply this updatetype to all Warehouse Trade extracts on the box). Task parameter version for RTR is ForceWRHSTradeIns |
Anchor |
---|
| W_I2I_RELOAD_FINAL_FLAG |
---|
| W_I2I_RELOAD_FINAL_FLAG |
---|
| W_I2I_RELOAD_FINAL_FLAG | N (default), Y |
Code Block |
---|
| <COL TAG="W_I2I_RELOAD_FINAL_FLAG" EXPRESSION="'Y'"/> |
| This parameter affects Warehouse Performance - Delta Mode only. Allows to load Warehouse Performance even in case STATUS_FLAG is already set as F(FINAL). |
Anchor |
---|
| W_USE_ORCH_FOR_DELTA |
---|
| W_USE_ORCH_FOR_DELTA |
---|
| W_USE_ORCH_FOR_DELTA | Y(default), N |
Code Block |
---|
| <COL TAG="W_USE_ORCH_FOR_DELTA" EXPRESSION="'N'"/> |
| When set to N, extracts in delta mode do not use orchestration. |
Some parameters are noted as Required - this is only in case you want to use FTP delivery method |
Anchor |
---|
| w_i2i_ftp_url |
---|
| w_i2i_ftp_url |
---|
| w_i2i_ftp_url | ftp url |
| FTP URL. Required |
Anchor |
---|
| w_i2i_ftp_pass |
---|
| w_i2i_ftp_pass |
---|
| w_i2i_ftp_pass | password |
| FTP Password (It can be either encrypted or not - we recommend that you encrypt your password). Required |
Anchor |
---|
| w_i2i_ftp_encrypted |
---|
| w_i2i_ftp_encrypted |
---|
| w_i2i_ftp_encrypted | YES or NO (default) |
| YES – password is encrypted. NO or NULL if not encrypted. Optional. |
Anchor |
---|
| w_i2i_ftp_user |
---|
| w_i2i_ftp_user |
---|
| w_i2i_ftp_user | user name |
| FTP User Name. Required |
Anchor |
---|
| w_i2i_ftp_data_location |
---|
| w_i2i_ftp_data_location |
---|
| w_i2i_ftp_data_location | folder path |
| Folder for archive on FTP. Default value is 'CMW/inbound/'. Optional |
Anchor |
---|
| w_i2i_ftp_reply_location |
---|
| w_i2i_ftp_reply_location |
---|
| w_i2i_ftp_reply_location | folder path |
| Required when the workflow is launched remotely (Extract or Load). If you want TSR to be loaded on FTP. |
Anchor |
---|
| w_i2i_ftp_control_location |
---|
| w_i2i_ftp_control_location |
---|
| w_i2i_ftp_control_location | folder path |
| Required when the workflow is launched locally (Extract or Load). If you want RTR to be loaded on FTP. |
Some parameters are noted as Required - this is only in case you want to use Web Service delivery method |
Anchor |
---|
| w_i2i_web_service_url |
---|
| w_i2i_web_service_url |
---|
| w_i2i_web_service_url | WS url |
| WS URL. Required |
Anchor |
---|
| w_i2i_web_service_pass |
---|
| w_i2i_web_service_pass |
---|
| w_i2i_web_service_pass | password |
| WS password. Required |
Anchor |
---|
| w_i2i_web_service_user |
---|
| w_i2i_web_service_user |
---|
| w_i2i_web_service_user | user name |
| WS user name. Required |
Anchor |
---|
| w_i2i_web_service_retry_count |
---|
| w_i2i_web_service_retry_count |
---|
| w_i2i_web_service_retry_count | number (integer) |
| WS number of retries. Optional |
I2I Filters |
Anchor |
---|
| w_i2i_spoke_enitity_list |
---|
| w_i2i_spoke_enitity_list |
---|
| w_i2i_spoke_enitity_list |
|
|
|
Anchor |
---|
| w_i2i_spoke_xref_id_type_list |
---|
| w_i2i_spoke_xref_id_type_list |
---|
| w_i2i_spoke_xref_id_type_list |
|
|
|
Anchor |
---|
| w_i2i_spoke_data_sources |
---|
| w_i2i_spoke_data_sources |
---|
| w_i2i_spoke_data_sources |
|
|
|
Anchor |
---|
| w_i2i_spoke_xref_id_type_output |
---|
| w_i2i_spoke_xref_id_type_output |
---|
| w_i2i_spoke_xref_id_type_output |
|
|
|
I2I workflow parameters |
Anchor |
---|
| w_i2i_from_folder |
---|
| w_i2i_from_folder |
---|
| w_i2i_from_folder |
|
|
|
Anchor |
---|
| w_i2i_to_folder |
---|
| w_i2i_to_folder |
---|
| w_i2i_to_folder |
|
|
|
Anchor |
---|
| w_i2i_delivery_stream |
---|
| w_i2i_delivery_stream |
---|
| w_i2i_delivery_stream |
|
| This is the MAIN parameter in configuration, which defines the way TSRs/RTRs are sent to the other side of the I2I process. |
Anchor |
---|
| w_i2i_mixed_delivery |
---|
| w_i2i_mixed_delivery |
---|
| w_i2i_mixed_delivery | YES or NO (default) |
| If this parameter set to YES, extracted data will be base64-encoded and wrapped into RTR/TSR |
PACE and STAR Jobs |
---|
Anchor |
---|
| W_CONFIG_SKIP_SUCCESS_STEPS |
---|
| W_CONFIG_SKIP_SUCCESS_STEPS |
---|
| W_CONFIG_SKIP_SUCCESS_STEPS | Y (default), N |
Code Block |
---|
| <COL TAG="W_CONFIG_SKIP_SUCCESS_STEPS" EXPRESSION="'N'"/> |
| Available since May 2016 EagleML Release. Toggles displaying details for successful substeps. Switched off ("Y") by default. Read more... |
Anchor |
---|
| W_CONFIG_INCLUDE_ENTITIES_DETAILS |
---|
| W_CONFIG_INCLUDE_ENTITIES_DETAILS |
---|
| W_CONFIG_INCLUDE_ENTITIES_DETAILS | N (default), Y |
Code Block |
---|
| <COL TAG="W_CONFIG_INCLUDE_ENTITIES_DETAILS" EXPRESSION="'Y'"/> |
| Setting to Y enables Event Entity Details for STAR events and for DataMart Model Manager steps in the final TSR for PACE jobs - these are available since May 2016 EagleML Release for PACE and since September 2016 EagleML Release for STAR. In addition, includes execution details for STAR (available since October 2016 EagleML Release). Read more... |
Anchor |
---|
| W_CREATE_PACE_JOB_DEF |
---|
| W_CREATE_PACE_JOB_DEF |
---|
| W_CREATE_PACE_JOB_DEF | N (default), Y |
| Enable support for Pace Jobs with incoming parameters. |
Anchor |
---|
| W_CONFIG_INCLUDE_SECURITY_DETAILS |
---|
| W_CONFIG_INCLUDE_SECURITY_DETAILS |
---|
| W_CONFIG_INCLUDE_SECURITY_DETAILS | N (default), Y |
Code Block |
---|
| <COL TAG="W_CONFIG_INCLUDE_SECURITY_DETAILS" EXPRESSION="'Y'"/> |
| Enable security-level details for failed TSR for RDC Composites. |
TBA workflow |
---|
Anchor |
---|
| W_TBA_LoadStream |
---|
| W_TBA_LoadStream |
---|
| W_TBA_LoadStream | stream name |
Code Block |
---|
| <COL TAG="W_TBA_LoadStream" EXPRESSION="'custom_load_stream_for_tba'"/> |
| Data delivery stream for TBA workflow. |
Anchor |
---|
| W_TBA_STP_Flag |
---|
| W_TBA_STP_Flag |
---|
| W_TBA_STP_Flag | N (default), Y |
Code Block |
---|
| <COL TAG="W_TBA_STP_Flag" EXPRESSION="'N'"/> |
| If value is set to Y the last step of each relevant workflow will start the next one automatically. |
FTP/SFTP |
---|
Anchor |
---|
| FTP_RE_TRY_MAX_CNT |
---|
| FTP_RE_TRY_MAX_CNT |
---|
| FTP_RE_TRY_MAX_CNT | number, default is 5 |
Code Block |
---|
| <COL TAG="FTP_RE_TRY_MAX_CNT" EXPRESSION="'5'"/> |
| Defines the number of retry attempts. |
Anchor |
---|
| FTP_RE_TRY_ATT_INTERVAL |
---|
| FTP_RE_TRY_ATT_INTERVAL |
---|
| FTP_RE_TRY_ATT_INTERVAL | time in seconds, default is 1 |
Code Block |
---|
| <COL TAG="FTP_RE_TRY_ATT_INTERVAL" EXPRESSION="'1'"/> |
| Defines the timeout between attempts. Read more.. |
Anchor |
---|
| SFTP_RE_TRY_MAX_CNT |
---|
| SFTP_RE_TRY_MAX_CNT |
---|
| SFTP_RE_TRY_MAX_CNT | number, default is 5 |
Code Block |
---|
| <COL TAG="SFTP_RE_TRY_MAX_CNT" EXPRESSION="'5'"/> |
| Defines the number of retry attempts.
|
Anchor |
---|
| SFTP_RE_TRY_ATT_INTERVAL |
---|
| SFTP_RE_TRY_ATT_INTERVAL |
---|
| SFTP_RE_TRY_ATT_INTERVAL | time in seconds, default is 1 |
Code Block |
---|
| <COL TAG="SFTP_RE_TRY_ATT_INTERVAL" EXPRESSION="'1'"/> |
| Defines the timeout between attempts. Read more.. |
NG Logic |
---|
Anchor |
---|
| W_NG_CUST_SWITCH |
---|
| W_NG_CUST_SWITCH |
---|
| W_NG_CUST_SWITCH | NG, CUSTOM, CORE |
| For some Warehouse objects, such as Warehouse Month End, this parameter allows: • NG – to use common NG XSLT – 1 for all NG SP • CUSTOM – for warehouse objects this allows to use custom xslt for each data type object like: wrh_pos_cust.xsl • CORE- to use CORE XSLT and SP. This value can also be set within the Warehouse message itself - in the procedureSwitch node |
w_ng_enabled | list of feedtypes |
| Defines the list of feedtypes for which NG logic is enabled |
Anchor |
---|
| W_varObjectType_NG_SCHEMA_NAME |
---|
| W_varObjectType_NG_SCHEMA_NAME |
---|
| W_'+Upper(:varObjectType:)+'_NG_SCHEMA_NAME | schema name |
Code Block |
---|
| <COL TAG="W_GENERICSMF_NG_SCHEMA_NAME" EXPRESSION="'PACE_MASTERDBO'"/> |
| Custom NG schema name. Default value is core schema name |
Anchor |
---|
| W_varObjectType_NG_PACKAGE_NAME |
---|
| W_varObjectType_NG_PACKAGE_NAME |
---|
| W_'+Upper(:varObjectType:)+'_NG_PACKAGE_NAME | package name |
Code Block |
---|
| <COL TAG="W_GENERICSMF_NG_PACKAGE_NAME" EXPRESSION="'ESTAR_SEC_NG'"/> |
| Custom NG package name. Default value is core package name + _NG |
Anchor |
---|
| W_varObjectType_NG_SP_NAME |
---|
| W_varObjectType_NG_SP_NAME |
---|
| W_'+Upper(:varObjectType:)+'_NG_SP_NAME | SP name |
Code Block |
---|
| <COL TAG="W_GENERICSMF_NG_SP_NAME" EXPRESSION="'INSERT_UPDATE_SMF_MI_NG'"/> |
| Custom NG SP name. Default value is core SP name + _NG |
EJM Notification Filename Settings |
---|
Anchor |
---|
| W_TSR_STRICT_PATTERN |
---|
| W_TSR_STRICT_PATTERN |
---|
| W_TSR_STRICT_PATTERN | custom TSR strict pattern |
| Please refer to this page to learn more about configuring EJM Notification Filenames. |
Anchor |
---|
| W_ACK_STRICT_PATTERN |
---|
| W_ACK_STRICT_PATTERN |
---|
| W_ACK_STRICT_PATTERN | custom ACK strict pattern |
|
Anchor |
---|
| W_TSR_NAME_PATTERN |
---|
| W_TSR_NAME_PATTERN |
---|
| W_TSR_NAME_PATTERN | custom TSR name pattern |
|
GPG Encryption |
---|
GPG_USERID | user ID |
Code Block |
---|
| <COL TAG="GPG_USERID" EXPRESSION="'MYNAME'" USERDESCRIPTION="UserId for the encryption process" /> |
| UserId for the encryption process of GPG. |
Anchor |
---|
| ENCRYPTION_MODE |
---|
| ENCRYPTION_MODE |
---|
| ENCRYPTION_MODE | GPG,PGP,NONE |
Code Block |
---|
| <COL TAG="ENCRYPTION_MODE" EXPRESSION="'GPG'" USERDESCRIPTION="Encrypt logic used by the workflow. Choose GPG,PGP,NONE"/> |
| Set encryption mode. |
GPG Decryption |
|
|
|
Anchor |
---|
| W_AUTO_DETECT_ENCRYPTION |
---|
| W_AUTO_DETECT_ENCRYPTION |
---|
| W_AUTO_DETECT_ENCRYPTION | Y (default), N |
Code Block |
---|
| <COL TAG="W_AUTO_DETECT_ENCRYPTION" EXPRESSION="'Y'"/> |
| By default automatic detection of encrypted files for both unpacker and ndfa streams is enabled. This flag has a higher priority than W_NDFA_INCOMING_ENCRYPTED |
Anchor |
---|
| W_NDFA_INCOMING_ENCRYPTED |
---|
| W_NDFA_INCOMING_ENCRYPTED |
---|
| W_NDFA_INCOMING_ENCRYPTED | EXTENSION BASED (default), ALL |
Code Block |
---|
| <COL TAG="W_NDFA_INCOMING_ENCRYPTED" EXPRESSION="'ALL'"/> |
| By default, the ndfa automatically detects encrypted files by their extension. ALL value enables |
Anchor |
---|
| GPG_PASSPHRASE |
---|
| GPG_PASSPHRASE |
---|
| GPG_PASSPHRASE | pass phrase |
Code Block |
---|
| <COL TAG="GPG_PASSPHRASE" EXPRESSION="'sdp10923'" USERDESCRIPTION="Pass phrase for the encryption/decryption process"/> |
| Pass phrase for the decryption process. |
Anchor |
---|
| DECRYPTION_MODE |
---|
| DECRYPTION_MODE |
---|
| DECRYPTION_MODE | GPG,PGP |
Code Block |
---|
| <COL TAG="DECRYPTION_MODE" EXPRESSION="'GPG'" USERDESCRIPTION="Decrypt logic used by the workflow. Choose GPG or PGP"/> |
| Set decryption mode. |
Workflow Waiting and Error Queues |
---|
Anchor |
---|
| W_WAITEVENTS_DATABASE_MODE |
---|
| W_WAITEVENTS_DATABASE_MODE |
---|
| W_WAITEVENTS_DATABASE_MODE | Y (default), N |
Code Block |
---|
| <COL TAG="W_WAITEVENTS_DATABASE_MODE" EXPRESSION="'Y'"/> |
| Setting to Y makes the process store wait event info in orch_request_params table. |
W_GLOBAL_ERROR_QUEUE_CLEANUP_PERIOD | time in days |
Code Block |
---|
| <COL TAG="W_GLOBAL_ERROR_QUEUE_CLEANUP_PERIOD" EXPRESSION="'45'"/> |
| Sets the cleanup period for global error queue in days. |
W_WORKFLOW_SPECIFIC_ERROR_QUEUE_CLEANUP_PERIOD | time in days |
Code Block |
---|
| <COL TAG="W_WORKFLOW_SPECIFIC_ERROR_QUEUE_CLEANUP_PERIOD" EXPRESSION="'10'"/> |
| Sets the cleanup period for workflow specific error queue in days. |
W_WORKFLOW_SPECIFIC_WAITING_QUEUE_CLEANUP_PERIOD | time in days |
Code Block |
---|
| <COL TAG="W_WORKFLOW_SPECIFIC_WAITING_QUEUE_CLEANUP_PERIOD" EXPRESSION="'10'"/> |
| Sets the cleanup period for workflow specific waiting queue in days. |
W_GLOBAL_ERROR_QUEUE_ORCH_INSTANCE | instance number |
Code Block |
---|
| <COL TAG="W_GLOBAL_ERROR_QUEUE_ORCH_INSTANCE" EXPRESSION="'-418'"/> |
| Sets the value of ORCH_INSTANCE for global error queue. |
W_WORKFLOW_SPECIFIC_WAIT_QUEUE_ORCH_INSTANCE | instance number |
Code Block |
---|
| <COL TAG="W_WORKFLOW_SPECIFIC_WAIT_QUEUE_ORCH_INSTANCE" EXPRESSION="'-200'"/> |
| Sets the value of ORCH_INSTANCE for workflow specific waiting queue. |
W_WORKFLOW_SPECIFIC_ERROR_QUEUE_ORCH_INSTANCE | instance number |
Code Block |
---|
| <COL TAG="W_WORKFLOW_SPECIFIC_ERROR_QUEUE_ORCH_INSTANCE" EXPRESSION="'-200'"/> |
| Sets the value of ORCH_INSTANCE for workflow specific error queue. |
Other Parameters |
---|
w_mc2_http_retry_count | time in seconds |
Code Block |
---|
| <CODE>:w_mc2_http_retry_count: := '5';</CODE> |
|
|
Anchor |
---|
| w_disable_task_statistics_update |
---|
| w_disable_task_statistics_update |
---|
| w_disable_task_statistics_update | N (default), Y |
Code Block |
---|
| <CODE>:w_disable_task_statistics_update: := 'Y';</CODE> |
| Setting to Y disables the execution of update_tasks_statistics.inc logic globally. Alternative to apply it to a single process is DisableTaskStatisticsUpdate RTR parameter. Expand |
---|
title | Note (click to expand): |
---|
| Disabling update task statistics will lead to the following consequences: 1. There may be problems in the Monitoring Tool. Not all information may be displayed.
2. There may be problems with AC. Not all information may be displayed.
3. You can see incorrect status if there are errors in events that are not displayed due to the use of this option |
|
Anchor |
---|
| W_REF_BATCH_MODE |
---|
| W_REF_BATCH_MODE |
---|
| W_REF_BATCH_MODE | Y (default), N |
| Disable single commit scope mode when loading Schedule, Variable Rate and Earnings in batch mode (when loading via the _mi stream). |
Anchor |
---|
| W_LOAD_XREFID_IN_UPPER_CASE |
---|
| W_LOAD_XREFID_IN_UPPER_CASE |
---|
| W_LOAD_XREFID_IN_UPPER_CASE | N (default), Y |
| Disable single commit scope mode when loading Schedule, Variable Rate and Earnings in batch mode (when loading via the _mi stream). |
Anchor |
---|
| W_WRHS_IGNORE_POS_FLAG |
---|
| W_WRHS_IGNORE_POS_FLAG |
---|
| W_WRHS_IGNORE_POS_FLAG | N (default), Y |
Code Block |
---|
| <COL TAG="W_WRHS_IGNORE_POS_FLAG" EXPRESSION="'Y'"/> |
| Ignore POS_FLAG field in POSITION flag during load. Available since February 2017 EagleML release. |
Anchor |
---|
| W_VALIDATE_MSG_SAFETY |
---|
| W_VALIDATE_MSG_SAFETY |
---|
| W_VALIDATE_MSG_SAFETY | Y (default), N |
Code Block |
---|
| <CODE>
:W_VALIDATE_MSG_SAFETY: := 'N'
</CODE> |
| Setting to N disables validation for SQL injection. |
Anchor |
---|
| W_NO_LOAD_VALIDATION_FLAG |
---|
| W_NO_LOAD_VALIDATION_FLAG |
---|
| W_NO_LOAD_VALIDATION_FLAG | N (default), Y |
Code Block |
---|
| <COL TAG="W_NO_LOAD_VALIDATION_FLAG" EXPRESSION="'Y'"/> |
| Global analog of noLoadValidationFlag element for Reference objects. |
Anchor |
---|
| W_UNDERLYING_VALIDATION_SKIP |
---|
| W_UNDERLYING_VALIDATION_SKIP |
---|
| W_UNDERLYING_VALIDATION_SKIP | N (default), Y |
Code Block |
---|
| <COL TAG="W_UNDERLYING_VALIDATION_SKIP" EXPRESSION="'Y'"/> |
| Setting to Y turns off validation of fields during the load of Underlying SMF shell records created for Underlying from the SMF .Effect is close to noLoadValidationFlag, but works only for Underlying. |
Anchor |
---|
| W_UNDERLYINGSMF_DELETE_REINSERT_SWITCH |
---|
| W_UNDERLYINGSMF_DELETE_REINSERT_SWITCH |
---|
| W_UNDERLYINGSMF_DELETE_REINSERT_SWITCH | N (default), Y |
Code Block |
---|
| <CODE>
:W_UNDERLYINGSMF_DELETE_REINSERT_SWITCH::='Y';
</CODE> |
| Setting to Y allows to delete the underlying record by key and reinsert a new incoming one. RTR analog is underlyingDeleteReinsertSwitch. |
Anchor |
---|
| W_UNDERLYINGSMF_COMPABILITY_MODE |
---|
| W_UNDERLYINGSMF_COMPABILITY_MODE |
---|
| W_UNDERLYINGSMF_COMPABILITY_MODE | N (default), Y |
Code Block |
---|
| <CODE>
:W_UNDERLYINGSMF_COMPABILITY_MODE::='Y';
</CODE> |
| Setting to Y allows to avoid new implemented logic for underlying upload that tracks underlying periods and adjust them. Basically it is a backup option in the case that someone would require old behavior and wanted to avoid updated underlying period by period loading process. |
Anchor |
---|
| W_ExecuteSRM |
---|
| W_ExecuteSRM |
---|
| W_ExecuteSRM | 0,1 |
| Toggle SRM process usage when the generic load workflow launches the composite pace_event. |
Anchor |
---|
| W_USE_STREAM_FAILURE_TOLERANCE |
---|
| W_USE_STREAM_FAILURE_TOLERANCE |
---|
|
W_USE_STREAM_FAILURE_TOLERANCE | Y, N(default) |
Code Block |
---|
| <COL TAG="W_USE_STREAM_FAILURE_TOLERANCE" EXPRESSION="'Y'" USERDESCRIPTION="Use the preset stream Failure Tolerance value for TSR status. Y(yes) or N(no)"/> |
| Toggle stream Failure Tolerance value usage in TSR status resolution. |
Anchor |
---|
| W_FAILURE_TOLERANCE_TYPE |
---|
| W_FAILURE_TOLERANCE_TYPE |
---|
| W_FAILURE_TOLERANCE_TYPE | BATCH (default), RECORD |
Code Block |
---|
| <COL TAG="W_FAILURE_TOLERANCE_TYPE" EXPRESSION="'BATCH'"/> |
| Switches failure tolerance type between batches and separate records. Works only with Warehouse Preproc stream (as only this stream can handle batches with multiple records inside). Default value is BATCH. |
Anchor |
---|
| W_VENDOR_PARAMS |
---|
| W_VENDOR_PARAMS |
---|
| W_VENDOR_PARAMS | formatted value |
Code Block |
---|
| <COL TAG="W_VENDOR_PARAMS" EXPRESSION="'120:
:FTP_URL:199.181.252.17
:FTP_USER:EAGLEACCFTPH3
:FTP_PASSWORD:'+IIF (:g_EagleML20_Version: >= '13','base64aes~3ixVtDShlFVvUggGTym0xtgyXc5KbnS/','base64vig~Sn1cdCkrKUU=')+'
:FTP_DIRECTORY:/IN/FRFILEHOLD/
:FTP_FILE:CUSTID.MMKT
:VENDOR_NAME:IDC
:FEED_NAME:Fundrun:\n
120:
:FTP_URL:10.70.132.27
:FTP_USER:DISDEVFTP2
:FTP_PASSWORD:base64aes~9LwuJR5vWo6gtnndb9sUxn3r3ivvhiDe
:FTP_DIRECTORY:/ABVDEV/REQUEST/
:FTP_FILE:unvmnt.ftp
:VENDOR_NAME:IDC
:FEED_NAME:Solvency
:FTP_RESPONSE_DIRECTORY:/ABVDEV/RESPONSE/'" /> |
| VENDOR FTP credentials. |
Anchor |
---|
| UNPACK_WITH_CORR_ID |
---|
| UNPACK_WITH_CORR_ID |
---|
| UNPACK_WITH_CORR_ID | Y, N |
Code Block |
---|
| <CODE>
CreateVariable( 'UNPACK_WITH_CORR_ID','N');
</CODE> |
| Unpackaging with correlation Id in file names. |
Anchor |
---|
| w_preproc_path |
---|
| w_preproc_path |
---|
| w_preproc_path | folder path |
Code Block |
---|
| <CODE>
:w_preproc_path: :=GetDirRoot() + 'servers/msgservice/preprocessors';
</CODE> |
| Setting correct preprocessors folder location in case IWS resolves them in a wrong way. |
Anchor |
---|
| W_REQ_CNT_LOOP_MAX |
---|
| W_REQ_CNT_LOOP_MAX |
---|
| W_REQ_CNT_LOOP_MAX | time in seconds |
Code Block |
---|
| <COL TAG="W_REQ_CNT_LOOP_MAX" EXPRESSION="'18000'"/> |
| Sets the timeout during which the parallel_exec stream checks if the file has been loaded. Default value is 18000 (5h). |
Anchor |
---|
| EAGLEML_WAREHOUSE_BATCH_ERROR_MODE |
---|
| EAGLEML_WAREHOUSE_BATCH_ERROR_MODE |
---|
| EAGLEML_WAREHOUSE_BATCH_ERROR_MODE | N (default), Y |
Code Block |
---|
| <CODE> :EAGLEML_WAREHOUSE_BATCH_ERROR_MODE::='Y';
</CODE> |
| Toggles Batch Error mode for Warehouse objects. See more details on this page. |
Anchor |
---|
| W_BATCH_COLLECT_ERRORS_FLAG |
---|
| W_BATCH_COLLECT_ERRORS_FLAG |
---|
| W_BATCH_COLLECT_ERRORS_FLAG | N (default), Y |
Code Block |
---|
| <COL TAG="W_BATCH_COLLECT_ERRORS_FLAG" EXPRESSION="'Y'"/> |
| Toggles Report all errors at once feature. Read more |
Anchor |
---|
| W_SMF_GENERICSMF_DEBUG |
---|
| W_SMF_GENERICSMF_DEBUG |
---|
| W_SMF_GENERICSMF_DEBUG | N (default), Y |
Code Block |
---|
| <COL TAG="W_SMF_GENERICSMF_DEBUG" EXPRESSION="'Y'"/> |
| If this flag set to "Y" the additional XSLT is used in genericSMF rule logic and all tags are mapped into TAGVALUE format and after that all tags are split and created by CreateVariable construction. With this approach tags will be displayed in the Outgoing tab in Message Center Console, thus making SMF debug more comfortable. Currently unavailable due to MC bug. This warning will be removed as soon as it is fixed. |
Anchor |
---|
| w_default_send_notifications |
---|
| w_default_send_notifications |
---|
| w_default_send_notifications | ALWAYS (default) , NEVER, ONFAILURE |
Code Block |
---|
| <COL TAG="w_default_send_notifications" EXPRESSION="'ALWAYS'"/> |
| Manages EJM jobs notifications. ‘ALWAYS’ or ‘1’ to enable ‘NEVER’ or ‘0’ to disable ‘ONFAILURE’ to send notification on failure case only (TSR has ‘FAILED’ final status). |
Anchor |
---|
| W_INTERNAL_TSR_GENERATION |
---|
| W_INTERNAL_TSR_GENERATION |
---|
| W_INTERNAL_TSR_GENERATION | Y (default), N |
Code Block |
---|
| <COL TAG="W_INTERNAL_TSR_GENERATION" EXPRESSION="'N'"/> |
| Setting to N suppresses intermediate TSR generation. RTR analog is InternalTSRGeneration. |
Anchor |
---|
| W_INCLUDE_ALL_DETAILS |
---|
| W_INCLUDE_ALL_DETAILS |
---|
|
W_INCLUDE_ALL_DETAILS | N (default), Y |
Code Block |
---|
| <COL TAG="W_INCLUDE_ALL_DETAILS" EXPRESSION="'Y'"/> |
| This flag allows to show details for SUCCESS messages in consolidated TSR like: Code Block |
---|
| <transactionId>B90DBM55FL6PIXJB</transactionId>
<eagleDetailId>4839327</eagleDetailId>
<identifier><identifierName>fromId</identifierName><identifierValue>1</identifierValue>
</identifier><identifier><identifierName>account</identifierName><identifierValue>261</identifierValue>
</identifier><identifier><identifierName>referenceNumber</identifierName><identifierValue>-3862</identifierValue>
</identifier><identifier><identifierName>identifier2</identifierName><identifierValue>19900101</identifierValue>
</identifier><identifier><identifierName>identifier3</identifierName><identifierValue>99</identifierValue>
</identifier> |
This flag works in conjunction with CreateConsolidatedTSR and IncludeRecordErrorDetails. So to use this option within one single process you need to set IncludeAllDetails = Y, CreateConsolidatedTSR = Y and IncludeAllDetails = Y in the RTR. |
Anchor |
---|
| W_INCLUDE_RECORD_ERROR_DETAILS |
---|
| W_INCLUDE_RECORD_ERROR_DETAILS |
---|
|
W_INCLUDE_RECORD_ERROR_DETAILS | Y (default), N |
Code Block |
---|
| <COL TAG="W_INCLUDE_RECORD_ERROR_DETAILS" EXPRESSION="'N'"/> |
| Setting to N excludes errors from TSR. RTR analog is IncludeRecordErrorDetails. See more details on this page. |
Anchor |
---|
| W_DISABLE_EXT_ERR_DESC_PACE_UPLOADER |
---|
| W_DISABLE_EXT_ERR_DESC_PACE_UPLOADER |
---|
|
W_DISABLE_EXT_ERR_DESC_PACE_UPLOADER | N (default), Y |
Code Block |
---|
| <COL TAG="W_DISABLE_EXT_ERR_DESC_PACE_UPLOADER" EXPRESSION="'Y'"/> |
| Setting to Y excludes errors from Pace Uploader in TSR generation. There is no RTR analog. |
Anchor |
---|
| W_SYNCCALL_OPTIMIZE_FLAG |
---|
| W_SYNCCALL_OPTIMIZE_FLAG |
---|
| W_SYNCCALL_OPTIMIZE_FLAG |
|
|
|
Anchor |
---|
| w_enable_ndfa_multifiles |
---|
| w_enable_ndfa_multifiles |
---|
| w_enable_ndfa_multifiles |
|
|
|
Anchor |
---|
| W_ROLLUP_FLAG |
---|
| W_ROLLUP_FLAG |
---|
| W_ROLLUP_FLAG | Y (default), N |
Code Block |
---|
| <COL TAG="W_ROLLUP_FLAG" EXPRESSION="'N'"/> |
| Setting to N disables the roll-up for Warehouse Position and Open Lot. Alternative setting: Code Block |
---|
| <rollupFlag>N</rollupFlag> |
element in the incoming message. |
Anchor |
---|
| W_USE_RDC_PRICING |
---|
| W_USE_RDC_PRICING |
---|
| W_USE_RDC_PRICING | N (default), Y |
Code Block |
---|
| <COL TAG="W_USE_RDC_PRICING" EXPRESSION="'Y'"/> |
| Global analog of useRdcPricing element for IssuePcPrice object. Toggles RDC load mode for IssuePcPrice. When set to Y, loads using RDC processes. |
| N (default), Y |
Code Block |
---|
| <COL TAG="W_USE_RDC_FX" EXPRESSION="'Y'"/> |
| Global analog of useRdcFx element for IssueFxPcRate object. Toggles RDC load mode for IssueFxPcRate. When set to Y, loads using RDC processes. |
Anchor |
---|
| w_disableACKForStreams |
---|
| w_disableACKForStreams |
---|
| w_disableACKForStreams | pipe-delimited list of streams' |
Code Block |
---|
| <CODE>
:w_disableACKForStreams: := '|eagle_ml-2-0_default_out_q|eagle_ml-2-0_default_in_xml_reference|';
</CODE> |
| Disable ACK messages for specified streams. For example, when you load via eagle_ml-2-0_default_cm_control_message or when you do not want extra ACK produced for acync extract. |
Anchor |
---|
| W_WRITE_WORKFLOW_LOG |
---|
| W_WRITE_WORKFLOW_LOG |
---|
| W_WRITE_WORKFLOW_LOG | Y, N (default) |
Code Block |
---|
| <COL TAG="W_WRITE_WORKFLOW_LOG" EXPRESSION="'N'"/> |
| Toggles writing of logs generated by exec_wkfl stream. These logs are required to autostart subprocesses, for other cases can be switched off. |
Anchor |
---|
| W_SCHD_EJM_WORKFLOW_CANCEL |
---|
| W_SCHD_EJM_WORKFLOW_CANCEL |
---|
| W_SCHD_EJM_WORKFLOW_CANCEL | Y, N (default) |
Code Block |
---|
| <CODE>
:W_SCHD_EJM_WORKFLOW_CANCEL: := 'Y';
</CODE> |
| Toggles the timeout for workflow_restart rule. RTR version of this parameter is EnableTimeoutCancel. Timeout value is set with W_SCHD_EJM_RUN_TIMEOUT parameter. |
Anchor |
---|
| W_SCHD_EJM_RUN_TIMEOUT |
---|
| W_SCHD_EJM_RUN_TIMEOUT |
---|
| W_SCHD_EJM_RUN_TIMEOUT | time in seconds or time in hh:mm format |
Code Block |
---|
| <CODE>
:W_SCHD_EJM_RUN_TIMEOUT: := 60;
</CODE> |
Code Block |
---|
| <CODE>
:W_SCHD_EJM_RUN_TIMEOUT: := 17:30;
</CODE> |
| Sets the timeout value for workflow_restart rule. RTR version of this parameter is EJMRunTimeout. Timeout can be enabled with W_SCHD_EJM_WORKFLOW_CANCEL=Y parameter. |
Anchor |
---|
| W_SCHD_EJM_RUN_CANCEL_TIME |
---|
| W_SCHD_EJM_RUN_CANCEL_TIME |
---|
|
W_SCHD_EJM_RUN_CANCEL_TIME | time in hh:mm format |
Code Block |
---|
| <CODE>
:W_SCHD_EJM_RUN_CANCE_TIME: := 17:30;
</CODE> |
| Sets the cancel time value for workflow_restart rule. RTR version of this parameter is EJMRunCancelTime. This parameter allows to setup a specific time to end all orphaned scheduled workflow executions and stop specific scheduled events at the specified time. |
Anchor |
---|
| g_eaglepy_version |
---|
| g_eaglepy_version |
---|
| g_eaglepy_version |
|
|
|
Anchor |
---|
| USE_TRADE_EXT |
---|
| USE_TRADE_EXT |
---|
| USE_TRADE_EXT | 1, N (default) |
Code Block |
---|
| <COL TAG="USE_TRADE_EXT" EXPRESSION="'1'"/> |
| When enabled, Warehouse Trade load calls EGL_TRD_INTERFACE_EXT stored procedure instead of default TRD_EGL_GEN_INTERFACE. |
Anchor |
---|
| W_ENABLE_EXTENDED_FILE_STATISTICS |
---|
| W_ENABLE_EXTENDED_FILE_STATISTICS |
---|
| W_ENABLE_EXTENDED_FILE_STATISTICS | N (default), Y |
Code Block |
---|
| <COL TAG="W_ENABLE_EXTENDED_FILE_STATISTICS" EXPRESSION="'Y'"/> |
| Setting to Y expands file statistics with translation statistic and stores it in the PACE_MASTERDBO.ORCH_QUEUE.ORCH_STATE_CLOB DB table to support data load validation. ORCH_STATE_CLOBE table contains: statistics for the source file: partition count; count of filtered records before the translation; total batches for main destination; count of input records; count of records passed to translation. statistics for translated files: total translated records; number of batches and filtered records for destination; translated records for partition; outgoing filename; count of records in key file for roll-up process.
|
Anchor |
---|
| W_ENABLE_SIGNAGE_LOGIC |
---|
| W_ENABLE_SIGNAGE_LOGIC |
---|
| W_ENABLE_SIGNAGE_LOGIC | N (default), Y |
Code Block |
---|
| <COL TAG="W_ENABLE_SIGNAGE_LOGIC" EXPRESSION="'Y'"/> |
| Y enables signage logic. Please note, that the if local parameter EnableSignageLogic is present in Control Message (RTR), it will have priority over the global parameter. |
W_ISSUEROLE_UPDATE_CLOSED_ALLOWED | N (default), Y |
Code Block |
---|
| <CODE>
:W_ISSUEROLE_UPDATE_CLOSED_ALLOWED: = 'Y';
</CODE> |
| Setting to Y allows to update closed issue roles (records woth close date not null). Alternative way to use this logic is to set referenceTransaction/issuerRole/allowUpdateClosedSwitch to Y.
|
W_WRHS_USE_GENERATED_BIND |
|
|
|
Anchor |
---|
| W_DISPLAY_ENVNAME_IN_SENTBY |
---|
| W_DISPLAY_ENVNAME_IN_SENTBY |
---|
|
W_DISPLAY_ENVNAME_IN_SENTBY | N (default), Y |
Code Block |
---|
| <COL TAG="W_DISPLAY_ENVNAME_IN_SENTBY" EXPRESSION="'Y'"/> |
| By default the sentBy value is the URL. Setting to Y allows to set meaningful information about the region. The information will be taken from EnvironmentName variable from eagle_ml-2-0_custom_cm/w_config_version.inc. RTR analog is DisplayEnvNameInSentBy. Default value: Code Block |
---|
| <sentBy>http://www.eagleinvsys.com/</sentBy> |
Parameter is set to Y:
Code Block |
---|
| <sentBy>http://www.eagleinvsys.com/O171Q001</sentBy> |
|
Anchor |
---|
| W_HTTP_CALL_TIMEOUT |
---|
| W_HTTP_CALL_TIMEOUT |
---|
|
W_HTTP_CALL_TIMEOUT | time in seconds |
Code Block |
---|
| <COL TAG="W_HTTP_CALL_TIMEOUT" EXPRESSION="'1000'"/> |
| Sets the timeout value for http_calls.inc include file. Alternative way to use this logic is to set the local parameter httpCallTimeout before including http_calls.inc. |
Anchor |
---|
| W_UNPACKER_TIMEOUT |
---|
| W_UNPACKER_TIMEOUT |
---|
|
W_UNPACKER_TIMEOUT | time in seconds |
Code Block |
---|
| <COL TAG="W_UNPACKER_TIMEOUT" EXPRESSION="'500'"/> |
| Sets the timeout value for all runpreprocessors (unzip, file listing, ...) in unpacker. Alternative way to use this logic is to set the parameter UnpackerTimeout in Properties of Task Unpacker in IWS when you edit a workflow. |
W_SEC_SHELL_RECORD_ONLY | N (default), Y |
Code Block |
---|
| <COL TAG="W_SEC_SHELL_RECORD_ONLY" EXPRESSION= "'Y'"/> |
| By default, during initial load the tag 1257 (HISTORY ONLY) is not sent to the Stored Procedure even when it is populated in incoming file. As a result the data is loaded into the master table fully. The flag allows load initial security in History mode, as a result only specific list of tags will be inserted into master table. This mode can be enabled for a single message by setting element referenceTransaction/header/processingOptions with the value 'SEC_SHELL_RECORD_ONLY' |
Anchor |
---|
| W_UNPACKER_UNZIP_SKIP_TIMESTAMP_RESTORATION |
---|
| W_UNPACKER_UNZIP_SKIP_TIMESTAMP_RESTORATION |
---|
|
W_UNPACKER_UNZIP_SKIP_TIMESTAMP_RESTORATION | N (default), Y |
Code Block |
---|
| <COL TAG="W_UNPACKER_UNZIP_SKIP_TIMESTAMP_RESTORATION" EXPRESSION="'Y'"/> |
| By default, during unpacker processing zip files are unzip utility always use timestamp restoration and unpacked files always have original timestamp when they were created. This option allows to skip timestamp restoration and set actual timestamp for unpacked files. Alternative way to use this logic is to set the parameter UnpackerUnzipSkipTimestampRestoration in Properties of Task Unpacker in IWS when you edit a workflow or as parameter edit a workflow or as parameter in RTR. |
Anchor |
---|
| W_WAIT_LAST_TASK_REPORTER_SECONDS |
---|
| W_WAIT_LAST_TASK_REPORTER_SECONDS |
---|
|
W_WAIT_LAST_TASK_REPORTER_SECONDS | time in seconds |
Code Block |
---|
| <COL TAG="W_WAIT_LAST_TASK_REPORTER_SECONDS" EXPRESSION="'3'"/> |
| Allows to freeze execwkfl step and wait last task_reporter step if it is still in processing. Should be used together with W_WAIT_LAST_TASK_REPORTER_RETRY_COUNTS parameter. Alternative way to use this logic is to set the parameter WaitLastTaskReporterSeconds in RTR. |
Anchor |
---|
| W_WAIT_LAST_TASK_REPORTER_SECONDSRETRY_COUNTS |
---|
| W_WAIT_LAST_TASK_REPORTER_RETRY_SECONDSCOUNTS |
---|
|
W_WAIT_LAST_TASK_REPORTER_RETRY_SECONDS time in secondsCOUNTS | number, default is 3 |
Code Block |
---|
| <COL TAG="W_WAIT_LAST_TASK_REPORTER_ | SECONDSRETRY_COUNTS " EXPRESSION="' | 3
| Can be used only with W_WAIT_LAST_TASK_REPORTER_RETRY_COUNTS parameter. Allows to freeze execwkfl step and to set how many times we will try to wait last task_reporter step if it is still in processing. Should be used together with W_WAIT_LAST_TASK_REPORTER_RETRY_COUNTS parameter. Alternative way to use this logic is to set the parameter WaitLastTaskReporterSeconds in RTR. Alternative way to use this logic is to set the parameter WaitLastTaskReporterRetryCounts in RTR. |
Anchor |
---|
| W_SKIP_SINK_SCHEDULE_MANAGER_VERSION_CHECK |
---|
| W_SKIP_SINK_SCHEDULE_MANAGER_VERSION_CHECK |
---|
|
W_SKIP_SINK_SCHEDULE_MANAGER_VERSION_CHECK | Y, default is empty |
<COL TAG="W_SKIP_SINK_SCHEDULE_MANAGER_VERSION_CHECK " EXPRESSION="'Y'"/> | Can be used for eagle_ml-2-0_default_in_xml_sink_schd_manager stream to skip version check if you have SECURITYDBO.SINK_SCHEDULE_KEYS table. |
Anchor |
---|
| W_WAIT_LAST_TASK_REPORTER_RETRY_COUNTS MC2_LOAD |
---|
| W_WAIT_LAST_TASK_REPORTER_RETRY_COUNTS MC2_LOAD |
---|
|
W_WAIT_LAST_TASK_REPORTER_RETRY_COUNTS numberMC2_LOAD | Y, default is 3 Code Block |
---|
| language | xmlempty<COL TAG="W_WAIT_LAST_TASK_REPORTER_RETRY_COUNTS " MC2_LOAD" EXPRESSION="'5Y'" /> | Can be used only with W_WAIT_LAST_TASK_REPORTER_RETRY_COUNTS parameter.Allows to set how many times we will try to wait last task_reporter stepby eagle_ml-2-0_default_cm_acquire_data stream to load data using MC2 service. Alternative way to use this logic is to set the parameter WaitLastTaskReporterRetryCounts parameter MC2Load in RTR. |
---|
Anchor |
---|
| W_SKIPWRHS_SINKCHECK_SCHEDULEENTITY_MANAGERACTIVE_VERSION_CHECKSTATUS |
---|
| W_SKIPWRHS_SINKCHECK_SCHEDULEENTITY_MANAGERACTIVE_VERSION_CHECKSTATUS |
---|
|
W_SKIPWRHS_SINKCHECK_SCHEDULEENTITY_MANAGERACTIVE_VERSION_CHECKSTATUS | Y, default is empty | <COL TAG="W_SKIPWRHS_SINKCHECK_SCHEDULEENTITY_MANAGERACTIVE_VERSION_CHECK STATUS" EXPRESSION="'Y'"/> | Can be used for eagle_ml-2-0_default_in_xml_sink_schd_manager stream to skip version check if you have SECURITYDBO.SINK_SCHEDULE_KEYS table. | W_MC2_LOAD | Can be used for eagle_ml-2-0_default_in_xml_warehouse and eagle_ml-2-0_default_in_xml_warehouse_preproc to check Entity Active Status during a processing. If entity is not active (RULESDBO.ENTITY.ACTIVE_STATUS = N), then process will be failed with an error. If entity is active (RULESDBO.ENTITY.ACTIVE_STATUS = Y) or active status is empty, then record will be processed without errors. |
Anchor |
---|
| W_PRESERVE_NULL |
---|
| W_PRESERVE_NULL |
---|
|
W_PRESERVE_NULL | Y, default is empty | | MC2 | LOAD | Can be used | by eagle_ml-2-0_default_cm_acquire_data stream to load data using MC2 service.Alternative way to use logic is to set the parameter MC2Load in RTR.GenericSMF SP mode to switch on Preserve Null logic by default. If option is Y, then you can use next example how to set null to different value types: string - null: <userGroupChar1>NULL</userGroupChar1>
numbers - lowest integer: <equityFloat1>-2147483648</equityFloat1>
dates - 0001-01-01: <userGroupDate1>0001-01-01</userGroupDate1> |