KB Article #178989

Errors during setup-apimanager with Cassandra HA

Problem

Errors during setup-apimanager with Cassandra HA:

apigtw3prd:/opt/Axway-7.5.3/apigateway/posix/bin # ./setup-apimanager -g "API Security Group" -n "API GW Instance7"
Enter username: admin
Enter password: ********
Group name is: API Security Group
Service name is: API GW Instance7
INFO 17/Oct/2017:10:20:36.391 [663f:000000000000000000000000] Starting environmentalization of '0' entities...
INFO 17/Oct/2017:10:20:36.391 [663f:000000000000000000000000] Completed environmentalization of '0' entities
Creating API Administrator account apiadmin. Please specify password:
Creating API Administrator account apiadmin. Please re-enter password:
Checking password length (minimum 6 characters)
Service EnvSettings updated
Loading the API Manager Configuration...
INFO 17/Oct/2017:10:22:47.977 [663f:000000000000000000000000] The deployment succeeded but 3 issues recorded.
INFO 17/Oct/2017:10:22:47.978 [663f:000000000000000000000000] KPS: API Portal_PortalTimestamp: Unexpected exception for query: KeyQuery: keys: [entityType], values: [VIRTUALIZED_API]:
com.datastax.driver.core.exceptions.InvalidQueryException: Predicates on non-primary-key columns (entityType) are not yet supported for non secondary index queries
at com.datastax.driver.core.exceptions.InvalidQueryException.copy(InvalidQueryException.java:50)
at com.datastax.driver.core.DriverThrowables.propagateCause(DriverThrowables.java:37)
at com.datastax.driver.core.AbstractSession.prepare(AbstractSession.java:104)
at com.axway.apigw.cassandra.impl.datastax.kps.BasicDmlOperationsImpl.lambda$readQuery$4(BasicDmlOperationsImpl.java:112)
at java.util.HashMap.computeIfAbsent(HashMap.java:1126)
at com.axway.apigw.cassandra.impl.datastax.kps.BasicDmlOperationsImpl.readQuery(BasicDmlOperationsImpl.java:111)
at com.vordel.kps.storeImpl.cassandra.CassandraStore.queryIterator(CassandraStore.java:406)
at com.vordel.kps.storeImpl.cassandra.CassandraTransaction.queryIteratorInternal(CassandraTransaction.java:67)
at com.vordel.kps.storeImpl.AbstractTransaction.query(AbstractTransaction.java:233)
at com.vordel.persistence.kps.KpsSearchResult.iterator(KpsSearchResult.java:28)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
Caused by: com.datastax.driver.core.exceptions.InvalidQueryException: Predicates on non-primary-key columns (entityType) are not yet supported for non secondary index queries

Resolution

Synchronize clocks on all servers running cassandra
e.g. ntpdate -s time.axway.int