Highlighted
Absent Member.
Absent Member.
1868 views

Error accessing offline records - Excel Spreadsheets - TRIM 7.1.2.2017 & Win 7/Office 2010

Hi,

 

We are experencing issues in saving Excel Spreadsheets due to an HP TRIM error that keeps popping up. It is an intermittent issue and we cannot replicate it through testing.

 

Our staff may have a spreadsheet open, click Save As within Excel and then they recieve an error message - An error Occured accessing Offline Records. Document not saved.


Once this error pops up, if you click ok it just returns to the spreadsheet and there is no other way to save it. sometimes you can copy the data into a new blacnk workbook and it may save but it seems that we have to just ditch the spreadsheets and get our clients to start their work again.

 

Details of our set up:

  •  Integration is on for MS app's
  •  TRIM 7.1.2.2017
  •  Win 7 package with Office 2010
  • Offline records folders are within the drive as required
  • Standard spreadsheet (no major macro's ro is it s a compound doc)

 

Error message attached. Any info on this or how we could fix it would be great.

 

We have uninstalled and reinstalled TRIM which seems to fix it but an easier work around would help.

 

Thanks,


Holly

0 Likes
4 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

You said "Offline records folders are within the drive as required". Does that mean they are on the local disk drive? Have you redirected offline records to a mapped drive (usually as part of roaming profiles)? That's the usual culprit.
---------
Erik
Highlighted
Micro Focus Expert
Micro Focus Expert

You might be able to recreate the offline records repository:

These are the steps you should follow:

 

http://support.openview.hp.com/selfsolve/document/KM00288910

 

 

**Any opinions expressed in this forum are my own personal opinion and should not be interpreted as an official statement on behalf of Micro Focus**
0 Likes
Highlighted
Absent Member.
Absent Member.

Hey,

 

Offline records is redirected to follow us as part fo our roaming profiles. Is this part of the problem as it sometimes may not map to the drive/offline folder correctly on log in?

 

It is only happening with excel though. No cases of any of MS app being effected.

 

Thanks,


Holly

0 Likes
Highlighted
Micro Focus Expert
Micro Focus Expert


HollyBee wrote:

"...Offline records is redirected to follow us as part fo our roaming profiles. Is this part of the problem as it sometimes may not map to the drive/offline folder correctly on log in?..."

Absolutely. We've seen all sorts of errors occurring when the connection to the offline records documents folder or offline records database file is either very slow or generally flaky. I've also seen a range of errors when the roaming profiles fail to download correctly to the PC during login. There have been some enhancements to the check in/check out process in later TRIM/HPRM releases to improve TRIM's error handling in such situations, but as long as organisations configure their environments such that TRIM is trying to read from/write to a problematic network location, errors will continue.

 

In your case there may be some other issue with your Excel documents that's exacerbating or masking such issues. There have been some problems over the years with various confused versions/extensions for Excel spreadsheets, e.g. Excel documents being saved into TRIM as the wrong format or with the wrong file extension due to issues with the default save format in Excel vs the format the user chooses during Save As, or installed office compatibility packs causing similar format issues. You may benefit from having a closer look at the Excel documents the users are trying to save when the errors happen and seeing if you can find anything strange about them. Perhaps it's an Excel error that's causing TRIM to report its inability to save the document.

Neil

Note: Any posts I make on this forum are my own personal opinion, and unless stated otherwise do not constitute a formal commitment on behalf of Micro Focus.

(Please state the version of CM you're using in all posts.)

MySupport: https://softwaresupport.softwaregrp.com/

If you find this post useful, please use the and/or buttons below.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.