Tuesday, December 28, 2010

A Report Card for CDOT

You probably missed it in the run-up to Christmas, but a new legislative report has again given poor grades to the CDOT.  This report from the General Assembly’s chief investigative panel was released, strangely, on December 23rd, a date that all but guaranteed it would get no news coverage.  Do you think this was by chance?  Hardly.

But credit should go to the excellent online newspaper CT Mirror, which broke the story, and to a few print dailies across the state which picked it up.

In summary, the report said the CDOT is late in finishing its work, especially its most expensive undertakings.  On average, the agency took 5.3 years to finish big projects, with only 37% of work finished on time (think I-95).  That compares with others states’ 57% on-time completions.

Not only were the projects late, 74% of them were over budget with an average added cost of 23%.  Over the decade of work studied, that added up to an additional half-billion of your tax dollars.

Part of the problem is that CDOT has no automated project management system to track these multi-million dollar projects.  In other words, nobody is keeping score.  Nor, in my view, does there seem to be any accountability for mistakes.  In the private sector a batting record this dismal would cause heads to roll.

Of course, there are fewer “heads” at CDOT to roll: the agency today has 20% less staff than in 1990.  Past budget cuts have seen the most experienced engineers accept buy-outs, taking their expertise with them as they exited the agency.  And it’s only going to get worse:  29% of CDOT engineers are over age 50 and are edging toward the door.

Out-sourcing work to consultants doesn’t seem the answer, as their work was slower and more expensive than jobs done in-house by the civil servants.

On the plus side, progress has been made in highway safety.  Connecticut’s annual highway fatality rate of 0.83 deaths for every 100 million vehicle miles traveled ranks well below the US average of 1.25 deaths.

Among possible explanations for this good news are that 8.8% of all Connecticut roads are “over capacity” and only 41% of our highways are ranked as giving a “good” ride.  Those factors could slow you down and keep roads safer.

Even federal stimulus money hasn’t been spent all that well.  The long over-due work repairing our rail stations has been uncoordinated and, in my view, inept.  In April the overhead canopies at several rail stations were removed, leaving passengers still standing unprotected from rain and snow seven months later. 

CDOT says the canopies can’t be replaced until overhead caternary wires are replaced on an opposite track.  But they don’t hesitate to plaster these and other ARRA job sites with hundreds of thousands of dollars in signs proclaiming their good works.  At least the sign makers got jobs if not the roof-installers.

While the legislative report does give CDOT points for increased “transparency” in its dealings with the public, the recently announced delay (again) in the delivery and testing of the new M8 rail cars stands in contradiction to that claim.

More candor and communication by the agency on this crucial infrastructure investment could have gone a long way to lessening the cynicism and distrust most have of this agency.

And we still have no idea who our next Governor will chose as Commissioner of the DOT.  Who could possibly want the job?

Saturday, December 18, 2010

ODTUG Kscope 2011 abstract schedule

The best is yet to come

The best being KScope 2011, of course.

What do I mean by that?  Of course the very best place to see super cool (really, just keep reading on) content is going to happen.  What’s the big deal?

The big deal is that after much thought, consideration, and debate, the very best Oracle EPM and BI presentations you have ever seen have been selected.  Don’t believe me?  Check out the official schedule here and see the invited speakers.  Jump to the bottom of this post to get a more detailed view of the presentations.  Yep, this is going to be a great conference.

The pain and the agony

The ODTUG Hyperion SIG puts a huge (let me tell you, three hour Saturday afternoon conference calls are not fun, but for you, oh KScope 2011 attendee, we do it with a song in our heart) amount of effort into the abstract selection process.  We’re passionate, even obsessive, about quality, and I think you’ll agree that the sessions reflect that concern about the best of the best.

Each and every submitted abstract was individually reviewed and assigned a numerical rating by the content selection team.  We then met in multiple conference calls by track culminating in several overall Hyperion SIG meetings to evaluate every single one of those presentations (there were over 200 on the EPM side of it) and determine if it was in or out.

Many good abstracts were rejected because the level of competition was so high.  This may sadden or frustrate some who were rejected and I’m sorry that everyone who wanted to share knowledge didn’t have a chance to do so this year.  It’s commendable behavior and I hope you try again next time.  There are other opportunities other than the conference such as ODTUG Webinars.  Please contact us and see where you can contribute.

If everyone could agree that Kaleidoscope should be a two week long geek fest, then all of the deserving presentations could occur.  Sadly (?) I’m probably the only nut that would or could do it (realistically, two weeks away from work with hotel, travel, and lost income wouldn’t even work for me, but it’s a nice thought) so it isn’t really on but is humbling to realize that many people submitted quality abstracts.  Kaleidoscope is the place for quality, and the EPM and BI world knows it.

Not the square peg in the round hole

Oracle’s BI and EPM offerings are large and diverse, to put it mildly.

KScope 2011’s BI/EPM content chairwoman (and my good buddy), Natalie Delemar, had an inspired idea – instead of trying to be all things to all men by being the judge, jury, and executioner for presentations (I put that sentence into my patented Metaphor-O-Matic and out it came, unencumbered by the thought process), she instead reached out the Oracle BI and EPM community and got the experts in their respective areas to solicit and review abstracts before the Hyperion SIG, overall content chairman Monty Latiolais, and conference supremo Edward Roske put their final imprimatur on the schedule.  See, ODTUG is just full of good ideas.  And long sentences.

Below is that august group of geeks, by content review area.

BI


EPM


Hyperion SIG (and a few friends)
Joe Aultman

We owe them all a lot – many, many hours were spent on this, especially by Natalie who spent untold hours making the schedule work – 3 am emails asking my opinion on a abstract scare me, especially when we’re in the same time zone.  They did a tremendous service to us all by soliciting, reviewing, and selecting the best of the best.

How do you want to slice the pie?

There are four ways to view this conference:  track, not for just beginners, physical room, and business end users. 

The tracks are broken into:  case studies and panels, HFM, Essbase, Planning, Keeping It All Running, Reporting, OBIEE/DW, and of course Hands On Labs.

There’s also a beginner view – yes, Kaleidoscope isn’t going to leave those of us (like me, sometimes) starting out in a technology. 

Or you can view it by room, if you are of a sedentary nature.

And lastly, there’s even a map for business end users in case this all gets too geeky for you. 

If you want to just download the whole thing to geek out over during your free time, click here.

Whoever you are, whatever your interests, wherever your technical level lies, there’s a place for you at KScope 2011.

And the result is…

One awesome conference and in my opinion, the very best Kaleidoscope, and hence the very best “Hyperion” conference ever.  It’s that good.  Book those tickets, reserve that room, purchase that conference registrationYou won’t regret it.  See you in Long Beach.

Monday, December 13, 2010

To Florida, By Train

Any regular reader of this column knows my long-held disdain of flying.  The recently added insult of irradiation or proctological examination by the TSA made it a no-brainer when I had to travel this week to Miami on business:  Amtrak all the way.

The Silver Star departs NYC’s Penn Station each day at 11 am.  Its sister train, The Silver Meteor, leaves at 3:15 pm.  Both trains end up in Miami within minutes of each other, but take different routes south of Richmond.  I’m on The Star, which actually goes to Tampa, then on to Miami.

Secure in my roomy bedroom compartment (complete with sink, shower and bathroom), I fire up my radio scanner to hear the conductor call an on-time departure from New York.

Even though our ten-car train (engine, baggage car, two sleepers, dining car, lounge and four coaches) has a mixture of old “heritage fleet” and newer Amfleet equipment, my Blackberry GPS says we’re doing more than 105 mph as we careen thru central New Jersey.

On this Wednesday departure the train is only half-full, though the attendant assures me “she’ll fill up along the way.”  Fares are not cheap. Coach fare NY-Miami is $125, but adding a ”sleeper” on top of that adds $509 for a single-person roomette or $769 for my commodious bedroom.  However, sleeper pricing includes all meals.  And believe me, though the china in the dining car is plastic, the food is freshly cooked and delicious.

Mind you, my own roundtrip is free -- thanks to points accumulated in Amtrak’s excellent Guest Rewards program.  All those Acela and Northeast Corridor trips in recent months really paid off.
On this journey, unlike my “land cruises” out West, the scenery is far from spectacular.  But as the terrain moves from the urban squalor of the Northeast Corridor to the scrub pine of the Carolinas to the palmetto plains of Florida, I can tell I’m transitioning southward.

Our train is on time the entire way, thanks to heavy padding of the schedule at stops where the crew changes and many passengers disembark for a fast smoke.  It’s amazing how fast I can consume a cigar when I know I have limited time (and hours till the next opportunity.)

A couple of Tylenol PM’s and I sleep well through the night, missing stops in Columbia, SC and Savannah, GA.  The CSX track is well maintained, welded rail with none of the “clickety-clack” of olden times.  I awaken just after sunrise and well past Jacksonville, as our zigzag tour of the Sunshine State begins in earnest.

This is the Florida you don’t see from the Interstates:  miles of orange groves filled with fruit… the cattle farms… wild birds taking flight from countless swamps at the sound of the loco’s blasts… and trailer homes tucked into the brush everywhere.  The occasional Christmas trees in small towns just don’t seem to fit.

Instead of heading due south to Miami, we turn inland to Orlando, then west to Tampa.  High speed rail is planned here, but we’re cranking along at 75 mph before we turn on the wye and ignominiously back into Tampa Union Station in Ybor City.  Alas, no time for a tour of the local cigar factories as we board maybe a hundred intra-state riders heading to the east coast.  Our inter-city train from the northeast is now a Florida local serving such hot spots as Lakeland, Winter Haven and Okeechobee before arriving on the Gold Coast (West Palm Beach, Fort Lauderdale and Miami).


At West Palm Beach we start sharing the track with Tri-Rail, Florida’s answer to Metro-North, also paralleling I-95.  Except these trains are newer double-deckers and painted for full effect.  Their gaudy colors are designed to be visible as they zoom past the congested highways, almost taunting the motorists.

It’s raining lightly but about 40 degrees warmer than when we left NYC 30 hours ago.  Hardly tropical.  But the billboards are in Spanish and the city lights of Miami glow in the distance as we arrive five minutes ahead of schedule.

I think it was the folks at Cunard who said “getting there is half the fun.”  Certainly true for cruising, and equally so on Amtrak. 

“Saving Your Transit Benefits… and Your Trains”

Don’t look now, but Congress is about to give motoring commuters a big tax break and take one away from riders of mass transit.
Under current federal law, commuters can deduct up to $230 a month from their pre-tax paychecks to pay for the trips to and from work.  That deduction can cover bus / rail tickets via programs like TransitChek or pay their parking expenses.  But unless Congress acts by the end of the year, the mass transit commuter’s benefit will be cut to $120 per month while the motoring commuter keeps the full benefit. Huh?
Cutting this pre-tax benefit would hurt low income workers the most because they often have no car and must rely on bus and train.  At a time when we’re trying to reduce highway congestion and improve air quality, penalizing mass transit riders and rewarding users of autos makes no sense.
But these tax benefits are for more than commuters.  Employers can save 10% on payroll taxes if they sign up employees for the program.  According to MetroPool, over 100 businesses in Fairfield County hiring over 34,000 workers participate in the commuter pre-tax program.
Here’s an example of the savings:  Let’s say you ride from Fairfield to NYC, and then take the subway.  With a monthly rail pass at $308 and monthly MetroCard at $45, you’d spend $4,200 a year just to get to and from work.  The current commuter benefit defrays 68% of this cost, saving you $1,355 a year in taxes.
But again, this tax break will be cut in half if Congress doesn’t act quickly.
Connecticut’s Senators Dodd and Lieberman are con-sponsors of The Commuter Benefits Equity Act (S 322 / HR 891) which would keep benefits equal for drivers and mass transit users at $230 per month.  Strangely, in the House, none of the co-sponsors are from our state.
If this bill doesn’t come out of Committee and get approved by December 31st 2010, reduced tax benefits for rail and bus riders may incentivize some commuters to get back in their cars.  According to TransitCenter Inc., a drop in the transit benefit will reduce ridership by as much as 9% among commuter benefit users. And you know what that means for traffic.
What can you do?  You need to contact your Congressman and ask him or her to support the bill.  Also, ask your employer’s Human Resources office why they don’t offer these pre-tax benefits, reminding them it’s in their interest as well as yours.
Finally, get in touch with the TSTC (Tri-State Transportation Campaign) at www.tstc.org and support their strong advocacy on this and so many other transportation issues.  They are among commuters’ greatest allies.
And while you’re in a mood to contact your elected officials, don’t forget to call or e-mail your State Rep and Senator.  We need their help to defeat Governor Rell’s recent senseless call to shut down trains on the New Canaan, Waterbury and Danbury branch lines.
Just weeks ago I was hailing Governor Rell for her leadership and support of mass transit.  Then she turns around and tries to save $5 million a year by stranding 4,300 daily riders of those lines.  And this, after spending $60 million in federal funds to put signals on the Danbury branch, only to suggest it be shut down? 
Days after her call to close down the trains, she literally “back-tracked”.  Her office called me to say she didn’t mean it, that she was trying to get attention of lawmakers and blaming her budget folks at OPM for putting rail cuts on the list of possible cost savings.
Shame on her for frightening commuters and using them as a political lever.  By admitting she was “crying wolf”, who will take her seriously on the next crisis?

Thank You Governor Rell

Anyone who follows this column knows I’m bipartisan in my criticism.  Whoever is in power, Democrat or Republican, I’ve got “suggestions” on how they could improve our transportation mess.
Since she came to office in the midst of a scandal, no other politician has been the target of my commentary more often than Governor M. Jodi Rell.  Today, however, I want to give her the credit she’s due for all she’s done on the transportation front.
Watching the Governor ride the first of the new M8 rail cars this week, I was struck by how she had come full circle in only six years.  The irony is it took her entire tenure in office to order, design, build, test and finally deliver these new cars.
In Governor Rell’s first budget address to lawmakers in February 2005 she started to undo years of her predecessors’ neglect of our trains.  She told lawmakers we must order 300 new rail cars, and they did.  Mind you, she told us then the cars would be in service by 2008.  I predicted, accurately it turned out, that 2010 was a better guess.
The Governor said riders should pay a small part of their cost with a modest fare hike, and that too was passed by lawmakers.
But Governor Rell also said that commuters shouldn’t pay more until they were actually riding in the new cars… a promise she kept.  As manufacturing delays by Kawasaki slowed delivery of the M8’s, that planned 1.25% fare hike was deferred.   A politician who keeps a promise.  Imagine that.
More recently, Governor Rell also told the New York MTA, parent of Metro-North, there was no way she was going to raise fares in Connecticut to pay for the budget problems of New York’s own making.  That was a first in the troubled history of Connecticut / New York relations, but again the Governor deserves credit for doing the right thing.
But not every dream came true during the Rell administration. 
Grumblings about a lack of a voting seat on the MTA or Metro-North boards never amounted to more than that… grumbling.
And yes, Governor Rell did change Commissioners in the Dept. of Transportation at a pace that left many people wondering who was in charge:  five Commissioners in six years.  One was a former State Trooper, another had run Bradley airport.  The two most recent of them actually had experience in rail transportation.
Wracked by scandals, Governor Rell was embarrassed on several occasions by her DOT, eventually asking local businessman Michael Critelli to study the agency and issue recommendations for reform.  Of course, few of the group’s suggestions were ever embraced.
Long promised repairs to our dilapidated train stations took four years to happen, thanks mainly to Federal stimulus money.  If this work wasn’t “shovel ready”, nothing was.
We’re still not certain if the much-needed New Haven Rail facility will ever be fully built, as its price yo-yoed from $300 million in 2005 to $1.2 billion in 2008.  The Governor’s solution… pay consultants $630,000 for an audit.  Their report found only $11 million in potential cuts.
Still, Governor Rell was a big rail fan, realizing the importance not only of fixing Metro-North, but planning for the future.  Together with fellow lame-duck Senator Chris Dodd, she secured a serious down-payment on high-speed rail between New Haven and Springfield.  Well, maybe not true “high-speed”, but certainly higher speed than Amtrak currently offers.
I’m not sure how Governor-elect Malloy will do on transportation, though he clearly understands the problems from his years as mayor of Stamford.  His dreams for better mass transit will be most tempered by our economic crisis.

But to outgoing Governor Rell all commuters should give a loud “thank you” for all that she accomplished.  She’ll be a hard act to follow.

Thursday, November 18, 2010

Stupid programming tricks #5

Introduction

Number five in my short and sweet series of tricks and tips.

I call this series “Stupid programming tricks” and this one reflects yr obdnt srvnts’ stupidity.  Try to think of this particular post in the now-I-don’t-have-to-make-Cameron’s-mistake category.

DATAEXPORT is my friend, sometimes

DATAEXPORT came out in Essbase 9.3.1 and allowed Essbase calc scripts to export data without having to resort to the JExport Custom Defined Function.

DATAEXPORT can write to tables or files.  What’s really nice about this method is that you can also define the file field delimiter.  It could be a comma, a pipe, an exclamation point, whatever.  It’s all very easy peasy lemon squeezy

Here’s an example of a comma delimited export in a calc script:
DATAEXPORT "File" "," "c:\temp\testexport.txt" ;

And here’s an example of a pipe delimited export statement:
DATAEXPORT "File" "|" "c:\temp\testexport.txt" ;

But what if you want to do tab delimiting?  Uh-oh, what’s the magic symbol for tab?  I didn’t think it could be doneAnd to be fair to myself, I wasn’t the only one.  You will note a distinct lack of contradiction to my statement in that thread.  In discussions with my good buddy Josie Manzano, she fell into the same trap.  If the Divine Miss Josie can make the mistake, anyone can.

And this is why I like answering questions on OTN

I spend an inordinate amount of time on OTN’s Essbase board in part to answer questions but mostly to learn.  Did I ever in this thread which started out about a poster’s problem in loading a exported data file and quickly detoured into DATAEXPORT.

The way to tab delimit a DATAEXPORT file is to…hit the tab key on your keyboard. 

That’s it.  So simple. So obvious.  Why on earth did I think I needed to send a special character?  Isn’t tab a special character?  Sigh.  My cognitive blinders were on quite firmly for this one.

Here’s the code.  That big space is really a tab character.
DATAEXPORT "File" "              " "c:\temp\testexport.txt" ;

The same approach would go for a space.
DATAEXPORT "File" " " "c:\temp\testexport.txt" ;

Yes, these work – I’ve tried them.

So, definitely a Stupid Programming Trick.  May the next one not be so stupid.

One last note

Btw, Glenn Schwartzberg wrote a great series on DATAEXPORT and I strongly urge you to check them out.

Wednesday, November 3, 2010

Do I look like Sally Field

My name is not Gidget

Not really, no not at all.  And I can’t even surf.  And yes, that is a scary video for me to know about (thank you, Oh Great False God Google) and even more scary for you if you clicked on the link.

 

Nor do I wear a wimple whilst flying, or at any other time.

 

But I can say, “You like me, you really like me”.

Not the Academy Awards

I know, more blathering, but that’s just me being bashful about something that you, my adoring/tolerant/frankly bored reading public have done:  elected me a member of the ODTUG board.

 

All kidding aside, I never thought I would get elected, particularly on the first go round.  I am beyond pleased, humbled, and more than a little scared.

 

Thank you so much for taking a flier on me.    I hope I don’t disappoint.

Saint Crispin’s Day?

Here are we happy few in the 2011 ODTUG Board of Directors:

New

  • Mike Riley, Hortica Insurance
  • Tim Tow, Applied OLAP
  • Cameron Lackpour, CLSolve (yr. obdnt. srvnt.)
  • Barbara Morris, Idaho National Laboratory

Existing

  • Bambi Price, Park Lane Information Technology
  • John King, King Training Resources
  • Mark Rittman, Rittman Mead Consulting
  • Monty Latiolais, SCGTS

The future and thanks again

It’s often dangerous to make promises if you aren’t sure you can deliver on them.  This may be why I am a semi-successful consultant and not a fan of politicians.  Regardless, getting onto the board was the outcome of an election. 

 

What I know I can do is to serve you, the Oracle EPM community, and the rest of the Oracle world as best I can.  I am more than open to suggestions and comments.  You can always contact me through LinkedIn. 

 

I look forward to this – it’s going to be a lot fun.

 

And thanks for your confidence in me.


Sunday, October 31, 2010

Trolleys: Riding Back in Time

What was commuting like back in the “good old days”? Well, cheaper, slower and with fewer options. Still, we have nostalgia for our grandparents’ travel methods long before families owned cars. Back then, it was all about trolleys!


It’s been 200 years since trolleys first plied city streets. Initially pulled by horses they were eventually electrified, adding speed and dependability. While we think of streetcars mostly for in-city service, trolleys criss-crossed our state, supplementing the railroads for longer distance travel.


It is true that you could travel all the way from New York to Boston by connecting trolley lines, a nickel a ride. (Click here for a fabulous 1916 timetable showing four routes from NY to Boston complete with descriptions of the towns).


The trolley companies were often owned by power utilities, giving themselves a steady client for their electricity. To generate even more weekend business, trolley lines would often run to amusement parks which they also owned, like Roton Point in Norwalk.


The expansion of the trolley lines had a profound effect on housing, allowing city dwellers to live further than walking distance from their factories. Nowhere was this better illustrated than in Boston as detailed in “Streetcar Suburbs”, a classic sociology text. This was truly the first “Transit Oriented Development”.


But the story of New England’s trolleys is not limited to the history books. Fortunately, we are blessed with two excellent trolley museums just a short drive away.


The Shoreline Trolley Museum in East Haven was founded in 1945 and now boasts more than one hundred trolley cars in its collection. It still runs excursion trolleys for a short run on tracks once used by The Connecticut Company for its “F Line” from New Haven to Branford. You can walk thru the car barns and watch volunteers painstakingly restoring the old cars. There’s also a small museum exhibit and gift shop.


The Connecticut Trolley Museum in East Windsor began in 1940, making it the oldest trolley museum in the US. It too was started on an existing right-of-way, the Rockville branch of the Hartford & Springfield Street Railway Company. You can ride a couple of different trolleys a few miles into the woods and back, perhaps disembarking to tour the collection of streetcars, elevated and inter-urbans in the museum’s sheds and barns.


Both museums also offer you the chance to “drive” a streetcar… under supervision and after a little training. Passengers are not allowed, but your friends can join you if they are brave. If you’re looking for a day-trip, especially for kids, I can highly recommend either museum. But check ahead for hours, especially off-season.


Being born and raised in Toronto, streetcars were always a part of my life. Long before Toronto had a subway or commuter rail service, citizens would go shopping, go to church or an evening at the movies by streetcar. Even today that city of 2.5 million is served by new, Canadian-built streetcars. You can still ride trolleys, both old and new, in New Orleans, Philadelphia, Boston and Newark NJ. There’s even talk of returning streetcars to Stamford.


When it comes to getting around by means other than the auto, everything old is new again.

CT Trolley Museum

New Orleans trolley on St Charles Ave

PCC Car - CT Trolley Museum

Tuesday, October 26, 2010

Stupid Programming Tricks #4

Introduction

This is number four in my series of short tricks and tips. 

 

I debated about the utility of this until I spent an hour trying to figure out how to search MaxL scripts with Windows Explorer’s Search function.

 

The fix is easy and oh so useful.

What am I trying to do?

Let’s say I want to find all of the MaxL scripts that use the “spool” command.

 

If I searched all of the .txt files in a given folder, Explorer’s Search function would give me a nice list of files that contain the string “spool” in the file body. 

 

To prove this, I renamed a MaxL file so that it has an extension of .txt.

 

Here are the results:

 

But if I search the same folder for the same file with a .msh extension I get this:

 

Of course, I could:

1)    Find every MaxL script (in my world, they end with a .msh, and yes, that is important) in a given folder, harddrive, computer, etc.

2)    Open up every one of those MaxL scripts and search within for “spool”.

3)    Do an Oedipus Rex and take out my eyes with knitting needles in a completely non-Freudian way because of the despair, ennui, and avoir le cafard that steps one and two engender.

 

But there is a Better Way.  The cockroaches of Sidi-Bel-Abbes will thank me for that one.

Don’t fear the Registry

Go to the Start->Run menu and type regedit.

 

A key is required

If you’ve already changed .msh files in Explorer to open with Notepad or my personal favorite TextPad, this step isn’t necessary as  the main key will exist in the registry.

 

Add a new Key:

 

The Registry Editor will stick this new key at the bottom of the list – don’t worry about the order.

 

Rename the selected text to .msh and hit Enter.

 

Tell Search to look inside .msh files

Add another new key to the .msh key – I guess you could call this a subkey – by right clicking on .msh.

 

Here’s what it looks like:

 

Now give that key a default String value:

 

It is not going to be set by default.

 

Right click on (Default) and select Modify.

 

Now we need to give the Default key a very specific value.  Just copy and paste this into Regedit:

{5e941d80-bf96-11cd-b579-08002b30bfeb}

 

 

After you click on OK, you should see the following:

 

Log off and log back on; rebooting shouldn’t be necessary.

Conclusion

Search now lets you look inside .msh files.

 

Not a big deal, or the world’s best hack, but it sure is a nice way to search for a string within a non-standard file type.  Of course you can extend this technique to .csc, .rep, and .whatever files you need to scan.  Useless 99% of the time, but when you need it, you need it.

 

Happy hacking till next time.

Thursday, October 21, 2010

Who will rid me of this turbulent bug

It’s déjà vu all over again

Yep, life is sometimes like a Yogi Berra saying.  That’s scary.

I just rolled off a Planning migration from h-e-double-toothpicks.  I am reminded, again, that I am an applications, not an infrastructure consultant.  For some strange reason, I seem to enjoy parading my serial infrastructure incompetence to all and sundry via this blogDirty Harry said it best.  I am embracing my limitations with renewed fervor.

My pain=your gain

In an effort to ensure that this particular problem doesn’t bite you, oh applications consultant/administrator reader, in the unmentionables, think back, far back to the long-ago days of Planning 2.2.  Was there a release with that number?  Oh yes, and even before that.  I have been around Planning a long time.  So why have I learnt so little?

Moving past questions that cannot be answered (or at least questions that have answers I do not want to hear), there was a problem in older releases of Planning – ephemeral port consumption.  No, that is not a Victorian-era disease that involves sanitariums and bloody coughs.

Why do you care and what are they?


The issue is that when Planning refreshes filters, it consumes ephemeral ports during its communication with Essbase.  When the OS runs out of ports, Planning filter refreshes fail.

What does it look like?

The symptoms

What should have tipped me as to the error was that with 100 users in the app (I got pretty darn good with the Planning importsecurity.cmd/exportsecurity.cmd utilities) the refresh would work.  The fact that the command line syntax for invoking the import and export utilities is completely different was just a dollop of Hyperion icing on the misery cake.

Getting back to what worked and didn’t, the filter refresh would work with 300 users in the app.

As the number of usernames increased (I was slowly adding known good MSAD usernames) to just over 600, at some point (and no, I never did get to the actual count that just tripped failure as I was adding in groups of 50) Planning would fail on the refresh.

I (and quite a few others) spent a lot of time trying to figure out if the MSAD ids were bad (some were and “bad” in MSAD means a bunch of different things, e.g., corrupted, locked out, etc.).  But that wasn’t the issue.

Should have paid attention, but didn’t

What really threw me is that as I did the refresh, I’d get a pretty consistent list of failed usernames.  However, when I selected those usernames individually, their refresh would work.  Huh?  Also, these same ids worked in other Planning apps.  Huh, again.

And the answer(s) are

I would love to tell you that I came up with the diagnosis and the cure to this filter refresh failure, especially because I suffered through this in 2002, but I must give credit where it is due – say hello to Jason D’Onofrio who went into Metalink and started searching for an answer.  Why would anyone want to search the help?  If you don’t fancy my preferred diagnostic method of blindly poking around you too can search Metalink for knowledge base article 826673.1.

And the thing of it is, Tim Tow has documented this error and its fix for, oh, forever, maybe?  A long time certainly.

If you can’t be bothered to read any of the explanations, here’s the quick and dirty Windows fix (the same issue affects *nix, but not very much and while the concept applies to that OS, the mechanics below do not):
1)    Go into Windows Registry editor on the Essbase server.
2)    Navigate to the following key:  HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
3)    Right click and select New or Edit->New and then select DWORD Value.
4)    The name should be MaxUserPort.
5)    Right click on the new “MaxUserPort” and edit the DWORD value. Enter a decimal value of 65534.  You have just increased the number of ephemeral ports to their maximum value.
6)    Again create a new DWORD Value.  Call it TcpTimedWaitDelay.  Set it to a decimal value of 30.  You have now decreased to the minimum the time Windows will take to release a port.
Your registry settings should look like this when you’re done.
7)    Reboot the Essbase box after stopping your various services – you know the boot order.
8)    After starting the Oracle EPM services back up, try doing a refresh.  You should have bottled magic at this point.

NB – The Metalink instructions go on about adding MaxFreeTcbs and setting that the decimal value to 6250.  That wasn’t necessary in my case.

Why might you not see an error?

Maybe the registry settings are already there and you don’t know it. 

Maybe you have small user communities and you never blow through Windows ephemeral ports.

Maybe you just can’t believe that this issue exists almost a decade after Hyperion Planning 1.0 was released on an unsuspecting world.

Maybe you’re on 11.1.2 and are using Windows 2008 which has a larger ephemeral port range.  Yes, despite Essbase.sec’s almost complete emasculation in this release, filters are still stored in good old Essbase.sec.

Maybe you’re running some version of *nix.

Maybe you’re just lucky.  :)

Phew, this is a problem I never want to revisit.  Thanks again, Justin, for finding the answer.

Popular Posts