Skip to main content
  • EN

Hey FME Community!

I'm working on a project where I need to write logfile "ERROR" messages to a database attribute table. Specifically, I want to capture the time of writing data whenever an error occurs, and then collect that error information into the database attribute table.

I'm wondering if anyone has experience or suggestions on how best to achieve this within FME. Are there any transformers or workflows you've used successfully for similar tasks? Any insights or advice would be greatly appreciated!

Looking forward to hearing from you all and learning from your expertise!

Hi vishnunv

Perhaps a workflow using a Timestamper to capture the datetimenow() function, follow this with a DatetimeConvertor if you need to make the date ISO format.

After the logger, add a FeatureWriter transformer and point it to the database and the featuretype will be the table name. From here you need to consider the table operations, which may always be simply INSERT and use existing. Under the user attributes, each the attribute definition to match the destination. You may need an attributerenamer before the FeatureWriter if you need to align the columns between the workflow and the destination database

Perhaps the LogMessageStreamer could be helpful here, it lets you “listen” for messages in the FME log and lets you capture and process those that interest you, e.g. by saving them to a database log table.

Reply


Community Stats

30,354
Posts
115,364
Replies
38,091
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.