Documentation corrections for BW 6.3.2 feature: Write process and activity stats to an external Database(DB).

Documentation corrections for BW 6.3.2 feature: Write process and activity stats to an external Database(DB).

book

Article ID: KB0093996

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Description:
This will be fixed in a Documentation update very soon. Till then please refer to the corrections below:

Current Documentation:

Edit the logback.xml file, located at BW_HOME/domains/<domain_name>/appnodes/<appspace_name>/<appnode_name>, and add the following appender:
<appender name="activityStatsDBAppender" class="com.tibco.bw.thor.management.stats.logback.db.BWActivityStatsDBAppender">
        <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource">
             <driverClass>org.postgresql.Driver</driverClass>
             <url>jdbc:postgresql://localhost:5432/bwadmindb</url>
             <user>bwuser</user>
             <password>bwuser</password>
    </connectionSource>
 </appender>

 <appender name="processInstanceStatsDBAppender" class="com.tibco.bw.thor.management.stats.logback.db.ProcessInstanceStatsDBAppender">   
    <connectionSource  class="ch.qos.logback.core.db.DriverManagerConnectionSource"> 
              <driverClass>org.postgresql.Driver</driverClass> 
              <url>jdbc:postgresql://localhost:5432/MyStatDB</url> 
              <user>postgres</user> 
              <password>test</password> 
    </connectionSource> 
 </appender> 

Corrected content

Edit the logback.xml file, located at BW_HOME/domains/<domain_name>/appnodes/<appspace_name>/<appnode_name>, and add the following appender:
<appender name="activityStatsDBAppender" class="com.tibco.bw.thor.management.stats.logback.db.BWActivityStatsDBAppender">
        <connectionSource class="ch.qos.logback.core.db.DriverManagerConnectionSource">
             <driverClass>org.postgresql.Driver</driverClass>
             <url>jdbc:postgresql://localhost:5432/bwadmindb</url>
             <user>bwuser</user>
             <password>bwuser</password>
    </connectionSource>
 </appender>

 <appender name="processInstanceStatsDBAppender" class="com.tibco.bw.thor.management.stats.logback.db.BWProcessInstanceStatsDBAppender">   
    <connectionSource  class="ch.qos.logback.core.db.DriverManagerConnectionSource"> 
              <driverClass>org.postgresql.Driver</driverClass> 
              <url>jdbc:postgresql://localhost:5432/bwadmindb</url> 
              <user>bwuser</user> 
              <password>bwuser</password> 
    </connectionSource> 
 </appender> 

Issue/Introduction

Documentation corrections for BW 6.3.2 feature: Write process and activity stats to an external Database(DB).

Additional Information

AMBW-23990
https://jira.tibco.com/projects/AMBW/versions/36006