EDM attachment very slow when locking a documnet attached to invoice in App 10 Aurena

Sorry that it has taken so long to respond to this, but we have been in the middle of a UPD deployment and investigating an Oracle upgrade. I had the end-user run the “Document Object Connection” with the Chrome DevTools running. I believe I have captured the appropriate data for diagnosing this, just don’t know what part of it to post. I am also worried that it might contain proprietary or confidential information.  Here is a screenshot showing the process that took the longest (almost a minute). To be clear, this process works well in IEE, but very slow in Aurena.

I also captured all of the DevTools output to a HAR file, but that has tons of text to it.

here is the line referenced with the long time factor (redacted for security):

 "url": "https://server.domain.site.tld:99999/main/ifsapplications/projection/v1/DocumentHome.svc/GetOCTResultCount(LuName='ManSuppInvoice',KeyRef='COMPANY%3Dcomp%5EINVOICE_ID%zzzzzzzzzz')",

Please let me know if more details are required and how to capture them.

Best regards,

Bob
 

Sorry that it has taken so long to respond to this, but we have been in the middle of a UPD deployment and investigating an Oracle upgrade. I had the end-user run the “Document Object Connection” with the Chrome DevTools running. I believe I have captured the appropriate data for diagnosing this, just don’t know what part of it to post. I am also worried that it might contain proprietary or confidential information.  Here is a screenshot showing the process that took the longest (almost a minute). To be clear, this process works well in IEE, but very slow in Aurena.

 

 

I also captured all of the DevTools output to a HAR file, but that has tons of text to it.

here is the line referenced with the long time factor (redacted for security):

 

 "url": "https://server.domain.site.tld:99999/main/ifsapplications/projection/v1/DocumentHome.svc/GetOCTResultCount(LuName='ManSuppInvoice',KeyRef='COMPANY%3Dcomp%5EINVOICE_ID%zzzzzzzzzz')",

 

The screenshot is quite clear, just getting the count of attachments is taking a very long time. It happens for some customers and there can be different reasons for it:

- "Many" document - object connections in the database (millions possibly)
- "Many" Object Connection Transformation rules or badly written Object Connection Transformation rules
- Bugs
I think the best way to get help with this is to file a support case, such that someone can take a more detailed look at your environment.
 

@woprhowe 

100K documents is quite a lot, but we have customers that has 10 times that, even 100 times that. Not on Aurena in Apps 10 though, which, since it's our first "big" release on the new platform, is much less optimized than the later versions of IFS Cloud.

Do you happen to make heavy use of the Restricted Access for feature on documents? And, when are you upgrading to IFS Cloud 🙂?

> Within Document Management, we are using “Access Templates” and “Person Groups” that do essentially restrict access to documents based on document class, is this what you mean by “heavy use of Restricted Access”?

No, that's completely normal 🙂 On the document revision, and the document title, there is a flag/setting named Restricted Access. It essentially makes the record invisible and not listed in any screen or LOV, unless you have at least View access. It's a useful feature for very sensitive documents where those who don't have access should not even know the document exists (it's NOT about viewing the uploaded file). The feature makes some searches much slower though, so our view is that it needs to be used with care, and it’s in particular a problem if you have many documents since the access checks needs to be run for all documents that you would normally get a hit on when searching..