When running wso2 API Manager Analytics 2.1.0 I am getting below error. DB - cassandra
When running wso2 API Manager Analytics 2.1.0 I am getting below error. Db is cassandra
2017-08-01 11:39:17,472] [EI-Analytics] ERROR {org.wso2.carbon.analytics.dataservice.core.AnalyticsDataServiceComponent} - Error in activating analytics data service: All host(s) tried for query failed (tried: localhost/127.0.0.1:9042 (com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured table schema_keyspaces))
com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed
(tried: localhost/127.0.0.1:9042 (com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured table schema_keyspaces))
source to share
It's your problem:
InvalidQueryException: unconfigured table schema_keyspaces
In Cassandra 3.x, it schema_keyspaces
no longer exists in system
the keyspace. I am assuming WSO2 has hard-coded Cassandra integration for pulling schema from system.schema_keyspaces
and system.schema_columnfamilies
.
Since version 2.2, this data is now stored in the key space system_schema
, in system_schema.keyspaces
and system_schema.tables
.
I also tried using apache-cassandra-2.1.0 but was getting the same error.
Not sure what to tell you there as this keyspace exists in 2.1.
If you are going to use 2.1.x, be sure to get 2.1.18. Patch 2.1.0 has gone through many fixes. If a clean install of this doesn't work, I suppose you could try 2.0.17 from the archives, but I don't recommend that.
But honestly, I don't recommend middleware from companies that post support on StackOverflow .
source to share