cancel
Showing results for 
Search instead for 
Did you mean: 

AO randomly crashing

0 Kudos

We have AO 1.4.7 SP01. After working continuously in a workbook for more than 30 minutes, users are reporting random crashes and AO must be restarted. Has anyone else had this issue?

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Hi Cathy Moore,


To find the root cause of the situation is better to record a log file and show the exactly point of the error message.

Usually this kind of session time out is related with net connection or backend configuration. Please check the session timeout of the backend.


Kind regards,
Diego Ferrary

Derek_Fox
Contributor
0 Kudos

Hi Cathy

AO 1.4 SP9 is available and you can refer to the SAP Service Marketplace for OSS Notes 1910505 for SP8 release notes and 1910506 for SP9 release notes which describe which issues are corrected by SAP.

We have seen AO crashing occurring on an infrequent basis, the average is about one a month reported to our support desk. We have investigated this and it seems to be an Excel related issue (although now and again it may also be an AO issue which SAP has to fix), therefore we implemented some best practices which seems to minimize the crashing of AO:

  1. Install the latest Support Packages/Patches available with fixes for AO- recommended by SAP
  2. If using Office 2013, deactivate the Start Screen (Excel > File > Options and deselect the option "Show the Start Screen when the application starts") this improves the start up time of Excel
  3. Run only one Excel session at a time
  4. Close Excel every 1-2 hours as Excel does not seem to release all memory when workbooks are closed, ultimately a crash will occur
  5. Or if you are doing a lot of editing or creating a lot of charts, close Excel every hour
  6. Deactivate all non-essential Excel add-ins
  7. Uninstall Google Desktop Search if installed - this is a memory hog and has been reported to interfere with Excel
  8. Minimize the use of conditional formats as much as possible.


I'll admit that the list above is not complete or ideal, however we have found it to minimize the crashing of AO in our environment.

Also if you are using the 32-bit version of Excel, there is a memory limit of 1.7Gb RAM for Excel 32-bit (limitation of the .NET framework) so if you have large workbooks then the memory limit is reached very quickly and which may cause Excel to crash. An option is to may be consider the 64-bit version of Excel?

Regards

Derek

0 Kudos

We are using Office 2010 and I do not see #2 as an option.

TammyPowlas
Active Contributor
0 Kudos

Hi Cathy,

Could you upgrade to SP8?

I haven't heard of this issue

0 Kudos

We just recently moved to SP7, not ready forSP8 yet.