Version 1 - Reviewed: December 23, 2011

Hotfix: Extend Schema Version Dates

Running the SQL script provided herein against any TariffShark database of version 7, 8, 9, 710, 720, 730, 810, 820, 830, 910, 920 or 930 will resolve an issue that can prevent the Filing Schema Version field from working correctly in some cases.

If you attempt to update the "Schema Version" field on the "FERC Details" tab of the "Update Filing" screen for a Filing with a "Filing Date" that falls after December 31, 2011 and this hotfix has not been applied, you will see the error shown below. Applying this database hotfix resolves the issue.

Note: Each time the TariffShark Database Installer is used to create a new TariffShark database, this script must be run against that database.

Resolution

  1. Download the script below and run the entire script against a valid TariffShark database.

Back to the top

More Information

APPLIES TO

  • TariffShark Database versions 7, 8, 9, 710, 720, 730, 810, 820, 830, 910, 920 and 930.

Back to the top