cancel
Showing results for 
Search instead for 
Did you mean: 

BEx Analyzer - A critical program error has occurred. The Program will now terminate.

Former Member
0 Kudos

We have a BEx Analyzer workbook that everyone can run (refresh) except one user. She gets the "A critical program error has occurred. The Program will now terminate." error. I checked some of the previous discussion threads, but we have already followed the suggestion to ensure that she has a new install of current version of SAP GUI 7.40 and BEx 7.X with Excel 2007.

We had her try refreshing this workbook on someone else's PC under her own ID, and she got the same error. She gets the pop-up to log in, but gets the critical program error before the variables entry pop-up box is displayed. So this makes me think it is not PC-related, but rather personal related; however, she can run the BEx query as a stand alone query, just not that query embedded in a workbook. So she has the needed security to run that query. Any other ideas on what I can trouble shoot other than GUI version and security?

Accepted Solutions (1)

Accepted Solutions (1)

Loed
Active Contributor
0 Kudos

Hi,

To check if it is really an issue with user ID, then try to copy the authorization of any member who can run the workbook to her account. I think it is not a user ID issue. I encountered it before because my BEx is not updated or lacks some patches.

Regards,

Loed

Answers (2)

Answers (2)

Former Member

We verified that the SAP GUI and BEx installation on the PC is current. We verified that the user ID security to run the BEx query was correct. In this case, we additionally found that a combination of Global Settings enabled along with user-created Excel macros and sheet password protection were causing the issue. Thanks to all who replied.

Former Member
0 Kudos

Hello,

Did you apply latest BEX Patches also?

What operating system? Windows 7 + Excel 2007 gave us this problem and BEX patches helped resolve the problem.