Question
HCL
NL
Last activity: 4 May 2017 8:30 EDT
Getting DatabaseException : the Query has timed out, when trying to open any item from Data Explorer
I have created a new application in PEGA v7.1.9. While creating the application itself i added few data objects. So the corresponding data classes got created.
Now, when i am trying to open any data Item form the Data Explorer, i am getting following exception in logs and a distorted screen gets displayed on the screen (Attached the screenshot)
Can anybody please help me resolving this issue?
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.
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 0 SQLState: HY008 Message: The query has timed out.
From: (H8CA3901010CBAE280B6016C09DEC3A1E: Proprietary information hidden) .....
I have created a new application in PEGA v7.1.9. While creating the application itself i added few data objects. So the corresponding data classes got created.
Now, when i am trying to open any data Item form the Data Explorer, i am getting following exception in logs and a distorted screen gets displayed on the screen (Attached the screenshot)
Can anybody please help me resolving this issue?
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.
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 0 SQLState: HY008 Message: The query has timed out.
From: (H8CA3901010CBAE280B6016C09DEC3A1E: Proprietary information hidden) .....
Caused by SQL Problems.
Problem #1, SQLState HY008, Error code 0: com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out.
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:257)
at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6080)
at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:5785)
at com.pega.pegarules.data.internal.rd.queryexec.SqlQueryExecutor.executeQuery(SqlQueryExecutor.java:68)
at com.pega.pegarules.data.internal.rd.queryexec.SqlQueryExecutor.executeQuery(SqlQueryExecutor.java:43)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeQuery(SqlReportExecutor.java:284)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.executeMainReport(SqlReportExecutor.java:128)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:90)
at com.pega.pegarules.data.internal.rd.SqlReportExecutor.execute(SqlReportExecutor.java:57)
at com.pega.pegarules.data.internal.PRDataProviderImpl.executeReport(PRDataProviderImpl.java:1203)
at com.pega.pegarules.session.internal.mgmt.Executable.executeReport(Executable.java:10716)
at ......
***** Detailed Exception is attached
***Updated by moderator: Lochan to add SR details***