another audit trail (tracking) problem

Hi all,

I’ve been using servoy for a while now and haven’t had this problem. This is occuring on my test environment.(i have audit logs set up successfully for my other environements)

On my test server, I turn on audit trail (tracking) for a particular table. However, instead of doing the audit tracking like normal, it would ONLY create a record log_id of “0”, and record that one change and that’s it. It will not log any more. I know my links and audit log set up is correct since it does TRY to create records (but only 1 record with the PK of 0)

I’ve tried:
a) rebooting the server AND servoy services many times
1)moving the log server to another to another table.
2)deleting and re-creating the log table using servoy’s security dialog
3) creating just a simple form, and just turn on tracking for that.

The funny thing is, i have the exact specs and set up for my other test environments and it works great. anyone else experience this problem? Please help!! thanks

my specs are:

servoy 2.2.5
Java 1.5.0_06-b05
Microsoft SQL server 2000
Windows 2000 advance server

problem solved. not sure how this happend, but thru combination of deleted and recreating the log table thru Servoy and SQL server, it’s working again.

weird… </twilight zone music>