Related Values Not always rendering in tableview

[Mccourt.cordingley1372837951]

Hi

I have a standard tableview form which show some standard fields and some related ones.

On show of the form, the related values only render randomly.
There is always related data to be displayed and when when selecting a row which has not rendered properly, some of the rows above and below will render but not all.

See here

[img]

before.png (27.53 KiB) Viewed 5479 times

[/img]
This is on frst show of the tableview, the Place holder text is still displayed 'No Value Set'.

Then If is click record 64, some details are rendered below.

[img]

after.png (25.75 KiB) Viewed 5479 times

[/img]

And finally if i click on record 55 the missing items render

[img]

finally.png (24.21 KiB) Viewed 5479 times

[/img]

Can anyone offer some advice on this?
This has only just started occurring on a server which has been running fine for about a year.

[Bernd.N]

Some general thoughts: As software usually behaves the same when nothing was changed, something must have changed after that year when everything was fine.
So please ask yourself what that could be:
- Java Version
- Servoy Version
- Database Version
- Browser Version in case you run Web Client
- Network problems
All topics both on Server and Client.
If not yet done restart the Server and the Client (my favorite first attempt if anything runs wrong).

Was there an update on the application recently?
If the application is running somewhere else without problems, compare that configuration with the one that creates problems.

[Bernd.N]

I forgot to ask if you already had a look to the application server log, there might be some error messages regarding the network or database connection.

[Mccourt.cordingley1372837951]

Hi We are running Servoy 7.4.4
The only thing that has changed is the java version is now the most current for both client and server.

This is a smart client solution.
I have copied the database to our in house test lab and cannot reproduce the issue.
We have no errors in the logs and no, the code for the form in question has not been updated for some months.

So specs are
Java 1.8.0_101
Servoy 7.4.4
MS Sql Server 2008 R2 with JTDS
Network is generally highly available as this is on a private domain.
The database is hosted on the same machine as the application server.

We have tried restarts, rebuilding the repository_server.
I have also tested adding application.updateUI at various points to no success.

[kwpsd]

McCourt,

MS Sql Server 2008 R2 with JTDS

We have had nothing but problems using the JTDS driver with MS SQL. After switching to the MS SQL JDBC driver, our problems went away.

https://www.microsoft.com/en-us/download/details.aspx?id=11774

[Bernd.N]

If this is the jTDS Driver that you use, in the news section one can see that the latest update is from 2013.
So it would be no wonder if a Java-Update 101 from 2016 might create problems.
https://sourceforge.net/p/jtds/news/
Here it says the latest update is from 2014:
https://sourceforge.net/projects/jtds/

[Mccourt.cordingley1372837951]

HI

After wrestling with this for a couple of days i rebuilt a fresh Servoy repository again.
This time the issue has gone away?
I know this is a fix but it seems extreme to me.
Are there any was to diagnose a repo gone bad?
And are there any sql operations we can perform so that a complete repo rebuild can be avoided?

As for the driver, I will take a look at that definitely, many thanks

[mboegem]

I've discussed this with one of my customers (ISV), as they encounter this issue on various on premise servers.
They also use MS-SQL, with a different driver though.

Their experience is that the issue isn't restricted to MS-SQL setups, as it also happened when using Sybase.
Also on fresh installs (clean repository) the issue occurred.

It seems to occur only when servoy-clients connect through a proxy server.
Setting the java-client network settings to Direct Connection resolved the issue.

@McCourt: Could your fix be a coincidence and are clients facing this issue behind a proxy?

[Mccourt.cordingley1372837951]

Hi Marc

Yes we definitely have a proxy running at all times so I will have to look into this.
I will do some testing and get back to you.
Hope the family is well btw.

Regards

[Mccourt.cordingley1372837951]

Hi

Direct connection has no effect on this I'm afraid.
I will switch out the driver and let you know.

Regards