Question

8
Replies
4606
Views
Close popover
Radhika Lambe (RadhikaL)
Tata Consultancy Services
Assistant Consultant (AST)
Tata Consultancy Services
BE
RadhikaL Member since 2013 6 posts
Tata Consultancy Services
Posted: March 8, 2017
Last activity: May 4, 2017
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 Support Case Created
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.