Question

4
Replies
562
Views
Close popover
Gladson Soans (GladsonS3738)
Commonwealth Bank of Australia
Devops Engineer
Commonwealth Bank of Australia
AU
GladsonS3738 Member since 2017 9 posts
Commonwealth Bank of Australia
Posted: July 27, 2017
Last activity: July 31, 2017
Closed
Solved

Pega 7.3 Ignite : java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DATA_SCHEMA_USER.PRPC_IGNITE_SERVER_ADDR_PK)

Hi,

I'm getting below error when trying to bring up Pega-Ignite cluster on one of the server. There are 3 servers used in the cluster

ddress=server/XX.XX.XX.XX:5701, uuid=ca311f1b-2ddd-486e-a026-5ae397b1a7d0, mode=SERVER]
2017-07-27 16:01:38,994 [ent-worker-#41%PRPC%] [ ] [ ] [ ] (.util.ClusterMembershipManager) INFO - Members [3] {
2017-07-27 16:01:38,994 [ent-worker-#41%PRPC%] [ ] [ ] [ ] (.util.ClusterMembershipManager) INFO - Member: [name=pega_clustermgr_dev-01, address=server/XX.XX.XX.XX:5701, uuid=82700c57-64b4-41ac-8e1a-6fede94c0059, mode=SERVER] <== THIS node
2017-07-27 16:01:38,994 [ent-worker-#41%PRPC%] [ ] [ ] [ ] (.util.ClusterMembershipManager) INFO - Member: [name=pega_clustermgr_dev-01, address=server/XX.XX.XX.XX:5701, uuid=ed18112b-ef5d-4d62-9ccd-74cda4f66753, mode=SERVER]
2017-07-27 16:01:38,994 [ent-worker-#41%PRPC%] [ ] [ ] [ ] (.util.ClusterMembershipManager) INFO - Member: [address=server/XX.XX.XX.XX:5701, uuid=ca311f1b-2ddd-486e-a026-5ae397b1a7d0, mode=SERVER] <== NEW node
2017-07-27 16:01:38,994 [ent-worker-#41%PRPC%] [ ] [ ] [ ] (.util.ClusterMembershipManager) INFO - }
2017-07-27 16:02:06,934 [der-cleaner-#6%PRPC%] [ ] [ ] [ ] (internal.ClusterServiceJdbcDAO) INFO - Updating addresses into the database. Current Timestamp: 06:02:06.934
2017-07-27 16:11:07,005 [der-cleaner-#6%PRPC%] [ ] [ ] [ ] (internal.ClusterServiceJdbcDAO) INFO - Updating addresses into the database. Current Timestamp: 06:11:07.05
2017-07-27 16:13:07,041 [der-cleaner-#6%PRPC%] [ ] [ ] [ ] (internal.ClusterServiceJdbcDAO) INFO - Updating addresses into the database. Current Timestamp: 06:13:07.41
2017-07-27 16:13:07,078 [der-cleaner-#6%PRPC%] [ ] [ ] [ ] (internal.ClusterServiceJdbcDAO) ERROR - Failed to get registered addresses
java.sql.BatchUpdateException: ORA-00001: unique constraint (DATA_SCHEMA_USER.PRPC_IGNITE_SERVER_ADDR_PK) violated
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:11190) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:244) ~[ojdbc7.jar:XX.XX.XX.XX]
at com.pega.pegarules.configdbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[prdbcp-7.3.0-77.jar:7.3.0-77]
at com.pega.platform.cluster.internal.ClusterServiceJdbcDAO.registerAddresses(ClusterServiceJdbcDAO.java:217) ~[cluster-impl.jar:?]
at com.pega.platform.cluster.internal.JdbcNodesProvider.registerAddresses(JdbcNodesProvider.java:98) ~[cluster-impl.jar:?]
at org.apache.ignite.spi.discovery.tcp.ServerImpl$IpFinderCleaner.cleanIpFinder(ServerImpl.java:1800) ~[ignite-core-1.7.0.jar:?]
at org.apache.ignite.spi.discovery.tcp.ServerImpl$IpFinderCleaner.body(ServerImpl.java:1719) ~[ignite-core-1.7.0.jar:?]
at org.apache.ignite.spi.IgniteSpiThread.run(IgniteSpiThread.java:62) ~[ignite-core-1.7.0.jar:?]
2017-07-27 16:13:07,078 [der-cleaner-#6%PRPC%] [ ] [ ] [ ] (internal.ClusterServiceJdbcDAO) ERROR - Failed to get registered addresses
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DATA_SCHEMA_USER.PRPC_IGNITE_SERVER_ADDR_PK) violated
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:10932) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:11043) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:244) ~[ojdbc7.jar:XX.XX.XX.XX]
at com.pega.pegarules.configdbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[prdbcp-7.3.0-77.jar:7.3.0-77]
at com.pega.platform.cluster.internal.ClusterServiceJdbcDAO.registerAddresses(ClusterServiceJdbcDAO.java:217) ~[cluster-impl.jar:?]
at com.pega.platform.cluster.internal.JdbcNodesProvider.registerAddresses(JdbcNodesProvider.java:98) ~[cluster-impl.jar:?]
at org.apache.ignite.spi.discovery.tcp.ServerImpl$IpFinderCleaner.cleanIpFinder(ServerImpl.java:1800) ~[ignite-core-1.7.0.jar:?]
at org.apache.ignite.spi.discovery.tcp.ServerImpl$IpFinderCleaner.body(ServerImpl.java:1719) ~[ignite-core-1.7.0.jar:?]
at org.apache.ignite.spi.IgniteSpiThread.run(IgniteSpiThread.java:62) ~[ignite-core-1.7.0.jar:?]

***Updated by moderator: Lochan to mask proprietary information***

System Administration Installation and Deployment
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.