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?...

Discussion posts and replies are publicly visible

Parents

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

Reply

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

Children

No Data