# Servoy 7.4.1

**URL:** <https://forum.servoy.com/t/servoy-7-4-1/17997>\
**Category:** Classic Servoy\
**Created:** [June 2, 2014, 6:12pm UTC](https://forum.servoy.com/t/servoy-7-4-1/17997 "2014-06-02T18:12:14Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\
**Post date:** [June 2, 2014, 6:12pm UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/1 "2014-06-02T18:12:14Z")

</div>

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](https://support.servoy.com/browse/SVY-6530) JSRecord.getPKs() returns an array of String when the PK column is of type UUID  
[fix] [SVY-6438](https://support.servoy.com/browse/SVY-6438) OnDataChange event does not triggers for checkbox with valuelist  
[fix] [SVY-6302](https://support.servoy.com/browse/SVY-6302) selectOnEnter on OSX does not work correct  
[fix] [SVY-6249](https://support.servoy.com/browse/SVY-6249) Exceptions thrown in the “after” table events are not propagated  
[fix] [SVY-6378](https://support.servoy.com/browse/SVY-6378) JSValueList.globalMethod doesn’t return the method

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

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

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

**Server changes**  
[fix] [SVY-6338](https://support.servoy.com/browse/SVY-6338) Delete all solutions is slow  
[fix] [SVY-6185](https://support.servoy.com/browse/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](https://support.servoy.com/browse/SVY-6290) using Java ApplicationServer api waitForInstanceStarted() never returns  
[fix] [SVY-6423](https://support.servoy.com/browse/SVY-6423) Update/insert failed, unexpected nr of records affected: expected 1, actual 0  
[fix] [SVY-6553](https://support.servoy.com/browse/SVY-6553) Security logout does not show in servoy-admin page  
[fix] [SVY-6603](https://support.servoy.com/browse/SVY-6603) Headless-Client blocks other Headless-Client, when performing long task

---

<div class="post-metadata">

**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\
**Post date:** [June 2, 2014, 7:44pm UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/2 "2014-06-02T19:44:32Z")

</div>

> Jan Blok:  
> [fix] [SVY-6377](https://support.servoy.com/browse/SVY-6377) Allow styling of IMAGE\_MEDIA component

Please make this link: [https://wiki.servoy.com/display/DOCS/Cu … ad+dialogs](https://wiki.servoy.com/display/DOCS/Customizing+the+image+media+and+file+upload+dialogs) under SVY-6377 public!

---

<div class="post-metadata">

**Author:** ![deezzub](https://avatars.discourse-cdn.com/v4/letter/d/dec6dc/32.png) [@deezzub](https://forum.servoy.com/u/deezzub)\
**Post date:** [June 3, 2014, 9:52am UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/3 "2014-06-03T09:52:51Z")

</div>

```auto
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?

---

<div class="post-metadata">

**Author:** ![mmuntean](https://avatars.discourse-cdn.com/v4/letter/m/e36b37/32.png) [@mmuntean](https://forum.servoy.com/u/mmuntean)\
**Post date:** [June 3, 2014, 10:17am UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/4 "2014-06-03T10:17:26Z")

</div>

“servoy\_updater.bat -releaseNumber 2028” should work.

---

<div class="post-metadata">

**Author:** ![rioba1401913570](https://avatars.discourse-cdn.com/v4/letter/r/b5a626/32.png) [@rioba1401913570](https://forum.servoy.com/u/rioba1401913570)\
**Post date:** [June 4, 2014, 8:31pm UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/5 "2014-06-04T20:31:19Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\
**Post date:** [June 5, 2014, 9:49am UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/6 "2014-06-05T09:49:11Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![rioba1401913570](https://avatars.discourse-cdn.com/v4/letter/r/b5a626/32.png) [@rioba1401913570](https://forum.servoy.com/u/rioba1401913570)\
**Post date:** [June 5, 2014, 8:44pm UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/7 "2014-06-05T20:44:58Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![siavash.roozbehan](https://avatars.discourse-cdn.com/v4/letter/s/49beb7/32.png) [@siavash.roozbehan](https://forum.servoy.com/u/siavash.roozbehan)\
**Post date:** [August 19, 2014, 11:42pm UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/8 "2014-08-19T23:42:42Z")

</div>

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:

```auto
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?

---

<div class="post-metadata">

**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\
**Post date:** [August 20, 2014, 7:23am UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/9 "2014-08-20T07:23:58Z")

</div>

strange, as an alternative eclipse update site url try:  
[http://download.servoy.com/developer/70x\_updates/](http://download.servoy.com/developer/70x_updates/)

---

<div class="post-metadata">

**Author:** ![siavash.roozbehan](https://avatars.discourse-cdn.com/v4/letter/s/49beb7/32.png) [@siavash.roozbehan](https://forum.servoy.com/u/siavash.roozbehan)\
**Post date:** [August 20, 2014, 11:39pm UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/10 "2014-08-20T23:39:57Z")

</div>

no luck with that either Jan ![:(]( "Sad")

---

<div class="post-metadata">

**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\
**Post date:** [August 21, 2014, 8:43am UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/11 "2014-08-21T08:43:42Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![siavash.roozbehan](https://avatars.discourse-cdn.com/v4/letter/s/49beb7/32.png) [@siavash.roozbehan](https://forum.servoy.com/u/siavash.roozbehan)\
**Post date:** [August 22, 2014, 4:50am UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/12 "2014-08-22T04:50:36Z")

</div>

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+

---

<div class="post-metadata">

**Author:** ![studiomiazzo](https://avatars.discourse-cdn.com/v4/letter/s/5f8ce5/32.png) [@studiomiazzo](https://forum.servoy.com/u/studiomiazzo)\
**Post date:** [September 1, 2014, 3:29pm UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/13 "2014-09-01T15:29:00Z")

</div>

When will the 7.4.2 release be available?

---

<div class="post-metadata">

**Author:** ![Jan\_Blok](https://avatars.discourse-cdn.com/v4/letter/j/41988e/32.png) [@Jan\_Blok](https://forum.servoy.com/u/Jan_Blok)\
**Post date:** [September 1, 2014, 7:19pm UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/14 "2014-09-01T19:19:36Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![grahamg](https://avatars.discourse-cdn.com/v4/letter/g/a4c791/32.png) [@grahamg](https://forum.servoy.com/u/grahamg)\
**Post date:** [September 2, 2014, 12:41pm UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/15 "2014-09-02T12:41:15Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![tgs](https://avatars.discourse-cdn.com/v4/letter/t/f19dbf/32.png) [@tgs](https://forum.servoy.com/u/tgs)\
**Post date:** [January 16, 2015, 8:51am UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/16 "2015-01-16T08:51:11Z")

</div>

[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:

```auto
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

---

<div class="post-metadata">

**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\
**Post date:** [January 16, 2015, 5:16pm UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/17 "2015-01-16T17:16:20Z")

</div>

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](https://wiki.servoy.com/pages/viewpage.action?pageId=8061867)

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

Rob

---

<div class="post-metadata">

**Author:** ![tgs](https://avatars.discourse-cdn.com/v4/letter/t/f19dbf/32.png) [@tgs](https://forum.servoy.com/u/tgs)\
**Post date:** [January 16, 2015, 5:46pm UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/18 "2015-01-16T17:46:29Z")

</div>

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:

```auto
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

---

<div class="post-metadata">

**Author:** ![tgs](https://avatars.discourse-cdn.com/v4/letter/t/f19dbf/32.png) [@tgs](https://forum.servoy.com/u/tgs)\
**Post date:** [January 19, 2015, 2:32pm UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/19 "2015-01-19T14:32:09Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\
**Post date:** [January 22, 2015, 8:32am UTC](https://forum.servoy.com/t/servoy-7-4-1/17997/20 "2015-01-22T08:32:19Z")

</div>

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?

[Next page](https://forum.servoy.com/t/servoy-7-4-1/17997.md?page=2)
