Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it! Learn more

  • State Suggested Answer
  • Replies replies
    6
  • Answers answer
    1
  • Subscribers subscribers
    25
  • Views views
    964
  • Users 0 members are here
Related
Options

Excel Spreadsheets

Lauren Taylor

Hello,

Last year we upgraded to Content Manager 10.1 [patch 1] and we are intermittently having issues with opening & saving spreadsheets.

What appears to be happening is the user opens the spreadsheet it immediately closes the edit function when you highlight a cell to amend, the audit trail shows it as "Document Checked In (Undo Checkout), rather than saving an edited revision.

This is affecting users at random; we're not sure why.

We are unable to perform a patch at present.

We also received outside advice about closing CM, going into the users C:/ and re-naming the MicroFocus folder so that a new folder appears with new connections when CM is opened again. This has worked for the other company that gave us advice, but hasn't worked for ourselves.

Any advice/help much appreciated, please!

  • Suggested Answer

    0

    Have you tried enabling TRIMWatcher logging to diagnose?. It might assist identifying what's happening in the background during the checkout and edit process?. The following post discusses how to enable TRIMWatcher logging via user registry > community.microfocus.com/.../146896

  • 0 in reply to 

    I read the linked thread, but I don't understand how to turn TRIMWatcher on for another user?

  • 0   in reply to 

    Lauren,

    you would have to remote assist the user and enable the TRIMwatcher logging on their Client machine.

    I have a question, does it occur on specific spreadsheets or just for specific people?

  • 0 in reply to   

    It's affecting specific user accounts and it tends to be the flexi-sheets for their hours.

  • 0 in reply to 

    We are on 10.1 patch 3 and are also have issues with Excel, if checked out and then you log off for example to completely close the records watcher and log back in, when viewed in Offline Record window it shows as a draft and is no longer associated with the orignal record in TRIM. See below line from the watcher logs using client logging.

    WTCHR: offlineDatabase::removeDocuments() - failed Could not delete the file 'C:\%username%\Offline Records (ED)\Test - INFORMATION MANAGEMENT - EVALUATION'. Access denied. Attempt to determine file handle ownership failed with: The Windows API function RmGetList failed. Access is denied. (0x00000005).

  • 0 in reply to 

    Bumping this as we're getting the same errors coming up since upgrading to 10.1.3 in April.

    We initially thought it was caused by Microsoft Defender because the errors coincided with risky actions blocked in Windows Security. An exception for TRIM.exe and TRIMWatcher.exe seemed to fix it but, since testing with the 10.1.5 client in the past few days, we're now seeing it again. 

    The Excel integration log also reports an error at the same time:

    2024-05-29 14:17:37:693 1 00:00:00:0000000 Error Error thrown Exception has been thrown by the target of an invocation. 

    Event Viewer reports an Application error for TRIM.exe and tsjTrim.dll

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.