topic Re: Unix to Linux | SPDS Error: Unable to open due to incompatible data file version number in Administration and Deployment

Unix to Linux | SPDS Error: Unable to open due to incompatible data file version number

MariaD — Tue, 05 May 2020 17:49:47 GMT

Hi folks,

We're changing our SAS Server from Unix (9.4 M5, SPDS 5.3) to Linux (9.4 M6, SPDS 5.4). We copied a SPDS table from our Unix Server to our Linux Server and when we tried to open it the following error appears:

ERROR: Unable to open due to incompatible data file version number

Any ideia why? Is there any compatibility issue between Unix and Linux server?

Regards,

Re: Unix to Linux | SPDS Error: Unable to open due to incompatible data file version number

SASKiwi — Tue, 05 May 2020 20:09:21 GMT

@MariaD - I suggest you try the Migration Compatibility Calculator to identify what types of SAS files need converting: https://support.sas.com/rnd/migration/planning/files/calculator/

I suspect you need to convert SPDS tables when changing operating systems.

Re: Unix to Linux | SPDS Error: Unable to open due to incompatible data file version number

MariaD — Tue, 05 May 2020 20:17:08 GMT

@SASKiwi , I believe you are right. May I use a PROC COPY to do it?

Regards,

Re: Unix to Linux | SPDS Error: Unable to open due to incompatible data file version number

MargaretC — Tue, 05 May 2020 20:25:39 GMT

This is correct. You need to use a migration tool to be able access SPDS tables created on UNIX SAS with Linux SAS.

Re: Unix to Linux | SPDS Error: Unable to open due to incompatible data file version number

SASKiwi — Tue, 05 May 2020 20:33:47 GMT

@MariaD - I'm not familiar with SPDS tables, but you could always copy these to Base SAS tables first, migrate those, then write them back to the destination SPDS library on your new server.

Re: Unix to Linux | SPDS Error: Unable to open due to incompatible data file version number

MariaD — Tue, 05 May 2020 20:56:23 GMT

Thanks @MargaretC . What migration tool do you recommend?

Re: Unix to Linux | SPDS Error: Unable to open due to incompatible data file version number

Ksharp — Wed, 06 May 2020 11:21:46 GMT

proc cport + proc cimport

Re: Unix to Linux | SPDS Error: Unable to open due to incompatible data file version number

SASKiwi — Wed, 06 May 2020 20:18:24 GMT

@MariaD - See the PROC MIGRATE example in your other migration-related post.

Re: Unix to Linux | SPDS Error: Unable to open due to incompatible data file version number

MargaretC — Thu, 07 May 2020 14:25:34 GMT

I have a note that PROC MIGRATE does not work with SPDS. Your best bet is to use PROC CPORT and PROC CIMPORT like others have said.