Sage 200 BI - 'BI admin utility has stopped working' message appears when loading the Sage 200 Business Intelligence Admin Utility
Description

Internal only: *** Do not amend this article via KCS ***

When attempting to open the Sage 200 Business Intelligence Admin Utility, an error message may appear stating 'Sage200BIAdminUtility has stopped working', at which point it is not possible to carry on using the utility in that session.

Cause
Resolution

Refer to the following points, making any changes where necessary and then attempt to run the BI Admin Utility again.

This issue most often occurs when the log.txt file has a status of read-only. The log file is located in the following folder - C:\users\\Documents. Right-click on the file and choose Properties. If the read-only checkbox is selected, clear the option, select OK then try running the utility again. If the utility still fails to load without the error, check the points below.

  • Open Windows Explorer. Rename the log file in the location above then retry accessing the Sage 200 Business Intelligence Admin Utility. If the error still appears, check Windows Explorer to see if a new log file was created. If not, this means that the current user does not have access rights to the relevant folders and you should check that their profile is set up correctly.
  • Rename the BISettings.xml file in (C:\Sage\Databases) and retry accessing the Sage 200 Business Intelligence Admin Utility. Again, if the error appears, you should check to see if a new log was created, then checking their access rights if not.
  • Ensure the user has access to the relevant company in System Administration.
  • Check that the user has dbcreator and sysadmin level permissions in Microsoft SQL Server Management Studio. If you are not familiar with how to check this, please contact your database administrator.
  • Ensure the same user exists in SQL Analysis Services security properties. If you are not familiar with how to check this, please contact your database administrator.
  • Clear the temp files from the PC. To do this, go to the Start Menu and in the Search field at the bottom, type %temp% and press Enter. Delete all files that are displayed.
  • Try to run the utility whilst logged on to the PC as a different Windows user. You should also try a domain admin and a local admin to help indicate if the issue is specific to an individual user.
  • Restart the server.
  • Sage 200 Extra and above only: Ensure the user is a member of the Sage 200 Administrators group.

If the above steps do not resolve the problem, we would recommend uninstalling and reinstalling the software on the PC. If the issue is still not resolved at this point, please contact Sage 200 Technical Support.

 


Sage Business Partners can now log new cases online!

If you're unable to find the help you require from our online resources, log a new case with us without having to use phone or email. Simply select 'Manage your cases' from the dashboard or visit my.sage.co.uk/cases.

Steps to duplicate
Related Solutions