Home » Developer & Programmer » Warehouse Builder » Log mapping failure
Log mapping failure [message #177544] Thu, 15 June 2006 07:45 Go to next message
gnuda
Messages: 5
Registered: June 2006
Junior Member
Hi.

I have a mapping where we do an error check. We have set the Maximum number of errors variable to 0 so that if an error occures that we don't handle the mapping should fail.
First i wonder if a Post Mapping Process will execute even if this happens. And if it it executes...is there any way to get a variable or somethin in to it that says 'FAILURE'.

In my post mapping process i run a stored procedure that logs the execution. If it succeeds it should write 'FINISHED' and if the above happens it should write 'FAILURE'.

Greatful for any help.
Re: Log mapping failure [message #177680 is a reply to message #177544] Fri, 16 June 2006 01:28 Go to previous messageGo to next message
Maaher
Messages: 7045
Registered: December 2001
Senior Member
That would be something you do in the Workflow rather than the post mapping process.

MHE

[Updated on: Fri, 16 June 2006 01:28]

Report message to a moderator

Re: Log mapping failure [message #177683 is a reply to message #177680] Fri, 16 June 2006 01:32 Go to previous messageGo to next message
gnuda
Messages: 5
Registered: June 2006
Junior Member
OK...I do log the work flow the same way...byt i want to log the mapping as well.


Should I Use a Transformation activity in the workflow to execute my log proedure in the work flow instead?
Re: Log mapping failure [message #177691 is a reply to message #177683] Fri, 16 June 2006 02:06 Go to previous messageGo to next message
Maaher
Messages: 7045
Registered: December 2001
Senior Member
I'm not sure about this (comes from memory, I don't have OWB near me right now) but if the mapping fails will the post mapping process be executed? I doubt it. So, no logging. I think you have to use a transformation, yes. But again: I am not sure but I *think* that's how we logged mappings.

MHE
Re: Log mapping failure [message #177710 is a reply to message #177691] Fri, 16 June 2006 03:19 Go to previous message
gnuda
Messages: 5
Registered: June 2006
Junior Member
You can set the mapping to execute postmapping on success, on error and always...so that works....But i think i will do another kind of logging instead....
but still...thank you
Previous Topic: Get inserted rows/get processed rows
Next Topic: OWB 9.2 32-bit design repository (windows 2000 server) and combined 32/64 bit runtime rep.
Goto Forum:
  


Current Time: Sat Aug 23 11:20:10 CDT 2014

Total time taken to generate the page: 0.09501 seconds