More fun with the IBM 3690 X5, Bad status has been detected on 2 physical drives

Posted on April 4, 2012 by mellerbeck

So…. normally you get a new IBM server. You download the update express CD (Except now you have to download the IBM ToolsCenter Bootable Media Creator) update everything in the system then pop in the ServerGuide CD http://www-947.ibm.com/support/entry/portal/docdisplay?lndocid=SERV-GUIDE and then configure the RAID Adapter.

But then I got this:

Bad Status has been detected on 2 physical drives. What is going on here? Did we get to bad drives shipped to us? That doesn’t seem likely?

So I try all sorts of things, after the whole mezzanine issue (LINK) I’m starting to suspect all of the hardware. But everything seems to check out OK.

Then I remembered vaguely reading something about the RAID and UEFI. And there it was page 362 of the 580 page manual

Create a drive RAID array before installation. The ServeRAID management interface is
accessible via UEFI settings, by selecting System Settings  Adapters and UEFI
Drivers.

You open up this abomination from the UEFI screen

 

Then it brings up a screen where you can configure your JBOD disks as unconfirmed good. At that point you can use serverguide to set up the RAID…. very annoying.

 

Filed under: 3690 X5, IBM | Tagged: | Leave a Comment »

The BIOS reports that NUMA node 1 has no memory. The problem is either caused by a bad BIOS or a very unbalanced distribution of memory modules.

Posted on April 4, 2012 by mellerbeck

I was thinking this http://www.youtube.com/watch?v=60og9gwKh1o when I got this error :)

But it turns out,

With the IBM 3690 X5, if you are installing VMWare with two processors you need a memory mezzanine. Half the memory will be installed on the board for processor 1, and the other half will be installed on the mezzanine for processor two….

Important VMware ESX considerations: When installing and running VMware ESX on
this server, the operating system might fail to install or boot with the following error
message when the server memory configuration is not NUMA-compliant:
“NUMA node 1 has no memory”
There are only three possible configurations to support VMware:
 One processor is installed and no mezzanine board is installed.
 Two processors are installed and matching memory is installed on both the system
board and the mezzanine board.
 Two processors are installed, no internal memory is installed, and the memory installed
in an attached MAX5 memory expansion is configured as non-pooled memory.

Filed under: Applied IT, vmware | Tagged: | 1 Comment »

DataGridViewComboBoxColumn Drop Down Menu Appears All Black

Posted on April 4, 2012 by mellerbeck

This annoying bug was haunting me for quite a while. Luckily Nick Olsen figured it out

http://nickstips.wordpress.com/2010/12/20/c-datagridviewcomboboxcolumn-drop-down-menu-appears-all-black/

Code to fix

01 private void dataGridViewGLEntries_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
02 {
03     ComboBox cmbBx = e.Control as ComboBox;
04
05     if (cmbBx != null)
06     {
07         cmbBx.SelectedIndexChanged -= ComboBoxCell_SelectedIndexChanged;
08         cmbBx.SelectedIndexChanged += ComboBoxCell_SelectedIndexChanged;
09
10         // Fix the black background on the drop down menu
11         e.CellStyle.BackColor = this.dataGridViewGLEntries.DefaultCellStyle.BackColor;
12     }
13 }

Filed under: Applied IT | Leave a Comment »

Storage VMotion fails to complete validation with the error: The requested Storage VMotion would move a virtual machine’s disks without assigning the virtual machine a new home

Posted on April 3, 2012 by mellerbeck

I was attempting to storage vmotion a volume that currently housed the configuration file, If you move the configuration file to the new location as well it passes validation.

Filed under: Applied IT, vmware | Leave a Comment »

iPhone like badges in #Qlikview

Posted on March 26, 2012 by mellerbeck

First off I had no idea that they called those little popup numbers on the iPhone ‘Badges’ until a co-worker told me. Anyways, was doing an AR-Aging Qlikview and thought it would be informative to show the amount of invoices for the various ‘buckets’ It’s not anything special, just round text objects. Basically one with Red background and white border and then another text object with a black background slightly larger in order to get the correct red center, white outline, and final black outline.

Somewhere online I found that to make a round text object use a Squareness of 2, and then Relative (%) of 100

 

So the finished product looked like this

Filed under: Qlikview | Leave a Comment »

Recreating a drill down type website in #Qlikview

Posted on March 26, 2012 by mellerbeck

We have a pretty useful website for looking up our production orders (we make frozen veggies). The trick was to #qlikview-a-fy-it to get instant results.

So, this is what the original web based app looked like.

Then when a production order is clicked on, it shows more detailed information about that production order.

So, then how do you go about Qlik-View-A-Fying it?

Under the ‘show’ section of another table I used the condition

=if(GetSelectedCount(Order)= 1,1,False())

Order being the clickable object. So once you click on an order the order detail ‘magically’ appears. Same thing for when you click on an item, the next level of detail is conditionally shown in a table.

Filed under: Applied IT, Qlikview | Tagged: | Leave a Comment »

Qlikview Column() Function

Posted on March 22, 2012 by mellerbeck

Not to be confused with the ColumnNo

ColumnNo([total])

Returns the number of the current column within the current row segment in a pivot table. The first column is number 1. 

Column() will return the value in that column.

The count starts from 1 for the first expression. 

—

Column(ColumnNo)

Returns the value found in the column ColumnNo in a straight table or a pivot table. 

Filed under: Uncategorized | Tagged: | Leave a Comment »

Saving changes is not permitted sql server 2008 r2

Posted on February 28, 2012 by mellerbeck

http://msdn.microsoft.com/en-us/library/bb895146.aspx

To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.

Filed under: Uncategorized | Leave a Comment »

EqualLogic Maintenance Record, Take Two

Posted on February 21, 2012 by mellerbeck

I don’t know if I dare post this, but no drives lost or hardware issues since 1/26/10
Yay!
My previous post was here

 

Filed under: Uncategorized | Leave a Comment »

When creating a temp file System.IO.IOException: The file exists error

Posted on February 14, 2012 by mellerbeck

http://blog.dileno.com/archive/201103/fixing-the-file-exists-ioexception-error/

If you get the System.IO.IOException: The file exists error, it’s probably because your C:/Windows/Temp folder is absolutely full with temporary files. In fact, if you have more than 65535 files in your temp folder, the method GetTempFileName will throw this error.

To resolve this, just remove all temporary files in C:/Windows/Temp. It might take some time, but it will solve the problem.

Here’s the stack trace I got:

System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   System.IO.Path.GetTempFileName()

 

Filed under: Uncategorized | Leave a Comment »

« Previous Page — Next Page »
Follow

Get every new post delivered to your Inbox.

Join 201 other followers