Lookup error throwing capabilities

[Former Member]

Hi Gurus,

Help me by giving some good solutions for the below requirement:-

I am using a JDBC lookup in my scenario. Now, I want to implement some error throwing capabilities in the same.

For eg:- If the lookup was not excuted because of the connection failure, or the data was not fetched as a result of the lookup, then some exception should come up in the monitoring.

Thanks in advance.

Neetesh

[Former Member · Accepted solution]

hi,

Throw an exception in your Lookup UDF function. Create also an alert which will be send in case of error in the mapping.

Regards,

Wojciech

[Former Member · Accepted solution]

Hi Prakash / Wojciech

Can you guys send me some documents which can be a little helpful in this context?

My feeling is that I can use the exception message in the mapping UDF.

Also, I am trying to use the concept of throwing exceptions from the graphical mapping (ref:- /people/alessandro.guarneri/blog/2006/01/26/throwing-smart-exceptions-in-xi-graphical-mapping by Alessandro Guarneri), but I am facing some problems while I am trying to run the UDF.

It shows an error in the code line -- "ExceptionThrower.fire()".

Error message is -- "cannot access <packagename>.ExceptionThrower" and "please remove or make sure it appears in the correct subdirectory of the classpath ... ExceptionThrower.fire(Message[0])"

Can you have a look and suggest for a solution.

Thanks in advance.

[Former Member · Accepted solution]

Hi,

Here is some information about alerts ;):

/people/michal.krawczyk2/blog/2005/09/09/xi-alerts--troubleshooting-guide

/people/michal.krawczyk2/blog/2005/09/09/xi-alerts--step-by-step

/people/ginger.gatling/blog/2005/12/02/innovative-ways-to-use-alerts

/people/bhavesh.kantilal/blog/2006/07/25/triggering-xi-alerts-from-a-user-defined-function

/people/alessandro.guarneri/blog/2006/01/26/throwing-smart-exceptions-in-xi-graphical-mapping

/people/michal.krawczyk2/blog/2005/03/13/alerts-with-variables-from-the-messages-payload-xi--updated

http://help.sap.com/saphelp_nw04/helpdata/en/dc/6b7f2243d711d1893e0000e8323c4f/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/68/253239bd1fa74ee10000000a114084/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cf/f2bbc8142c11d3b93a0000e8353423/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/5d/2166e6a91d11d188de0000e8216438/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/05/bb223905b61b0ae10000000a11402f/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/33/4a773f12f14a18e10000000a114084/frameset.htm

Regarding this error, please first import archive with this class. Afterwards import correct package in UDF. And of course remember that in java you end line with ; not .

Regards,

Wojciech

[former_member206604]

Hi,

Just an idea in the UDF just throw a exception (throw Java exception ) with some description in the Trace objects. This would obviously throw an error in moni.

Regards,

Prakash