No selection set on foundset with size 1

[rossent]

Hi all,

We are getting the following error logged in the Java console when using a Smart Client connected to an application server:

SEVERE: No selection set on foundset with size 1 fs: RelatedFoundSet[Table:some_table_name,Size: 1,Relation: some_relation_name,CachedRecords: 1,SELECTED INDEX: 0, Args: 1.G;36.A0F53B35-8E91-4E6B-9DF0-4B1212986268;1.C;1.C;]

It appears that the error is generated when we make a call to: databaseManager.hasRecords(foundset). We cannot reproduce the error when using the Smart Client from Servoy Developer. The error is also not present when using the Web Client connected to the same application server. The relation in question uses for the join 1 column from the table (the column is of type UUID) and 2 scope variables (of type String) The error is not propagated to the client and our code appears to be executing correctly.

What causes this SEVERE error and how can we address it? Is it something which we should worry about since it is not propagated to our Servoy code?

Thank you in advance for your help!

[rossent]

Hi Servoy,
Any input on this?

[jcompagner]

it should be selected, but sometimes when the selected record is asked for the selection is still -1 even if the size is bigger then 0
When you see that message we auto correct this and select the first record. (and print out that statement)
So its not really something to worry about, but we could have a look when you have something reproducible

[rossent]

Thanks for the update. Perhaps then this log message should not be classified as SEVERE but rather as DEBUG or INFO... along with some explanation that the selection will be set automatically to 1.