Calculations not firing

Classic Servoy
1

Servoy version 4.1.7 -build 690

I have a table called address

I have several calculation fields (stored) in that table which concatenate the individual address lines into various text blocks

The calculations work fine in developer but do not on the server

Both server and developer are the same version

Both server and developer use same version of MySQL

The server end used to work but I do not know what could have happened at the server end to cause this problem

Anybody else seen this behaviour ?

Cheers
Harry

2

Anybody else seen this behaviour ?

Yes. And in fact that is what promoted me to post:

http://forum.servoy.com/viewtopic.php?f=25&t=15258#p81861

I still can’t figure out why our calcs are not firing. We are on 5.2.2

3

Hi Jeff

Thanks for the reply and the pointer to the other thread

I have just ‘cured’ my problem this morning.

I assumed that something had gone amiss between adding the calculations into developer and importing that solution to the server

I went through a sequence of checks and potential solutions as follows:

  1. Added a method which would set the concatenated address data into one of the problem fields
  2. Deleted the calculations from developer and import this new solution version to server
  3. Add back the calculations into developer and import this version again onto server
  4. Delete the solution completely from the server and reimport from scratch

Option 4) has finally worked and now the calcs fire and update the concatenations for me

What caused this problem is unknown?
Whatever it was seems to have been something within the repository perhaps ?
I had 30+ releases for this solution on the server and no new release seemed to resolve the issue
So I assume that it was something deeper within the repository and within that solution which caused the hiccough !
Maybe some missing flag on the solution which linked the calcs to the columns ?
You can see that I am just speculating here
So I have no idea what caused it nor exactly what then resolved it except that it is gone now and my developer and server versions seem to be in sync again

Anybody have any ideas then please share them as I would like this to not happen again so knowing what went amiss would certainly help

Cheers ( and good luck to you Jeff)
Harry

4

Thanks for the notes(!), although I think we are having a different issue.