Pega Admin password reset
Hi Team,
I have install the Pega 8.4.3 with SQLserver .I had some .dll issue which I have resolved .After that i am having some DB dead lock issues ,however I am able to up the login screen and login with the UID [email protected] with temp password .Once it is reset I am not able to login . Please let me know if I can reset the password in the DB directly
Caused by: com.pega.pegarules.pub.database.DatabaseException: Problem in executing BatchData-Decision-DDF-Run-Partition: code: 1205 SQLState: 40001 Message: Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
DatabaseException caused by prior exception: java.sql.BatchUpdateException: Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
| SQL Code: 1205 | SQL State: 40001
at com.pega.pegarules.data.internal.sqlapi.exec.NativeSQLBatchExecutor.executeBatch(NativeSQLBatchExecutor.java:275) ~[prprivate-data.jar:?]
at com.pega.pegarules.data.internal.sqlapi.nologgingprocessor.NoLoggingNotSupportProcessorImpl.executeBatch(NoLoggingNotSupportProcessorImpl.java:58) ~[prprivate-data.jar:?]
... 26 more
Hi Team,
I have install the Pega 8.4.3 with SQLserver .I had some .dll issue which I have resolved .After that i am having some DB dead lock issues ,however I am able to up the login screen and login with the UID [email protected] with temp password .Once it is reset I am not able to login . Please let me know if I can reset the password in the DB directly
Caused by: com.pega.pegarules.pub.database.DatabaseException: Problem in executing BatchData-Decision-DDF-Run-Partition: code: 1205 SQLState: 40001 Message: Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
DatabaseException caused by prior exception: java.sql.BatchUpdateException: Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
| SQL Code: 1205 | SQL State: 40001
at com.pega.pegarules.data.internal.sqlapi.exec.NativeSQLBatchExecutor.executeBatch(NativeSQLBatchExecutor.java:275) ~[prprivate-data.jar:?]
at com.pega.pegarules.data.internal.sqlapi.nologgingprocessor.NoLoggingNotSupportProcessorImpl.executeBatch(NoLoggingNotSupportProcessorImpl.java:58) ~[prprivate-data.jar:?]
... 26 more
Caused by: java.sql.BatchUpdateException: Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1870) ~[sqljdbc42-6.0.8112.jar:?]
at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242) ~[tomcat-dbcp-9.0.37.jar:9.0.39]
at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:242) ~[tomcat-dbcp-9.0.37.jar:9.0.39]
at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.executeBatch(DatabasePreparedStatementImpl.java:491) ~[prprivate-data.jar:?]
at com.pega.pegarules.data.internal.sqlapi.exec.NativeSQLBatchExecutor.executeBatch(NativeSQLBatchExecutor.java:260) ~[prprivate-data.jar:?]
at com.pega.pegarules.data.internal.sqlapi.nologgingprocessor.NoLoggingNotSupportProcessorImpl.executeBatch(NoLoggingNotSupportProcessorImpl.java:58) ~[prprivate-data.jar:?]
... 26 more
2020-11-11 06:09:39,703 [egaRULES-MasterAgent] [ STANDARD] [ ] [ ] ( internal.async.Agent) INFO - System date: Wed Nov 11 06:09:39 UTC 2020 Total memory: 2,274,361,344 Free memory: 1,050,530,640 Requestor Count: 101 Shared Pages memory usage: 0% Current number of threads: 233
2020-11-11 06:09:52,678 [http-nio-8080-exec-1] [ STANDARD] [ ] [ PegaRULES:8] ( DistributedCache) DEBUG localhost|0:0:0:0:0:0:0:1 [email protected] - Create cache StaticContentAGCache
2020-11-11 06:09:52,683 [http-nio-8080-exec-1] [ STANDARD] [ ] [ PegaRULES:8] ( DistributedCache) DEBUG localhost|0:0:0:0:0:0:0:1 [email protected] - CacheConfiguration properties : key type = class java.lang.String value type = class java.util.ArrayList expiry time unit = Days eviction policy = LRU expiry duration = 0
2020-11-11 06:09:52,683 [http-nio-8080-exec-1] [ STANDARD] [ ] [ PegaRULES:8] ( DistributedCache) DEBUG localhost|0:0:0:0:0:0:0:1 [email protected] - adding StaticContentAGCache cache with [email protected] config to distributed config cache
2020-11-11 06:19:39,703 [egaRULES-MasterAgent] [ STANDARD] [ ] [ ] ( internal.async.Agent) INFO - System date: Wed Nov 11 06:19:39 UTC 2020 Total memory: 1,669,332,992 Free memory: 637,061,256 Requestor Count: 100 Shared Pages memory usage: 0% Current number of threads: 233
2020-11-11 06:21:21,939 [ttp-nio-8080-exec-10] [ STANDARD] [ ] [ PegaRULES:8] (hentication.ForgotPasswordUtil) ERROR localhost|0:0:0:0:0:0:0:1 - Failed to open email account configured to send verification code:
2020-11-11 06:22:05,363 [ttp-nio-8080-exec-10] [ STANDARD] [ ] [ PegaRULES:8] (hentication.ForgotPasswordUtil) ERROR localhost|0:0:0:0:0:0:0:1 - Failed to open email account configured to send verification code: