<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Set up  appender to write events to an Oracle Table in Administration and Deployment</title>
    <link>https://communities.sas.com/t5/Administration-and-Deployment/Set-up-appender-to-write-events-to-an-Oracle-Table/m-p/310656#M6506</link>
    <description>&lt;P&gt;This type of question is best answered by SAS Technical Support: &lt;A href="http://support.sas.com/techsup/contact/" target="_blank"&gt;http://support.sas.com/techsup/contact/&lt;/A&gt;. Best of luck to you, and thank you for using the SAS online communities.&lt;BR /&gt;&lt;BR /&gt;Shelley Sessoms&lt;BR /&gt;Online Community Manager&lt;/P&gt;</description>
    <pubDate>Thu, 10 Nov 2016 13:46:15 GMT</pubDate>
    <dc:creator>ShelleySessoms</dc:creator>
    <dc:date>2016-11-10T13:46:15Z</dc:date>
    <item>
      <title>Set up  appender to write events to an Oracle Table</title>
      <link>https://communities.sas.com/t5/Administration-and-Deployment/Set-up-appender-to-write-events-to-an-Oracle-Table/m-p/310026#M6479</link>
      <description>&lt;P&gt;I setup an appender in logconfig.xml in order to&amp;nbsp;write&amp;nbsp;events to an Oracle Table.&lt;/P&gt;&lt;P&gt;I created a table with 4 rows &amp;nbsp;in Oracle and after I restart the metadata server no events are loaded in Oracle. In metadata log I see no error message, even so no data are loaded in the table. Here is the appender and the appender ref is under ROOT&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;&amp;lt;!-- Oracle Appender --&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;lt;appender name="LoggingTimeFile" class="DBAppender"&amp;gt;&lt;BR /&gt;&amp;lt;param name="ConnectionString" value="DRIVER=oracle;UID=user1; PWD='****';PATH='path';CATALOG=oracle_log" /&amp;gt;&lt;BR /&gt;&amp;lt;param name="MaxBufferedEvents" value="300" /&amp;gt;&lt;BR /&gt;&amp;lt;param name="TableName" value="LOG" /&amp;gt;&lt;BR /&gt;&amp;lt;param name="Column" value="sn" /&amp;gt;&lt;BR /&gt;&amp;lt;param name="Column" value="d" /&amp;gt;&lt;BR /&gt;&amp;lt;param name="Column" value="c" /&amp;gt;&lt;BR /&gt;&amp;lt;param name="Column" value="m" /&amp;gt;&lt;BR /&gt;&amp;lt;/appender&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;&amp;lt;!-- &amp;nbsp;Successful User Login --&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;lt;appender name="SuccLogin" class="FilteringAppender"&amp;gt;&lt;BR /&gt;&amp;lt;appender-ref ref="LoggingTimeFile" /&amp;gt;&lt;BR /&gt;&amp;lt;filter class="AndFilter"&amp;gt;&lt;BR /&gt;&amp;lt;param name="AcceptOnMatch" value="true"/&amp;gt;&lt;BR /&gt;&amp;lt;filter class="StringMatchFilter"&amp;gt;&lt;BR /&gt;&amp;lt;param name="StringToMatch" value="New client connection"/&amp;gt;&lt;BR /&gt;&amp;lt;param name="AcceptOnMatch" value="true"/&amp;gt;&lt;BR /&gt;&amp;lt;/filter&amp;gt;&lt;BR /&gt;&amp;lt;filter class="StringMatchFilter"&amp;gt;&lt;BR /&gt;&amp;lt;param name="StringToMatch" value="accepted"/&amp;gt;&lt;BR /&gt;&amp;lt;param name="AcceptOnMatch" value="true"/&amp;gt;&lt;BR /&gt;&amp;lt;/filter&amp;gt;&lt;BR /&gt;&amp;lt;filter class="DenyAllFilter" /&amp;gt;&lt;BR /&gt;&amp;lt;/appender&amp;gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;can you please give me a hint what i'm doing wrong?&lt;/P&gt;&lt;P&gt;In what log can I check more details?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thank you&lt;/P&gt;</description>
      <pubDate>Tue, 08 Nov 2016 11:38:39 GMT</pubDate>
      <guid>https://communities.sas.com/t5/Administration-and-Deployment/Set-up-appender-to-write-events-to-an-Oracle-Table/m-p/310026#M6479</guid>
      <dc:creator>felyp222</dc:creator>
      <dc:date>2016-11-08T11:38:39Z</dc:date>
    </item>
    <item>
      <title>Re: Set up  appender to write events to an Oracle Table</title>
      <link>https://communities.sas.com/t5/Administration-and-Deployment/Set-up-appender-to-write-events-to-an-Oracle-Table/m-p/310656#M6506</link>
      <description>&lt;P&gt;This type of question is best answered by SAS Technical Support: &lt;A href="http://support.sas.com/techsup/contact/" target="_blank"&gt;http://support.sas.com/techsup/contact/&lt;/A&gt;. Best of luck to you, and thank you for using the SAS online communities.&lt;BR /&gt;&lt;BR /&gt;Shelley Sessoms&lt;BR /&gt;Online Community Manager&lt;/P&gt;</description>
      <pubDate>Thu, 10 Nov 2016 13:46:15 GMT</pubDate>
      <guid>https://communities.sas.com/t5/Administration-and-Deployment/Set-up-appender-to-write-events-to-an-Oracle-Table/m-p/310656#M6506</guid>
      <dc:creator>ShelleySessoms</dc:creator>
      <dc:date>2016-11-10T13:46:15Z</dc:date>
    </item>
    <item>
      <title>Re: Set up  appender to write events to an Oracle Table</title>
      <link>https://communities.sas.com/t5/Administration-and-Deployment/Set-up-appender-to-write-events-to-an-Oracle-Table/m-p/311334#M6517</link>
      <description>Thank you Shelley Sessoms!&lt;BR /&gt;I'll do so.&lt;BR /&gt;&lt;BR /&gt;Have a nice day</description>
      <pubDate>Mon, 14 Nov 2016 07:24:04 GMT</pubDate>
      <guid>https://communities.sas.com/t5/Administration-and-Deployment/Set-up-appender-to-write-events-to-an-Oracle-Table/m-p/311334#M6517</guid>
      <dc:creator>felyp222</dc:creator>
      <dc:date>2016-11-14T07:24:04Z</dc:date>
    </item>
  </channel>
</rss>

