Tuesday, June 30, 2009

Problem vs Solution(s)

In the last couple of weeks I was trying to configure Oracle BI and informactica to run a full ETL for data transfer from Siebel Sales to Oracle Sales Analytics. I’m almost there but I had been posting some questions in forums to get some help with the configuration. Also, happen to skim through some threads for answers. One thing I noticed in all the threads was when people ask question on certain error people give solutions based on the knowledge or past experience even when it’s completely irrelevant to the problem posted. I agree that it depends on the question too. When you see a vague question in the thread you tend to give multiple solutions. But most of the times it happens even if you post the problem correclty. That got me thinking on interesting argument, how to approach a problem.
In the IT world you can either think of a solution that would fix the problem or identify the problem then think of a solution. I would say the later is better since it’s based on experience and ability but the first one is just based on a person experience. I don’t think it's just not IT field but it across all profession .When something is not working as expected try to identify the problem then just suggesting a solution.

I got this error when I was running a full ETL using DAC.I should say it took almost 4 hours to fix this but as always felt great when it worked.
ANOMALY INFO::: Failed:General error while executing ETL javax/mail/Authenticator
MESSAGE:::javax/mail/Authenticator
Solution :
Merge the Oracle BI Lib folder with DAC library folder.OOB Oracle BI library folder was missing mail.jar files so I got the above error..

BTW , this is my first post on Oracle BI .Later…