Servoy 7.4.1

Classic Servoy
1

We are pleased to announce the availability of Servoy 7.4.1 release (releaseNumber 2028).

This version is available through the download option on the Servoy website and auto-update.
Always make a backup of your current Servoy installation (directory and database) before installing/upgrading.
To update a Servoy eclipse open “Check for updates” via help menu.

The issues addressed, since Servoy 7.4 release:

Client changes
[enh] SVY-6530 JSRecord.getPKs() returns an array of String when the PK column is of type UUID
[fix] SVY-6438 OnDataChange event does not triggers for checkbox with valuelist
[fix] SVY-6302 selectOnEnter on OSX does not work correct
[fix] SVY-6249 Exceptions thrown in the “after” table events are not propagated
[fix] SVY-6378 JSValueList.globalMethod doesn’t return the method

WebClient changes
[fix] SVY-6535 Internal error in rendering a dialog
[fix] SVY-6533 Pressing enter loses focus in webclient
[fix] SVY-6492 Multiselect not working in WebClient element
[fix] SVY-6483 Underline appears when table header with image and onAction method
[fix] SVY-6477 showFormInOverlay destroys HTML area in IE10 / 11
[fix] SVY-6377 Allow styling of IMAGE_MEDIA component
[fix] SVY-6363 Re-opening webclient in a new tab shows solution’s first form, doesn’t run onSolutionOpen
[fix] SVY-6297 Vertical alignment center/default not working in Web Client
[fix] SVY-6289 Popup menus cannot be shown at the correct position
[fix] SVY-6251 Problem changing the selection from field that have “format” applied to it
[fix] SVY-5660 Cannot iterate over FoundSet reliably
[fix] SVY-5583 warning in log “Calling initForJSUsage on a destroyed form”
[fix] SVY-6389 getScrollX(),getScrollY() and setScroll(x,y) don’t work
[fix] SVY-6557 Calendar input element displays date in wrong font

MobileClient changes
[enh] SVY-6546 application.getUserProperty is not working in Mobile client
[enh] SVY-6515 DataSource URL inconsistency in Mobile getFoundSet for In-Mem DataSource
[fix] SVY-6465 i18n.getI18NMessage invalid key results inconsistent between Smart & Mobile clients
[fix] SVY-6464 i18n.getI18NMessage(String, Array) does not work in Mobile
[fix] SVY-6398 Scripts included in the Servoy Media library get included with an incorrect encoding
[fix] SVY-6261 getUUIDPKValueAsString returns NULL for records created on mobile

Developer changes
[fix] SVY-6501 Mobile Export incorrect if you don’t complete wizard
[fix] SVY-6474 Unit tests with syntax errors do not fail when they are run through Jenkins
[fix] SVY-6433 Error (NullPointerExceptiopn) after removing foundsetfilters
[fix] SVY-6388 “Error updating table” during “Update Meta Data…” into workspace
[fix] SVY-6369 When unit tests are run through Jenkins, the output log is flooded with info messages
[fix] SVY-6316 Debugger “Step Over” button acts like “Step Into” button
[fix] SVY-6278 The user operation if waiting for building to complete, takes a long time
[fix] SVY-6250 Warnings for tables without pk that have row ident
[fix] SVY-6181 Debugger starts in function with no breakpoint and ignores function with breakpoint
[fix] SVY-5470 Dataset row application.output different then interactive Console
[fix] SVY-6224 Incorrect interpretation of * (Any) in JSDoc

Server changes
[fix] SVY-6338 Delete all solutions is slow
[fix] SVY-6185 Warning log message “Cannot sort on dataprovider…” appears in Server Log even when no sorting is being performed by our code or by the user
[fix] SVY-6290 using Java ApplicationServer api waitForInstanceStarted() never returns
[fix] SVY-6423 Update/insert failed, unexpected nr of records affected: expected 1, actual 0
[fix] SVY-6553 Security logout does not show in servoy-admin page
[fix] SVY-6603 Headless-Client blocks other Headless-Client, when performing long task

2

Jan Blok:
[fix] SVY-6377 Allow styling of IMAGE_MEDIA component

Please make this link: https://wiki.servoy.com/display/DOCS/Cu … ad+dialogs under SVY-6377 public!

3 
c:\Servoy7>servoy_updater.bat
Current Servoy version 2026
Checking for new Servoy version
Working in directory: c:\Servoy7
Loading version info...
No update found, if you want beta versions start with option: -beta
Done, Servoy can be started
Drücken Sie eine beliebige Taste . . .

Is there no Servoy server update?

4

“servoy_updater.bat -releaseNumber 2028” should work.

5

Still no joy with the it2be FtpPlugin that is no more loading since 7.4 release. See case SVY-6116

6

We tested one of the reported plugins in that case and it worked fine, as a test you might want to try to copy commons-logging.jar from application_server/lib dir into application_server/plugins to see if there is any change

7

Thanks a lot. Copying the commons-logging.jar to plugins folder has solved the problem. Now the plugin is correctly loaded.

8

Hi guys, I’m trying to update my developer from 7.3.1 to 7.4.1 and it doesn’t let me do it. I get this error:

An error occurred while collecting items to be installed
session context was:(profile=Servoy, phase=org.eclipse.equinox.internal.p2.engine.phases.Collect, operand=, action=).
Unable to read repository at https://www.servoy.com/developer/70x_updates/plugins/org.eclipse.emf.common_2.9.2.v20131212-0545.jar.
The server download.servoy.com failed to respond
Unable to read repository at https://www.servoy.com/developer/70x_updates/plugins/org.eclipse.emf.common.ui_2.8.0.v20130610-0406.jar.
The server download.servoy.com failed to respond
Unable to read repository at https://www.servoy.com/developer/70x_updates/plugins/org.eclipse.emf.ecore_2.9.2.v20131212-0545.jar.
The server download.servoy.com failed to respond
Unable to read repository at https://www.servoy.com/developer/70x_updates/plugins/org.eclipse.emf.ecore.change_2.9.0.v20131212-0545.jar.
The server download.servoy.com failed to respond
Unable to read repository at https://www.servoy.com/developer/70x_updates/plugins/org.eclipse.emf.ecore.xmi_2.9.1.v20131212-0545.jar.
The server download.servoy.com failed to respond
Unable to read repository at https://www.servoy.com/developer/70x_updates/plugins/org.eclipse.emf.edit_2.9.0.v20130610-0406.jar.
The server download.servoy.com failed to respond
Unable to read repository at https://www.servoy.com/developer/70x_updates/plugins/org.eclipse.emf.edit.ui_2.9.0.v20130610-0406.jar.
The server download.servoy.com failed to respond
Unable to read repository at https://www.servoy.com/developer/70x_updates/plugins/org.eclipse.wst.common.emf_1.2.200.v201301171800.jar.
The server download.servoy.com failed to respond
Unable to read repository at https://www.servoy.com/developer/70x_updates/features/org.eclipse.emf.common_2.9.2.v20131212-0545.jar.
The server download.servoy.com failed to respond
Unable to read repository at https://www.servoy.com/developer/70x_updates/features/org.eclipse.emf.common.ui_2.8.0.v20130610-0406.jar.
The server download.servoy.com failed to respond
Unable to read repository at https://www.servoy.com/developer/70x_updates/features/org.eclipse.emf.ecore_2.9.2.v20131212-0545.jar.
The server download.servoy.com failed to respond
Unable to read repository at https://www.servoy.com/developer/70x_updates/features/org.eclipse.emf.edit_2.9.0.v20130610-0406.jar.
The server download.servoy.com failed to respond
Unable to read repository at https://www.servoy.com/developer/70x_updates/features/org.eclipse.emf.edit.ui_2.9.0.v20130610-0406.jar.
The server download.servoy.com failed to respond

I have tried to remove servoy update url, restart the editor add the url back and restart the editor again and still no luck. Is there any suggestions?

9

strange, as an alternative eclipse update site url try:
http://download.servoy.com/developer/70x_updates/

10

no luck with that either Jan :(

11

Strange, just tested and works over here, try a full install?

12

Yeah I can’t find out what is the issue. There is no problem with the fresh install though. But the reason I was trying to update my current installation was the Browsersuite bean as it breaks the developer the moment you install it over servoy 7.4+ but it seems to be ok if you have it already installed and then update your servoy to verson 7.4+

13

When will the 7.4.2 release be available?

14

We started working on the 7.4.2 release candidate last friday, expect RC this week.

15

Would be great if you guys could include SVY-6765 in 7.4.2

The copy/paste bug was new to 7.4 and catches me out a lot.

Cheers

16

[fix] SVY-6423 Update/insert failed, unexpected nr of records affected: expected 1, actual 0

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:

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

17

Hi Thomas,

This error indicates that Servoy wanted to do an update or a delete and the datase driver indicated nothing has actulaly changed.

The Servoy Wiki describes some situations and a setting that turns this exception into a warning:
https://wiki.servoy.com/pages/viewpage. … Id=8061867

Best to find the cause of this.
Does the log file also show the sql statement that was failing?

Rob

18

Hi Rob,

thank you for your reply.

I will read the Errors & Warnings wiki and perhaps I am able to indicate the error.

The log file also shows the sql statment that was failing:

Error executing sql: update sped_auftrag set date_modification=?, uid_rec_modification=?, auftrag_dat=?, kunden_nr=?, ladeadr_nr=?, entladeadr_nr=?, anschrift_kunde=?, anschrift_ladeadresse=?, anschrift_entladeadresse=?, kurzansch_kunde=?, kurzansch_ladeadresse=?, kurzansch_entladeadresse=?, region_kunde=?, text_zusatztext=?, text_sonstiges=?, fax_nr_kunde=?, artikel_nr=?, artikel_bezeichnung=?, menge=?, einheit=?, einzelpreis_re=?, einzelpreis_tpgs=?, berechnung_re=?, berechnung_tpgs=?, berechnung_vgs=?, toleranz_menge=?, ust_satz=?, uid_kunde=?, email_kunde=?, uid_artikel=?, uid_ladeadresse=?, uid_entladeadresse=?, ust_satz_transporteur=?, ust_satz_vermittler=?, select_text_1_auftragbest_int=?, select_text_1_tpauftrag_int=?, uid_mandant=?, menge_fahrten=?, mandant_st_schluessel=?, menge_transportiert=?, kunde_firma=?, kunde_ort=?, ladeadresse_firma=?, ladeadresse_ort=?, entladeadresse_firma=?, entladeadresse_ort=?, text_lock=?, check_dispoplan_int=?, menge_auftrag=?, menge_auftrag_rest=?, uid_real_client_group=? where uid_auftrag = ? and uid_real_client_group = ? with params: [2015-01-16 16:10:37.788 ,type: java.sql.Timestamp, '23' ,type: java.lang.String, 2015-01-16 16:11:22.524 ,type: java.sql.Timestamp, 10075 ,type: java.lang.Integer, 32435 ,type: java.lang.Integer, 32367 ,type: java.lang.Integer, 'xxx' ,type: java.lang.String, 'xxx' ,type: java.lang.String, 'xxx' ,type: java.lang.String, 'xxx' ,type: java.lang.String, 'xxx' ,type: java.lang.String, 'xxx' ,type: java.lang.String, 'Inland' ,type: java.lang.String, '' ,type: java.lang.String, 'Lade- und liefernummer: ' ,type: java.lang.String, 'xxx' ,type: java.lang.String, 1161 ,type: java.lang.Integer, 'Silicium metal, lose' ,type: java.lang.String, 25.0 ,type: java.lang.Double, 'to' ,type: java.lang.String, 49 ,type: java.math.BigDecimal, 44 ,type: java.math.BigDecimal, 'Einheit' ,type: java.lang.String, 'Einheit' ,type: java.lang.String, 'Einheit' ,type: java.lang.String, 5.0 ,type: java.lang.Double, 19.0 ,type: java.lang.Double, 23413 ,type: java.lang.Integer, 'info@xxx' ,type: java.lang.String, 1809 ,type: java.lang.Integer, 33281 ,type: java.lang.Integer, 32983 ,type: java.lang.Integer, 19.0 ,type: java.lang.Double, 19.0 ,type: java.lang.Double, 1 ,type: java.lang.Long, 1 ,type: java.lang.Long, 6 ,type: java.lang.Integer, 1.0 ,type: java.lang.Double, 23 ,type: java.lang.Integer, 0.0 ,type: java.lang.Double, 'xxx' ,type: java.lang.String, 'xxx' ,type: java.lang.String, 'xxx' ,type: java.lang.String, 'Anglefort' ,type: java.lang.String, 'xxx' ,type: java.lang.String, 'Ranshofen' ,type: java.lang.String, 'Berechnungsart geändert von in Einheit am 16.01.2015 16:11[Maciek] Menge Fahrten: 1 am 16.01.2015 16:11 [Maciek] Bestellmenge: 25 to am 16.01.2015 16:11 [Maciek] Auftragsmenge: 25 to am 16.01.2015 16:11 [Maciek] KD-Auftrag erstellt am: 16.01.2015 16:11 [Maciek] ' ,type: java.lang.String, 1 ,type: java.lang.Long, 25.0 ,type: java.lang.Double, 25.0 ,type: java.lang.Double, 'client1' ,type: java.lang.String, 40762 ,type: java.lang.Long, 'client1' ,type: java.lang.String]

A table filter is set by ‘client1’, ‘client2’… because of differnt customers (clients) are using the solution. But this is working for years without code changes. I don’t touched the code for that and also the PSQL behind is stiil 9.3.
It’s also strange that the same issue occurs only on some clients and not always.

Regards

19

I think the table filter in my solution occurs the error “Update/insert failed, unexpected nr of records affected: expected 1, actual 0”.

I have checked my code, but the table filter id will be set even a new record is created (like in the past as it worked).
Because I had to fix this problem immediately, I have disabled the table filter function and switched every client to his own sql db. This cost me the whole weekend.

Today Servoy is working without problems and errors, but this can’t be the solution!

Regards

20

Thomas, as rob already explained this is not directly a problem in servoy, and you could just turn this error off (or make it just a warning) see the wiki page.

But it is better to look at the actual cause, because the code (the client) expects that it would update (or insert) a record into the database, but the database reports that nothing is really changed
So no record is updated or inserted, which should really have happened because an update or insert statement was send to the database to update a record.

So the question is should the update statement for that record really have happened for that client?
so look at the where part: where uid_auftrag = 40752 and uid_real_client_group = ‘client1’

does that where part hit a record? and if not why? is that auftrag record (with id 40752) really belonging to another client?