UploadFileMaintenance GetFile always returns null

Question

Hello,

I’m trying to get file info from the UploadFileMaintenance graph using the code below.
Unfortunately, the GetFile and GetFileWithNoData methods always returns null for me and I cannot understand why, and I’m out of ideas of try.
I’ve added comments to the code to explain what I believe is happening. Can anyone explain what I’m doing wrong please?

//create the CABatchEntry graph, find the batch I'm interested in and set the graphs 'current' record to the record I've found.
CABatchEntry graph = PXGraph.CreateInstance<CABatchEntry>();
PXResultset<CABatch> pXResults = SelectFrom<CABatch>.Where<CABatch.batchNbr.IsEqual<@P.AsString>>.View.Select(new PXGraph(), batchID);
graph.Document.Current = (CABatch)pXResults.TopFirst;

//create the UploadFileMaintenance graph
var fileUploadGraph = PXGraph.CreateInstance<UploadFileMaintenance>();
//get a list of all FileIDs for the current record
var savedFilesIDs = PXNoteAttribute.GetFileNotes(graph.Document.Cache, graph.Document.Current);

//things appear to be working well at this point I have a 35 guids to loop through
foreach (Guid fileID in savedFilesIDs)
{
    //the following 2 lines always returns null
	var savedFileInfo = fileUploadGraph.GetFileWithNoData(fileID);
    var savedFileInfo1 = fileUploadGraph.GetFile(fileID);
	if (savedFileInfo != null) 
	{
		fileUploadGraph.Files.AllowDelete = true;
		fileUploadGraph.Files.Delete(fileUploadGraph.Files.Current);
		fileUploadGraph.Persist();
	}

}

Thanks

icon

Best answer by davidnavasardyan09 28 June 2023, 05:37

View original

davidnavasardyan09 · Accepted Answer

Hi @stephenward03This is quite unusual. The GetFile and GetFileWithNoData methods are designed to retrieve the file info based on the provided fileID. If the fileID exists in the database, as you've mentioned, these methods should not return null.One possible issue could be that these methods are running in a different context and may not have access to the same database session where the fileID is valid. However, this would be quite uncommon and it's more likely that there's another issue at hand.Here are a few things to check:Data Availability: Double-check that the fileID is in fact present in the UploadFileRevision table in the database.Graph Initialisation: The UploadFileMaintenance graph is typically not used programmatically. Instead, the PX.SM.FileInfo object and PXNoteAttribute are used to handle file-related operations. You could use the static method PXNoteAttribute.GetFileNotes to fetch file notes, and then retrieve file info using PX.SM.FileInfo. It's not clear from your example why you need UploadFileMaintenance graph, so consider if it's possible to use these more common approaches instead.Access Rights: Ensure that the user under which the code is running has the necessary access rights to fetch file info.Refresh the FileUploadGraph instance: You may want to try to refresh the UploadFileMaintenance graph instance for each iteration, although it's not an ideal solution performance-wise.If none of the above works, I suggest you open a support case with Acumatica. It seems that you've encountered a somewhat peculiar issue that might require more in-depth troubleshooting. It would be helpful if you could provide any additional details about the context in which this code is running, such as if it's part of a customization project, running in a scheduled process, etc.

darylbowman · Answer

I can’t really see anything wrong with your code. I’ve used similar code before:

var files = PXNoteAttribute.GetFileNotes(cache, row);
var upload = PXGraph.CreateInstance<UploadFileMaintenance>();

foreach (Guid fileID in files)
{
	FileInfo fileInfo = upload.GetFile(fileID);
	if (fileInfo != null && !string.IsNullOrEmpty(fileInfo.Name))
	{
		using (MemoryStream stream = new MemoryStream(fileInfo.BinData))
		{
			// do stuff
		}
		break;
	}
}

UploadFileMaintenance GetFile always returns null

3 replies

Reply

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded