BusinessQuery Add-in for Excel

other Business Query
1

Hello All,

I am having difficulty with the BusinessQuery Add-in for Excel. When I attempt to Load the add-in from the Business Query menu in excel, Excel crashes - giving a cryptic message about being unable to write to some memory address etc. etc.

Has anyone seen this fault and managed to find a fix?

The platform in question is:

  • Windows NT 4.0 sp 4
  • Excel '97 SR1
  • Business Objects 4.12

TIA,
Justin

Listserv Archives (BOB member since 2002-06-25)

2

I guess this is the service pack 4 problem that had been mentioned on this list previously.

CONFIGURATION*
Windows NT 4.0 service pack 4
BusinessQuery 4.1.x

WARNING**
This resolution involves making a modification to the registry. Incorrect
registry editing can cause unpredictable results. Please ensure that you
know how to restore it if a problem occurs by understanding the restore concepts in the registry editor online help. Please make note of the changes
you make to the registry and inform technical support of these changes in
any future contact.

****SYMPTOMS
When you load BusinessQuery in Excel, you get the following error:

An application error has occurred
and an application error log is being generated
EXCEL.EXE
Exception Access Violation

CAUSE****
This error occurs due to an incompatibility between BusinessQuery and Service Pack 4 of Windows NT 4.0. (This is a Microsoft problem).

****RESOLUTION
The resolution requires a change in your NT registry provided by Microsoft
support:

  1. Close the application.
    HKEY_LOCAL_MACHINE\ Software\Microsoft\Windows NT\CurrentVersion\Image File Execution Options 4. Select Edit > Add Key.
  2. Type in Excel.exe or the exact application name which appeared in the error. You do not need to enter the path.
    Leave the Class field blank.
  3. Select the new key (Excel.exe), Edit-> Add Value. 7. Value Name: DisableHeapLookaside
    Data Type: REG_SZ
    Click ok.
  4. Then it will ask you for the string value. Type in 1 (no quotes around the 1).
    ie : Key Name: application.exe
    Class:

Value Name: DisableHeapLookaside
Data Type: REG_SZ
String: 1

Listserv Archives (BOB member since 2002-06-25)