topic Attachments added to related table in FGDB -> gets corrupt? in Geodatabase Questions

Attachments added to related table in FGDB -> gets corrupt?

Anonymous User — Tue, 07 Apr 2020 08:07:42 GMT

Hi there,

I created a File Geodatabase with some feature classes, a table which is related tot these feature classes, and an attachment table added to the related table.

Looks like this:

However, when I add some records including attachments to the related table (using FME), and view the data in ArcMap, after some time (about 0,5 to 3 hours) the related table seems to get corrupt.

In ArcMap I get this message when I try to open the table:

And when I try to read the data from the table in FME, no records are imported.

The feature classes and attachments table however stay up and running.

Now we have a lot of strange IT-issues in our organisation affecting the performance of GIS.

So I am not sure:

Is this setup of the FGDB too complicated, so it migth be expected to get corrupt? Or should this work properly?

And in the latter case, does anyone possibly have clou what might be the problem?

Re: Attachments added to related table in FGDB -> gets corrupt?

George_Thompson — Tue, 07 Apr 2020 10:53:49 GMT

Those type of errors seem to correlate to network issues.

When you get that error message, noted above, can you access "Feature Class 1" or any other feature class in the fGDB?

What if you bring the fGDB locally and do all the edits and then copy to the network?

Re: Attachments added to related table in FGDB -> gets corrupt?

Anonymous User — Tue, 07 Apr 2020 12:58:40 GMT

Thanks for your quick response George!

When you get that error message, noted above, can you access "Feature Class 1" or any other feature class in the fGDB?

It is indeed possible to access "Feature Class 1" or "Attachments", the error message only appears when I try to open the attribute table of "Related table".

What if you bring the fGDB locally and do all the edits and then copy to the network?

As far as I know, we only have network directories in our organisation, so i think i can't bring it locally unfortunately.

What kind of network issues could cause this error?

Re: Attachments added to related table in FGDB -> gets corrupt?

George_Thompson — Tue, 07 Apr 2020 13:01:01 GMT

odd that it seems to only impact the related tables. In terms of networks issues I have seen it all. There may be a network timeout, virus scan, etc.

Is all of this being done in an edit session for the entire time?

How often are the edits being saved?

Re: Attachments added to related table in FGDB -> gets corrupt?

Anonymous User — Tue, 07 Apr 2020 14:06:15 GMT

Indeed!

The edit sessions are relatively short: in FME it takes some seconds and changes I make in arcmap take a minute at most.

The edit session is already closed for minutes/hours before the table gets this error.

Re: Attachments added to related table in FGDB -> gets corrupt?

George_Thompson — Tue, 07 Apr 2020 14:10:16 GMT

Ok, that is good to know about the edit session. I am not sure why the tables are corrupting, you may want to work with Esri Technical Support on this.

Can you reproduce this easily (besides the time waiting)?

Re: Attachments added to related table in FGDB -> gets corrupt?

Anonymous User — Tue, 07 Apr 2020 14:23:20 GMT

Thank you for your input!

Before sending it to our ICT support organisation, I would be sure if this is no common issue .

The issue is relatively easy reproducable, so I think I have enough input for them/Esri Support.

Re: Attachments added to related table in FGDB -> gets corrupt?

George_Thompson — Tue, 07 Apr 2020 14:26:54 GMT

I am not sure that is "common". I will say that working with fGDB's over a network can sometime introduce odd behavior. That is why I asked about storing the fGDB locally first and seeing if it is reproducible, which is what support will do and test it locally.

Re: Attachments added to related table in FGDB -> gets corrupt?

Anonymous User — Thu, 23 Apr 2020 06:18:32 GMT

The issue turned out to be caused by an installation of Sophos antivirus software

Re: Attachments added to related table in FGDB -> gets corrupt?

George_Thompson — Thu, 23 Apr 2020 10:37:02 GMT

Thanks for the update, glad to see a resolution.

I know that antivirus like to do a LOT of nasty things to our software and creates quite some interesting circumstances.