<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size: 12pt; color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif, "EmojiFont", "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols;" dir="ltr">
<p style="margin-top:0;margin-bottom:0">Hello,</p>
<p style="margin-top:0;margin-bottom:0"><br>
</p>
<p style="margin-top:0;margin-bottom:0">I have configured syslog.ng OSE version 3.5.3 <span> to log to a MSSQL destination and that all works well.</span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span>However when I have specified 2 MSSQL destination, same SQL Server, same table on different database, syslog-ng have problem to insert on database, <span id="result_box" class="short_text" lang="en"><span class="">both
on the first and on the second.</span></span></span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span>Some time will insert, sometimes not.</span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span>On /var/log/syslog I have found some lines reporting error CREATE TABLE on the second database,<br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span>Restarting the service, <i>sudo service syslog-ng restart,</i>
<span id="result_box" class="short_text" lang="en"><span class="">takes a long time.</span></span></span></p>
<p style="margin-top:0;margin-bottom:0"><span><span id="result_box" class="short_text" lang="en"><span class=""><br>
</span></span></span></p>
<p style="margin-top:0;margin-bottom:0"><span><span id="result_box" class="short_text" lang="en"><span class="">When I comment out the destination of the 2nd database, syslog-ng run very well.<br>
</span></span></span></p>
<p style="margin-top:0;margin-bottom:0"><span><span id="result_box" class="short_text" lang="en"><span class=""><br>
</span></span></span></p>
<p style="margin-top:0;margin-bottom:0"><span><span id="result_box" class="short_text" lang="en"><span class="">Is it a limit of the OSE version? Or may be an error on the configuration file?<br>
</span></span></span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span>See attached my configuration file.</span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span>Thank you for the patience.</span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span>-----------------------</span></p>
<p style="margin-top:0;margin-bottom:0"><span>Garry De Toffoli</span></p>
<p style="margin-top:0;margin-bottom:0"><span>-----------------------</span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span><br>
</span></p>
<p style="margin-top:0;margin-bottom:0"><span></span><br>
</p>
</div>
</body>
</html>