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
Replies
4 replies
Subscribers
9 subscribers
Views
2897 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi, We are a cloud customer using VPN tunnels to connect to our SQL Server
garym
over 8 years ago
Hi,
We are a cloud customer using VPN tunnels to connect to our SQL Server database in our location. We are not a large shop so we don't have large databases.
Whether you are on a similar setup or not, has anyone experienced timeout issues with the database? The message that users see is:
Error Evaluating UI Expression
Expression evaluation error in rule......
at function a!queryEntity: An error occurred while retrieving the data
If the user clicks the refresh button a few times it may work which means the issue is intermittent. A lot of the times, the data source is a view that is not pulling a lot of data (200-300 records) so it is not a large data set and we did use a view to reduce the amount of fields to pull.
The problem with this issue is that there could be so many possibilities of the cause - database utilization, VPN connection, etc. If anyone else has had this issue, how did you go about isolating it and did you get it resolved?
...
OriginalPostID-212834
OriginalPostID-212834
Discussion posts and replies are publicly visible
0
garym
over 8 years ago
...
Thanks,
Gary
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
garym
over 8 years ago
An example of the dreaded pink error message
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Jim Schweitzer
Certified Lead Developer
over 8 years ago
I've seen these errors before, and they're usually an issue that's independent from VPN. VPN may add up to a 100ms latency, but these timeouts occur at 10s. I would recommend having DBA check indexes on the db, and use tools like profiler to make sure the indexes that are set up are actually being used. SQL server can sometimes have a mind of its own in this regard.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mathieud
over 8 years ago
We've had similar issues in the past. Since it's intermittent it usually points to unusually high latency in the internet connection used to establish the VPN.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel