Overview

The customer is experiencing an issue with the Evidence-Based Scheduling (EBS) feature in FogBugz taking up a significant amount of space in their ShipDate table. This problem is occurring in an older version of FogBugz, version 8.22.36H. The customer is unable to find the option to disable EBS in their account settings due to their On-Premises account setup. They also need guidance on how to navigate to the Accounts and Billing page in their FogBugz interface.

Solution

To resolve the issue of EBS taking up a significant amount of space in the ShipDate table in FogBugz On-Premises version 8.22.36H, follow these steps:

1. Review the data in the ShipDate table and take a backup before proceeding with the change. You can do this by truncating the table using the command: `TRUNCATE TABLE Shipdate`.
2. Since you have an On-Premises account and the option to disable the Time Tracking & EBS modules was removed post-version 8.21.913, you can disable it from the fbhosted database `tblSubscribedApp` table by changing the value of `fSubscribed` to 0 for `sapp = 'FogBugz-TimeTracking'`. Use the following command:

3. update [fbhosted].[dbo].[tblSubscribedApp]
   set fSubscribed =0 and sapp = 'FogBugz-TimeTracking'
   where [ixFogBugzTrial] =1

4. To navigate to the Accounts and Billing Page, hover your mouse over the profile in the lower left corner and click on Your FogBugz Account. However, as you have an On-Premises account, you may see different options under the Accounts and Billing page due to the nature of your account setup.

Summary

By following the above steps, you should be able to resolve the issue of EBS taking up a significant amount of space in the ShipDate table in FogBugz On-Premises version 8.22.36H. Remember to test and verify if the issue has been resolved after performing these steps.

FAQ

1. Can I disable EBS in FogBugz version 8.22.36H?
   Yes, you can disable it from the fbhosted database `tblSubscribedApp` table by changing the value of `fSubscribed` to 0 for `sapp = 'FogBugz-TimeTracking'`.
2. How can I navigate to the Accounts and Billing Page in FogBugz?
   Hover your mouse over the profile in the lower left corner and click on Your FogBugz Account. However, as you have an On-Premises account, you may see different options under the Accounts and Billing page due to the nature of your account setup.
3. What should I do before truncating the ShipDate table?
   Review the data in the ShipDate table and take a backup before proceeding with the change.