SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 18459: "Unable to create data" error when you replace SAS server on a migrated project

DetailsHotfixAboutRate It

If you attempt to Replace the SAS server on a project migrated into SAS® Enterprise Guide® 4.1 from a previous release of SAS Enterprise Guide, you might receive the following error message:

Unable to create data WORK.QURYXXXX on Servername

This will typically happen when you have a table used as input to a task or when a query does not exist on the server you are specifying in the replace.

For example, if you have an input table to a query that outputs to a WORK table, and that WORK table is also input into another query such as in the following:

Input table ► Query ► WORK.QURY1 table ► Query ► WORK.QURY2 table

Suppose you originally ran this project on your local SAS Server. Then you moved the project to SAS Enterprise Guide 4.1 and now want to run this project on your SASMain server. However, the WORK.QURY1 table does not exist on the SASMain server. When you run Replace SAS Server, it returns an error "Unable to create data WORK.QURY1" and the replace will fail.

To circumvent this problem, you can try one of the following two workarounds:

  1. Convert the 3.0 project using the EGPMover tool to modify the server before you are migrating the project to SAS Enterprise Guide 4.1.
  2. Make sure the temporary table exists on the new server before running Replace SAS Server in SAS Enterprise Guide 4.1. You can create a dummy table in the same library/location on the server with the same name.

Select the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Enterprise GuideMicrosoft Windows 2000 Professional4.14.19.1 TS1M3 SP19.1 TS1M3 SP1
Microsoft Windows XP Professional4.14.19.1 TS1M3 SP19.1 TS1M3 SP1
Microsoft Windows NT Workstation4.14.19.1 TS1M3 SP19.1 TS1M3 SP1
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.