Again, we lost the Auto Enter settings like creation server datetime, creation user id, modification server datetime etc. in one of our solutions. We still don’t know when it happens, but it definitely happens “from time to time”.
It makes us very nervous and leds to a paranoia, as some functionality depends on creation and modification date, and you can imagine what happens if the auto enter settings are suddenly NOT set any more → all results depending on that are wrong! The paranoia now leds to checking very often if these settings are still there, i. e. set, but we still couldn’t find out when it happens that they get unset (also very time consuming to check all these settings in a project with 110 tables). Unset means the System Value is set to none.
Just for info, Patrick Rushert mentioned this bug first in 2006 I think and I am sure it still exists, we just have been hit by it again.
Servoy 5.2.4
Mac OS Server 10.6.5
Mac OS 10.6.5 (client)
Java 1.6.0_22
So what makes you think this has a relation with something mentioned in 2006? It’s never happened to me in my 13 years using Servoy solutions on a daily basis so I don’t see an urgent need for paranoia (besides the fact that I don’t think paranoia is in place even if it happened)
When do you experience it? Are you sure it’s Servoy? How often? Any particular workflow before it happens? Imports/exports? If during import/export how does the original look in your svn?
Jan Aleman:
So what makes you think this has a relation with something mentioned in 2006? It’s never happened to me in my 13 years using Servoy solutions on a daily basis so I don’t see an urgent need for paranoia (besides the fact that I don’t think paranoia is in place even if it happened)
I just read the tread and I remember having talked about that with Patrick. Yes I know, we are the only ones Yes, Jan, it definitely happens and as we don’t know WHEN it happens we are quite afraid of it. Can you imagine having records in your database with no creation date and you need just that information in a query? If it’s not entered by auto enter, how can I later ever know what to enter in the creation date field for example? Or the user id. No chance.
Jan Aleman:
When do you experience it?
Believe me, we try for above mentioned reason and our customers asking what’s going on, i. e. what we do wrong to NOT have this data (the auto enter data) in the corresponding fields. We just don’t have a clue under what circumstances it happens. We only suddenly see it happened again (after one of our checks). All autor enter values like creation date, modification date, creatin user id etc. on all tables are lost.
Jan Aleman:
Are you sure it’s Servoy? How often?
We all here (3 developers) have experienced independently this problem. We are just absolutely sure that the System Value is set to none where it was previously set to creation server datetime for example. We did loose the settings about 5 to 10 times now. It’s with the PostgreSQL database version 8.x. It’s PostgreSQL with PostGIS, i. e. it’s used as a GIS database with columns having data type geom(etry). But I don’t think that is the cause. See attached screenschot for info. The data type is set to UNKNOWN TYPE#1111 by Servoy.
Jan Aleman:
Any particular workflow before it happens? Imports/exports? If during import/export how does the original look in your svn?
A list of what we do to get an idea:
We import many different files, the largest has closed to 3 Mio records (Import done with Java programming)
We use RAW SQL statements
We use the Servoy Team > Synchronize mechanism (no “external” SVN yet)
We use GIS tables (see above)
We create the database using a SQL script (generated by an external database design tool)
That’s about it what could be a bit special, of course we use many of the “normal” Servoy functionality.
I cross my fingers you or someone at Servoy may have an idea why this happens …
jcompagner:
when do you loose it exactly?
just when you are in the developer?
I assume it may have something to do with working in the Servoy Developer, but I am not sure. Let’s say, we open at one morning the Servoy Developer, and ALL auto enter values on ALL tables are set to none, i. e. the radio button System Values set to none. We are pretty sure it was always happening on the whole database, i. e. all tables, and all auto enter values are set to none!
jcompagner:
Or when importing solutions in the application server?
No, it does not happen while importing into the application server as we do not import it, the application runs internally on a server, so we do not import the solutions.
jcompagner:
If just at the developer what do you use for your team repository? Servoy or SVN?
there you have table.dbi files if you open that with a text editor then you can see there the auto enter settings (there it should be defined)
So look if it is really in that file when they are there in the eclipse table editors
and when they are not there look at the file again, is the file changed?
If that happens then something did alter the file (you could check the file stamp when that happens)
But maybe it did happen because of an update…
How do you update from the team repository? Do you just update or use synchronize and really look what is incoming?
Besides that, if you are really developing in a team, please use SVN, that is a better for team development…
there you have table.dbi files if you open that with a text editor then you can see there the auto enter settings (there it should be defined)
So look if it is really in that file when they are there in the eclipse table editors
and when they are not there look at the file again, is the file changed?
When it happened we looked at the dbi files and the auto enter information was really NOT there. After adding it for one table and syncing, it was again in the dbi file as expected. So, if it’s in the eclipse table editor and synced with the repository, it’s after that also in the dbi file - so far it is an expected behaviour and correct.
jcompagner:
If that happens then something did alter the file (you could check the file stamp when that happens)
But maybe it did happen because of an update…
How do you update from the team repository? Do you just update or use synchronize and really look what is incoming?
We do both, we use udate or commit directly, and often we use also synchronize to see what the others have done - so it is really a mix of all we are doing in daily business.
jcompagner:
Besides that, if you are really developing in a team, please use SVN, that is a better for team development…
We thought it’s easiest and safest to stay wit team synchronising as long as we don’t need more functionality like branching etc.
