K2 Studio - Deployment: A database error occurred: "Could not allocate space for object"
KBS100056
PRODUCTK2 blackpearl
BASED ONK2 blackpearl (all)
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.
Issue
On Deployment the below error occurs:
"A database error occurred : Could not allocate space for object 'Server.Assembly'.PK_Server_Assembly in database K2Dev'"
Symptoms
The solution fails on deployment because the K2 Database is 4GB and SQL Express has a limitation of 4GB.
Resolution
To upgrade the SQL instance
Microsoft SQL Server comes in different versions that includes
- SQL Server Enterprise
- SQL Server Business Intelligence
- SQL Server Standard
- SQL Server Web
- SQL Server Express
SQL Express has a limitation on space allocation and it is suggested to use SQL Enterprise without any space limitations.