Servoy Forum

We announce the immediate availability of Servoy 2.2rc5

NOTE: this is PRE-RELEASE SOFTWARE, use with caution and make BACKUPS before you start.

This version is available through auto update (if you have beta update notify enabled, meaning having the line 'wantsBetaCodeNotifies=true' in your servoy.properties file)

Previous build info

Fixes/Enhances:
[fix]-JavaScript issues due to performance enhance for string handling
[fix]-bad locale use in i18n JavaScript called from within headless client
[fix]-better module support for Servoy Runtime
[fix]-relookup incase 2 fields that has the same lookup value
[fix]-solution close method can't stop the solution closing
[fix]-more oracle clob/blob issues workaround (oracle driver flaw)
[fix]-mysql log tablename handing workaround (mysql sql parser flaw)
[fix]-valuelist in a module 2 deep (solution->module1->module2) http://forum.servoy.com/viewtopic.php?p=21084#21084
[enh]-utils.formatNumber now also supports formatNumber(number, "###,###.#") behave the same as format on field
[enh]-next/previous records commands implemented
[enh]-relation item less strict for number -> integer join
[enh]-lookup/copy values column property now also supports globals
[enh]-more checks for calcs/aggregates bound to missing server/table
[new]-databasemanager.addTableFilterParam(...) support
[new]-postgress driver

Thumbs up!!
RC5 is (in my case) looking very good!

We got an error while exporting different modules and solutions, starting with RC5.

The solution (module) refuses to export because:

com.servoy.j2db.persistence.RepositoryException: Solutions
contains references to calculation or aggregate variable on
nonexistent table 'zzzzz' in server 'xxxxx'.

Where zzzzz and xxxxx were longtime erased items.

Querying the repository, we effectively found references to these apparently erased elements, which did not prevent solutions to be exported before RC5.

Can you perhaps provide us with an option to export solutions without the faulty references? (cleaning them) Or may be to export anyway solutions containing faulty references, as these references seems to have been left by precedent versions of servoy.

By the way, the ability to export nested modules is very interesting, and we enjoy to test it as soon as we will be able to export a solution again.

UPDATE: By manually erasing all references in the repository DB, we manage to be able to export again one of the 'faulty' modules, but this is not a sustainable solution as it took several man hours (building a tool to analyse repository first)...

There is already a check for lost servers (calcs/aggregates) in rc5, we will add one more for missing table only.

We are also getting same error.

Today the Developer was auto updated from rc3 to rc5. We are getting the following error in two systems.

Code: Select all

com.servoy.j2db.persistence.RepositoryException: Solutions contains references to calculation or aggregate variable on nonexistent table 'chart_of_account' in server 'chart_of_account'.

We never created a table/server with name
'chart_of_account'
Could pls show me a way to expot the solution.
________________
Backer
Pilot Simple Software