Friday, November 04, 2011

No Professional Should Ever Be Without a Tide To Go Pen [Field Notes]

Dressed up nicely today for a big meeting with the head of our division at work.

A coworker needed a spoon, and I used it as an excuse to indulge my inner caffeine addict in the cafeteria.

5 minutes after I bought the coffee, it splashed against the side of the container and formed a nice little geyser to land on my light-colored shirt.

Normally, I would have been doomed to a day of embarrassment at a time when I really don't need any. Luckily, this is where Tide to Go comes in.

I keep a TTG pen in my office for just such an occasion. I walked quickly back to my office and used it on a gigantic area of my shirt. It took a few minutes (it was a seriously large area to cover), but was painless.

The end result? By the time I delivered the spoon to my coworker, she couldn't notice any stain.

This product is sheer brilliance. I'm buying 2 more today.

Tuesday, November 01, 2011

Crystal Reports Error: "A subscript must be between 1 and the size of the array." [Field Notes]


Problem

A long-standing Crystal Report (being run out of SAP Business Objects XI v12) suddenly started generating an error along the lines of:

Error in File [File Name]: Error in formula [Formula Name]: 'left(split({[Field Name]},"/")[2],3)'
A subscript must be between 1 and the size of the array.
Details: errorKind

(The bracketed values were specific to the report itself)

Solution

In this case, the formula is looking for a "/" to split the string. On a hunch, I decided to query the database, and sure enough, some of the fields in the database had been modified and no long included a "/", causing the formula to bomb out.

Two solutions here:

  • If the "/" is a business requirement and is supposed to be there, modify the data.
  • Otherwise, modify the formula to include branching logic that takes other steps if a "/" is not detected.

Monday, October 31, 2011

iPhone 4S / iOS 5 battery issues? Turn off time zone settings

The excellent folks over at Lifehacker have a tip that seemingly works to resolve iPhone 4S and iOS 5 battery level issues.

The culprit? It looks to be a bug in the Time Zone settings that causes location services to go nuts and poll way more often than it needs to, draining the battery.

To remedy the issue, according to Lifehacker:
The solution for now seems to be manually switching off the automatic time zone updates located at Settings -> Location Services -> scroll to bottom to System Services -> Setting Time Zone. Expect more conclusive results in the coming weeks.
I've tried it and saw an immediate and striking difference in battery life. Give it a shot if you haven't yet. And if you're jet-setting anytime soon, just re-enable it (or take me with you and I'll do it for you!)

iPhone 4S Battery Problems May Be a Bug with iOS Location Services | Lifehacker