Search does not work on application server

Classic Servoy
1

I uploaded a solution to our test application server and on that server the search does not work. I only get the message: “No records found, search again?”. In the Smart Client from Seroy Developer the search works.

The servoy_log.txt from the server.:

2014-01-27 18:55:04,544 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - used sql select SCHIFFNAME, VESSEL_NR from FLOTTE  order by SCHIFFNAME asc, SERVOY_SE asc, VESSEL_ID asc, VESSEL_NR asc questiondata.length <none> [ ]
2014-01-27 18:55:04,544 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - RMI TCP Connection(25)-172.20.20.9-COS: Written 4194 bytes, compressed: 71% [ ]
2014-01-27 18:55:04,544 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - RMI TCP Connection(25)-172.20.20.9-CIS: Read 83 bytes, compressed: 93% [ ]
2014-01-27 18:55:04,544 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - sql select SELECT VESSELDOCS<db:/boss_db/vesseldocs>#VESSELDOCS6647.15589=ID_NR<4,0,0> IDENTITY FROM VESSELDOCS<db:/boss_db/vesseldocs>#VESSELDOCS6647 SV:S ((VESSELDOCS<db:/boss_db/vesseldocs>#VESSELDOCS6647.15595=VESSEL_NR<2,11,0>)=([527.0]) AND (VESSELDOCS<db:/boss_db/vesseldocs>#VESSELDOCS6647.15589=ID_NR<4,0,0> IDENTITY)=([47]) AND (VESSELDOCS<db:/boss_db/vesseldocs>#VESSELDOCS6647.15595=VESSEL_NR<2,11,0>)=([527.0])) ORDER BY VESSELDOCS<db:/boss_db/vesseldocs>#VESSELDOCS6647.15589=ID_NR<4,0,0> IDENTITY ASC [ ]
2014-01-27 18:55:04,544 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - Analysing filters null [ ]
2014-01-27 18:55:04,544 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - SELECT VESSELDOCS<db:/boss_db/vesseldocs>#VESSELDOCS6647.15589=ID_NR<4,0,0> IDENTITY FROM VESSELDOCS<db:/boss_db/vesseldocs>#VESSELDOCS6647 SV:S ((VESSELDOCS<db:/boss_db/vesseldocs>#VESSELDOCS6647.15595=VESSEL_NR<2,11,0>)=([527.0]) AND (VESSELDOCS<db:/boss_db/vesseldocs>#VESSELDOCS6647.15589=ID_NR<4,0,0> IDENTITY)=([47]) AND (VESSELDOCS<db:/boss_db/vesseldocs>#VESSELDOCS6647.15595=VESSEL_NR<2,11,0>)=([527.0])) ORDER BY VESSELDOCS<db:/boss_db/vesseldocs>#VESSELDOCS6647.15589=ID_NR<4,0,0> IDENTITY ASC FILTER null [ ]
2014-01-27 18:55:04,544 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - QuerySet { prepares = <null>, select = select ID_NR from VESSELDOCS  where VESSEL_NR = ? and ID_NR = ? and VESSEL_NR = ? order by ID_NR asc [[527.0,47,527.0]], cleanups = <null> } [ ]
2014-01-27 18:55:04,544 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - used sql select ID_NR from VESSELDOCS  where VESSEL_NR = ? and ID_NR = ? and VESSEL_NR = ? order by ID_NR asc questiondata.length 3 [ ]
2014-01-27 18:55:04,544 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - questiondata[0] = 527.0 ,type: java.lang.Double ,overrideType: 2 [ ]
2014-01-27 18:55:04,544 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - questiondata[1] = 47 ,type: java.lang.Long ,overrideType: 4 [ ]
2014-01-27 18:55:04,544 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - questiondata[2] = 527.0 ,type: java.lang.Double ,overrideType: 2 [ ]
2014-01-27 18:55:04,544 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - RMI TCP Connection(25)-172.20.20.9-COS: Written 32 bytes, compressed: 94% [ ]
2014-01-27 18:55:04,560 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - RMI TCP Connection(25)-172.20.20.9-CIS: Read 19 bytes, compressed: 97% [ ]
2014-01-27 18:55:04,560 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - sql select SELECT FLOTTE<db:/boss_db/flotte>#FLOTTE6648.220369=SERVOY_SE<12,36,0>,FLOTTE<db:/boss_db/flotte>#FLOTTE6648.14614=VESSEL_ID<4,0,0> IDENTITY,FLOTTE<db:/boss_db/flotte>#FLOTTE6648.14465=VESSEL_NR<4,0,0> FROM FLOTTE<db:/boss_db/flotte>#FLOTTE6648 ORDER BY FLOTTE<db:/boss_db/flotte>#FLOTTE6648.14465=VESSEL_NR<4,0,0> ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6648.14614=VESSEL_ID<4,0,0> IDENTITY ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6648.220369=SERVOY_SE<12,36,0> ASC [ ]
2014-01-27 18:55:04,560 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - Analysing filters null [ ]
2014-01-27 18:55:04,560 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - SELECT FLOTTE<db:/boss_db/flotte>#FLOTTE6648.220369=SERVOY_SE<12,36,0>,FLOTTE<db:/boss_db/flotte>#FLOTTE6648.14614=VESSEL_ID<4,0,0> IDENTITY,FLOTTE<db:/boss_db/flotte>#FLOTTE6648.14465=VESSEL_NR<4,0,0> FROM FLOTTE<db:/boss_db/flotte>#FLOTTE6648 ORDER BY FLOTTE<db:/boss_db/flotte>#FLOTTE6648.14465=VESSEL_NR<4,0,0> ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6648.14614=VESSEL_ID<4,0,0> IDENTITY ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6648.220369=SERVOY_SE<12,36,0> ASC FILTER null [ ]
2014-01-27 18:55:04,560 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - QuerySet { prepares = <null>, select = select SERVOY_SE, VESSEL_ID, VESSEL_NR from FLOTTE  order by VESSEL_NR asc, VESSEL_ID asc, SERVOY_SE asc [<null>], cleanups = <null> } [ ]
2014-01-27 18:55:04,560 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - used sql select SERVOY_SE, VESSEL_ID, VESSEL_NR from FLOTTE  order by VESSEL_NR asc, VESSEL_ID asc, SERVOY_SE asc questiondata.length <none> [ ]
2014-01-27 18:55:04,560 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - RMI TCP Connection(25)-172.20.20.9-COS: Written 4500 bytes, compressed: 66% [ ]
2014-01-27 18:55:04,560 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - RMI TCP Connection(25)-172.20.20.9-CIS: Read 21 bytes, compressed: 97% [ ]
2014-01-27 18:55:04,560 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - sql select SELECT FLOTTE<db:/boss_db/flotte>#FLOTTE6649.220369=SERVOY_SE<12,36,0>,FLOTTE<db:/boss_db/flotte>#FLOTTE6649.14614=VESSEL_ID<4,0,0> IDENTITY,FLOTTE<db:/boss_db/flotte>#FLOTTE6649.14465=VESSEL_NR<4,0,0> FROM FLOTTE<db:/boss_db/flotte>#FLOTTE6649 ORDER BY FLOTTE<db:/boss_db/flotte>#FLOTTE6649.14462=SCHIFFNAME<12,50,0> ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6649.220369=SERVOY_SE<12,36,0> ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6649.14614=VESSEL_ID<4,0,0> IDENTITY ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6649.14465=VESSEL_NR<4,0,0> ASC [ ]
2014-01-27 18:55:04,560 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - Analysing filters null [ ]
2014-01-27 18:55:04,560 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - SELECT FLOTTE<db:/boss_db/flotte>#FLOTTE6649.220369=SERVOY_SE<12,36,0>,FLOTTE<db:/boss_db/flotte>#FLOTTE6649.14614=VESSEL_ID<4,0,0> IDENTITY,FLOTTE<db:/boss_db/flotte>#FLOTTE6649.14465=VESSEL_NR<4,0,0> FROM FLOTTE<db:/boss_db/flotte>#FLOTTE6649 ORDER BY FLOTTE<db:/boss_db/flotte>#FLOTTE6649.14462=SCHIFFNAME<12,50,0> ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6649.220369=SERVOY_SE<12,36,0> ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6649.14614=VESSEL_ID<4,0,0> IDENTITY ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6649.14465=VESSEL_NR<4,0,0> ASC FILTER null [ ]
2014-01-27 18:55:04,560 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - QuerySet { prepares = <null>, select = select SERVOY_SE, VESSEL_ID, VESSEL_NR from FLOTTE  order by SCHIFFNAME asc, SERVOY_SE asc, VESSEL_ID asc, VESSEL_NR asc [<null>], cleanups = <null> } [ ]
2014-01-27 18:55:04,560 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - used sql select SERVOY_SE, VESSEL_ID, VESSEL_NR from FLOTTE  order by SCHIFFNAME asc, SERVOY_SE asc, VESSEL_ID asc, VESSEL_NR asc questiondata.length <none> [ ]
2014-01-27 18:55:04,560 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - RMI TCP Connection(25)-172.20.20.9-COS: Written 4414 bytes, compressed: 68% [ ]
2014-01-27 18:55:04,575 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - RMI TCP Connection(25)-172.20.20.9-CIS: Read 18 bytes, compressed: 98% [ ]
2014-01-27 18:55:04,575 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - sql select SELECT FLOTTE<db:/boss_db/flotte>#FLOTTE6650.14462=SCHIFFNAME<12,50,0>,FLOTTE<db:/boss_db/flotte>#FLOTTE6650.14465=VESSEL_NR<4,0,0> FROM FLOTTE<db:/boss_db/flotte>#FLOTTE6650 ORDER BY FLOTTE<db:/boss_db/flotte>#FLOTTE6650.14462=SCHIFFNAME<12,50,0> ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6650.220369=SERVOY_SE<12,36,0> ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6650.14614=VESSEL_ID<4,0,0> IDENTITY ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6650.14465=VESSEL_NR<4,0,0> ASC [ ]
2014-01-27 18:55:04,575 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - Analysing filters null [ ]
2014-01-27 18:55:04,575 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - SELECT FLOTTE<db:/boss_db/flotte>#FLOTTE6650.14462=SCHIFFNAME<12,50,0>,FLOTTE<db:/boss_db/flotte>#FLOTTE6650.14465=VESSEL_NR<4,0,0> FROM FLOTTE<db:/boss_db/flotte>#FLOTTE6650 ORDER BY FLOTTE<db:/boss_db/flotte>#FLOTTE6650.14462=SCHIFFNAME<12,50,0> ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6650.220369=SERVOY_SE<12,36,0> ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6650.14614=VESSEL_ID<4,0,0> IDENTITY ASC,FLOTTE<db:/boss_db/flotte>#FLOTTE6650.14465=VESSEL_NR<4,0,0> ASC FILTER null [ ]
2014-01-27 18:55:04,575 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - QuerySet { prepares = <null>, select = select SCHIFFNAME, VESSEL_NR from FLOTTE  order by SCHIFFNAME asc, SERVOY_SE asc, VESSEL_ID asc, VESSEL_NR asc [<null>] <0^-1>, cleanups = <null> } [ ]
2014-01-27 18:55:04,575 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - used sql select SCHIFFNAME, VESSEL_NR from FLOTTE  order by SCHIFFNAME asc, SERVOY_SE asc, VESSEL_ID asc, VESSEL_NR asc questiondata.length <none> [ ]
2014-01-27 18:55:04,575 INFO [RMI TCP Connection(25)-172.20.20.9] com.servoy.j2db.util.Debug - RMI TCP Connection(25)-172.20.20.9-COS: Written 4187 bytes, compressed: 71% [ ]
2014-01-27 18:56:14,638 INFO [RMI Scheduler(0)] com.servoy.j2db.util.Debug - Compressing socket closed [ ]

How can I debug this on the application server?

2

I use the Servoy Framework search function. It works for all columns also on our Servoy Production Server. The involved tables are FoxPro DBFs.

3

Found the problem which causes this. I have 2 fields on table the form. Both they uses a dataprovider vessel_nr, but one field is for showing the vessel_nr and the other for showing the vessel_name. The vessel_name field has a global valuelist filled by another table, that is used for providing type ahead for vessel names. On the test application server, the vessel DBF table has a record with a vessel_nr, but no vessel_name, so the vessel name field automatically selects this record.

Is this maybe a Servoy bug?

I found another problem. I have a column document_info in the table in that I want to search. That is a text field and stored as text in database. No relation or valuelist used on this field. The records for this field contains records like: “GA Plan”, “Docking Plan” etc… If search in Developer for “Plan” it finds all records that contain this string, but this doesn’t work on the application server.

4

deezzub:
I found another problem. I have a column document_info in the table in that I want to search. That is a text field and stored as text in database. No relation or valuelist used on this field. The records for this field contains records like: “GA Plan”, “Docking Plan” etc… If search in Developer for “Plan” it finds all records that contain this string, but this doesn’t work on the application server.

The problem is caused by the svy_framework database. I changed the svy_framework database on the test application server to the same svy_framework database, that we use in the Servoy Developer. After that, the search works.