SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 14717: CPDBCOPY fails to copy views created in older PDBs

DetailsHotfixAboutRate It
Using %CPDBCOPY in IT Resource Management 2.7 to copy a an older version
PDB into a SAS 9 PDB may fail with the following error messages:

   ERROR: DATA Step View xxx.xxx could not be processed. There is no
          source code stored with this view.

   ERROR: File xxx.xxx.xxx has not been saved because copy could not be
          completed.

Due to the variety and complexity of changes (generation/storage/usage)
that were made to views during the lifetime of Version 8 of the SAS
System, a specific release level that defines an "older PDB" has not
been determined.

To circumvent this problem, follow the steps below:

   1.  Make a backup of the CPDBCOPY member located in your
       prefix.AUTOLIB library.

   2.  Locate the following source in CPDBCOPY:

           PROC COPY IN=&cprefix.&level OUT=T&level
           %if &cpfeng=6 and &cpteng=7 %then %do;
               MEMTYPE=(CATALOG DATA ACCESS)
               %end;
           %else %do;
               MEMTYPE=ALL
               %end;
               ; RUN;

  3.  Change this code (above) to the following:

           PROC COPY IN=&cprefix.&level OUT=T&level
               MEMTYPE=(CATALOG DATA ACCESS)
               ; RUN;


A fix for this problem is being considered for a future software release.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS IT Resource Management-ServerMicrosoft Windows 2000 Server2.79.1 TS1M3 SP4
z/OS2.73.19.1 TS1M3 SP49.2 TS2M0
Microsoft® Windows® for 64-Bit Itanium-based Systems2.73.19.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Datacenter 64-bit Edition2.73.19.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Enterprise 64-bit Edition2.73.19.1 TS1M3 SP49.2 TS2M0
Microsoft Windows XP 64-bit Edition2.73.19.1 TS1M3 SP49.2 TS2M0
Microsoft® Windows® for x642.73.19.1 TS1M3 SP49.2 TS2M0
Microsoft Windows 2000 Advanced Server2.79.1 TS1M3 SP4
Microsoft Windows 2000 Datacenter Server2.79.1 TS1M3 SP4
Microsoft Windows 2000 Professional2.79.1 TS1M3 SP4
Microsoft Windows NT Workstation2.79.1 TS1M3 SP4
Microsoft Windows Server 2003 Datacenter Edition2.73.19.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Enterprise Edition2.73.19.1 TS1M3 SP49.2 TS2M0
Microsoft Windows Server 2003 Standard Edition2.73.19.1 TS1M3 SP49.2 TS2M0
Microsoft Windows XP Professional2.73.19.1 TS1M3 SP49.2 TS2M0
Windows Vista2.73.19.1 TS1M3 SP49.2 TS2M0
64-bit Enabled AIX2.73.19.1 TS1M3 SP49.2 TS2M0
64-bit Enabled HP-UX2.73.19.1 TS1M3 SP49.2 TS2M0
64-bit Enabled Solaris2.73.19.1 TS1M3 SP49.2 TS2M0
HP-UX IPF2.73.19.1 TS1M3 SP49.2 TS2M0
Linux2.73.19.1 TS1M3 SP49.2 TS2M0
Tru64 UNIX2.73.19.1 TS1M3 SP49.2 TS2M0
* 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.