Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

PutSQL catch the SQL error

avatar
Contributor

Hi,

 

I am getting an error after the PutSQL processor (failure)

I there a way the catch the SQL error, I want to send it via LogMessage

 

Thanks

1 REPLY 1

avatar

Hi,

I dont think you catch the SQL error in the sense that PutSQL wont report the error. However you can use the PutDatabaseRecrod instead and use the failure relationship to LogMessage where you can access the error message using the "putdatabaserecord.error" attribute.

A better way of capturing errors from any processor (Global Catch) is to use the SiteToSiteBulletinReportingTask as explained here:

SiteToSiteBulletinReportingTask

 

If that helps please accept solution.

Thanks