Consumption Site showing two sites with same number and only one showing in AG billing

Issue No: TM-2950
Created 11/7/2018 1:39:05 PM
Type Bug
Priority Minor
Status Closed
Resolution Fixed
Fixed Version 18.1
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-222042 - Still have 2 sites with same #|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-222042] This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-220264 - ACCT# 2005280 - Theron Comstock|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-220264]   *Steps* :   1. Open a Consumption Site. Click Site Action > Reassign Site.   2. Select a specific customer where you want the site to be reassigned. Make sure that the specific customer site has an existing site.   3. Message 'Site has been reassigned successfully. Do you want to load the new site record?"   3. Click Yes button. The new reassigned site will display. Check site number. It is displaying the same site number with the existing one.   *Issue* :   User reporting that Consumption Site is showing two sites but only one site record is showing in AG Billing   * Support is correcting by naming sites 001 and 002 respectively in SQL. * Changes are updated in both TMCustomer adn TMSite. * Two records are not showing in tblTMCOBOLREADSite * Support makes a change to each site record by adding TEST after the description and save and close. Support opens the record back up. * Two records show in tblTMCOBOLREADsite   *Fix* :   * Should not allow 001 to be used for both/all sites listed * need to find all existing sites with same number to fix so that records are accurate in AG Billing and TM Consumption Site