This issue is back in Servoy 7.4.2!
The SQL update failed, no data is saved to the database and clients get the error message dialog "cannot save data".
The complete error log from servoy_server:
- Code: Select all
com.servoy.j2db.util.ServoyException: Update/insert failed, unexpected nr of records affected: expected 1, actual 0
at com.servoy.j2db.server.dataprocessing.Zw.Za(Zw.java:1088)
at com.servoy.j2db.server.dataprocessing.Zw.performUpdates(Zw.java:479)
at sun.reflect.GeneratedMethodAccessor189.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:322)
at sun.rmi.transport.Transport$1.run(Transport.java:177)
at sun.rmi.transport.Transport$1.run(Transport.java:174)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:173)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:556)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:811)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:670)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Is there a workaround for this, because it is a major problem for our customers if the data is not stored to the database!?
Server:
Servoy version 7.4.2 -releaseNumber 2033
java.version=1.7.0_71
os.name=Mac OS X
os.version=10.9.5
Clients:
Windows 7 64bit
Java 1.7.0_71