Posts

warning: Win32API is deprecated after Ruby 1.9.1; use fiddle directly instead - Chef Development Kit Update

Today, I needed to do some tests with a newer version of the Chef Client and test my cookbooks. To version 14.12.9-1 to be precise. I also upgraded my ChefDK on my workstation to the 4.2.0 version. I believe that upgrades Ruby version as well and now I have ruby version 2.6.3p62

Right after the upgrade, I tried with a basic knife node list command to see if I needed to reboot or anything was broke...

Everything seems to be working fine, except I get this annoying "warning" message. As it's just a warning, I don't really care about it as it just seems to annonce something that is deprecated...

Problem;
You receive "warning: Win32API is deprecated after Ruby 1.9.1; use fiddle directly instead" warning when using ruby or chef knife commands.

Solution;
You need to comment out that warning message in Ruby lib scripts.

System.Messaging.MessageQueueException (0x80004005): A workgroup installation computer does not support the operation (Public Queue create issue)

This is a weird issue that I don't fully understand why it would happen. But the symptoms are very persistent as we're able to reproduce these behavior easily.

Issue: The MSMQ (Microsoft Message Queuing) fails to create Public Queues and throws  "the System.Messaging.MessageQueueException (0x80004005): A workgroup installation computer does not support the operation" exception.

Excel - Merge Tables with Index and Match Formulas

Image
A lot of the times, I find myself having multiple Excel or CSV files with different tables & data that at some point, I need to merge them...

Here is a not to myself! Use Index and Match formulas.

Index Function

The INDEX function returns a value or the reference to a value from within a table or range.

Match Function

The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. For example, if the range A1:A3 contains the values 5, 25, and 38, then the formula =MATCH(25,A1:A3,0) returns the number 2, because 25 is the second item in the range.

Ex :

INDEX (return_range, MATCH (lookup_valuelookup_range, 0))


=INDEX(Sheet1!$B$2:$B$218,MATCH($A2,Sheet1!$A$2:$A$218,0))

In this example, with Match, we're trying to find cell A2's exact value by looking in the "Sheet1", from A2 to A218. When the exact value of A2 is found in the range of Sheet1!$A$2:$A$218, with the Index formula, we pull it's v…

Assassin's Creed Games doesn't lunch!

Although I don't consider myself a real gamer, I do enjoy playing games from time to time. Since, I've started working at Ubisoft, I'm trying to take advantage of the games available to me. One does not simply work for one of the greatest gaming companies in the world and simply refuse to play their games ;)


So after installing uPlay on my computer, I downloaded & installed huge packages of the Assassin's Creed, Crew, South Park, For Honor, etc... Everything was working fine until I decide to lunch on of the Assassin's Creed games.

Veeam Backup Error : Failed to prepare guest for hot backup. Error: VSSControl

Image
Problem Description;

I had this issue on one of my backup jobs recently and I was able to fix the issue with the solution explained below. After a quick google search, I realized that I'm not the only one and neither you are :)
Full Error Description;

Failed to prepare guest for hot backup. Error: VSSControl: Failed to prepare guest for freeze, wait timeout 900 secError: VSSControl: Failed to prepare guest for freeze, wait timeout 900 sec





Windows 10 Sysprep Error

Almost all of the obvious bugs and errors are all related to Microsoft new environment and the APPs...
Recently, I was trying to prepare a VM Template but I was stuck at the Sysprep process with the following error.

Get-VMHostFirmware Internal Error - Can't Backup Hypervisor Configuration

If you're getting an internal error while trying to run the Get-VMHostFirmware command with vSphere PowerCli, chances are the problem comes from a corrupt scratch directory on the hypervisor.

The Get-VMHostFirmware command is one of my favorites if I'm doing any maintenance on the hosts. It saved me hours of configuration multiple times... Very handy! But recently, I needed to run the command on one of my hosts and I was getting an internal error! Nothing more... Even after a reboot and trying all the other methods of configuration backup mentioned here, still no luck!