When you use SAS^® Environment Manager to import tables from Oracle, DB2, or SAS^® LASR™ libraries into SAS Viya from SAS 9, the import action may fail with the following error message:  

This error can be caused by a version mismatch between a component of the import9 and transfer services.

To check these versions, run the following commands and confirm that the transfer-representations versions match between the import9-service and transfer-service jars.

Linux (requires an unzip command)

1. As the SAS user, navigate to /opt/sas/viya/home/libexec.
2. Run this command:
   
   for package in $(ls | egrep '(import9|transfer)'); do unzip -l $package | grep transfer-representations; done
    
3. The output will list the versions for each file:
   
   BOOT-INF/lib/transfer-representations-3.3.3.jar
   BOOT-INF/lib/transfer-representations-3.3.3.jar

Windows

1. In PowerShell, navigate to C:\Program Files\SAS\Viya\libexec.
2. Run these commands:

   [Reflection.Assembly]::LoadWithPartialName('System.IO.Compression.FileSystem')

   foreach($sourceFile in (Get-ChildItem -filter '*.jar' | Where-Object { $_.Name -match '^import9.*|^transfer.*' })){[IO.Compression.ZipFile]::OpenRead($sourceFile.FullName).Entries.FullName | %{ "$sourcefile`:$_" } | findstr "transfer-representations" }
    

3. The output will list the versions for each file:

   import9-service-1.0.33.jar:BOOT-INF/lib/transfer-representations-4.0.5.jar
   transfer-service-2.27.1.jar:BOOT-INF/lib/transfer-representations-4.1.7.jar

If the versions do not match, SAS Viya must be updated.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

Operating System and Release Information

Viya on Windows: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Windows Deployment Guide at

Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at