Skip to main content
  • EN

My translation writes features to spatial and non spatial Oracle tables in a given order.

The problem is that any eventual DB related error should be reported to a web service and also logged to an xls file.

I'm using Featurewriters to control the writing order ​but the Featurewriter transformer has no Rejected port. How do I catch DB errors then?

SQLExecutor is fine for non spatial tables but not for spatial tables with complex geometries (due to the character number limitation for sql statements).​

Should I keep the Featurewriter approach and use a shutdown python script to catch DB errors and do the Excel and web service part​? Is there any other option?

Thanks for the help.​

​

Unfortunately this is a known weakness with the FeatureWriter, please consider adding your vote here: https://community.safe.com/s/idea/0874Q000000TkwiQAC

I would've used FeatureWriter + Python for this. You could also consider wrapping your workspace into a second (master) workspace, in which you could e.g. analyze the logs messages output from the FeatureWriter.

Unfortunately this is a known weakness with the FeatureWriter, please consider adding your vote here: https://community.safe.com/s/idea/0874Q000000TkwiQAC

I would've used FeatureWriter + Python for this. You could also consider wrapping your workspace into a second (master) workspace, in which you could e.g. analyze the logs messages output from the FeatureWriter.

I'm voting right away.​

Thanks!​

Reply


Community Stats

30,121
Posts
114,328
Replies
37,749
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.