I added a database writer destination to a working mirth channel. The destination is not writing to the table like it is supposed to, but it is not generating errors on the dashboard. I'm not really sure how to get it to work.
Here are the steps I have taken so far:
- changed the name of the table to a non-existing table // Does not generate error, suggesting that it does not even recognize the destination
- validator connector (successful)
- verified username/pw/URL are correct (I even cloned a working database writer from the same channel to try to get it to run)
- removed all filters (in case it was filtering for some reason)
- cloned the same transformer used in another working destination from the same channel
- allowed nulls in the SQL server database in case it was trying to insert nulls
- disabled/enabled channels. Started/restarted mirth. Opened/closed SQL server
I am not really sure what else there is to do. Any suggestions?