Hi all,

 I am using the latest version of Pervasive 10.0.

I have a couple of databases created with Pervasive 8.

On the X$Relate table: in one of databases, there is a field named Xr$Index, while on the other, the field name is Xr$PIndex.

This is causing that the tool we are using to generate the data layer crashes.

I have checked that the DEMODATA db that comes with the 10 version has the Xr$Index field, so I guess that this is coming from newer versions.

 Is there a way to "upgrade" the system tables to v10 (Xr$Index field)??

I have tried to delete the table from the database, so the engine would create a new one, but the one created also contained the "wrong" field name.

 Thank you!

 

The field was called Xr$PIndex in older versions (e.g. PSQLV8), but was changed to just Xr$Index in newer ones (e.g. PSQLv10).  The data structure is also slightly different.

You MUST match them up for it to work correctly.  From your post, it is unclear which is working and which is not (and which you think is the "wrong" field name.  

The best solution will be to create a NEW set of DDF's in PSQLv10, then add all of your tables and constraints back in, and you should have a nice clean set to work with.

Hi,

Thanks again for your reply. I am a beginner with Pervasive and I have tried to create a new DDF (I deleted the existing one and it was automatically created empty by the database when I opened), but the new empty one kept the same structure from the old one. Could you please tell me how to create this new set of DDF's in PSQLv10?

(I need the new structure)
 

Many thanks.

I created a new set of DDF's in a new directory, and X$Relate had an Xr$Index field.  I am using v10.10 released version.  What version are you using?  What process are you using?

Hi Bill,

I am using v10.1 with the latest patch applied. The problem is that I don't know how to create a new set of DDFs.

If I delete the RELATE.DDF file and open the database again, a new one is created but with the same field names.

I need to keep the existing FILE and FIELD system tables because they contain the current structure of my ddbb.

 Any ideas?

Thanks 

Pervasive created a veriaible versioning nightmare with their numbering system.  When you say v10.1, do you mean v10.01,  or v10.10?  They are VERY different.

The definition of the X$Relate table is in the DDF's, along with all of your table definitions.  DDF's are a relational database that are self-defining.  If you are only deleting this table, then you are doing no good whatsoever.

Create an empty directory first.  Create a new database in that directory.  This should create the "new" structure for the X$Relate table.  Then, run your CREATE TABLE statements in the new database to create your own tables therein as well.  I'm not aware of any other way to recreate this table without hacking all of the DDF's with a tool like WBEXEC32.
 

Hi again Bill,

Once more thank you for your reply. The version I have is 10.01, my bad. I will try to do as you say, create a new database and then use the CREATE TABLE USING.

I think Pervasive should provide together with thhe version one purchases, a tool to upgrade previous versions of the database to the one purchased...

Thanks for your help!
 

Hi,

I just wanted to share my solution. It was as simple as to select the Metadata Version 2 when creating the database.

New Database > Metadata > Version 2

Thanks.