Author Archive for angraze

11
Jun
09

sqlplus : ORA-12154

I have been facing this issue with sqlplus for quite sometime and have been ignoring it with shortage of time as an excuse. But i couldn’t avoid any further given that i had to do lot of DB stuff recently and i needed it running fine.

Issue:

I have TOAD, SQL Developer and SQLPlus all installed. I was able to connect to my db using TOAD and SQL Developer without issues but whenever i tried connecting using SQLPlus with same db/schema/pwd it threw up following error message,

ORA-12154: TNS:could not resolve the connect identifier specified

Strange!!!. There aint any issue with tnsnames.ora or sqlnet.ora since it is being used by other tools and they work fine. I googled around and did checks here n there but no help.

Resolution:

I happened to read somewhere that some special characters like @ etc. have special meaning for sqlplus and using them in userid/password confuses it. I had an @ in my password and that was the reason for this error. I changed my pwd and it worked like charm. :)

 

23
Apr
08

GenX SDLC mindmap

GenX SDLC

I have tried to capture all essential things that different stakeholders in a software development project need to keep-in-mind for successful execution. If one does a careful study, s/he can find that there is nothing new mentioned here except for few best practices followed in agile style of software development. Its just a easier way to capture, convey and enforce. If we follow these few and simple things, most of our development projects can be saved. :)

If the image is not clear, please try to access the image URL directly.

22
Apr
08

Go Green Save Earth

This is a small contribution from my side towards saving energy on this Earth Day. I understand that computer screens take lot less power to display darker pages than lighter ones. So i am changing my blog design to prominently contain darker shades. My apologies to all if you find this look and feel a little less appealing or pleasing. But isn’t it still a better deal  given that it will contribute towards a greater cause.

Did you know that Google has a darker variant of its site? You may like to use that next time you want a search engine. Go Green.

26
Dec
07

Indiaplaza.in : Tall claims, bitter realities

This is for all tech savvies who like to shop online, my personal experience with IndiaPlaza.in who claim themselves to be the “finest virtual supermarket” of India. I bought few gift items online to be delivered as Rakhi gift to my little sister. The order had items destined for different shipment locations. The items for Bangalore reached to me within a week. But items which were destined for smaller towns in Orissa went through a lot of turbulence and finally never really reached. Below is a recount of the sequence of events that unfolded in the process of getting my items delivered, before finally i give up on it and lost the entire money.

I placed the order on 23rd Aug 2007. The sequence of events since then,

  1. There was no communication regarding the order for about two weeks. I sent a mail to customer care.
  2. I do not have the exact mail chain of what happened in the initial one month. So i am not mentioning explicitely here. But if i remember correctly there were conflicting statements from different people in customer care about the status of order. In any case, they raised another order for the same item and sent me a mail of shipment on 20th Sep.
  3. I waited for three weeks without any communication from them. So i sent another mail on 16 Oct asking the status.
  4. I received a response next day. “Our sincere apologies for the delay and inconvenience caused. We have shipped the item Junior Tv Game of the order # 200920070030 through TNT courier. TNT does not have the service at your location and the item returned to its origin. We will ship the item through First Flight courier within 2 days. The same will reach to you within 3 days of reshipment.”
  5. Six days passed without any communication. I sent a stinker this time on 21st Oct.
  6. Got this response next day – “Please accept our sincere apologies for the delay and inconvenience caused. we would like to inform you that, The matter has been taken on priority and the same is being investigated. Kindly provide us time for a day to update you on the same. We request you to kindly treat this case in isolation and not as a true reflection of indiaplaza services to it’s valued Customers. Please feel free to revert for any information or clarifications.” They seem to be finally taking the matter in urgency. I have waited for two months anyways, so no harm in another few days.
  7. A couple of days later (Oct 25) they sent another mail. “Your order # 200920070030 for the ?Junior Tv Game? is delayed in delivery as the address is incomplete. We request you to revert to us with a complete or alternate address, so that we shall reship the above order. We apologize for the delay and inconvenience caused.” Ha ha ha. I have been sending parcels to that address through different courier companies. It suddenly became incomplete for this people.
  8. On Oct 26 i provided them an alternate address in a nearby bigger city.
  9. I got the following response the same day – “We would like to inform you that the order for the item ‘Junior Tv Game’ placed under order #200920070030 will be reshipped to the given alternate address.We have already instructed our shipment department to ship the item to the alternate address given.Shipment details will be given once the order is reshipped.” See the matter-of-fact tone in the email. There is still no urgency from their part even though they earlier promised that the matter will be taken up with urgency.
  10. I sent a reply to above mail on Oct 30 showing my frustration and asking for a refund.
  11. Another two weeks gone without any response from them.
  12. I sent a mail on Nov 14th asking the status.
  13. I got a response on Nov 22 that the item has been returned undelivered even at the new address. :) Looks like i need to find one address where they WANT to deliver. Nonetheless, the email said that they will refund the order price and deduct the shipment amount paid by me. So i made up my mind to at least recover the money and forget about delivery of gift to my sister.
  14. At this point enter their manager Lalita Jain (Customer Service), who sent me an apology mail (nov 16) about all the mess and promised to take a detail look into the problem and get back by Nov 19. She was the only person whose mails made me feel like a customer again, otherwise i was feeling like a prisnor fallen in a trap. I had my hopes raised again, but only for a short period.
  15. I did not get any mail from her. I waited till Nov 22 before sending another mail to know the status.
  16. She responded back on nov 22. “My apologies for the delay . We have canceled the order and the refund will reflect in your account in 5 business days.”.
  17. I got a mail next day mentioning that some xxx amount will be credited to my credit card. The refund amount mentioned was way below my order amount.
  18. I replied asking for clarification.
  19. Two days letter i got a response. My order was paid using a gift certificate and balance using credit card. So the gift certificate money will be credited to me as gift certificate and the rest as refund to my credit card. This was opposite of what i was told by Lalita Jain. She mentioned about refunding the entire order money to my credit card.
  20. I forwarded the mail to Lalita Jain. She replied on nov 26- “The below is an automated mail and since you had used a gift certificate to pay for the order, according to our refund policy the refund first goes into gift certificate. But in your case , the entire money will be refunded into your credit card.” First time it looked like they will go out of process in my case (they seem to accept troubling me) and do me a favor by paying entire money in cash/credit.
  21. Another mail from her on nov 30 – “The refund was rejected by the bank as the transaction was old. We will issue a cheque to you by monday.”.
  22. I did not want to get into another loop now. I requested her to deposite the money to my IndiaPlaza account. And she agreed to do so.
  23. I kept checking my IndiaPlaza account since their was no confirmation from them regarding any credit. However, they did deposit some amount on Dec 06. It was again less that what i was supposed to get.
  24. That was the last nail in the coffin. I decided to close the matter here itself and forget about the whole episode. So i sent this mail to Lalita Jain – “INR xxx/- is credited to my IndiaPLaza account, not INR yyy/-. Looks like there is a big disconnect between you and the team which supports the accounts. Unless i keep a constant watch, errors seem to keep happening. I pity the sorry state of affairs in an Indian Online shop. I am IT professional myself and have created many such websites for our international customers. But it feels bad when the sites are NOT supported by adequate/qualified backend staff and hence poeple do not rely on Indian sites. Its not that yyy rupees will make any difference to me. But i persisted with this loop to know exactly how an Indian online shopping site operates. I have a fare idea now and enough material for an article. You have been the only good thing in the entire episode.
  25. She responded – “I am sorry that your account was not credited with entire Rs.yyy. I will ensure that the difference of Rs.zzz is credited today itself. I have to agree with you that a good back end support team is required in a business like ours. This is our focus area and on a constant basis we keep improvising our processes and systems to improves or services.  I cannot assure you flawless execution but I can assure you at this point 110% redressal.. If you do happen to write an article on online shopping experience can I request you to send me the link or where it is published , so that I can read it too.”
  26. I have checked my account multiple times since then and it still reflects the reduced refund amount, not the amount i am entitled for.
I have left the matter here without any further persual. It took me 15 weeks, at least 30 emails and numerous phone calls to my sister during this entire unresolved saga. They credited a gift voucher to me which had very little time left for expiry. It stands expired now, which means that i did not get a single penny out of the order which was never delivered :)

My lessons from this episode are,

> There is a big disconnect between the different internal departments of the company. And you as a customer will not have enough time, energy and insight to keep all of them in loop and on same track. So always try to avoid to get into a situation where you would need their SERVICES(if at all you call it service). One of them being, DO NOT ship items to smaller towns.
> Their customer service is very very bad. You can see the mails above anyway. Also surprisingly i only got ONE call from them during this entire 15 weeks and it was to confirm that someone has responded to my eamils. No one from them took any initiative to talk to me about it, let alone verbal apologies. Run though the above sequence again. Twenty six steps and no results. Gosh….!!!
> They keep spamming your mailbox with new offers on their website even though you never asked them to do so.
Thats all. I have narreted my experince and bid a GoodBye to this website. God bless customers of this “FINEST virtual supermarket”.
21
Dec
07

Issue with RSA/RAD 6.0.0.1 in XP

I was given licenses of both RSA and RAD version 6.0.0.1 from my customer. well, if the version numbers sound prehistoric, so be it. I cant help it. Neither could anybody help me when i ran into multiple issues one after another with these. I will discuss one issue here because i did not find a single reference on internet about this.

When i install RSA/RAD on Win XP, i have the option to choose the installation of integrated websphere runtime environment. This helps in local development by providing hot deployment, local test server and other debugging features. At the end of installation i get a message that my RSA/RAD installation was successful but installation of integrated test environment failed, of course without any meaningful error message (not that i expected one). A bit of googling did provide a couple of references all asking me to apply patches and upgrade the version to 6.0.1.2. Apparently it was a known limitation of XP and hence an upgrade was required, as per a link provided by IBM. I followed this link to download the patch and for installation instructions.

The patch download size is 3.2 GB only. [Can you believe it? A patch size in GBs for a mere java IDE?]. Anyways, i had no option but to download. So i did. But even the patch installation failed. I didnt get any favorable google hits this time and all roads seemed blocked. Only option was to contact support and wait. I raised a discussion about this with one of my friend and an idea occurred to us. I had the RSA/RAD installable copied into a network share drive so that everyone could install it easily[it is an enterprise lic, so no isses with that :) ]. I was trying to install directly from there. Instead, i mapped the network share as a local drive and tried installing from there. Surprisingly it worked and installation was successful. :)

No idea why, but it worked. Now i am busy with other gifts of this tool. :)




History

Blog Stats

  • 125,713 views

Bookmarks