Hi All,
Wondering if anyone has seen the following set of symptoms before, or even if not any suggestions as to how best to resolve such a problem....
As a result of UI customisations only (no code development), client has a Dynamics implementation with a custom entity which has a lookup relationship with the Account entity. Client has loaded 25000 documents into SharePoint folders based on a tested procedure which automatically created SP folders under the Account SP folders - i.e. Account library/Specific account/custom entity/Specific custom entity record/multi-level folder structure for custom record. This took more than an elapsed week of intermittent effort, basically 100 times approximately 250 records per custom entity record, say.
From Document location records it can be shown that this worked Ok for a while, but unfortunately at some point early on in the week, Dynamics stopped creating the above folder hierarchy automatically, and from that point on automatically created folders in the custom entity's library only, i.e. Custom entity library/Specific custom entity record/multi-level folder structure for custom record.
It is worth noting that automatic folder creation for the Opportunity entity still works as expected.
The client performing the bulk folder uploads that created the multi-level folder structure did not notice the change of behaviour, and now has 25000 documents in the wrong SP library and now cannot see the custom entity's documents through the account records as was required.
And SharePoint Online by design does not support copying or moving such a large number of documents around between libraries, so we are looking for solutions there in order to relocate the documents manually.
Just as an aside using File Explorer view took 7 hours to copy 1.25 GB of documents (only about 400 in number) between these two libraries, and SPFileZilla refused to do the copy because the SharePoint List View threshold (5000 entries in list max) was exceeded when requesting the copy of the 400 documents - I assume that it (and indeed SP Online) is objecting to having to search the whole source library of 25000 documents just to find the 400 to copy at one time.
I have found no way to date of reversing this change of Dynamics behaviour, including creating a brand new SharePoint site and recreating the Dynamics - SP integration with automatic folder creation under the Account entity. My conclusion here is that a setting actually within the custom entity itself is now preventing the custom entity from behaving as the other system entities related to Account behave.
I have no theories and am aware of no evidence that might explain the change of behaviour, so am open to all suggestions from those with deep experience in this area of Dynamics!!
PS we have another instance of Dynamics running for which the automation is still working as expected for the custom entity, but unfortunately the client's customer, contact, quotation, product, price lists, inventory and custom entity data as well as the 25000 documents are not loaded into that instance.....
Thanks in advance for any ideas!
Regards,
Mike
*This post is locked for comments