SAP GUI 7.10 Business Explorer Analyzer toolbar

2 06 2008

If you are deploying SAP GUI 7.10 with Business Explorer component the Analyzer toolbar may not work with Microsoft Excel 2003. After you start the Analyzer; Excel application is started and toolbar displayed as below in German. I installed the latest release of SAP Gui 7.10, BW 3.5 and BI 7.0 with bw350gui710_3-10004473.exe  and bi710sp05_500-10004472.exe patch on a Windows XP SP2 client and Office 2003 SP2.

image

To fix this problem please make sure you install the “Update for Office 2003 KB907417“.

Microsoft has released an update for Microsoft Office Excel 2003 and for Microsoft Office Word 2003. This update corrects a potential problem in which an add-in, a smart tag, or a smart document may not load if the add-in, smart tag, or smart document uses the Microsoft .NET Framework 2.0.
When you try to run a custom Microsoft Office 2003 solution that was created by using Microsoft Visual Studio .NET, the solution does not run. This issue may occur because the Microsoft .NET policy that enables the custom solution to run is not loaded after you install Visual Studio Tools for Office 2003.

Download and install the hotfix and reboot after. After reboot the BEx Analyzer toolbar is working. If you are deploying this on many clients please make sure this update is installed before SAP GUI installation.

image

After the reboot the toolbar is working.

image

Credit goes to “Steven Glennie” for pointing me in the right direction when troubleshooting this problem.



Cacti RRD graphs are not updated and the application slow

17 04 2008

image I have two identical Cacti (0.8.6h) virtual machines and both based on CactiEZ version 1 installation. I have been migrating the virtual machines between different Vmware hosts  and at some point my second Cacti appliance did not update the RRD graphs and using the web interface was very slow. I tried rebooting; changing parameters in the Configuration Settings but noting helped to solve the issues. I even tried to bring the virtual machine on the original vmware host and I had same symptoms.

I logged in with a SSH session and went to my cacti database folder. I did a list and reviewed the file structure.

Shell> cd /var/lib/mysql/cacti
Shell> ls -all
-rw-rw—- 1 mysql mysql 303340164 Apr 15 09:32 poller_output.MYD
-rw-rw—- 1 mysql mysql 119115776 Apr 15 09:32 poller_output.MYI

As you can see the poller_output.MYD and poller_output.MYI are too huge and mysqld used a lot of resources. Total size of two files 366MB and my physical memory assigned to this virtual machine was only 384MB.

image

I read couple posts on the Cacti forms and decided to clean up my poller_output table from shell.

Shell> mysqld
mysql>use cacti mysql>
delete from poller_output;
mysql>exit

Read the rest of this entry »



VMWare Server: 511 vmware-serverd service is not running.

2 03 2008

At some point the VMWare Server  host run out of diskspace on which the virtual guest machines were stored. Windows started to complain about low disk space and only 32KB was left. I tried to open VMWare Server console and I got the error message below "511 vmware-serverd service is not running." All virtual machines were running except the one which consumed the remaining diskspace of the physical SAS drives.

image

To resolve this issue I shutdown one of the virtual machines with a RDP session and moved the directory to another VMWare Server host; next step I did I tried to bring other virtual machines down by a RDP session and at some point I was left with two other virtual machines which both were not accessible by RDP nor by SSH for the linux one.

I opened Task Manager and located the remaining processes for the virtual machines.

image

vmware-vmx.exe is individual process for each virtual machine. Two were left and I stopped both vmware-vmx.exe processes. Open Services.msc console and restart the "VMware Registration Service" service.

image

After the service was restarted the initial process of starting the virtual machines started and all virtual machines were up and running. This is how I resolved the problem with VMWare Server, but it brings me back to the root cause of why this happened and one of the import things is to really think how you are going to seize your virtual machines and their disk space. I am going to implement thresholds and notifications with CactiEZ appliance soon and hopefully something which can help you also.