Laddawn.com : NEW Go-Live Document

Created by Judy Ascensao, last modified on Feb 07, 2015

PRE-LIVE (WEEK BEFORE):

  1. Change w/o traveller to print multiple copies for manual recording of barcode data over the weekend
  2. Get final ITMMST file from Cliff for item masters and run on  Staging today.
  3. Get final IMAGE list from Chris for the upload of images
  4. Copy all Conversion Programs from Training Live to LIVE and TRN
    1. CREATE.WEB.FILES - IIUTIL
    2. CREATE.FILE.PTRS - AVBP 
  5. Set rates in comments that have upcharges
  6. Get g/l accounts for upcharges from Scott and update Rev Chg Codes
  7. License and configure new responders
  8. Make sure that unlocking service is installed on 00srv01
  9. Make sure Bartender is running on 00srv01
  10. Make a version of COPY.DATA called COPY.DATA.LIVE to stay on 00srv01 (leave old version for training)- this was given to Janice

PRE-LIVE (FRIDAY NIGHT):

Cathy and Judy will take care of 1 to 8

THEN

John and Marc will do 9 to 14

  1. Make sure all users are logged off
  2. Production - shut down
  3. Make sure that auto pick and auto ship phantoms are turned off
  4. Laddawn.com - put 'under construction' page on site (8pm)
  5. Put SYSTEM.MAINT in VOC LOGIN
  6. Stop the CE mailbox so that no inbound emails will go into the queue
  7. Kill all phantoms (including nightly job)
  8. Run SOPS4013 (INVOICE UPDATE) & Bookings report
  9. Stop UDT Services
  10. Stop Scheduled Tasks
  11. MARC - Redirect inbound faxes to a folder so they can be copied over when the system is ready
  12. Stop replication (8pm - Marc)
  13. Save a complete copy of AVANTE92 on 00srv01 and the current website
  14. Restart Unidata Services

SOFTWARE DEPLOYMENT

Unidata:

  1. John - COPY CREATE.WEB.FILES (from IIUTIL IN LIVE.DATA on 00ITDEVSERVER01) and CREATE.FILE.PTRS (from AVBP in LIVE925 on 00ITDEVSERVER01)
  2. John - Run CREATE.WEB.FILES in TRN.DATA and LIVE.DATA
  3. John - Run CREATE.FILE.PTRS in LIVE925
  4. John - Roll Web 2.0 version in PRC
  5. John - Recompile IIUTIL COPY.DATA.LIVE
  6. John - RUN IIUTIL COPY.DATA.LIVE
  7. John - Login to LIVE.DATA
  8. Cathy and Judy take care of the following 
    1. Set clipboard on system to capture the following OR COMO FILE
    2. Select BP WITH @ID = "_]"
    3. DELETE BP
    4. Compile BP File
    5. Catalog BP DIRECT FORCE
    6. CLEAR-FILE DATA IIDRIVERS
  9. Logto LIVE925:
    1. Select LDLIB WITH @ID = "_]"
    2. DELETE LDLIB
    3. Recompile all LDLIB
    4. CATALOG LDLIB DIRECT FORCE
    5. Setup pointer to DEV925 for DELETED.AVBP
    6. SELECT DELETED.AVBP
    7. DELETE-CATALOG AVBP
    8. SELECT DELETED.AVBP
    9. DELETE AVBP
    10. BASIC AVBP
    11. CATALOG AVBP DIRECT FORCE
    12. SELECT DEV.VOC WITH TYPE = "C" AND WITH F2 = "BP8.0" (IN BRACKETS)
    13. CATALOG LBP DIRECT FORCE
    14. Make sure LOGIN voc on LIVE925 looks like DEV925
    15. Add SYS0001 to process at set common in housekeeping
    16. Verify LDLIB SB.SETUP exists
  10. Optio:
    1. Copy Optio changes from DEV to TRN and LIVE

Website:

  1. Add laddawnlockliverpc to rgwresp.ini
  2. Update webconfig: Website folder: configuration/appsettings.config & make sure 'from email address' is correct as web_customerservice@laddawn.com
  3. Copy all files from 00extranet01\d$\websites\laddawnstaging\ to 00srv01\e$\websites\laddawn20\
  4. Copy from 00extranet01\d$\websites\laddawnweb\configuration\appsettings to 00srv01\e$\websites\laddawn20\configuration
  5. Change redback connection to laddawnliverpc
  6. Make sure that we have the right number of responders set up
  7. Point the unlocking service to live.data

 

SATURDAY A.M..: 

 Setup:

  1. Change field 2 of EPCCTL EZVAR.PREF from "X" to "XX" (this is the prev field indicator for the config going forward)
  2. Load the correct octene and clarity prices into EPCCTL MARKETPLACE_RATES - use EPC Table Entry Screen.  Get current prices from WEB9001 (PRIME_OCTENE and PRIME_CLARITY)
  3. Create "MOD" item in BOM3000:
    1. Desc & Internal Desc = MADE ON DEMAND ITEM
    2. Sort Key = MOD
    3. UOM = M
    4. Class Code = PRO
    5. Config Code = 1 (Configure to Order)
    6. Eng Status =- 1 (Active)
    7. F6 - GLG=MI, Item Type=7, Make/Purch=M, Buyer & Planner codes = 01, Order Policy=A, Mfg Leadtime=3
    8. F7-> F6: Generic Name Code = N/A, Closure Type=3
    9. Modify SYSCON MOD.CONV.LAD and enter cpn associated with MOD item in field 1
  4. Roll MOD configuration (all 10 CF... files starting with "MOD]")  Select filename = "MOD]"
    1. EPCBOM  (1 item)
    2. EPCPLC   (248 items)
    3. EPCPLD   (1 item)
    4. EPCPLM   (21 items)
    5. EPCPLP   (12 items)
    6. EPCPLR   (0 items)
    7. EPCPLT   (76 items)
    8. EPCRULES  (23 items)
    9. EPCSCHDR (1 item)
    10. EPCSCDET (89 items)
  5. On Clippership Server Stations
    1. Preserve existing Brandit forms
    2. Load Bartender forms
    3. Deploy and run script to update the SQL DB w/new fields needed for labeling
    4. Deploy modified version of Clippership to all shipping servers
    5. Deploy modified version of Brandit label program for production to all production labeling machines

 

Database Changes/Conversion Programs:

  1. Customer Master:
    1. Select all ship-to customers and set via to BW
    2. Compile all IITUIL programs before running
    3. Get newest version of Chris's spreadhseet then RUN IIUTIL UPDT.ITMMST.USR.IMAGE
    4. Get newest version of Cliff's spreadsheet (ItemWebFields.txt) then RUN IIUTIL UPDT.ITMMST.USR.WEB.INFO
    5. RUN IIUTIL UPDATE.CE.SECURITY (to create WEBROLES.USR records)
      1. Per Tina's list - Update managers and IT with code 30 (manager)
      2. Tina, Meme, Sarah, Kelly, Amber, Mark, IT
    6. Verify that SYSCTL CONTACT.ITEM.XRF.USR has nothing in field 1 (next MOD Item#)
    7. RUN IIUTIL CONVERT.SHOPPINGCART (to convert shopping cart keys and load billto customer#)
    8. Before continuing, all verifications should be completed
    9. Verify that CONFIG.CONV file exists
    10. RUN BP CONFIG.GRID (to build default table for ASHAD conversions)
    11. RUN BP WEB.CONVERT.CONFIG
    12. RUN IIUTIL CREATE.CPXRF.USR (Building XRF record for stock and NS items)
    13. RUN IIUTIL WEB.CONV.MASTER.ORDERS (to build MSTRORDHDR.USR and MSTRORDDET.USR - writes master order# to SOHDR.USR)
    14. RUN IIUTIL CONVERT.MP.DESC (reformats marketplace QUDET/SODET descriptions in field 12)
    15. RUN IIUTIL CONVERT.ACTIVE.QUOTES (to build SHOPPINGCART.USR for active quotes)
    16. Remove Customer Part Number Maintenance Screen and Customer Part Number Upload from Menus
    17. Put QUO9014 on QUOSUB3PS menu and roll KNITMENU - rebuilding menu security

 

Verify:

  1. Check that T001 to T300 have been created and KTXX1-99 were created
  2. Check that the following files were created and resized properly (using FILE.STAT):
    1. CONTACT.ITEM.XRF.USR  then resize to 4391,1
    2. CUSTPARTXRF.USR then resize to 1001,1
    3. ITMTAGS.USR then resize to 503,1
    4. MOD.ITMMST.USR then resize to 2999,4
    5. MSTRORDDET.USR  then resize to 44701,1
    6. MSTRORDHDR.USR then resize to 23027,1
    7. SCRATCHPAD.USR  then resize to 503,1
    8. SHAREDCARTS.USR  then resize to 503,1
    9. SHAREDITEMS.USR  then resize to 503,1
    10. WEBLOCK.USR  then resize to 503,1
    11. WEBOPTIONS.USR  then resize to 7,2
    12. WEBROLES.USR then resize to 203,1
    13. WEBROUTINES.USR then resize 503,1
    14. CHECKOUT.CART.USR  then resize to 503,1
    15. SHOPPINGCART.USR - make sure it's resized properly to 503,1
  3. Check that the following VOC pointers exist in LIVE925: 
    1. ARDEPOSIT
    2. BOOKINGS
    3. COMPET.USR
    4. COMPET.USR.INDEX
    5. CONXRF
    6. CURRDET
    7. CURRHDR
    8. EMPLOYEES
    9. FAMMST
    10. IVTTBL
    11. JOBHDR
    12. JOBDET
    13. JOBMST
    14. LD.INCLUDES
    15. ORDREQHST
    16. ORDREQXRF
    17. RMTDET
    18. RMTHDR
    19. SLSTAXMST
    20. SOAUDIT
    21. SOPWRK.LF1
    22. TAXCLASSMST
    23. USRSECACT
    24. WIP
    25. WIPMTLRQ
    26. XFREXP
    27. CHGTBL
    28. DMTRN
    29. DMTRN.LF1
    30. IICOMBO
    31. INVPLAN07 *** VOC dictionary s/b pointing to D_INVPLAN
    32. WBDEFN IIUTIL
    33. IN PRC39 - check that pointer LIVE.II.MD is in AVBP (copy LIVE.II.MD LDLIB but change remove A from LIVE925)
    34. IN LIVE.DATA - check that pointer to AVBP exists (which lives in LIVE925)
  4. SYSCON's (New/Changed) - look at each and verify:
    1. NAMED.PARAMS.LAD (Changed - was copied from DEV w/overwrite) - make.named.params has already been run and programs w/lad.common recompiled
    2. CONFIG.SETTINGS.LAD (New - was copied from DEV)
    3. WEB.APP.LAD -(Changed - was copied from DEV w/overwrite)
    4. MOD.CONV.LAD (New - this should have been manually created - field 1 s/b the newly created MOD item's CPN)
    5. ITEM.DESC.LAD (New - was copied from DEV)
    6. NEXT.SHAREDITEM.LAD (New - was created - make sure that field 1 is null)
    7. WEB.SETTINGS.LAD (New - was copied from DEV)
    8. NEXT.TAG.ID.LAD (New - make sure that field 1 is null)
    9. QUOTE.TERMS.LAD - added field 14 for Godzilla (history cutoff days) ( should only have brought over field 14 from DEV)
    10.  SHIP.CUTOFF.LAD - added field 3 for cutoff time  (should only have brought over field 3 from DEV)
    11. EMAIL.LAD - set field 30 to ITDEPT (should only have setup field 30)
  5. SYSTBL's (New/Changed) look at each one individually verify that they exist - IICOMBO should also have been updated prior
    1. CFG.RULES.LAD (New - 57 records including header)
    2. MOD.CRITERIAXRF.LAD (New - 234 including header)
    3. SUPPMSG.LAD (New - 3 including header)
    4. RTC.LAD - the following records should have a "1" in field 3 (rate) for c/e request popup filtering
      1. 041, 043, 070, 080, 090, 140
    5. RTC.LAD -the following records should have a "2" in field 3 (rate):
      1. 030, 110, 120, 130
    6. RTC.LAD - make sure new request types 005, 111, 031 and 127 have been moved from DEV
    7. FOB - make sure FOB code "CPU" for customer pickups
    8. WEB.OPTIONTYPES.LAD (New - should have been copied from DEV
    9. Existing VIA code "PO" - make sure "PO" is in field 1 for carrier selection
    10. SYSTBL WEBOPTIONS.XRF.LAD (new - all records copied from DEV)
    11. WEB.EXT.DESC.LAD (New - all records copied from DEV)
    12. WEBROLE.LAD (New - all records copied from DEV)
  6. Make sure that WEBCRITERIA.USR has 45 records beginning with "S.]"
  7. Make sure that CATALOG.CD.USR has 69 records that start with 1,2,3,4 or 5.
  8. Make sure that WEBSEARCHGROUPS.USR has 6 records
  9. Make sure COMMENTS.USR has comment numbers 901-908
  10. Make sure ITMTAGS.USR has tags 1-9 and the next tag number to start is set to 10
  11. Make sure WEBOPTIONS.USR has 86 records
     
  12. Make sure the folllowing EPCCTL tables exist (MDT and MDTV prefixes):
    1. MARKETPLACE_RATES

    2. MP_FRTCONSTANT

    3. MP_MINMULT

    4. MP_MARKUPS

    5. MP_DFLTCASE

    6. MP_IMP_MINWGT

    7. MP_IMP_BOXWGT

    8. MP_IMP_MARKUPS

  13. New/Changed standard comments (COMMENTS.USR) -make sure the following exist with the correct info:
    1. 000 - Blank Comment
    2. 005 - 40x48 4-way pallet
    3. 006 - Export Pallet (Verify upcharge rate)
    4. 007 - #Pkgs per Pallet (Verify upcharge rate)
    5. 008 - Max Pallet Height (Verify upcharge rate)
    6. 101 - change text to say "SHIP ORDER COMPLETE"
    7. 102  - change text to say "BACKORDER"
    8. 105 - Inside Delivery (Verify upcharge rate)
    9. 106 - Tailgate Delivery (Verify upcharge rate)
    10. 107 - Lift Gate Delivery (Verify upcharge rate)
    11. 108 - Call for Delivery
    12. 109 - Receiving Hours
    13. 111 - Load Tags
    14. 116 - Ship with Order
    15. 133 - BOL Comment
    16. 144 - Attach Documents to Shipping Paperwork
    17. 160 - New comment for Residential Delivery.  Verify the delivery charge rate.  *** do not set the 'preference flag' to Y
    18. 161 - New comment for LIMITED ACCESS DELIVERY.  Verify the delivery charge rate (per lb for small pkg and flat rate for LTL). *** do not set the 'preference flag' to Y
    19. 162 - New comment for 'don't use wooden slats'
    20. 163 - New comment for 'don't use slats'
    21.  

  14.   

  15. Verify that non-inventory GLG Code 900 exists in INVGLCTL

  16. Verify that revenue charge codes 901-906 exist in file CHGCODE

  17. Verify that indexes are created and enabled for MSTRORDHDR.USR and SODET 

  18. External Folders (on 00srv01)

    1. Brandit Logos
    2. Brandit Forms
    3. Plates
    4. Product Images 
       

IT Testing before turnover for user test:

  1. Delete unnecessary COMMENTS.USR records
  2. Run GUIDE and check all file sizes - resize where necessary
  3. Make sure there are no global catalogs on LIVE, TRN, DEV
  4. Test Plate Upload in Avante (make sure it writes to correct file(s))
  5. Test to make sure Bartender is running and getting logos and there is only 1 instance of the service running
  6. Test ce webroles
  7. Test to make sure product images are coming up in sharing, product details
  8. Make sure Brandit labels are coming up in checkout and summary

 

SUNDAY P.M.

  1. Run nightly job (JOB9004) - shouldn't find any shipments to update but will send invoices and run other processes
  2. Rebuild SB Menu Security
  3. Open CE Mailbox & make sure emails get sent to cswf folder properly
  4. Change inbound faxes to go to the inbox and copy any that came over during downtime to the ce inbox
  5. Send inbound fax and email to ce and make sure it makes it to the cswf folder
  6. Comment the SYSTEM.MAINT execution in LOGIN VOC
  7. Remove 'under construction' page from laddawn.com
  8. Run deffered w/o update and restart production updating
  9. Remove page 2 printing on w/o traveller
  10. Restart Replication
  11. Restart Scheduled Tasks
  12. Write fix pgm to loop through CFHDR and delete CF... files if order/quote no longer exists.  Remove them from CFHDR also. (COMPARE TRAIN TO LIVE TO SEE WHAT WAS DELETED - WHY WAS IT STILL THERE TO BE PROCESSED BY CONVERSION PGM - CAN WE CLEAN THESE UP???)
  13. Run ZIPCODE.USR update (if we have time)

 

Clippership:

  1. Deploy database changes to all shipping servers