WEM (WIC EBT Middleware) Release History

Version 1

1.0.0.1

Release Date February 18, 2016

Initial Release -- Only Batch Processing Support

Known Issues

Updates are not persisted to the message logs table.
Files are not being archived correctly.
The File Processor is not yet included in the installation script.
Redemption file processing is not complete.
Permissions as well as a lack of reconnect logic prevented use of a network share for this build.

1.0.0.7

Release Date: March 2, 2016

Added support for Account Setup and Benefit Transaction messages.

Issues Fixed

The file processor is included in the installation scripts.
Redemption file processing has been completed.
Configured using a network share with FTP support for the Inbox/Outbox.

Known Issues

Host name resolution is not working in the socket host.
IP Connectivity fails when connected via VPN.

1.0.0.10

Release Date: March 4, 2016

Issues Fixed

Success return code 0000 returned when unable to initialize socket host. This has been corrected so now the response is DT99.
Host name resolution is working correctly.
IP and Host name connectivity is working as expected when connected to the VPN.

Known Issues

Files are not being archived correctly.

1.0.0.13

Release Date: March 9, 2016

This is the first complete build of the WEM software. It does have several known defects.

Issues Fixed

All components are now included in the build.

Known Issues

Void Benefits Returns an Error of DT04:2050.
Serialized Raw Request Field In The MessageLogDetails Table Does Not Have The Complete Message.
File Are Remaining In WEM NV Inbox When File Names Are Not Unique.
NV Vendor With An Action Code = 02 De-Activate Is Not Converting To ICD2014 Action Code = 03.
WEM Is Not Creating Logs For File Process.
DT99 Was Return For A WIC Direct Return Code = 1020 For The Account Setup Message With An Invalid Recipient Number.
Invalid Action Code Reflects Back A 0000 Return Code.
WIC Direct 1060 Error Is Returning DT99 On An Account Update.
Account Update Message Is Deactivating The Card Number And Then Attempts To Replace The Card Number With The Same Card Number.
WEM UPC Conversion File Has UpcPluDescription Text In The BenefitUnitDescription Field And Is Missing UpcPluDescription Field.
NV UPC With An Action Code = 02 De-Activate Is Not Converting To ICD2014 Action Code = 03.
ITCN WIC Direct Fails UPNXML-2014 From WEM With FunctionReturnCode = 0101.
UPC-E Is Converted To UPC-A.
Void Benefit Message Are not Being Processed By WEM.
Void Benefits Returns An Error Of DT04:2050.
Benefit Redemption File For Open Domain is Not Converted Correctly, Transaction Type Is Field Is Short, Product Description Is In The UPC/PLU Field, HouseholdID Is In The CardNumber Field.
Redemption File Not Being Pick Up By WEM.

1.0.0.23

Release Date: April 07, 2016

This was the UAT release of the software. All known issues have been resolved via incremental patches against internal development and QA environments.

Issues Fixed

All known issues have been resolved.

Known Issues

1.0.0.27

Release Date: May 4, 2016

This is the first official release. It corrects several issues found during UAT.

Issues Fixed

Does not retain leading zeros in vendor number when the vendor file is forwarded to the EBT host.
Sometimes file processing ends in an error.
Files are not being processed. This refers to a specific situation where the files were not being processed randomly and sporadically.

1.0.0.30

Release Date: June 8, 2016

Corrective release containing fixes for 3 bugs and an enhancement.

Issues Fixed

Multiple files larger than 4MB cannot be processed by the file processor without restarting the service.
Redemption file processing gets Divide By Zero exception.
File is being locked before it can be renamed to remove .filepart when uploaded to WIC Direct.
Files sometimes take 15 minutes to process although logging indicates the file is not locked.
Update mappings for NV to better match the expectation of Open Domain

1.0.0.31

Release Date: June 17, 2016 Current Nevada Production Version

Corrective release to address an issue with an incompatibility related to the database interface and the high availability group cluster.

Issues Fixed

Corrected an issue with the database interface so distributed transaction coordinator could not be invoked against the cluster.

Version 2

2.0.0.10

Release Date: November 4, 2016

This major release version is the first release candidate build for adding support for SPIRIT integration with WIC Direct into the WEM Middleware. It enhances the existing support that was implemented for Nevada for Account Setup and Benefit Management messages over a TCP/IP Raw Socket, to include these and all the message types required by SPIRIT over a SOAP Client Endpoint. In addition to the support for this new platform and the new methods it entails, it also provides many bug fixes and performance improvements over what was originally released as 1.0.0.31.

Features Added

Support a call to UI2014: Add EBA from SPIRIT: ACCT_SETUP message.
Support a call to UI2014: Add Cardholder/Card from SPIRIT: ACCT_SETUP message.
Support a call to UI2014: Update EBA from SPIRIT: ACCT_SETUP message.
Support a call to UI2014: Update Cardholder/Card from SPIRIT: ACCT_SETUP message.
Support a call to UI2014: Add or Update PIN from SPIRIT: RESET_BAD_PIN_CNT_REQUEST message for unlocking a pin locked card.
Support a call to UI2014: Add or Update Benefits from SPIRIT: WIC_BENEFIT_REQUEST message.
Support a call to UI2014: Get Benefit Balance from SPIRIT: WIC_ACCT_BALANCE_REQUEST message.
Support a call to UI2014: GetCardholder/Cards from SPIRIT: ACCT_SETUP message.
Support a call to UI2014: GetEbaDetails from SPIRIT: ACCT_SETUP message.
Support a call to UI2014: GetBenefitMaintenanceHistory from SPIRIT: WIC_BEN_HIST message.
Support a call to UI2014: GetBenefitRedemptionHistory from SPIRIT: REDEMPTION_HISTORY_REQUEST.
Support a call to UI2014: GetCardholderCards using a card number, from SPIRIT: CARD_RECIPIENT message.
Support a call to UI2014: GetCardHistory from SPIRIT: CARD_HISTORY_REQUEST.
Support converting the SPIRIT Vendor file to a .wvxml-2014 file.
Support converting the SPIRIT UPC/PLU file for .upnxml-2014 file.
Support converting the SPIRIT Category/Subcategory file to a .csxml-2014 file.
Support converting the .rxml-2014 to a SPIRIT redemption file.
Support converting the .bpxml-2014 to a SPIRIT benefits purged file.
Support converting the .bxml-2014 to a SPIRIT activity file.
Send e-mail alerts to a configurable address list when files are generated.

Issues Fixed

Bug 82467 WEM: Invalid Action Code in Cat Subcat csxml-2014 file.
Non-specific: Overall performance enhancements.

Known Issues

File processing performance issues: The fix has been coded for this but we must get it into a new build for NV and tested with Open Domain in UAT before including them in Mainline and then down into integration.

2.0.1.0

Release Date: November 23, 2016

This release addressed some bug fixes will adding support for smart card methods.

Important Note

This release introduces a new message interface for the Smart Card. In doing so it changes configuration a bit in the sense that the endpoint is not pointed to a root zone rather than the specific interface. What this essentially means is that an endpoint in an older version defined as http://localhost/MessageService would now simply be defined as http://localhost. Or an endpoint previously defined as http://localhost/C4/MessageService would now become http://localhost/C4/.

Features Added

Support Report Damaged Card method from the Card Application.
Support Card Present message from the Card Application.
Support Confirm Smart Card Update message from the Card Application.

Issues Fixed

Removing An Assigned Card Number By Deactivate Account Returns DT1022 Invalid/Missing Reason Code.
Files from WIC Direct get dropped on the floor and an error is thrown when a file already exists in the Outbox with the same name.
SPIRIT Displays Error code DT59 For A Card Number That Is Already Used In WIC Direct When Error code DT1060 Was Expected.
Benefit Activity File Transaction Log Time Field Is 6 Digits / Expected 8.

2.0.1.1

Release Date: November 28, 2016

This release is a single bug fix that was left out of the 2.0.1.0 build, but was intended to be part of the build.

Issues Fixed

Empty Files Cause a Processing Error.

2.0.1.2

Release Date: December 1, 2016

Features Added

Support for the Solutran S3 EBT system.

2.0.1.3

Release Date: December 8, 2016

Issues Fixed

UPC/PLU Files From SPIRIT Are Not Being Processed by WEM / No UPNXML is Being Created.
File processing uses hard-coded values and should use configuration values instead to support file processing.

2.0.1.4

Release Date: December 12, 2016

Issues Fixed

WEM: File processing uses hard-coded values and should use configuration values instead to support file processing (re-fix after merge issue).
Transaction Log Time Field In The WACT File Is Not In 24hr Format.
APL Type is Incorrect in UPNXML / File Contains 49 & 50, Should be 1 & 2.

2.0.1.5

Release Date: December 16, 2016

Issues Fixed

Benefit Activity File Not to Spec/WIKI.
PeerGroup = 00 Is Not In The UPNXML-2014 file / # of WICVendorPeerGroups = 7 But Only 6 Are in the UPNXML File.
UPC File in WEM doesn't correctly handle pre-formatted UPC values.

2.0.2.0

Release Date: December 18, 2016

Features Added

Support split-routing of all real-time messages to SWEM-Q and the EBT host.
Support Confirm Message Completion Message.

Issues Fixed

SPIRIT Is Not Processing The C4WURD C4WEXP C4WACT Files / "EBT batch file import had errors: File Doesn't Exist".
Benefit Activity File Not to Spec/WIKI.

2.0.2.1

Release Date: December 20, 2016

Issues Fixed

MIS EOD Errors [File Cannot be Parsed] / Batch Import Errors on Expired Benefit File / Not to Spec/WIKI.
Redemption File - File Cannot Be Parsed / Causes SPIRIT EOD Errors / Not to Spec/WIKI.
Outgoing files to the EBT system do not include fractional seconds, this is required for S3.

2.0.2.2

Release Date: December 21, 2016

Issues Fixed

When BXML-2014 BenefitQuantity = -1.00 The WACTYYMMDD00 File's Applied Qty Contains -00100 Causing SPIRIT Database to Receive -0.10 After EOD.
WURD File Discount Record For A Void Transaction Has Transaction Type = CR and Transaction Code = 305 When A Transaction Type = DB And Transaction Code = 411 Is Expected.

2.0.2.3

Release Date: December 22, 2016

Issues Fixed

Card Diagnostics Screen Displays a Status Of Active When The Card Number Is Inactive In WIC Direct.

2.0.2.4

Release Date: December 22, 2016

Issues Fixed

UPCXML-2014 File Has UpcPluDataLength = 0.

2.0.2.5

Release Date: January 24, 2017

Issues Fixed

Cat Subcat file truncates leading zeros. This is causing a problem for MT/S3.
Redemption File Authorization Number not truncated properly.

2.1.0.0

Release Date: February 10, 2017

Important Notes

Two new configuration values are added in this build and need to be updated as part of any upgrade installation.

    "EnableFileProcessingMemoryMappedFiles": true,
    "FileProcessingMemoryMappedFilesMinSizeKB": 64,

Features Added

Update file processing methods to use the same data context and utilities as the socket processor, and optimize the file processor to be less resource intensive.

Issues Fixed

File Processing Fails on some files in production due to packet re-assembly and indexing.
Configuration Toolkit Missing SSHThumbprint editor.
Configuration Tool doesn't retain values correctly.

2.1.0.1

Release Date February 15, 2017

Important Notes

This build simply joined 2.1.0.0 and 2.0.2.5 which were released from two different branches.

2.1.0.2

Release Date February 16, 2017

Issues Fixed

Removes unnecessary plug-ins from the Message Service installation path which to reduce load placed on MSMQ.

2.1.0.3

Release Date February 20, 2017

Issues Fixed

Cat Subcat file truncates leading zeros. This is causing a problem for MT/S3.
WEM: Redemption File Authorization Number not truncated properly.

2.1.0.4

Never Released, Rolled into 2.1.0.5

Features Added

Support routing of Redemption File to SWEM-Q from the EBT Host, and then to SPIRIT from the SWEM-Q

2.1.0.5

Release Date March 9, 2017

Issues Fixed

CDP-234 / SPIRIT Throws an Error on Accessing the EBT Account Balance Report and Using the Functionality for Food Adjustment Wizard for Household With Issued Benefits

Important Notes

This build introduced some background changes to use updated 3rd party packages as well as many non-impacting changes to correct code comments. These included spelling errors, etc.

2.1.1.0

Release Date March 10, 2017

Issues Fixed

Corrects a version number error where 2.1.0.5 was incorrectly listed as a 2.1.0 build instead of a 2.1.1 build.

2.1.1.1

Release Date April 17, 2017

Issues Fixed

Redemption file fails with Object Reference error in the error logs.

2.1.1.2

Release Date August 25, 2017

Issues Fixed

Bug 92674: WEM: The rebate flag in the file output to the EBT Processor always contains "Yes" for the rebate on all items.

2.2.0.0

Never released rolled into 2.2.1.0

Features Added

WEM: Add machine name to ApplicationErrorLogs and MessageLogs tables.
Encrypt Secure information in configuration files and database storage.
Support routing of Redemption File to SWEM-Q from the EBT Host, and then to SPIRIT from the SWEM-Q
When file processing email is sent, include the message content in the logs as well.

2.2.1.0

Internal Release October 18, 2017

Issues Fixed

General Improvements to code with regards to best practices and Microsoft standards.

Features Added

Add configuration setting and logic to support sending time information to compliment changes in SPIRIT that stem from [ENH-518]]
Will make caching changes so it performs more quickly and corrects an issue where records could sometimes get dropped
Remove NServiceBus from Client Endpoint Processing
Remove NServiceBus from Socket Host Processing

####Important Notes ####

This build includes a notable change to the configuration subsystem enabling encryption in the configuration file. Because of this it will be necessary to open the file in the configuration tool, then save the file. This save will trigger the file to re-write with encrypted contents. The encrypted content is required for the application to operate normally.
Once the content is encrypted as explained above the encrypted fields will be masked in the "release" version of the toolkit. Troubleshooting connection information showing that data in the clear will require a special "debug" build of the toolkit.
When paired with SPIRIT version 2.31 or greater, the value of "Card History Action DateTime" in the configuration toolkit must be configured to use the format value yyyy-MM-ddTHH:mm:ss.fff. Versions prior to 2.31 should use yyyyMMdd instead.

2.3.0.0

Never released rolled into 2.3.1.0

2.3.1.0

Internal Release October 31, 2017

Issues Fixed

[CDP-286] Rebate Flag Values of 1/0 Are Being Stored in UPC File Instead of Y/N.

Features Added

[TMP-283] Unable to Terminate Vendor on EBT Processor (WEM)

Notes

2.3.0.0 was the completion of a rollup release which includes everything since 2.2.0.0. 2.3.1.0 expands on 2.3.0.0 by adding a fix for an issue that was introduced as part of the 2.1.1.2 build.

2.4.0.0

Never released rolled into 2.4.1.0

2.4.1.0

Features Added

[CDP-243] WEM - Package Size is not sent to EBT Processor, but is required in Redemption file from EBT Processor.
[CDP-266] WEM - No way to enable deletion of files on FTP Site.

Issues Fixed

Refactor file processor to remove NServiceBus Libraries.
[CDP-277] Correctly handle auxiliary and offline files in the file processor.
Correct Logging in File Processor.
Refactor file processor to consolidate handler logic.
Update installer for the NServiceBus removal.
[TMP-283] Unable to Terminate Vendor on EBT Processor (Reintroduced).

Important Notes

This release includes major performance enhancements and code cleanup. This is the final release of the technical debt remediation efforts in WEM. In addition to those efforts it corrects an issue found in how WEM currently handles offline EBT redemption files, and addresses an issue causing file processor logs to not always update the Application Error Logs table.

The substance of the NServiceBus change is substantial. It will require some updates to the wem-config.json (using the WEM Configuration Toolkit) after installation. As a good practice the current wem-config.json should be backed up before starting the installation. The following considerations should be noted:

While it is not enforced in code, it is recommended that update installations to the WEM now by default include inserting the connection string when prompted by the installer.
In a basic WEM configuration - 1 MIS to 1 EBT, simply opening saving and closing the WEM configuration will typically be sufficient for updating the file.
More complex configurations such as offline EBT, SEBT supported configurations, etc. may need to verify the settings as some new ones were added and some old ones (not used) were removed to simplify configuration.
The message processor is no longer a service, it is instead a simple satellite assembly used by the Client Endpoint and File processor libraries. It will not be reinstalled and if the prior version was not uninstalled it will not start.

Finally, this release takes corrective action on the results of the code quality metrics evaluation and aligns the software to be fully compliant with Microsoft best practices.

2.4.1.2

Issues Fixed

Minor bug fixes.

2.4.1.3

Issues Fixed

Minor bug fixes.

2.4.1.4

Issues Fixed

Not Processing Redemption, Benefit Activity nor Expired Benefit Files When One WEM Instance is Shared Among Multiple State Agencies.

2.5.0.0

Issues Fixed

[ENH-568] WEM: Add Benefit Dates to the Get Account Balance Message

2.5.0.1

Issues Fixed

Not Processing Redemption, Benefit Activity nor Expired Benefit Files When One WEM Instance is Shared Among Multiple State Agencies.

2.5.0.2

Features Added

Support for single instance SWEM-SC WIC Direct environment.

2.5.0.4

Issues Fixed

DT19 Invalid Card # Error Returns on Reset Failed Debit Instead of Reactivating the Deactivated Card (Adding new unlock functionality for WEM)

2.5.0.5

Features Added

Allow Benefits issued with the same FTDU and LTDU to be redeemed by the POS.

2.5.0.6

Features Added

Adjust FDTU for Smart Card EBT hosts.

Special NOTE: This release deprecates all business rule functionality applied in 2.5.0.5.

2.5.1.0

Features Added

Support better abstraction in the Real Time Message Processor so EBT Providers are more truly pluggable.

2.5.2.0

Issues Fixed

Support better abstraction in the Batch Message Processor so EBT Providers are more truly pluggable.