Error "Invalid foundset set in form " when showing a form

Classic Servoy
1

Hi All,

I am getting a strange error message, “Invalid Foundset Set in form formName” while showing a form (please check the attachment 1)

[attachment=1]attachment1.png[/attachment]

and I have a value list which depends on the same table that the previous mentioned form’s table. One more problem is, that value list is not showing values correctly, it shows some message like, “org.mozilla.javaScript.UniqueTag:NOT_FOUND”, please check attachment 2,

[attachment=0]attachment2.png[/attachment]

Please suggest me to solve this.

Thanks in advance.

attachment2.png
attachment2.png400×530 3.26 KB

attachment1.png
attachment1.png456×530 13.9 KB

2

Hi chaitanyas,

Please check the following 3 things:

  • check if that table still exists in the database you are connecting to
  • check if Servoy disabled the table (usually because it doesn’t see a PK, then you need to assign a row ident)
  • see if the db-user used in your Servoy connection can access/see the table (db-level permissions).

Hope this helps.

3

Hi ROCALSI,

Thanks for your response and will try this.

4

I just upgraded server from 6.1.2 to 6.1.6 and now get “Invalid Foundset” errors for all my forms, including my Relationless TabPanel

The only TabPanel form that seems to “work” is the one that matches the Parent Form

and It is as if the “Default” FoundSets got disconnected for my entire solution ( a Find in one Form no longer appears in other forms with the same Table )

I then upgraded to Server 7.1.3 and had the same problems

The strange thing is that the Developer Debug Smart Client works. It does NOT pop up “Invalid Foundset” errors, so I have no easy way to debug this

I use databaseManager.setCreateEmptyFormFoundsets() in my “Open” Method, so that every Foundset starts empty

Our server is on Windows XP SP3 Java 1.6.0 43

What changed after Server 6.1.2 ? and how could the Smart Client and Debug Client behave differently ?

greg

PS
as suggested:

  • the tables still exist in the database ( and it works in Server 6.1.2 )
  • the tables are not disabled
  • all users have permission
5

Update:

Tech Support suggested there was some junk in my Repository ( a method with no name ), so I deleted the Solution in Server, and re-imported

It now appears to work

greg

6

Hi All,

Is there any solution for this error, please let me know what causes this error. I have checked the 'Rocalsi points about the table that using the form but still no luck. :cry: .

7

This is still problematic for me

Even in Servoy 7.3, I still have to delete my solution, before I can import an update

So I no longer have “Versions”. I am always at Version 1

In my “Ticket”, Tech Support suggested it was a problem with the Export / Import process

greg

8

I get the same error message, after I uploaded a modules to the application server. I’ve created a case: SVY-6500 “After uploading solution to server message: “invalid foundset set in form” appears”.

9

Hi All,

Any update on this issue, still it’s an issue at my end. Please help.

10

Yes, please help !

I’m now on 7.4.1, and it still does not work

I have to delete my Solution first, then Import, so I am always on Rev 1

Note: From my Ticket, it seems like you did identify the problem

greg

11

Hi All,

This will be fixed in the next release.

12

Just curious …

is this posted anywhere ?

greg

This will be fixed in the next release.