Attachment error

Epicor ERP 10
,
41

Same situation here which is really lame… just started happening around the time you put this post up. We have 10k+ attachments on two tables. Epicor doesn’t have a good workaround… best they came up with was to create a new sharepoint site every time you reach the max which kinda defeats the purpose of putting the docs in sharepoint in the first place for us.

Still not sure what we are going to do. For the time being I made another document type for the two tables that reached the max which uses a networked file share instead.

42

BTW, “classic” Document Libraries have the 5000 limit but the Modern Document Library is higher. Nonetheless, SharePoint was certainly not designed to be a dumping ground…

43

@Mike @sschuettenberg ended up writing customization to manage the the files in subfolder. Epicor uses standard MS sharepoint dll.

for instance, attachments to apinvoice is like

company/apinvhed/{jan2021}/attachedfile

{jan2021} is the period when the file is attached.

thanks everyone for the insights.

44

@Mike we didnt create site. we instead renamed the “APInvHed” folder in sharepoint as “APInvHed2” and updated the filepath reference on table xfileref from “APInvHed” to “APinvHed2” via a updatable dashboard. works fine.

45

This is what we tried to do with no success. Can you share the customization you did for this?

Thank you!

46

@Mike sorry, due to SLA , couldn’t post here.
at high level,

  1. in data directive > xfileref > intransaction > check for new row/storage is sharepoint
  2. check the subfolder({Jan2021}) exist in the parent folder in sharepoint library
    2.1 if doesnt exit, create it using c# csom
  3. move the file from apinhed to {Jan2021} programmatically using c# csom
    same process when a file is deleted. dm me for any further assistance.
47

Not sure if this got posted elsewhere but the 5000 limit is resolved in 2021.1.3 when adding, deleting, etc.

3 Likes