Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
Replies
6 replies
Answers
1 answer
Subscribers
10 subscribers
Views
6865 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Problem in query entuty
bhanuprakashm
over 8 years ago
Hi,
I am facing very weird issue when I am using the query entity the issue is like that
"Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data."
For that, I am using View for retrieve the data from db
I am using query entity like that.,but I am getting the above problem..
a!queryEntity(
entity: cons!BPMF_V_BPMF_TASK_DETL,
query: a!query(
selection: a!querySelection(
columns: {
a!queryColumn(
field : "REQ_TYPE_NME"
)
}
),
pagingInfo : a!pagingInfo(
startIndex: 1,
batchSize : 1
)
))
But I am creating query rule for the same entity(View)..it is working fine
I am not sure where i am doing wrong please help.
OriginalPostID-247419
Discussion posts and replies are publicly visible
0
sikhivahans
over 8 years ago
@bhanuprakashm Did you explore the logs generated at the time when you are seeing the error as mentioned by you in the post? If not, doing so and finding out for 'Caused By' in the log contents might give you leads.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
bhanuprakashm
over 8 years ago
I got this problem...(ajp-/10.229.85.21:8009-40) at com.appiancorp.core.expr.server.fn.query.QueryEntity.queryDataStoreEntity(QueryEntity.java:135)
08:32:24,114 INFO [stdout] (ajp-/10.229.85.21:8009-40) ... 369 more
08:32:24,119 INFO [stdout] (ajp-/10.229.85.21:8009-40) Caused by: org.hibernate.JDBCException: This query did not finish within the timeout period: could not execute query
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
bhanuprakashm
over 8 years ago
Now the problem is resolved..
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mohammedz
Certified Senior Developer
over 7 years ago
Hi Bhanu,
I am encountering the same issue. Can you please let me know how this issue is resolved ???
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
chandu
A Score Level 2
over 7 years ago
in reply to
mohammedz
Hi mohammedz,
The log for the above problem is clearly saying like
) Caused by: org.hibernate.JDBCException: This query did not finish within the timeout period: could not execute query
Time out issue. By default the time out period for QE is 10 sec unless you change the configuration.
Are you seeing the same issue as well? Please do check your logs. If you encounter same issue, try to tune the view/table.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Jamal Case
Certified Lead Developer
over 7 years ago
This error message is usually either that view has a performance issue and that query is timing out on the Appian side or the structure of the of the view has been changed and the XSD from the cdt doesn't match. Please verify those 2 things and that should resolve your problem.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Reject Answer
Cancel