Thread: Handling metadata errors in ODI/Planning

This question is answered.


Permlink Replies: 5 - Pages: 1 - Last Post: Sep 27, 2009 4:55 AM Last Post By: JohnGoodwin
CL

Posts: 1,132
Registered: 08/06/07
Handling metadata errors in ODI/Planning
Posted: Sep 16, 2009 7:21 AM
 
Click to report abuse...   Click to reply to this thread Reply
I debated between putting this question onto the ODI forum or here but as the world-famous John Goodwin so dominates this board, I thought I’d post it here. :)

How are people handling Planning dimension builds in ODI wrt error handling within packages?

My goal is to only send exception emails when a problem occurs. I am automating this via packages compiled to scenarios.

I have found that a genuine error in an interface will cause a trappable error in a package, e.g., the server name is really plan01.corpname.com and somehow the physical schema gets changed to bozotheclown.goaway.org. I can then send a failure email off.

I have also found that if I have a metadata error in a Planning dim build interface I can trap the errors to an error file. A bad record (syntactically correct, but its parent can’t be found, for instance) will generate an entry in the error file if I turn error logging on.

However, that bad record does not generate an ODI error in a package.

I thought about testing for the existence of this error file but the constant generation (from the LOG_ERRORS option in the IKM SQL to Hyperion Planning) of the error file regardless of bad record condition means that I can’t use the ODIFileWait control to test if the file is there or not.

I cannot find a way to test for the length of the file (if it is zero, there is no metadata error) within ODI.

I guess I could do it through an external script (Windows environment) but that is so wrong on so many levels that I can’t believe that is my only option.

Any thoughts? If you come up with an answer I’ll post it in my blog and give you all the credit. As if that were a real incentive…

Regards,

Cameron Lackpour
JohnGoodwin

Posts: 5,509
Registered: 10/09/07
Re: Handling metadata errors in ODI/Planning
Posted: Sep 16, 2009 8:41 AM   in response to: CL in response to: CL
Helpful
Click to report abuse...   Click to reply to this thread Reply
Hi Cameron,

I do have a few ways of checking if the error file exists/ has errors, it would probably be easier if I did a step-by-step with screenshots as I am not sure how well I could explain it on here, plus I do know you have a problem with understanding what I write ;)

Once I get a chance I will write it up.

Cheers

John
http://john-goodwin.blogspot.com/
CL

Posts: 1,132
Registered: 08/06/07
Re: Handling metadata errors in ODI/Planning
Posted: Sep 16, 2009 9:39 AM   in response to: JohnGoodwin in response to: JohnGoodwin
 
Click to report abuse...   Click to reply to this thread Reply
I do have a few ways of checking if the error file exists/ has errors, it would probably be easier if I did a step-by-step with screenshots as I am not sure how well I could explain it on here
If it really is that involved (what exactly in ODI is not involved?) for the time being I better just go with an NT cmd script that gets thrown into the mix and generates a new file (or not) depending on file length. Kludgy but effective. Now I just have to figure that out...

plus I do know you have a problem with understanding what I write
Ouch. :)

Once I get a chance I will write it up.
That would be awesome. Just keep the words simple for your American cousin(s).

The questions I hear about you are: does he float or walk, put on his pants two legs at time or just one, does he eat, is he from the future. Most imporantly, does he have a job beyond dominating OTN and that wonderful blog. :)

In all seriousness, you really have been a lifesaver for me and many others. Thanks again for your amazing work.

Regards,

Cameron Lackpour

P.S. I'm in favor of the Kaleidoscope John Goodwin day, too. You've got two ODTUG SIG board members on that Network54 thread asking for you to present (I'm one of them).
CL

Posts: 1,132
Registered: 08/06/07
Re: Handling metadata errors in ODI/Planning
Posted: Sep 26, 2009 12:42 PM   in response to: JohnGoodwin in response to: JohnGoodwin
 
Click to report abuse...   Click to reply to this thread Reply
Most definitely answered! http://john-goodwin.blogspot.com/2009/09/odi-series-handling-errors-with.html

I hope your employers/the Oracle EPM community appreciates you. You are a rock star. :)

If I could figure out how to award you the points on my own reply, I would.

Thanks again,

Cameron Lackpour

P.S. Not like it's exactly going to be overly special for you, but a promise is a promise: Why aren t you reading More To Life Than This
CL

Posts: 1,132
Registered: 08/06/07
Re: Handling metadata errors in ODI/Planning
Posted: Sep 26, 2009 1:11 PM   in response to: CL in response to: CL
 
Click to report abuse...   Click to reply to this thread Reply
Because I goofed when I clicked it. John Goodwin answered the question externally to OTN -- he certainly deserves the credit. Regards,

Cameron Lackpour
JohnGoodwin

Posts: 5,509
Registered: 10/09/07
Re: Handling metadata errors in ODI/Planning
Posted: Sep 27, 2009 4:55 AM   in response to: CL in response to: CL
Correct
Click to report abuse...   Click to reply to this thread Reply
All that hard work and you don't even give me any points ;) only joking it doesn't bother me.
It was a excellent question you raised and definitely needed covering and thanks for all the praise.

Cheers

John
http://john-goodwin.blogspot.com/
Legend
Guru Guru : 2500 - 1000000 pts
Expert Expert : 1000 - 2499 pts
Pro Pro : 500 - 999 pts
Journeyman Journeyman : 200 - 499 pts
Newbie Newbie : 0 - 199 pts
Oracle ACE Director
Oracle ACE Member
Oracle Employee ACE
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums