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

Questions and answers for designing and implementing forms in Servoy

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

Postby chaitanyas » Fri Oct 04, 2013 10:08 am

Hi All,

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

attachment1.png
attachment1.png (20.13 KiB) Viewed 8991 times


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,

attachment2.png
attachment2.png (14.58 KiB) Viewed 8991 times


Please suggest me to solve this.

Thanks in advance.
chaitanyas
 
Posts: 101
Joined: Tue Jul 26, 2011 8:28 am

Re: Error "Invalid foundset set in form " when showing a for

Postby ROCLASI » Tue Oct 08, 2013 11:48 am

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.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Error "Invalid foundset set in form " when showing a for

Postby chaitanyas » Tue Oct 29, 2013 4:44 pm

Hi ROCALSI,


Thanks for your response and will try this.
chaitanyas
 
Posts: 101
Joined: Tue Jul 26, 2011 8:28 am

Re: Error "Invalid foundset set in form " when showing a for

Postby gdurniak » Sun Nov 17, 2013 3:12 pm

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
File Shoppe
gdurniak
 
Posts: 232
Joined: Thu Jul 08, 2004 7:25 pm
Location: Bayside, NY, USA

Re: Error "Invalid foundset set in form " when showing a for

Postby gdurniak » Thu Nov 28, 2013 12:00 pm

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
File Shoppe
gdurniak
 
Posts: 232
Joined: Thu Jul 08, 2004 7:25 pm
Location: Bayside, NY, USA

Re: Error "Invalid foundset set in form " when showing a for

Postby chaitanyas » Fri Apr 11, 2014 8:59 am

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: .
chaitanyas
 
Posts: 101
Joined: Tue Jul 26, 2011 8:28 am

Re: Error "Invalid foundset set in form " when showing a for

Postby gdurniak » Fri Apr 11, 2014 1:07 pm

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
File Shoppe
gdurniak
 
Posts: 232
Joined: Thu Jul 08, 2004 7:25 pm
Location: Bayside, NY, USA

Re: Error "Invalid foundset set in form " when showing a for

Postby deezzub » Fri Apr 25, 2014 8:28 am

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".
deezzub
 
Posts: 328
Joined: Tue May 28, 2013 3:02 pm
Location: Oldenburg, Germany

Re: Error "Invalid foundset set in form " when showing a for

Postby chaitanyas » Tue Sep 30, 2014 5:20 am

Hi All,

Any update on this issue, still it's an issue at my end. Please help.
chaitanyas
 
Posts: 101
Joined: Tue Jul 26, 2011 8:28 am

Re: Error "Invalid foundset set in form " when showing a for

Postby gdurniak » Wed Oct 01, 2014 3:10 pm

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
File Shoppe
gdurniak
 
Posts: 232
Joined: Thu Jul 08, 2004 7:25 pm
Location: Bayside, NY, USA

Re: Error "Invalid foundset set in form " when showing a for

Postby chaitanyas » Tue Oct 21, 2014 8:49 am

Hi All,

This will be fixed in the next release.
chaitanyas
 
Posts: 101
Joined: Tue Jul 26, 2011 8:28 am

Re: Error "Invalid foundset set in form " when showing a for

Postby gdurniak » Tue Oct 21, 2014 2:36 pm

Just curious …

is this posted anywhere ?

greg

> This will be fixed in the next release.
File Shoppe
gdurniak
 
Posts: 232
Joined: Thu Jul 08, 2004 7:25 pm
Location: Bayside, NY, USA


Return to Forms

Who is online

Users browsing this forum: No registered users and 5 guests