Set up appender to write events to an Oracle Table

[felyp222]

I setup an appender in logconfig.xml in order to write events to an Oracle Table.

I created a table with 4 rows  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

<!-- Oracle Appender -->

<appender name="LoggingTimeFile" class="DBAppender">
<param name="ConnectionString" value="DRIVER=oracle;UID=user1; PWD='****';PATH='path';CATALOG=oracle_log" />
<param name="MaxBufferedEvents" value="300" />
<param name="TableName" value="LOG" />
<param name="Column" value="sn" />
<param name="Column" value="d" />
<param name="Column" value="c" />
<param name="Column" value="m" />
</appender>

<!--  Successful User Login -->

<appender name="SuccLogin" class="FilteringAppender">
<appender-ref ref="LoggingTimeFile" />
<filter class="AndFilter">
<param name="AcceptOnMatch" value="true"/>
<filter class="StringMatchFilter">
<param name="StringToMatch" value="New client connection"/>
<param name="AcceptOnMatch" value="true"/>
</filter>
<filter class="StringMatchFilter">
<param name="StringToMatch" value="accepted"/>
<param name="AcceptOnMatch" value="true"/>
</filter>
<filter class="DenyAllFilter" />
</appender>

can you please give me a hint what i'm doing wrong?

In what log can I check more details?

Thank you

[ShelleySessoms]

This type of question is best answered by SAS Technical Support: http://support.sas.com/techsup/contact/. Best of luck to you, and thank you for using the SAS online communities.

Shelley Sessoms
Online Community Manager

[felyp222]

Thank you Shelley Sessoms!
I'll do so.

Have a nice day