Base Export Asset view missing some device serial numbers

Issue No: TM-2448
Created 7/10/2017 3:09:54 PM
Type Bug
Priority Major
Status Closed
Resolution Fixed
Fixed Version 17.1
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-200134 - Delivery Receipt (Serial Number)|http://helpdesk.irely.com/iRelyi21live/i21/#/HD/Ticket/?ticket=HDTN-200134]   *Issue* :   The Base Export Asset view, vyuTMBEExportConsumptionSite is not including device serial numbers in all cases.   The serial numbers are present when you look at Devices under Consumption sites, but the serial is not shown in the view for that customer site.     *Steps* :   1. From TM > Consumption Site, remove the attached device if there is an existing. If none, attached a regulator device. Save.   2. After the regulator device, attach a company owned Tank. Make sure that there is a serial number for the tank. Save.   3. On sql, execute query: select * from vyuTMBEExportConsumptionSite where lastAmount <> 0 and account = ''   4. Check the number column. It is only displaying the site number and does not include the tank serial number.     *Acceptance* : Should display the tank serial number of the device and should not include the regulator type of device.