1 / 24

Retail Sub-Committee Update Robert Connell June 14, 2002

Retail Sub-Committee Update Robert Connell June 14, 2002. Updates for RMS on June 14, 2002. Update on PTB Synchronization Plan Status on synchronizing the CR of record Provide Update from Previous RMS issues Portal Performance and Changes IDR / Non IDR Meter Usage Reports

fisk
Télécharger la présentation

Retail Sub-Committee Update Robert Connell June 14, 2002

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Retail Sub-Committee UpdateRobert Connell June 14, 2002

  2. Updates for RMS on June 14, 2002 • Update on PTB Synchronization Plan • Status on synchronizing the CR of record • Provide Update from Previous RMS issues • Portal Performance and Changes • IDR / Non IDR Meter Usage Reports • Status of ERCOT TCH Performance Issue • Update on Enhanced MP EDI Reporting Effort

  3. PTB Synchronization Plan • To address the current market issue with the rep of record getting out of synch between ERCOT, TDSP and CR systems. • The objectives of this project are to provide a plan to; • Identify the size of the problem • Provide root causes and options for correcting (if available) • Develop and implement a technical plan to synchronize databases • The Non-PTB (Over 1 MW) ESI Ids are being addressed through another process • RMS synchronization plan was approved at TAC unanimously • All MPs will participate • Project was Kicked off on 5/21 • Minutes distributed 5/22 .

  4. Market Synchronization Update • Phases of project: • Complete an internal clean-up of systems • Complete a test run of data extracts from MPs • Complete a comparison of all records with date begin on or after April 1st • Categorize results and determine technical solution to synchronize records • Status: • ERCOT internal clean-up is in progress • Several data entry people are in the process of correcting Siebel data • 30,000 records have been identified with the TDSP as LSE as the CR of record • Test run is in progress • 100% of the TDSPs have submitted test files • 50% of CRs have submitted test files • Functional and technical review has been completed on all files submitted • Test run will complete June 21st • Full data comparison will begin June 28th

  5. PTB Synchronization Plan - Next Steps • Market continues to support plan with appropriate technical and business resources being assigned. • Test files will be processed by ERCOT and finalize format and comparison programs verified. • ERCOT will work with MPs to correct any file format issues. • Pull together a detailed project plan to evaluate differences at a point in time and document steps required to correct • Full data send/analysis will take place once test run is complete • Report through RMS

  6. Questions

  7. Portal Performance History (Find ESI IDs) May 29, 2002 Total hits per week Unsuccessful hits

  8. Portal Performance Find ESI IDs) Week Ending 6/8/02

  9. Portal Performance Find Transaction Week Ending 6/8/02

  10. Portal Performance Items • Mux E Way fix from Seebeyond on week of 3/30 • Saw a temporary 7 % improvement • Moved Portal E Ways to New Hardware week of 4/13 • Saw a temporary 10 % improvement • Added components (threads) on 4/25 • Showed some very promising improvements • Additional Architecture change was made 5/21 • Removed TCH component competing with batch transactions • Seeing a 30% improvement in errors • Also added “heartbeat” functionality to verify EAI every minute • Implemented additional redundancy improvements 6/8 • Improvements in redundancy (6) for find transactions • Limited the result set to 500 transactions • Future options also being evaluated • Moving Siebel queries directly to Oracle • Additional redundant paths for Portal transactions • Continue to analyze errors and respond

  11. Questions

  12. IDR Meter Usage Report (data submitted 8 weeks following Trade date)

  13. IDR Meter Usage Report (as of 6/13/02)Percent of IDR accounts received by ERCOT since August 95% or better expected 66% * NOTE: ERCOT (and REPs) may have received additional non-sequential data (i.e, February data before January data). ERCOT rejects all meter reads that introduce gaps in the database

  14. IDR Meter Usage Report (date through which 99% of data received)

  15. Questions

  16. ERCOT TCH System Issue • ERCOT notified market June 6th technical call • Provided written update on June 11th on slow down in our TCH system impacting 814s and 867-04s Due to this slow down in processing over the past 7 days ERCOT has received 153,807 Initiating 814 transactions and has sent 53,911 814 response transactions leaving 99,896 transactions still to be processed. Additionally, ERCOT has received 378,853 814_20’s and has only been able to send 9,851 814_21 response’s which leaves 369,002 transactions still to be processed.

  17. ERCOT TCH System Issue Resolved • ERCOT resolved the TCH problem and reported to the market on technical call (2 PM 6/12) that we were processing normally again • Agreed with market to process newest transactions first During resumed processing, ERCOT processed over 111,000 transactions in 12 hours, all current transactions (last 2 days are processed) and expects to be fully caught up by Sunday 6/16. • Forwarding 867-03s were not impacted, and 867 meter data being loaded to Lodestar was not affected. • Internal Post Mortem has been conducted

  18. Questions

  19. Trading Partner Transaction Reports“Dark Side of the Moon” Files • ERCOT implemented daily EDI transaction reports for all market participants in October, 2001 • Reports purpose was to provide information to the MP on all files received and posted to MPs mailboxes. • Reports delivered to FTP Reports folder • Reports include file and transaction information for 24 hour period previous day • Reports provide MP with data to verify daily processing

  20. INITIATING ENTITY 814 data out FTP PGP PF Archive SeeBeyond SIEBEL 814 data in FTP TCH Archive PGP PF • Life Cycle data will span several days • CSV files will contain data • Based on only 3rd party matching and GPID • Reports will be pushed once a day and report for the previous day All report points

  21. Market Reports - Next Steps • ERCOT has worked with MPs to refine requirements for enhanced reporting • ERCOT has completed development of the new functionality • Currently working on User guide for full explanation of the reports and how to use the data effectively • Plan to deploy enhanced MP Reports in next 2 weeks

  22. Questions

  23. Questions

More Related