New application created in Pega 8.7.1, while loading the portal it is running OOTB report definition pxLoadRelevantRecords the default value for "Maximum elapsed time in seconds" is 30Sec but it is running for more than 30 Sec and causing exception.

There are multiple suggestions to solve this but in older versions of Pega, Want to know which one is relavent for Pega 8.7.1.

Suggestion 1: Run sp_updatestats on SQL server if not solved Create non clustered index

https://collaborate.pega.com/question/getting-databaseexception-query-has-timed-out-when-trying-open-any-item-data-explorer 

Suggestion 2: HFix DL-88518 and create few DSS.

https://collaborate.pega.com/question/getting-databaseexception-caused-prior-exception

Suggetion 3: Make sure connection parameters are set. selectMethod=cursor;sendStringParametersAsUnicode=false

https://community.pega.com/support/support-articles/there-are-large-number-sql-timeout-errors-mssql

 

Please advise if any of the above is applicable for 8.7.1 or is there any other fix?

Exception:

An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: HY008 Message: The query has timed out.

DatabaseException caused by prior exception: java.sql.SQLTimeoutException: The query has timed out.

 | SQL Code: 0 | SQL State: HY008

 

com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 0 SQLState: HY008 Message: The query has timed out.

DatabaseException caused by prior exception: java.sql.SQLTimeoutException: The query has timed out.

 | SQL Code: 0 | SQL State: HY008

 

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

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

    at com.pega.pegarules.data.internal.access.Lister.convertSqlExceptionToDatabaseException(Lister.java:624) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.access.Lister.listWithResultPresenter(Lister.java:271) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.rd.queryexec.SqlQueryExecutor.executeQuery(SqlQueryExecutor.java:100) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.rd.queryexec.SqlQueryExecutor.executeQuery(SqlQueryExecutor.java:50) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.rd.SQLExecutorResultsCP.executeQuery(SQLExecutorResultsCP.java:111) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeResolvedReport(SqlReportExecutor.java:202) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeMainResolvedReport(SqlReportExecutor.java:184) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeResolved(SqlReportExecutor.java:137) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeResolved(SqlReportExecutor.java:60) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.rd.query.resolution.rdbms.RDBMSExecutable.call(RDBMSExecutable.java:59) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.rd.query.resolution.rdbms.RDBMSExecutable.call(RDBMSExecutable.java:33) ~[prprivate-data.jar:?]

    at com.pega.platform.logicaldatastore.internal.query.LogicalQueryExecutor.lambda$executable$0(LogicalQueryExecutor.java:55) ~[logical-datastore.jar:?]

    at com.pega.pegarules.data.internal.PRDataProviderImpl.executeReport(PRDataProviderImpl.java:1614) ~[prprivate-data.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.executeReport(Executable.java:11778) ~[prprivate-session.jar:?]

    at com.pegarules.generated.definition.ra_action_pxloadrelevantrecords_285dfc3c0ae2b0a4f8d70d9ada7a19c6.perform(ra_action_pxloadrelevantrecords_285dfc3c0ae2b0a4f8d70d9ada7a19c6.java:59) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:2327) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:2228) ~[prprivate-session.jar:?]

    at com.pegarules.generated.activity.ra_action_pxretrievereportdata_c70780c382990c5f0cb5bd5102801e3a.step36_circum0(ra_action_pxretrievereportdata_c70780c382990c5f0cb5bd5102801e3a.java:4084) ~[?:?]

    at com.pegarules.generated.activity.ra_action_pxretrievereportdata_c70780c382990c5f0cb5bd5102801e3a.perform(ra_action_pxretrievereportdata_c70780c382990c5f0cb5bd5102801e3a.java:765) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2863) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:11491) ~[prprivate-session.jar:?]

    at com.pegarules.generated.activity.ra_action_pxfetchrelevantrecorddetailsbyruleresolution_c871f305b1bb2d2cc47316224805a548.step4_3_circum0(ra_action_pxfetchrelevantrecorddetailsbyruleresolution_c871f305b1bb2d2cc47316224805a548.java:706) ~[?:?]

    at com.pegarules.generated.activity.ra_action_pxfetchrelevantrecorddetailsbyruleresolution_c871f305b1bb2d2cc47316224805a548.step4_0_circum0(ra_action_pxfetchrelevantrecorddetailsbyruleresolution_c871f305b1bb2d2cc47316224805a548.java:489) ~[?:?]

    at com.pegarules.generated.activity.ra_action_pxfetchrelevantrecorddetailsbyruleresolution_c871f305b1bb2d2cc47316224805a548.perform(ra_action_pxfetchrelevantrecorddetailsbyruleresolution_c871f305b1bb2d2cc47316224805a548.java:139) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2863) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:11491) ~[prprivate-session.jar:?]

    at com.pegarules.generated.activity.ra_action_pxfetchruleresolvedrrlivelistfromhierarchy_72dc34cfc41e66fd2b2a305be2d7e02a.step3_circum0(ra_action_pxfetchruleresolvedrrlivelistfromhierarchy_72dc34cfc41e66fd2b2a305be2d7e02a.java:368) ~[?:?]

    at com.pegarules.generated.activity.ra_action_pxfetchruleresolvedrrlivelistfromhierarchy_72dc34cfc41e66fd2b2a305be2d7e02a.perform(ra_action_pxfetchruleresolvedrrlivelistfromhierarchy_72dc34cfc41e66fd2b2a305be2d7e02a.java:116) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2863) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:11491) ~[prprivate-session.jar:?]

    at com.pegarules.generated.activity.ra_action_pxloadruleresolvedrelevantrecordsinner_c46bbe41f6a5807e08db4122c914d880.step2_circum0(ra_action_pxloadruleresolvedrelevantrecordsinner_c46bbe41f6a5807e08db4122c914d880.java:297) ~[?:?]

    at com.pegarules.generated.activity.ra_action_pxloadruleresolvedrelevantrecordsinner_c46bbe41f6a5807e08db4122c914d880.perform(ra_action_pxloadruleresolvedrelevantrecordsinner_c46bbe41f6a5807e08db4122c914d880.java:93) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2863) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:11491) ~[prprivate-session.jar:?]

    at com.pegarules.generated.activity.ra_action_pxloadruleresolvedrelevantrecords_e22b511010929542aa564368aa3c2370.step4_circum0(ra_action_pxloadruleresolvedrelevantrecords_e22b511010929542aa564368aa3c2370.java:554) ~[?:?]

    at com.pegarules.generated.activity.ra_action_pxloadruleresolvedrelevantrecords_e22b511010929542aa564368aa3c2370.perform(ra_action_pxloadruleresolvedrelevantrecords_e22b511010929542aa564368aa3c2370.java:128) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2863) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:11491) ~[prprivate-session.jar:?]

    at com.pegarules.generated.activity.ra_action_pzpopulatedynamicnavigationpages_16d497b93d75f712d2e9c2763af6cc6f.step3_circum0(ra_action_pzpopulatedynamicnavigationpages_16d497b93d75f712d2e9c2763af6cc6f.java:393) ~[?:?]

    at com.pegarules.generated.activity.ra_action_pzpopulatedynamicnavigationpages_16d497b93d75f712d2e9c2763af6cc6f.perform(ra_action_pzpopulatedynamicnavigationpages_16d497b93d75f712d2e9c2763af6cc6f.java:120) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2863) ~[prprivate-session.jar:?]

    at com.pega.pegarules.exec.internal.declare.infengine.pages.DeclarativePageDirectoryImpl.runRule(DeclarativePageDirectoryImpl.java:1769) ~[prprivate-exec.jar:?]

    at com.pega.pegarules.exec.internal.declare.infengine.pages.DeclarativePageDirectoryImpl.runLoadActivity(DeclarativePageDirectoryImpl.java:508) ~[prprivate-exec.jar:?]

    at com.pega.pegarules.session.internal.mgmt.base.handler.EditableDataPageHandler.loadDataPage(EditableDataPageHandler.java:185) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.base.handler.EditableDataPageHandler.findDataPage(EditableDataPageHandler.java:360) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.base.AbstractPageDirectory.findDataPageInCurrentDir(AbstractPageDirectory.java:962) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.base.AbstractPageDirectory.getDirectPage(AbstractPageDirectory.java:742) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.base.ThreadPageDir.getDirectPage(ThreadPageDir.java:371) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.base.ThreadPageDir.getPage(ThreadPageDir.java:329) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.getPage(PRThreadImpl.java:610) ~[prprivate-session.jar:?]

    at com.pega.pegarules.data.internal.clipboard.PropertyReferenceImpl.getTopPage(PropertyReferenceImpl.java:2075) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.clipboard.PropertyReferenceImpl.resolveEmbeddedPages(PropertyReferenceImpl.java:1659) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.clipboard.PropertyReferenceImpl.doGet(PropertyReferenceImpl.java:1214) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.clipboard.PropertyReferenceImpl.doGet(PropertyReferenceImpl.java:1194) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.clipboard.PropertyReferenceImpl.doGet(PropertyReferenceImpl.java:1178) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.clipboard.PropertyReferenceImpl.getIfPresent(PropertyReferenceImpl.java:1558) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.clipboard.PropertyReferenceImpl.getIfPresent(PropertyReferenceImpl.java:1487) ~[prprivate-data.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.getIfPresent(Executable.java:3010) ~[prprivate-session.jar:?]

    at com.pegarules.generated.navigation.ra_action_pydynamicnavigation_21dd86f61544dbcb70cfaefc300a8f2d.method1_circum0(ra_action_pydynamicnavigation_21dd86f61544dbcb70cfaefc300a8f2d.java:248) ~[?:?]

    at com.pegarules.generated.navigation.ra_action_pydynamicnavigation_21dd86f61544dbcb70cfaefc300a8f2d.perform(ra_action_pydynamicnavigation_21dd86f61544dbcb70cfaefc300a8f2d.java:76) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:2327) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:2228) ~[prprivate-session.jar:?]

    at com.pegarules.generated.pxExecuteNavRule_080101_352232944757733634.pxExecuteNavRule08_01_01(pxExecuteNavRule_080101_352232944757733634.java:96) ~[?:?]

    at com.pegarules.generated.pxExecuteNavRule_080101_352232944757733634.invoke(pxExecuteNavRule_080101_352232944757733634.java:67) ~[?:?]

    at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:238) ~[prprivate-generation.jar:?]

    at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:125) ~[prprivate-generation.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9804) ~[prprivate-session.jar:?]

    at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:260) ~[prpublic.jar:?]

    at com.pegarules.generated.pega_uiengine_pznavigation.pxExecuteNavRule(pega_uiengine_pznavigation.java:397) ~[?:?]

    at com.pegarules.generated.pzProcessNavigationNode_080101__2689711438403196653.pzProcessNavigationNode08_01_01(pzProcessNavigationNode_080101__2689711438403196653.java:114) ~[?:?]

    at com.pegarules.generated.pzProcessNavigationNode_080101__2689711438403196653.invoke(pzProcessNavigationNode_080101__2689711438403196653.java:68) ~[?:?]

    at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:238) ~[prprivate-generation.jar:?]

    at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:125) ~[prprivate-generation.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9804) ~[prprivate-session.jar:?]

    at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflectionWithException(LibrarySupport.java:277) ~[prpublic.jar:?]

    at com.pegarules.generated.navigation.ra_action_mainnavigation_230e260c6f493a3249d61223f30bd6da.method1_circum0(ra_action_mainnavigation_230e260c6f493a3249d61223f30bd6da.java:222) ~[?:?]

    at com.pegarules.generated.navigation.ra_action_mainnavigation_230e260c6f493a3249d61223f30bd6da.perform(ra_action_mainnavigation_230e260c6f493a3249d61223f30bd6da.java:76) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:2327) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doAction(Executable.java:2228) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.autostreams.ControlRuntime.processNavRule(ControlRuntime.java:222) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.autostreams.uicomponent.context.RuntimeContextTree.loadNavigationPage(RuntimeContextTree.java:829) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.autostreams.ControlRuntime.executeNavRule(ControlRuntime.java:189) ~[prprivate-session.jar:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.generateMenu_2(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:2434) ~[?:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.pxMenu_2(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:2463) ~[?:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.simpleLayoutTemplateCell_12(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:2725) ~[?:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.simpleLayout_3(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:2816) ~[?:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.pzLayoutBody_3(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:2377) ~[?:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.pzLayoutContainer_3(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:2848) ~[?:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.pzLayout_4(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:2863) ~[?:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.simpleLayoutTemplateCell_13(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:4927) ~[?:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.simpleLayout_7(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:5079) ~[?:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.pzLayoutBody_7(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:816) ~[?:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.pzLayoutContainer_7(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:5115) ~[?:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.pzLayout_9(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:5130) ~[?:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.pzSectionBody_1(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:406) ~[?:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.performStream_1(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:5146) ~[?:?]

    at com.pegarules.generated.html_section.ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.execute(ra_stream_portalnavigation_5ee534ca657411cc99bccf0c6090cf04.java:155) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:4370) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.autostreams.AutoStreamRuleRuntime.getSectionStream(AutoStreamRuleRuntime.java:162) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.autostreams.AutoStreamRuleRuntime.getSectionStream(AutoStreamRuleRuntime.java:182) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.autostreams.uicomponent.context.ContextProcessor.executeSection(ContextProcessor.java:1200) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.autostreams.uicomponent.context.ContextProcessor.processSection(ContextProcessor.java:1183) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.autostreams.uicomponent.context.ContextProcessor.processSection(ContextProcessor.java:1464) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.autostreams.uicomponent.context.RuntimeContextTree.loadSection(RuntimeContextTree.java:516) ~[prprivate-session.jar:?]

    at com.pegarules.generated.html_harness.ra_stream_employee_c21daa1816e5605dbb884fcdcf696a02.buildSection_2(ra_stream_employee_c21daa1816e5605dbb884fcdcf696a02.java:13886) ~[?:?]

    at com.pegarules.generated.html_harness.ra_stream_employee_c21daa1816e5605dbb884fcdcf696a02.includeSectionBody_2(ra_stream_employee_c21daa1816e5605dbb884fcdcf696a02.java:13892) ~[?:?]

    at com.pegarules.generated.html_harness.ra_stream_employee_c21daa1816e5605dbb884fcdcf696a02.performStream_41(ra_stream_employee_c21daa1816e5605dbb884fcdcf696a02.java:14581) ~[?:?]

    at com.pegarules.generated.html_harness.ra_stream_employee_c21daa1816e5605dbb884fcdcf696a02.execute(ra_stream_employee_c21daa1816e5605dbb884fcdcf696a02.java:161) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:4370) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.getStream(Executable.java:4191) ~[prprivate-session.jar:?]

    at com.pegarules.generated.activity.ra_action_displayharnesswithclass_bcfa9048b9bfb60f49df540af7f8ad41.step4_circum0(ra_action_displayharnesswithclass_bcfa9048b9bfb60f49df540af7f8ad41.java:542) ~[?:?]

    at com.pegarules.generated.activity.ra_action_displayharnesswithclass_bcfa9048b9bfb60f49df540af7f8ad41.perform(ra_action_displayharnesswithclass_bcfa9048b9bfb60f49df540af7f8ad41.java:127) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2863) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:11491) ~[prprivate-session.jar:?]

    at com.pegarules.generated.activity.ra_action_uiactiondisplayharness_5865e2f27e85e1d55a156ccd8d9e483f.step11_circum0(ra_action_uiactiondisplayharness_5865e2f27e85e1d55a156ccd8d9e483f.java:1144) ~[?:?]

    at com.pegarules.generated.activity.ra_action_uiactiondisplayharness_5865e2f27e85e1d55a156ccd8d9e483f.perform(ra_action_uiactiondisplayharness_5865e2f27e85e1d55a156ccd8d9e483f.java:259) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2863) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:11491) ~[prprivate-session.jar:?]

    at com.pegarules.generated.activity.ra_action_showspaceharness_b883c799ff8fba62b51833367e95f22f.step5_circum0(ra_action_showspaceharness_b883c799ff8fba62b51833367e95f22f.java:619) ~[?:?]

    at com.pegarules.generated.activity.ra_action_showspaceharness_b883c799ff8fba62b51833367e95f22f.perform(ra_action_showspaceharness_b883c799ff8fba62b51833367e95f22f.java:158) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2863) ~[prprivate-session.jar:?]

    at com.pegarules.generated.activity.ra_action_showdesktop_9a4a9f7eea9814b2826979170b0b901c.step14_circum0(ra_action_showdesktop_9a4a9f7eea9814b2826979170b0b901c.java:1789) ~[?:?]

    at com.pegarules.generated.activity.ra_action_showdesktop_9a4a9f7eea9814b2826979170b0b901c.perform(ra_action_showdesktop_9a4a9f7eea9814b2826979170b0b901c.java:341) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2863) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:11491) ~[prprivate-session.jar:?]

    at com.pegarules.generated.activity.ra_action_showselectedportal_4e445a4ab3ce834b451c472d25f82842.step11_circum0(ra_action_showselectedportal_4e445a4ab3ce834b451c472d25f82842.java:963) ~[?:?]

    at com.pegarules.generated.activity.ra_action_showselectedportal_4e445a4ab3ce834b451c472d25f82842.perform(ra_action_showselectedportal_4e445a4ab3ce834b451c472d25f82842.java:257) ~[?:?]

    at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2863) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:653) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:521) ~[prprivate-session.jar:?]

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

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

    at jdk.internal.reflect.GeneratedMethodAccessor149.invoke(Unknown Source) ~[?:?]

    at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]

    at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]

    at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1392) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1124) ~[prprivate-session.jar:?]

    at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:978) ~[prprivate-session.jar:?]

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

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

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

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

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

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

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

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

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

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

    at jdk.internal.reflect.GeneratedMethodAccessor108.invoke(Unknown Source) ~[?:?]

    at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]

    at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]

    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:388) ~[prbootstrap-8.7.0-163.jar:8.7.0-163]

    at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:430) ~[prbootstrap-8.7.0-163.jar:8.7.0-163]

    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:225) ~[prbootstrap-api-8.7.0-163.jar:8.7.0-163]

    at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:274) ~[prbootstrap-api-8.7.0-163.jar:8.7.0-163]

    at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doPost(WebStandardBoot.java:164) ~[prbootstrap-api-8.7.0-163.jar:8.7.0-163]

    at com.pega.pegarules.internal.web.servlet.WebStandardBoot.doGet(WebStandardBoot.java:121) ~[prbootstrap-api-8.7.0-163.jar:8.7.0-163]

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:655) ~[servlet-api.jar:4.0.FR]

    at com.pega.pegarules.internal.web.servlet.WebStandardBoot.service(WebStandardBoot.java:191) ~[prbootstrap-api-8.7.0-163.jar:8.7.0-163]

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) ~[servlet-api.jar:4.0.FR]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-util.jar:9.0.60]

    at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-util.jar:9.0.60]

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

    at java.lang.Thread.run(Thread.java:834) [?:?]

Caused by: java.sql.SQLTimeoutException: The query has timed out.

    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:225) ~[mssql-jdbc-8.2.2.jre11.jar:?]

    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:503) ~[mssql-jdbc-8.2.2.jre11.jar:?]

    at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:93) ~[tomcat-dbcp-9.0.37.jar:?]

    at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:93) ~[tomcat-dbcp-9.0.37.jar:?]

    at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:532) ~[prprivate-data.jar:?]

    at com.pega.pegarules.data.internal.access.Lister.listWithResultPresenter(Lister.java:249) ~[prprivate-data.jar:?]

    ... 180 more