Question

8
Replies
3647
Views
X
RadhikaL Member since 2013 6 posts
Tata Consultancy Services
Posted: 3 years ago
Last activity: 3 years 2 months ago
Closed
Solved

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:10.81.10.96) .....

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***

Data Integration SR Created
Moderation Team has archived post
Share this page LinkedIn