Problem

Unable to start Interchange/B2Bi. Below error is found in <hostname>_cn.log.

Error

2017-09-12 12:47:03,485 - FATAL [Startup] (ClusterController.connect:70) - Error connecting to the cluster

com.axway.cluster.bus.RetryableClusterException: Could not initialize node information with database

at com.axway.cluster.bus.membership.DefaultRegistryManager.insertMembership(DefaultRegistryManager.java:483)

at com.axway.cluster.bus.membership.DefaultRegistryManager.register(DefaultRegistryManager.java:94)

at com.axway.cluster.bus.membership.DefaultRegistryManager.register(DefaultRegistryManager.java:32)

at com.axway.cluster.bus.membership.MembershipManager.start(MembershipManager.java:80)

at com.axway.cluster.bus.Cluster.connect(Cluster.java:76)

at com.axway.cluster.bus.Cluster.connect(Cluster.java:57)

at com.axway.cluster.management.ClusterControllerImpl.connect(ClusterControllerImpl.java:66)

at com.cyclonecommerce.clustercontroller.controlnode.startup.ClusterInitHelper.connect(ClusterInitHelper.java:54)

at com.axway.cluster.legacy.executive.NodeExec.main(NodeExec.java:46)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at com.axway.clusterold.startup.Boot$MainRunnable.run(Boot.java:109)

at java.lang.Thread.run(Thread.java:745)

at com.axway.cluster.extensions.thread.EventedThread.primRun(EventedThread.java:102)

at com.axway.cluster.extensions.thread.EventedThread.run(EventedThread.java:80)

Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

Resolution

Make sure all databases permissions mentioned in the pre-requisite of B2Bi/Interchange Installation guide are granted to the B2Bi/Interchange user before starting B2Bi.

After giving all the required permission, if issue still exists, follow below steps to resolve the issue.

1. Stop B2Bi.
2. Run the following command on your database to create the sequence it is looking for.

   CREATE SEQUENCE ""."ACF_SEQ_CLUSTERNODE"
   MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 31
   CACHE 10 NOORDER NOCYCLE ;<o:p></o:p>

   The above command is for an Oracle database. Please modify the command if you are using a different database.
3. Start B2Bi