Architecting, installing and maintaining your SAS environment

Set up appender to write events to an Oracle Table

Reply
Occasional Contributor
Posts: 7

Set up appender to write events to an Oracle Table

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

Community Manager
Posts: 348

Re: Set up appender to write events to an Oracle Table

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

Occasional Contributor
Posts: 7

Re: Set up appender to write events to an Oracle Table

Thank you Shelley Sessoms!
I'll do so.

Have a nice day
Ask a Question
Discussion stats
  • 2 replies
  • 263 views
  • 1 like
  • 2 in conversation