NOTICE DATE:  June 24, 2008

NOTICE TYPE:  W-A042308-43   UPDATE Extracts - Wholesale

CLASSIFICATION: Public

SHORT DESCRIPTION:  ERCOT is continuing the recovery effort of missing data for April 21 through April 30, 2008.

INTENDED AUDIENCE:  QSEs

DAY AFFECTED:  April 21 through April 30, 2008

LONG DESCRIPTION:  ERCOT conducted an emergency database failover on April 21, 2008 following a hardware failure.  This database failover resulted in an out-of-synch (OOS) data problem from April 21 through April 30.   ERCOT has developed a phased process to attempt to thoroughly recover the missing data. 

Phase 1: Repair the out-of-synch situation and begin posting daily extracts was completed as expected. 

Phase 2: However, during the course of executing the original Phase 2, a gap was exposed due to changes in the replication strategy during the time period affected because of system upgrades and migration.  A modified Phase 2 recovery plan has been initiated and is outlined below:

Recover the EMMS data for April 21 through April 30, 2008 into ISM.

  1. Restore/recover source database to 3/31/08 23:59:59 – Completed
  2. Restore/recover target database to 3/31/08 23:59:59 – Completed
  3. Validate source and target database match 100% at 3/31/08 23:59:59  - Completed
  4. Restore/apply files from 4/1/08 00:00:00 to 4/21/08 10:44:00 - Complete  **Cold backup in progress - Complete
  5. Generate/apply source transactions to target for DATA GAP period (4/21/08 10:44:01 to 4/22/08 11:14:00) – Complete  **Backup complete
  6. Restore/apply files from 4/22/08 11:14:01 thru 4/30/08 23:59:59 – In Progress - Complete
    1. Restore/apply files for 4/22/08 – Complete
    2. Restore/apply files for 4/23/08 – Complete
    3. Restore/apply files for 4/24/08 – Complete
    4. Restore/apply files for 4/25/08 – Complete
    5. Restore/apply files for 4/26/08 – Complete
    6. Restore/apply files for 4/27/08 – Complete
    7. Restore/apply files for 4/28/08 – Complete
    8. Restore/apply files for 4/29/08 – Complete
    9. Restore/apply files for 4/30/08 – Complete
  7. Validate results and run data extracts In Progress
  8. Merge transaction period from 4/21/08 10:44:00 to 4/30/08 23:59:59 back to PROD
  9. If no errors or gaps are found, the following extracts will be generated for April 21 through April 30, 2008:

Act_Res_Output

Ancillary_Services_Daily

Bids_and_Schedules_Daily

Forecast_Data_Daily

Market_Information_Daily

Sched_and_Actual_Load

Self_Sch_Energy_Services

ASDEPLOYMENTS

 

Phase 3:  As a mitigation in an effort to provide information to resolve the “Corrupt Data Calculations of Price Adjustments for Non-Spinning Reserve Service” issue, a third phase is being executed in parallel with the modified Phase 2.  Data is being restored using the production backup.  The steps in this process are complete.

 

ADDITIONAL INFORMATION:  ERCOT has filed with the Public Utility Commission of Texas (PUCT), NOTICE OF P.U.C. SUBSTANTIVE RULE AND PROTOCOL VIOLATION (Control number 27706, Item Number 118).  The full PUCT filing is available from the PUCT website at the following web address:

http://interchange.puc.state.tx.us/WebApp/Interchange/application/dbapps/filings/pgSearch.asp

From this page, select “Filings Retrieval” from the column on the right side of the page then select Login.  Enter the Control Number (27706) and select “Search Now”. 

The first 30-day Initial will post at the end of May for data from May 1 forward. 

CONTACT:  If you have any questions, please contact your ERCOT Account Manager. You may also call the general ERCOT Client Services phone number at (512) 248-3900 or contact ERCOT Client Services via e-mail at [log in to unmask].

If you are receiving e-mail from an ERCOT distribution list that you no longer wish to receive, please follow this link in order to unsubscribe from this list: http://lists.ercot.com.

yl