The process cannot access the file because it is being used by another process.

[Harlem98]

Hello.

I'm trying to save files in DB, which should record the file as "BinaryData".

I'm using RadAsyncUpload, but when i upload the file i get the extension "System.IO.IOException: The process cannot access the file because it is being used by another process." and the file only gets loaded in the App_Data folder of my app, in an automatically created "RadUploadTemp" folder.

I've tried to disable the Path mentions in my SaveFile method, getting "Path not found error". Any of the available telerik demos is similar to my context. 

How do i solve this?

//my insert/update operations method
public void SaveFile(object sender, EventArgs e)
        {
            ListagemTimesheet model = new ListagemTimesheet();
            model.IDRecursoHumano = Convert.ToInt32(rdpInvestigadorE.Text);
            model.IDEstadoTimesheet = Convert.ToInt32(rcbEstado.SelectedValue);
            model.Observações = Obervaçoestxt.Text;
            model.AssinaturaTimesheet = txtAssinaturaTimesheet.Text;
            model.DataEnvio = DataEnvio.SelectedDate.Value;

            if (!string.IsNullOrEmpty(Ficheiro) && FileTipo != null)
            {
                model.Ficheiro = Path.GetFileNameWithoutExtension(Ficheiro);
                model.FileContent = fileBytes;
                model.FileTipo = Path.GetExtension(FileTipo);
            }
            if (!string.IsNullOrEmpty(FileID.Text) && Convert.ToInt32(FileID.Text) > 0)
            {
                model.ID = Convert.ToInt32(FileID.Text);
                listagembll.UpdateFile(model);
            }
            else
            {
                listagembll.InsertFile(model);
            }

//Ascx.Cs method

public void RadAsyncUpload1_FileUploaded(object sender, FileUploadedEventArgs e)
        {

            RadAsyncUpload1.Visible = false; //false
            var liItem = new HtmlGenericControl("li");
            Ficheiro = e.File.FileName; // sintaxe metodo
            FileTipo = e.File.ContentType;
            e.IsValid = true;
            e.File.InputStream.Position = 0;
            fileBytes = new byte[e.File.InputStream.Length];
            for (int totalBytesCopied = 0; totalBytesCopied < e.File.InputStream.Length; )
                totalBytesCopied += e.File.InputStream.Read(fileBytes, totalBytesCopied, Convert.ToInt32(e.File.InputStream.Length) - totalBytesCopied); //conversao para bytes
        }

//Ascx reference

<telerik:RadAsyncUpload ID="RadAsyncUpload1" runat="server" AllowedFileExtensions="xlsx,xlsm,xls,txt,pdf" EditFormColumnIndex="1" MultipleFileSelection="Disabled"  RenderMode="Lightweight" TargetFolder=""  OnFileUploaded="RadAsyncUpload1_FileUploaded" UploadedFilesRendering="BelowFileInput" >
                                        </telerik:RadAsyncUpload>
                                        <br />
                                        <span class="allowed-attachments">Formatos permitidos: <span class="allowed-attachments-list">pdf,xlsx,xlsm,xls,txt</span></span> &nbsp; </td>

 

[Harlem98]

EDIT: The error was resolved adding the use of "fileStream.Close();", nevertheless, now the file is saving as null, saving only the file name, and only allows 1 operations, disapeering on the second one.

I created a target folder. dofferent from the temporary folder. Being the file name saved, i suppose my logic shoyld be close to be right.  

//partial class declarations
(...)
        string Ficheiro = string.Empty;
        string FileTipo = string.Empty;
       byte[] fileBytes = null;
(...)
//DataBase save method
public void SaveFile(object sender, EventArgs e)
        {
            ListagemTimesheet model = new ListagemTimesheet();
           
            model.IDRecursoHumano = Convert.ToInt32(rdpInvestigadorE.Text);
            model.IDEstadoTimesheet = Convert.ToInt32(rcbEstado.SelectedValue);
            model.Observações = Obervaçoestxt.Text;
            model.AssinaturaTimesheet = txtAssinaturaTimesheet.Text;
            model.DataEnvio = DataEnvio.SelectedDate.Value;

            if (Objecto.ID > 0)
            {
                model.ID = Convert.ToInt32(FileID.Text);

                if (!string.IsNullOrEmpty(Ficheiro) && FileTipo != null)
                {

                    model.Ficheiro = Path.GetFileNameWithoutExtension(Ficheiro); //FileName
                    model.FileTipo = Path.GetExtension(FileTipo); //FileExtension
                    model.FileContent = fileBytes; //Content
                }

                if (!string.IsNullOrEmpty(FileID.Text) && Convert.ToInt32(FileID.Text) > 0)
                {
                    model.ID = Convert.ToInt32(FileID.Text);
                    listagembll.UpdateFile(model);

                }
                else
                {
 
                }
            }

//Code-behind
protected void Page_Load(object sender, EventArgs e)
        {
            RadAsyncUpload1.TargetFolder = Server.MapPath("~/TargetFiles");
        }

public void RadAsyncUpload1_FileUploaded(object sender, FileUploadedEventArgs e)
        {
            RadAsyncUpload1.Visible = false;
            Stream fileStream = e.File.InputStream;
            Ficheiro = e.File.FileName; // sintaxe metodo
            FileTipo = e.File.ContentType;
            e.IsValid = true;
            byte[] fileBytes = new byte[fileStream.Length - 1 + 1];
            fileStream.Read(fileBytes, 0, System.Convert.ToInt32(fileStream.Length));
            fileStream.Close();
        }
//FrontEnd
<telerik:RadAsyncUpload ID="RadAsyncUpload1" runat="server" AllowedFileExtensions="xlsx,xlsm,xls,txt,pdf" MultipleFileSelection="Disabled"  OverwriteExistingFiles="true" OnFileUploaded="RadAsyncUpload1_FileUploaded" UploadedFilesRendering="BelowFileInput" Culture="pt-PT" TemporaryFileExpiration="00:30:00" ToolTip="Anexar ficheiro"></telerik:RadAsyncUpload><span class="allowed-attachments">Formatos permitidos: <span class="allowed-attachments-list">pdf,xlsx,xlsm,xls,txt</span></span>&nbsp;</td>
                                        
                                          

[Peter Milchev]

Hello Rúben,

You can check the following resources related to the access of the temporary files:

• https://docs.telerik.com/devtools/aspnet-ajax/knowledge-base/asyncupload-access-temporary-file 
• https://docs.telerik.com/devtools/aspnet-ajax/controls/asyncupload/how-to/how-to-manipulate-the-uploaded-files 
• https://docs.telerik.com/devtools/aspnet-ajax/knowledge-base/upload-uploadedfiles-saveas-throws-filenotfound-error-with-custom-handler 

This should help you access the file itself, save it in the database, and if you do not set a Target folder, the file will be automatically removed from the Temporary folder.

If the file is still used by another process, you can check which process is locking it as there is a chance a Firewall or an Antivirus software can quarantine the files in the Temp folder.

Regards,
Peter Milchev
Progress Telerik

[Harlem98]

Hello Peter.

I try to use a similar approach to the Demo made with OleDB, with input stream, assigning the filebytes property. Nevertheless, i get null value in the DB.

What is missing me? I'm using TargetFolder, and it is successfully getting FileName.

public void RadAsyncUpload1_FileUploaded(object sender, FileUploadedEventArgs e)
        {
            RadAsyncUpload1.Visible = false;
            Stream fileStream = e.File.InputStream;
            Ficheiro = e.File.FileName; // sintaxe metodo
            FileTipo = e.File.ContentType;
            e.IsValid = true;
            byte[] fileBytes = new byte[fileStream.Length - 1 + 1];
            fileStream.Read(fileBytes, 0, System.Convert.ToInt32(fileStream.Length));
            fileStream.Close();
        }

//save method, triggered by save button after upload is made
(...)
model.FileContent = fileBytes; //Saves Null

[Harlem98]

Partially resolved it! Hope this turns usefull. I was missing to copy the bytes to the variable. i'm still with problems nevertheless

public void RadAsyncUpload1_FileUploaded(object sender, FileUploadedEventArgs e)
        {
 

                RadAsyncUpload1.Visible = false; //false
                var liItem = new HtmlGenericControl("li");
                Ficheiro = e.File.FileName; // sintaxe metodo
                FileTipo = e.File.ContentType;
                e.IsValid = true;
                e.File.InputStream.Position = 0;
                fileBytes = new byte[e.File.InputStream.Length];
                for (int totalBytesCopied = 0; totalBytesCopied < e.File.InputStream.Length; )
                    totalBytesCopied += e.File.InputStream.Read(fileBytes, totalBytesCopied, Convert.ToInt32(e.File.InputStream.Length) - totalBytesCopied); //conversao para bytes
                e.File.InputStream.Close();
        }

//Save
(...)
 model.FileContent = fileBytes;

I can only save file if DB register is empty. How to add the possibility of replacing the file to my code? When i try to edit a file, it still throws the same ""The process cannot access the file because it is being used by another process.". Or it is not allowed?

And another problem is that i am using the RadAsyncUpload on a window, so i can only perform one operation until a complete page reload. Is it possible to use a partial postback in the window?

[Peter Milchev]

If you manage to get the uploaded file as a byte array, I believe there is nothing related to the AsyncUpload anymore because you have a copy of that file. With that said, probably the error is related to the DB itself? 

It is possible to see this error if you try to modify the e.File.InputStream instead of updating the database.

[Harlem98]

I managed to bounce off the issue by not binding the file to edit form. Displaying the item as empty in the form, allows me to update a new file normally. Not the ideal scenario but allows me to persuit.

I'm having other problems using this implementation along RadWindow, as well so it could be something wrong in my code or it is not possible to display the file value in edit form?

[Peter Milchev]

It depends on your whole setup, there might be some configuration issues.

You can also try the built-in capabilities of the Grid with popup editor and GridAttachment column instead of implementing it all from scratch.

As for the AsyncUpload, you can have the file only when selecting the file, then, once it is uploaded, you can access it on the server before it is moved to the Target folder. Once that is done, the AsyncUpload cannot access the files anymore and you need custom code to load a file from the DB.

Another thing you might see as an issue is that the file is processed on the first postback, so if your other editors do postback, that would result in a file loss. You can check this article how to overcome this behavior: https://docs.telerik.com/devtools/aspnet-ajax/controls/asyncupload/how-to/how-to-persist-uploaded-files