tempDB maxes out drive space after running TDD

Owned by Knowledge Assistant
Apr 13, 2022
1 min read



Description of Issue

After running Munis updates through Tyler Deploy, the Tyler Database Deployer (TDD) runs and fails with an error: Could not allocate space for object 'dbo.SORT temporary run storage: 'xxx' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.



Context

  • Munis

  • SQL

  • tempDB

  • TDD

  • Accounts Payable

  • Server drive space



Cause

Tyler Database Deployer (TDD) runs and fails due to the tempDB database maxing out drive space on the Munis database server.



Resolution

On-Premise sites:

  1. Log into the Munis database server. 

  2. Check drive space for tempDB drive. If space is maxed out, go to next steps.

  3. Open SSMS and log into SQL instance. 

  4. Expand System Databases

  5. Right click tempDB

    1. Go to Task> Shrink> Files

    2. Switch File Type to Log and click OK

  6. Add drive space if needed after shrinking. 

  7. Apply MUN-433829 to prevent issue when running the TDD in the future. 

    1. Reach out to TSM On-Premise Support for the MunisERP release that contains this MUN

    2. Deploy MunisERP release through Tyler Deploy

Tyler Hosted sites:

  • Reach out to TSM SaaS Support for assistance.



Additional Information