MSSQL error code: 1105 Could not allocate space for object "X" in database 'NIKU' because the 'PRIMARY' filegroup is full

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Not able to login in Clarity, multiple errors in logs on NIKU database: 

Could not allocate space for object 'niku.CMN_SEQ_CMN_SEC_GROUP_FLAT_HIERS' in database 'NIKU' 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.

Could not allocate space for object 'niku.LOG_SESSIONS' in database 'NIKU' 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.

Table names may vary. 

The DBA confirms niku.ldf is growing bigger and causing this issue

Environment

SQL Server

Resolution

• The error you are facing is not a Clarity but a database SQL Server error.
• The problem is most likely with transaction log growing too big and the settings may need adjustment. 
• Please connect with your DBA and ask them to apply the solutions below:
  • Resolving SQL Server errors - article on SQLshack.com
  • Broadcom KB: The MSSQL transaction log for the database is full, or has grown excessively.

Additional Information

If you have an issue on tempdb and not on NIKU database, please check MSSQL not allocating space in "tempdb", the PRIMARY file group is full