Servoy creates a table when a view is not available

Classic Servoy
1

A form is based on a view, the view is not created when I import the solution into the production server, Servoy warns me that I have to take care of datamodels sync (good) but then it creates a table with the name of the missing view (bad).

From the import log:

Importing sprintsystem.servoy...
[info]
Import contains XML version 12 and repository version 29.
[info]
Created table 'v_articoli_disponibili' in server 'sprint'.
[warning]
WARNING! The table 'v_articoli_disponibili in server 'sprint' has type TABLE but in the import it has type VIEW. Servoy cannot keep the datamodels synchronized automatically if you use database views, please do so manually.
[info]
Added column with name 'marca' to table 'v_articoli_disponibili'.
[info]
Added column with name 'articoli_id' to table 'v_articoli_disponibili'.
[info]
Added column with name 'quantita' to table 'v_articoli_disponibili'.
[info]
Added column with name 'report_spec' to table 'v_articoli_disponibili'.
[info]
Added column with name 'modello' to table 'v_articoli_disponibili'.
[info]
Added column with name 'classe_fmv' to table 'v_articoli_disponibili'.
[info]
Added column with name 'categoria' to table 'v_articoli_disponibili'.
[info]
Added column with name 'opzioni' to table 'v_articoli_disponibili'.
[info]
Added column with name 'engineering' to table 'v_articoli_disponibili'.
[info]
Added column with name 'internal_grade' to table 'v_articoli_disponibili'.
[info]
Added column with name 'riassunto_descrizione' to table 'v_articoli_disponibili'.
[info]
Import successful...
[info]
Activated solution SprintSystem_v1_1 release 1
[info]
Activated style sintpro_white release 12
[info]
Activated style SprintSystemGreen release 6
[info]
Activated style SprintSystemGray release 5

Servoy version 3.1.4-build 408, repository version 29
java.vm.name=Java HotSpot™ Server VM
java.vm.version=1.5.0_11-b03
java.vm.info=mixed mode
java.vm.vendor=Sun Microsystems Inc.
os.name=Linux
os.version=2.6.15-1.2054_FC5smp
os.arch=i386

2

yes, we saw this also this week.

Did you report it already in the support system??

3

Yessir, id 75722

4

The problem exists vice versa. Servoy will not create a table if there is a view with the same name (not so great, I know). SQL Server 2005 for example has a (system) view called messages. I couldn’t figure out how to hide that view from the user. Now I always have trouble importing that solution. Once the table is there, Servoy queries the right table and has no problem at all with the view of the same name.