Framework release news: v1 Alpha

Apr 19, 2010 at 12:03 PM
Edited Jul 8, 2010 at 12:06 PM

08/07/2010: v1 Alpha Updates

This is a quick note to let you know this project is not dead: i'm constructing all the test cases and data to run before I declare it fit for beta release.

09/05/2010: v1 Alpha Updates

Reports update and new Stored Procedure

Metadata Database:

  • New stored procedure: usp_Create_Run for creating entries in Run Master

Reports:

  • New report: Run Status
  • Formatting, Parameters and Navigation added to most reports

02/05/2010: v1 Alpha Updates

Recovery Only execution mode enabled and tested. Added Row Level Error Logging table and sample to Child Packages. Remaining activities prior to Beta are addition of Stored Procs to update Extract Limits and to Insert Tasks and Runs, and Report polishing.

Metadata Database:

  • New table Row_Error_Log

Packages:

  • Added "Recovery Only" execution mode to Master Package
  • Added Row Level Error logging to Child Package Template

 

27/04/2010: v1 Alpha Updates

With this update the framework moves much closer to beta status. Further testing has been done and the only planned feature outstanding is the Recovery Only run mode which will attempt recovery of incomplete runs only, without initiating a new set of tasks for that run. The views need a little further polishing and the reports definitely so.

Metadata Database:

  • New views to translate Run and Task Masters - vw_Run_Master & vw_Tasks_Master - some further work required
  • Updated view for Package Performance with some new metrics
  • Change to usp_Update_Task_Log - new parameter - Processing_Run_Execution_Id

Packages:

  • Correction to master package so task failure actions worked correctly

Reports:

  • Reports renamed with standard Rnnn prefix
  • Reports added for Run and Task Logs
  • Pie chart of run outcome rate added to Package Performance report
  • All reports need further work for formatting and interactivity

 

19/04/2010: v1 Alpha Updates

Metadata Database:

  • New view to translate Run Logs vw_Run_Log
  • Updated view for Package Performance with some new metrics

Packages:

  • Master package updated to use task failure actions.