You are viewing limited content. For full access, please sign in.

Question

Question

Could not allocate space for object 'dbo.cf_thumbnails'.'PK_cf_thumbnails' in database 'LF_Forms' because the 'PRIMARY' filegroup is full.

asked on October 6, 2021 Show version history

Hi all.

 

My customer can't upload a file using webform.

 

This is the event log

Erreur lors de l'importation. [LFF4101-FailedToUploadFile]

Details:
URL: /Forms/Handlers/FileUploadHandler.ashx?field=1&org=1&uqid=bc350cef-2943-4d39-9499-36d72dea1e93&formid=49
Error: FailedToUploadFile
Date: 06/10/2021 06:55:58 (Hawaii)
HTTP Status Code: 400
Business Process ID: 44
User: ADMIN
IP: 127.0.0.1
Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:93.0) Gecko/20100101 Firefox/93.0
Business Process Name: Test importation pj dans lf

Stack Trace:
Caught exception: Laserfiche.Forms.CommonUtils.Exceptions.LFFormsException
Message: Erreur lors de l'importation. [LFF4101-FailedToUploadFile]


Inner exception: System.Data.Entity.Infrastructure.DbUpdateException
Message: An error occurred while updating the entries. See the inner exception for details.
   à System.Data.Entity.Internal.InternalContext.SaveChanges()
   à E_Forms.Handlers.FileUploadHandler.ProcessRequest(HttpContext context)

Inner exception: System.Data.Entity.Core.UpdateException
Message: An error occurred while updating the entries. See the inner exception for details.
   à System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()
   à System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   à System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction)
   à System.Data.Entity.Infrastructure.DbExecutionStrategy.Execute[TResult](Func`1 operation)
   à System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction)
   à System.Data.Entity.Internal.InternalContext.SaveChanges()

Inner exception: System.Data.SqlClient.SqlException
Message: Could not allocate space for object 'dbo.cf_bp_attachment_data'.'PK_cf_bp_attachement_data_1' in database 'LF_Forms' 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.
   à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   à System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   à System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   à System.Data.SqlClient.SqlDataReader.get_MetaData()
   à System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   à System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   à System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   à System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   à System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   à System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary`2 identifierValues, List`1 generatedValues)
   à System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()

 

 

In my mind, it looks like a bug from database.

I tried to check the database and this got this error.

 

 

Need some help, please.

Thanks in advance

Regards

0 0

Replies

replied on October 8, 2021

You can upgrade to Forms 11 with which you can create file system volume to store the file uploads as well as migrate the existing files stored in the database to file system volume to reduce the size of the database. See more information from https://doc.laserfiche.com/laserfiche.documentation/11/administration/en-us/Default.htm#../Subsystems/Forms/Content/Administration/configuring-file-storage.htm

1 0
replied on October 6, 2021

The error message seems pretty clear. Are you saying that the drive isn't full and you think the problem is actually something else?

0 0
replied on October 6, 2021

Thanks for your help Brian.

Yes, the drive isn't full.

 

But in my last message, I had 2 problems :

1°) The access (I can not connect to the laserfiche database). This point is ok now. I can connect and check the database properties.

 

 

2°) The second problems is about the size of database. We are using SQL Express and it looks like we hit the limit.

 

0 0
replied on October 10, 2021

Hi Xiuhong.

Thanks for the tip. I'm going to try it this week.

Regards

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.