Cannot Import DBF-based Solution into 7.2.0

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

Cannot Import DBF-based Solution into 7.2.0

Postby kwpsd » Thu Oct 10, 2013 1:04 am

Servoy Version 7.2.0

We are attempting to import a solution that was developed in Servoy 6.0.9 - build 1239 into 7.2.0 - build 2013. One of the solution's databases contains Visual FoxPro DBF files. The solution import process fails with the following error message:

Could not import solution: Data model change needed: server - arm_data_vfp table - aorders missing sequence(s) - 'seq_aorders_pk' but is not allowed from import preferences.


where 'arm_data_vfp' is the database name, and 'aorders' is the VFP DBF table name. 'aorders' does have a pk column that is set to Row Ident = row_ident, and Sequence Type = db_seq in the 6.0.9 solution.

Does anyone have any idea why the import is failing?
Kim W. Premuda
San Diego, CA USA
User avatar
kwpsd
 
Posts: 687
Joined: Sat Jul 28, 2007 6:59 pm
Location: San Diego, CA USA

Re: Cannot Import DBF-based Solution into 7.2.0

Postby kwpsd » Mon Oct 14, 2013 6:30 am

Perhaps, one of the Servoy engineers can answer this. It looks like a Servoy emitted error message.
Kim W. Premuda
San Diego, CA USA
User avatar
kwpsd
 
Posts: 687
Joined: Sat Jul 28, 2007 6:59 pm
Location: San Diego, CA USA

Re: Cannot Import DBF-based Solution into 7.2.0

Postby rgansevles » Wed Oct 23, 2013 9:51 am

Kim,

Did you tick the 'Allow data model (database) changes' checkbox at import?

It seems the importer wants to create a sequence in the db.

Rob
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1927
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL

Re: Cannot Import DBF-based Solution into 7.2.0

Postby kwpsd » Thu Oct 24, 2013 6:56 pm

Hi, Rob.

The 'Allow data model (database) changes' checkbox is ticked by default, and I do not change it when importing.

I think I stumbled across the problem...

When importing DBF tables, I discovered that a file is created for each table (e.g. seq_tableName_pk.SEQ) in the folder containing the DBF files. Apparently, if these SEQ files were created with a previous version of Servoy, they will not import into a newer version of Servoy. After deleting the SEQ files, I was able to successfully import the solution (which created a new set of SEQ files).

Question: What creates these files, Servoy or the HXTT DBF driver? If Servoy generated, it would be nice to know what the data represents:

SEQ.png
Sample SEQ File Content
SEQ.png (4.44 KiB) Viewed 4279 times


Thanks!
Kim W. Premuda
San Diego, CA USA
User avatar
kwpsd
 
Posts: 687
Joined: Sat Jul 28, 2007 6:59 pm
Location: San Diego, CA USA

Re: Cannot Import DBF-based Solution into 7.2.0

Postby rgansevles » Thu Oct 31, 2013 10:22 am

Kim,

These files are managed by the hxtt driver.

Rob
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1927
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL


Return to Installation

Who is online

Users browsing this forum: No registered users and 4 guests