Verify - No entry for this table in X$FILE

[devoted]

I just inherited a site - Sage 300 6.0A, Windows Server 2008, Pervasive 10.2 - when running a verify on one of the company databases I get:

SPAUD: No entry for this table in X$FILE.
SPCHG: No entry for this table in X$FILE.
SPERR: No entry for this table in X$FILE.
SPGLB: No entry for this table in X$FILE.

Pervasive DAT files for the above exist in the data folder but there is no record of this in metadata. Sage Dump does not complete (I am testing migrating to MS SQL Server and upgrading to Sage 300 2012). In Sage in this company Vendor Change 5.5 was activated but all other modules were on 6.0. I activated Vendor Change 6.0 but it did not help the verify error. There are unfortunately a number of old installs still on the server.

Any help or advice would be appreciated. Thanks in advance.

 

[ettienne]

SP is vendor number changer, so it's not critical.
Does the dump fail on the SP files?

 

[devoted]

Thanks ettienne, Dump is throwing - SELECT (ec=49153) in a message box. The dataset directory at that point has all the files up to SPAUD.REC (that is 0KB in size). After I press Ok on the message box it deletes all the dump files.

 

[ettienne]

So it does not find the SP tables. Create a new company and then activate the same modules except for SP. Copy the *.DAT files from your live company data folder to the new company data folder - but do not copy DATADICT.DAT. You should now be able to run a dump without SP activated.

 

[devoted]

Thanks I will try this out as soon as I can.

 

[devoted]

Thanks ettienne, I did come right with this.