Question

55
Views
Close popover
Bala Venkateson (BalaV6531)
HCL Technologies

HCL Technologies
IN
BalaV6531 Member since 2020 6 posts
HCL Technologies
Posted: November 11, 2020
Last activity: November 17, 2020

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 adminisrator@pega.com 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 Administrator@pega.com - 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 Administrator@pega.com -      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 Administrator@pega.com - adding StaticContentAGCache cache with com.pega.platform.datagrid.cache.CacheConfiguration@23ee2324 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:

***Edited by Moderator Marissa to update Content Type from Discussion to Question; update Platform Capability tags***
Pega Platform 8.4.3 System Administration Security Insurance Project Manager