urgent issue

Questions and answers for all installation-related topics for Servoy products

urgent issue

Postby Hans Nieuwenhuis » Thu May 30, 2013 11:47 pm

Hi,

I have an issue that I never had before :

I have a solution which uses a number of views (and a lot of tables)
Each of these views has a row identifier.

When i export the solution and import it in our test or production servoy-server, one of the views doen not have a row identifier.
The others do.

I even removed all solutions from a development servoy server and imported the solution, but same issue.

What could be the problem ??

I am using 5.2.15 and oracle 10g

Regards,
Hans Nieuwenhuis
Betagraphics
http://www.deltics.nl
http://www.betagraphics.nl

Servoy Version 7.3.1
Java version 1.7.0.x
Database Oracle 11g
User avatar
Hans Nieuwenhuis
 
Posts: 1026
Joined: Thu Apr 12, 2007 12:36 pm
Location: Hengelo, The Netherlands

Re: urgent issue

Postby Hans Nieuwenhuis » Fri May 31, 2013 12:34 am

Think I found it.

The view that has the problem was never used within the solution, only in a getDataSetByQuery.

So it's dbi was not exported , and therefore also not imported at the server.

I now created a (dummy) relation based on this view and then it gets exported.

Will test the importing tomorrow and let You now.

Regards,
Hans Nieuwenhuis
Betagraphics
http://www.deltics.nl
http://www.betagraphics.nl

Servoy Version 7.3.1
Java version 1.7.0.x
Database Oracle 11g
User avatar
Hans Nieuwenhuis
 
Posts: 1026
Joined: Thu Apr 12, 2007 12:36 pm
Location: Hengelo, The Netherlands

Re: urgent issue

Postby mboegem » Fri May 31, 2013 9:14 am

Hi Hans,

on exporting the solution there's also a checkbox to make Servoy export every table from the referenced servers.
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1743
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: urgent issue

Postby Harjo » Fri May 31, 2013 9:17 am

Yes, this is always tricky with Servoy! In older version of Servoy this was really never a problem, because you had to create form, for working with records.
In new versions of Servoy, we more & more, use on the fly foundsets in code, and these tables will not be referenced by Servoy. :-(
So we always create a dummy form, for every table, we use in a solution, to prevent this...
Harjo Kompagnie
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: urgent issue

Postby Harjo » Fri May 31, 2013 9:19 am

mboegem wrote:Hi Hans,

on exporting the solution there's also a checkbox to make Servoy export every table from the referenced servers.


Look closely, that is says: referenced, so if you use a server, which you only use in code, and never referenced in form or relation, this also will break...
Harjo Kompagnie
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: urgent issue

Postby Hans Nieuwenhuis » Fri May 31, 2013 9:19 am

Hello Marc,

I also thougt of that, but that only works for tables not for views

The only workaround is to create dummy usage ( like a relation ) and the servoy will export it.
I tested and it also imports on servoy server, so my issue is solved.

I am also looking into to creating a primary key on the view, that is possible in Oracle.

Thanks,
Hans Nieuwenhuis
Betagraphics
http://www.deltics.nl
http://www.betagraphics.nl

Servoy Version 7.3.1
Java version 1.7.0.x
Database Oracle 11g
User avatar
Hans Nieuwenhuis
 
Posts: 1026
Joined: Thu Apr 12, 2007 12:36 pm
Location: Hengelo, The Netherlands


Return to Installation

Who is online

Users browsing this forum: Bing [Bot] and 3 guests