BO Universe Prompt doesn’t filter Multi byte Characters – Crystal Reports

A lot of times we create crystal reports on Business Objects Universes. We use the condition objects with @prompt to filter out data on particular columns. Sometimes we have multi byte characters in Databases like Japanese, Chinese characters which don’t get filtered properly unless the IsUnicode radio button is enable.

So for Reports built for multiple languages, this radio button is pretty mandatory. Also enable the Property IsUnicode at the universe parameters to be on the safer side. This appends an ‘N’ before fields of nvarchar datatype.

 

Papercraft – MV-101(Personal Marine Transport)

Hi,

Here is yet another paper craft item I have created a few weeks ago. This time it is of a marine transport vehicle.

Backstory: The MV-101 is used for quick insertion and exit of micro teams inside enemy territory. The craft can accommodate only one person.  This vehicle was never intended for combat. The craft is tuned for high speed in contrast of combat. No weapons installed means lighter weight coupled with high power twin turbine engines give it high speed and nimbleness. Armed forces around the world have customized this craft to add firepower like rockets and mini-guns.

 

Papercraft – VT-31(VTOL)

VTOL is short for Vertical Take Off and Land Aircraft. Besides Helicopters certain aircraft have this capability. The sea harrier, f-35 are some examples.

My Version of a VTOL named VT-31 from future.

Backstory: The VT-31 is a single pilot craft with align able boosters to help vertical take offs and landings. Mostly used for Recon this VTOL provides a quick way to enter and exit points of Interest. Although not built for combat, a VT-31 can be used for preliminary defense. Some variants have lock on air to air/air to surface missiles and pulse projectile guns. Few law enforcement agencies use the VT-31 as a workhorse for urban warfare.

Papercraft – Orbital Escape Pod

Starting today, I’ll be periodically sharing some of the origami/paper craft I do in my free time.  Most of the paper craft is fictional material and mostly sci-fi. Hope you find it good.

The first one is of an Orbital Escape pod.

Backstory: Dangers of Inter planetary travel include space garbage, bounty hunters, stellar material. Escape pods are mandatory in all carriers starting from space frigates to Ships. The Orbital Escape pod illustrated below has enough fuel for 8 days of stellar flight and stabilizers to help drifting. It also has laser and radio communication. On board there is one detachable phasor cannon that can be used in flight and on land.

Return to Sender

Is it just me or does anyone else send emails to themselves? No I do not have a split personality disorder! I do this when I want to preserve something for future references. I send a lot of stuff to myself like pics, huge amounts of text, Web Links, Work Stuff etc., So, When I look at my email it seems like I can see a chronicle of how my taste in various things improved or degenerated. To me this is a good way of having information lying around.

Ok., Ok. So as you know from my blogs that I dabble in day dreaming and Time Travel and then both, I imagine what would it be like if I could contact my past self through email(Why this can be plausible is explained at the end – Reading that content is optional to avoid bloodshed). So below is the transcript of my emails from my future self to me.

__________________________________________________________________________________________

From: Me <Me@email.com>
Sent Date: Fri, Dec 9, 2022 at 8:00 PM
Subject: Cracked the Time Continuum
To: Myself <Me@email.com>

Hey,

Just solved the biggest mystery. Will send you details…..

__________________________________________________________________________________________

After a few days,

From: Me <Me@email.com>
Sent Date: Sun, Dec 9, 2023 at 8:00 PM
Subject: RE : Cracked the Time Continuum
To: Myself <Me@email.com>

Hello again,

Built the time machine. It cost me..oops us a fortune. Meet you at our school ground on Dec 9 2015. See you there.

__________________________________________________________________________________________

Few days later,

From: Me <Me@email.com>
Sent Date: Mon, Dec 10, 2023 at 8:00 PM
Subject: RE : Cracked the Time Continuum
To: Myself <Me@email.com>

What the hell,

You didn’t turn up, Are you so lazy that you wouldn’t turn up to meet your future self. All the knowledge you could get from me wasn’t important than your Sunday morning sleep. Lets try this again, all right.  Dec 10, its a monday. Be there.

__________________________________________________________________________________________

Again.,

From: Me <Me@email.com>
Sent Date: Mon, Dec 11, 2023 at 8:00 PM
Subject: RE : Cracked the Time Continuum
To: Myself <Me@email.com>

Ok., this isn’t funny. What part of this extraordinary phenomenon don’t you understand. You turned up but saw the ice cream vendor and ran after him. I can’t believe you invented the time machine. Lets do this again, lets meet up at your house on Dec 11.  Please make it this time, I only have fuel for one more trip.

__________________________________________________________________________________________

Subsequently.,

From: Me <Me@email.com>
Sent Date: Tue, Dec 12, 2023 at 8:00 PM
Subject: RE : Cracked the Time Continuum
To: Myself <Me@email.com>

OH MY FRACKING GOODNESS!!!!! You went to office on that day….seriously oh my god, how retarded are you.

__________________________________________________________________________________________

After all this I send out a reply to my future self,

From: Myself <Me@email.com>
Sent Date: Wed, Dec 12, 2011 at 8:00 PM
Subject: RE : Cracked the Time Continuum
To: Me <Me@email.com>

I have been trying to reach you. I sent myself a bucket load of emails so that you could see them in future. Didn’t you get them?

__________________________________________________________________________________________

Single line Reply:

From: Me <Me@email.com>
Sent Date: Thu, Dec 14, 2023 at 8:00 PM
Subject: RE : Cracked the Time Continuum
To: Myself <Me@email.com>

All your mail went to spam folder………

__________________________________________________________________________________________

THE END

Image Coutesy: Live, Nerd, Repeat. Thanks Bro.,

Why this can be plausible: It is known that sub atomic particles in the large hadron collider sometimes move escape into different time due to large velocities. On the information highway, electrons do travel with the speed of light and some packets of data may get transferred although not with the same fidelity. But I will need to test this :).

Weekend Meltdown

Aah., its that time of the week. Time when my brain prepares it shutdown routines….

I imagine little people working in my brain, akin to a Nuclear Power Plant. Mind you its a private enterprise and not a government run plant(Vanity is my vice). Anyways, I think there are mangers, engineers, support, maintenance personnel in there. Every Friday 8:00 pm a siren kicks off when I press the windows and the L keys simultaneously and on cue the managers ping the support staff to commence shut down activities. The support guys go over the checklists and ping maintenance personnel for the go-ahead sign offs. The maintenance staff calls on the engineers to be on site to oversee the whole thing.

The shutdown process kicks off and people start shutting down the brain. I imagine lots of valves turned, buttons pressed and finally the President and the EVP pull out the keys and high level authorization codes they have in the steel brief cases handcuffed to their right hands(no points for guessing why right hands. Sorry for the potty humor). They enter the codes and turn the keys simultaneously and the brain is shut down. After a small cake cutting everyone leaves. Now all the Executive staff goes home to their families while the young-ins go off clubbing and pub hopping at cerebellum, and the hypothalamus and the synapse chain of restaurants. Every one is just happy to leave my brain. Even I don’t pick up my brain’s phone calls during weekends.

But some medieval Chinese guy said “Every Dog has its day” followed by “Today is not yours” while looking at a stray dog and subsequently relishing a doggy biryani. My brain one-ups me as somehow my Batman Arkham City game pulls me toward it. The brain says to me “look who came crawling back on a weekend”. The staff at my brain is called on an emergency hotline and they prepare for a tough weekend. There are somehow no comp-offs for those guys. I don’t even think they have a decent pension plan or insurance. Yet by the grace of god I didn’t have any meltdowns in the past.

I need to plan some incentives for the guys!!!!!! May be a long morale boosting email would be good….

hawleywood ke dialagaan

Some of the most awesome Hollywood dialogues in Hyderabadi….

Terminator Series: I’ll be back….

Main wapas aatuw…

300:  Tonight we dine in Hell….

Raatku Jahannam main daawat karingey

Casablanca: Of all the gin joints in all the towns in the world she walks into mine

Duniya bhar ke Saarey gaawan ke Sharaab khaanon main, mere ismeich challeko aayi

Scarface: Say “hello” to my little friend!

Merey chotey pattthey ko hallo bolo.

Forrest Gump: Mama always said life was like a box of chocolates. You never know what you’re gonna get.

Amma boley zindagi chacklet ka dabba hai. Kya milta ki kya maloom….

DB Session Management

Session Management is very important for Database Administrators. Hosting a database is not always fun as people accessing the database can do all kinds of stuff to it. These sessions need to be sometimes killed for the greater good. Below is session management for a few databases.

For Oracle Database Session Management;

Make sure you are have admin credentials. Use V$Session View for Session Management for Oracle Database.

select * from v$session;

or specifically

select sid,serial#,username,machine,program from v$session; to avoid unnecessary complicated data.

Now to kill the unnecessary session. Using the SID and Serial # of the session you can kill the session as below;

alter system kill session ‘SID,Serial #’;

e.g., alter system kill session ‘13,10196’;

For MS SQL Server 200x;

SQL Server has the simplest Session monitoring there is. Connect to the DB server from SQL Server Management Studio. Right Click on the Server and select “Activity Monitor”. In the resulting window expand the “Processes” pane to get the sessions running. Right click on the desired pesky session and select “Kill Process”.

I will add other Databases session management info soon….

Fragship

Whats “Fragship” you say? Its Fragging Friendship…. This is the kind of friendship you see between two gamers or two friends who are gaming.

Every gamer has Fragship stories…….Here are some of mine.

• Foot boards; Friends playing Need for Speed 2 with feet instead of hands over an irritating roommate’s PC.
  
• Princess is in another Castle; A friend losing a life at the end of the lava stage and the entire classroom who were concentrating on his screen gasps “oooooh” bewildering the tutor.
  
• In the land of the Blind, the guy with one eye is the king; Playing Unreal Tournament with my friends: Always hogging the invisible power and then camping on the skyscraper and sniping the hell out of everyone.
• No one gets left behind; Playing Army of Two with a friend who always leaves me behind and rushes of ahead.
• Mind Blowing; Achieving a Head shot through sniper scope zoomed in on the enemy while a friend is having dinner much to his discomfort.
• King of the Hill; Having a score of 21-24 in a 25 kill death match and getting 4 kills with a vehicle and winning the match at 3 am in the morning.
• Of mice and Men; Playing an online fps on a buddy’s laptop using his track pad and him letting me do it.

Gaming rocks but friends rock harder……

Thanks Ashu, Nagar, Sravan, Venky, Vijay, Bhanu, Anil and many more….

Writer’s Block

Sorry I can’t post stuff due to other commitments., Hopefully I will be back to my crazy antics soon…..