Enron email

Algorithmic Indexing

15 Dec 2000, 22:42 UTC

Capacity Book Status

From
Mark Ferguson mark.ferguson@enron.com
To
Lee Ferrell, Vernon Mercaldo, Kimberly Watson
Cc
Lisa Sawyer, david.tran@enron.com, victor.negrete@enron.com, steve.plant@enron.com, margaret.waters@enron.com
Bcc
Lisa Sawyer, david.tran@enron.com, victor.negrete@enron.com, steve.plant@enron.com, margaret.waters@enron.com
Date
Fri, 15 Dec 2000 14:42:00 -0800 (PST)
Murphy's Law has hit us the past few days. Since migrating to production we have had the following issues on Capacity Books:

Monday the Capacity Books were not available until 9:45am.
		Problem: This was because the Group table was created on the production server and not populated with the initial data.
		Solution:   Populated table and reran cycle.

Tuesday the Capacity Books were not available until 8:20am.
Problem: This was due to an RTI improvement that triggered a duplicate record on the contracted table.
Solution:   Corrected the stored procedure and reran cycle.

Wednesday the Capacity Books were not available until 2:00pm. Due to training we held off on publishing the views on Wired.
Problem:  The database server temp log file filled up  and triggered an abend to the Capacity Books batch cycle.  A notification was triggered to Steve 	       Plant's pager at 2:00am but he never received the page. Craig Buehler  had a problem with the Price Curve Manager spreadsheet, so if 	       	       Steve would have completed the batch cycle the pricing would have been calculated incorrectly. 
Solution:    We are automating the Price Curve Manager process, which will eliminate manual intervention. We are also looking into a better scheduling 	       and notification system.

Thursday the Capacity Books were available at 4:43am with no known problems.

If you have any additional questions please feel free to contact me at 3-3186.

Thanks,

Mark