When setting up WSO2 BAM with API Manager to collect and analyze runtime statistics, I get Cassandra exception as 'unable to connect to server'. How can I overcome this?
The reason could be that the default BAM port has changed (with a port offset) but the Cassandra port is not changed accordingly before running the Hive scripts. First, change the default Cassandra port with the offset value (default Cassandra port+offset) in
<BAM_HOME>/repository/conf/datasources/master-datasources.xml file and then add the following line at the beginning of the Hive script and rerun.
drop table <hive_cassandra_table_name>;
Also see Monitoring Using WSO2 BAM.