BookmarkSubscribeRSS Feed
felyp222
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" />
</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

2 REPLIES 2
ShelleySessoms
Community Manager

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
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
  • 925 views
  • 1 like
  • 2 in conversation