ESS delay / lagging

[Joost Miltenburg]

Hi All !

I am working with ESS and it works very nicely, but there is one problem : ESS seems to lag behind in the refreshing/updating of the data.

Example : When searching in a sql-based table in ESS I find less records then when doing the same search in the sql table directly.

What could be causing this ? Can I somehow check if the ESS-connection is alive ? Can I force a refresh of the shadow table ?

TIA

[mr_vodka]

I havent really seen this issue, but you can always try the refresh window script with flushing of the cached SQL data.

[Joost Miltenburg]

Apperently, the problem was the primary key. There was none, so in FM I defined one by checking several fields. As the values none unique this problem started to occur.

Adding a primary key in the SQL-table fixed this.