Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
+1
person also asked this
people also asked this
Replies
5 replies
Subscribers
8 subscribers
Views
2361 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
I could see below error in logs in our cloud environment. ERROR org.h
prasadr875
over 10 years ago
I could see below error in logs in our cloud environment.
ERROR org.hibernate.util.JDBCExceptionReporter - Packet for query is too large (4197887 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.
Can anybody tell me what might be causing the issue?...
OriginalPostID-136969
OriginalPostID-136969
Discussion posts and replies are publicly visible
0
prasadr875
over 10 years ago
How can I reduce the packet size?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim
Certified Lead Developer
over 10 years ago
Is this error coming from a queryrule()? If so try using a!queryentity() and only return the columns that are necessary for your use case as this can help to reduce packet size. You can also using pagingInfo if your query returns multiple results.
forum.appian.com/.../System_Functions.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Eduardo Fuentes
Appian Employee
over 10 years ago
Also take a look at
dev.mysql.com/.../packet-too-large.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
prasadr875
over 10 years ago
Thanks but the problem is how to know where exactly the issue is happening. By Looking at the below error how can anybody tell where exactly the issue is happening?
00:00:12,211 INFO [stdout] (ElementEventQueue.QProcessor-1) 2015-02-03 00:00:12,211 [ElementEventQueue.QProcessor-1] ERROR org.hibernate.util.JDBCExceptionReporter - Packet for query is too large (4197887 > 4194304). You can change this value on the server by setting the max_allowed_packet' variable.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
prasadr875
over 10 years ago
we have asked to change the max_allowed_packet to 20MB. But we are not able to make out if issue is in our custom plugin or our code.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel