web stats
Failed to write to database - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Thread Tools Display Modes
Old 08-31-2015, 09:01 AM
themochael themochael is offline
OBX.2 Kenobi
Join Date: Sep 2013
Posts: 54
themochael is on a distinguished road
Default Failed to write to database

I have a channel built that queries a MS SQL database and writes to an OpenEdge Progress database. I consulted with a progress DBA and they tell me my syntax is correct, however, Mirth throws the error:

[2015-08-31 11:55:42,971] ERROR (com.mirth.connect.connectors.jdbc.DatabaseDispatc her:113): An error occurred in channel "TEST_Direct": Failed to write to database
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or about "'p1m0-prov-no', 'p1m0-prov-lst-nm', 'p1m" (10713)

Mirth 3.2.2
Attached Files
File Type: xml TEST_Direct.xml (32.5 KB, 16 views)
Reply With Quote

database writer, mirth 3.2.1

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -8. The time now is 07:30 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation