BookmarkSubscribeRSS Feed
Fluorite | Level 6

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" />

<!--  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 class="StringMatchFilter">
<param name="StringToMatch" value="accepted"/>
<param name="AcceptOnMatch" value="true"/>
<filter class="DenyAllFilter" />


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

In what log can I check more details?


Thank you

Community Manager

This type of question is best answered by SAS Technical Support: Best of luck to you, and thank you for using the SAS online communities.

Shelley Sessoms
Online Community Manager

Fluorite | Level 6
Thank you Shelley Sessoms!
I'll do so.

Have a nice day

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1 like
  • 2 in conversation