Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Manjunath Pai G (ManjuPai)
Pai G
System Programmer
Pai G
IN
ManjuPai Member since 2016 33 posts
Pai G
Posted: May 30, 2019
Last activity: Jun 13, 2019
Posted: 30 May 2019 4:24 EDT
Last activity: 13 Jun 2019 23:15 EDT
Closed

Login screen refreshes and user is returned to same login screen

Our users had issue where the browser was refreshing continuously when they were trying to login to Pega. We are using Pega 8.1.3 with PostGreSQL DB. I found an article in community to resolve this issue (https://community.pega.com/support/support-articles/login-screen-refreshes-and-user-returned-same-login-screen). However, at the moment we are not ready to upgrade to 8.1.4 or 8.2.1. The article also said to make a local change to set the ActiveKeyID and CurrentSystemEncryptKeyIDHash to null. It did not mention how and where this change needs to be done (like in Designer Studio, prconfig, DSS settings etc). Can someone let me know where this change needs to be done and whether this will resolve the issue?

Regards,

Manju.

To see attachments, please log in.
User Experience

Posted: 5 years ago
Posted: 30 May 2019 5:00 EDT
Srinivas B Y (SrinivasB9086)
Wipro

Wipro
IN

Hi,

The root cause of the issue in the link could be different from what you are facing.

However, below was the local change that was suggested:

  • Restart machine. Now you should be able to login.
  • Open "Pega-IntegrationEngine" agent in Record explorer (Record explorer -> SysAdmin -> Agents -> Pega-IntegrationEngine).
  • Select step 7 "pyValidateKMSMetaData" agent and select "Delay next run of agent across the cluster by specified time period". Set time to at least 1 hour.

It would be advisable to first investigate what is causing the issue.

Thanks

To see attachments, please log in.
Posted: 5 years ago
Posted: 30 May 2019 5:44 EDT
Manjunath Pai G (ManjuPai)
Pai G
System Programmer
Pai G
IN

Thanks for your response Srinivas.  Below is the complete error stack trace.  The error appears to be from PostGres.  Do you know what could be reason for this error?

 

2019-05-30 05:29:49,430 [http-nio-8080-exec-9] [          ] [                    ] [                    ] (nternal.store.DataStoreManager) ERROR workflow-ext.intel.com| Proprietary information hidden  - Error occurred performing a "read" operation in a transaction

com.pega.pegarules.pub.database.DatabaseException: Database-General     There was a problem opening a database instance SYSTEM-REQUESTOR-CONTEXT ?__^&_???.??{}7EY5Z6ZUS2NEFCEU8A    0       22021   ERROR: invalid byte sequence for encoding "UTF8": 0x00

DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00

 | SQL Code: 0 | SQL State: 22021

 

        at com.pega.pegarules.data.internal.access.ExceptionInformation.createAppropriateExceptionDueToDBFailure(ExceptionInformation.java:381) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:360) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.store.AutoCommitTransaction.performQuery(AutoCommitTransaction.java:387) ~[prprivate.jar:?]

Show More

Thanks for your response Srinivas.  Below is the complete error stack trace.  The error appears to be from PostGres.  Do you know what could be reason for this error?

 

2019-05-30 05:29:49,430 [http-nio-8080-exec-9] [          ] [                    ] [                    ] (nternal.store.DataStoreManager) ERROR workflow-ext.intel.com| Proprietary information hidden  - Error occurred performing a "read" operation in a transaction

com.pega.pegarules.pub.database.DatabaseException: Database-General     There was a problem opening a database instance SYSTEM-REQUESTOR-CONTEXT ?__^&_???.??{}7EY5Z6ZUS2NEFCEU8A    0       22021   ERROR: invalid byte sequence for encoding "UTF8": 0x00

DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00

 | SQL Code: 0 | SQL State: 22021

 

        at com.pega.pegarules.data.internal.access.ExceptionInformation.createAppropriateExceptionDueToDBFailure(ExceptionInformation.java:381) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:360) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.store.AutoCommitTransaction.performQuery(AutoCommitTransaction.java:387) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.access.Opener$1.getResultPageFromDatabase(Opener.java:764) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.access.Opener$1.action(Opener.java:749) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.access.Opener$1.action(Opener.java:746) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.store.DataStoreManager.readInTransaction(DataStoreManager.java:70) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.access.Opener.openResultFromDatabase(Opener.java:775) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.access.Opener.openData(Opener.java:719) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.access.Opener.openData(Opener.java:467) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.access.Opener.open(Opener.java:2468) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.access.DatabaseImpl.open(DatabaseImpl.java:2638) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.access.DatabaseImpl.open(DatabaseImpl.java:2630) ~[prprivate.jar:?]

        at com.pega.pegarules.session.internal.mgmt.base.DatabaseStorage.activateRequestor(DatabaseStorage.java:269) ~[prprivate.jar:?]

        at com.pega.pegarules.session.internal.mgmt.base.NodeRequestorMgt.getRequestorState(NodeRequestorMgt.java:1194) ~[prprivate.jar:?]

        at com.pega.pegarules.session.internal.mgmt.base.NodeRequestorMgt.recreateRequestor(NodeRequestorMgt.java:1855) ~[prprivate.jar:?]

        at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.establishRequestor(EngineAPI.java:760) ~[prenginext.jar:?]

        at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.findRequestorInternal(HttpAPI.java:1555) ~[prprivate.jar:?]

        at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.findRequestor(HttpAPI.java:1493) ~[prprivate.jar:?]

        at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequest(EngineAPI.java:354) ~[prenginext.jar:?]

        at com.pega.pegarules.session.internal.engineinterface.service.HttpAPI.invoke(HttpAPI.java:882) ~[prprivate.jar:?]

        at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:331) ~[prprivate.jar:?]

        at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:274) ~[prprivate.jar:?]

        at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:251) ~[prprivate.jar:?]

        at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngineInner(JNDIEnvironment.java:275) ~[prpublic.jar:?]

        at com.pega.pegarules.priv.context.JNDIEnvironment.invokeEngine(JNDIEnvironment.java:220) ~[prpublic.jar:?]

        at com.pega.pegarules.web.impl.WebStandardImpl.makeEtierRequest(WebStandardImpl.java:712) ~[prwebj2ee.jar:?]

        at com.pega.pegarules.web.impl.WebStandardImpl.doPost(WebStandardImpl.java:398) ~[prwebj2ee.jar:?]

        at sun.reflect.GeneratedMethodAccessor70.invoke(Unknown Source) ~[?:?]

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_181]

        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_181]

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370) ~[prbootstrap-HEAD-6447.jar:HEAD-6447]

        at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411) ~[prbootstrap-HEAD-6447.jar:HEAD-6447]

        at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224) ~[prbootstrap-api-HEAD-6447.jar:HEAD-6447]

        at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273) ~[prbootstrap-api-HEAD-6447.jar:HEAD-6447]

        at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:141) ~[prbootstrap-api-HEAD-6447.jar:HEAD-6447]

        at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doGet(WebStandardBoot.java:102) ~[prbootstrap-api-HEAD-6447.jar:HEAD-6447]

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) ~[servlet-api.jar:?]

        at com.pega.pegarules.internal.web.servlet.WebStandardBoot.service(WebStandardBoot.java:167) ~[prbootstrap-api-HEAD-6447.jar:HEAD-6447]

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) ~[servlet-api.jar:?]

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[catalina.jar:8.5.14]

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:8.5.14]

        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) ~[tomcat-websocket.jar:8.5.14]

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:8.5.14]

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:8.5.14]

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) ~[catalina.jar:8.5.14]

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) ~[catalina.jar:8.5.14]

        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) ~[catalina.jar:8.5.14]

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) ~[catalina.jar:8.5.14]

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) ~[catalina.jar:8.5.14]

        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) ~[catalina.jar:8.5.14]

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) ~[catalina.jar:8.5.14]

        at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:677) ~[catalina.jar:8.5.14]

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) ~[catalina.jar:8.5.14]

        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799) ~[tomcat-coyote.jar:8.5.14]

        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) ~[tomcat-coyote.jar:8.5.14]

        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861) ~[tomcat-coyote.jar:8.5.14]

        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455) ~[tomcat-coyote.jar:8.5.14]

        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-coyote.jar:8.5.14]

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_181]

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_181]

        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-util.jar:8.5.14]

        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181]

Caused by: org.postgresql.util.PSQLException: ERROR: invalid byte sequence for encoding "UTF8": 0x00

        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476) ~[jdbc_driver_0.jar:42.1.1]

        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2189) ~[jdbc_driver_0.jar:42.1.1]

        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300) ~[jdbc_driver_0.jar:42.1.1]

        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428) ~[jdbc_driver_0.jar:42.1.1]

        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354) ~[jdbc_driver_0.jar:42.1.1]

        at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169) ~[jdbc_driver_0.jar:42.1.1]

        at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117) ~[jdbc_driver_0.jar:42.1.1]

        at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82) ~[tomcat-dbcp.jar:8.5.14]

        at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82) ~[tomcat-dbcp.jar:8.5.14]

        at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.executeDataStoreQuery(DatabasePreparedStatementImpl.java:354) ~[prprivate.jar:?]

        at com.pega.pegarules.data.internal.store.AutoCommitTransaction.performQuery(AutoCommitTransaction.java:356) ~[prprivate.jar:?]

        ... 60 more


Show Less
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice