Problem Note 18459: "Unable to create data" error when you replace SAS server on a migrated
project
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:
- 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.
- 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
SAS System | SAS Enterprise Guide | Microsoft Windows 2000 Professional | 4.1 | 4.1 | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP1 |
Microsoft Windows XP Professional | 4.1 | 4.1 | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP1 |
Microsoft Windows NT Workstation | 4.1 | 4.1 | 9.1 TS1M3 SP1 | 9.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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2006-10-11 07:27:50 |
Date Created: | 2006-09-07 16:37:14 |