We are having some issues with embedded invoices taking an extremely long time to open up. The invoice is in the N350 NOTES panel. Sometimes they open quickly and sometimes hang up for an extremely long time.
If you have an explanation please let us know. User is having the same issue with the majority of the invoices she does CPA’s for.
Thanks
Hello,
I tried to access the Ole from the Notes tab on the CPA and I got the following message:
"Previous Object Owner Detected The Object [123456789012] has been previously locked for update by [userID]"
I Examined the lock and then had to forcibly override it, I did notice that it took approximately a minute and a half to open. The embedded OLE doc is over 5 MB so it would be expected that it would take longer than usual, but almost 2 minutes is a long time to wait. I also remember something from a long time ago (when prior analyst was in charge of the Contracts module) about this lock having to be cleared by the technical team.
I was talking to another analyst and she mentioned that you helped last time with a similar issue - do you recall what you may have done to fix this?
Any help you can provide would be great!
Thanks,
Hi,
Asset Suite is taking care of the OLE locking using TIDOBLOK.Ole_Object_Status. It would appear user somehow ungracefully left Asset Suite and left a lock on the OLE. Your forcing the lock should be OK. It could also be removed via SQL.
This particular OLE is 5.6MB. It is an OLE containing a Word Doc containing an email that contains 3 Adobe pdf files. The 3 pdf files are 3MB, 1.2MB, and 1.2MB. Asset Suite uses a compression algorithm known as Lempel-Ziv-Welch which is unable to substantially compress the OLE so it doesn't attempt it. The OLE is stored as 1422 rows of 4000KB each. What this all means is that retrieval is slow.
Suggested method of speeding things up is:
Use Adobe Acrobat to edit the files and use: File, "Reduce File Size" to reduce the file size and then replace the files in the MS Word document. Experimented using Adobe Acrobat 7 on one of the files and reduced the size to 15% of the original.
Note 1: Portal/J 10.0.7 (HTTP instead of TCP) responds much faster with large OLEs.
Note 2: Experiment was done of removing the email layer of the OLE by putting the pdf files directly in the Word Doc. This did n0t make a difference to file size nor retrieval time.
Note 3: Windows Zip was attempted on individual pdf files and size reduction was minimal.
OLE containing MS Word containing Adobe pdf files
We are having some issues with embedded invoices taking an extremely long time to open up. The invoice is in the N350 NOTES panel. Sometimes they open quickly and sometimes hang up for an extremely long time.
If you have an explanation please let us know. User is having the same issue with the majority of the invoices she does CPA’s for.
Thanks
Hello,
I tried to access the Ole from the Notes tab on the CPA and I got the following message:
"Previous Object Owner Detected The Object [123456789012] has been previously locked for update by [userID]"
I Examined the lock and then had to forcibly override it, I did notice that it took approximately a minute and a half to open. The embedded OLE doc is over 5 MB so it would be expected that it would take longer than usual, but almost 2 minutes is a long time to wait. I also remember something from a long time ago (when prior analyst was in charge of the Contracts module) about this lock having to be cleared by the technical team.
I was talking to another analyst and she mentioned that you helped last time with a similar issue - do you recall what you may have done to fix this?
Any help you can provide would be great!
Thanks,
Hi,
Asset Suite is taking care of the OLE locking using TIDOBLOK.Ole_Object_Status. It would appear user somehow ungracefully left Asset Suite and left a lock on the OLE. Your forcing the lock should be OK. It could also be removed via SQL.
This particular OLE is 5.6MB. It is an OLE containing a Word Doc containing an email that contains 3 Adobe pdf files. The 3 pdf files are 3MB, 1.2MB, and 1.2MB. Asset Suite uses a compression algorithm known as Lempel-Ziv-Welch which is unable to substantially compress the OLE so it doesn't attempt it. The OLE is stored as 1422 rows of 4000KB each. What this all means is that retrieval is slow.
Suggested method of speeding things up is:
Use Adobe Acrobat to edit the files and use: File, "Reduce File Size" to reduce the file size and then replace the files in the MS Word document. Experimented using Adobe Acrobat 7 on one of the files and reduced the size to 15% of the original.
Note 1: Portal/J 10.0.7 (HTTP instead of TCP) responds much faster with large OLEs.
Note 2: Experiment was done of removing the email layer of the OLE by putting the pdf files directly in the Word Doc. This did n0t make a difference to file size nor retrieval time.
Note 3: Windows Zip was attempted on individual pdf files and size reduction was minimal.