Error: Could not allocate space for object xxx in database SCRIBEINTERNAL
book
Article ID: KB0078262
calendar_today
Updated On:
Products
Versions
TIBCO Scribe Insight
7.9.1
Description
If you see the database error below, use the instructions in this article to troubleshoot your SCRIBEINTERNAL database.
Database error: Could not allocate space for object xxx in database ‘SCRIBEINTERNAL’ because the ‘PRIMARY’ filegroup is full.
Open SQL Studio.
In the Object Explorer expand Databases.
Right-click SCRIBEINTERNAL and select Properties.
In the Select a page pane, click Files.
Check the Autogrowth/maxsize column to see if you are hitting a hard limit. If Autogrow is set to x % and Maxsize set to unlimited, that is not the problem.
Check the hard disk to make sure you have enough space.
Check the directory where the SCRIBEINTERNAL_dat.mdf file resides for any limitations. This file is typically located in C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data. If that is not the path on your server, locate the .mdf file by checking the path in the SCRIBEINTERNAL SQL Database Properties dialog under Files next to the Autogrowth/maxsize column.
If there is enough space in the directory and no quota, check the SCRIBEINTERNAL_dat.mdf file size.
NOTE: There is a hard limit of 10GB for the SQL Express edition, if growth is set to unlimited, the file can reach the 10GB limit.
If this the case, locate the ScribeMaintenance.sql maintenance script in the C:\Program Files (x86)\Scribe folder on the server.
Edit the script and adapt it to your needs.
Run the script against the ScribeInternal DB to free up some space in the DB and clear the error.
Issue/Introduction
Use the instructions in this article to troubleshoot your SCRIBEINTERNAL database.