ERROR: File PFAM.person.DATA does not exist following DB clone 1

[jlaw10]

Here is a screen dump of the error I am encountering with SAS. We started receiving this error following a DB clone to a new server.


[ PFAM2:/opt/pfam/dev/sas/pfamTEST ]
linnstdt@pfam01>sas test.sas

[ PFAM2:/opt/pfam/dev/sas/pfamTEST ]
linnstdt@pfam01>more test.log
1 The SAS System 17
:48 Wednesday, May 31, 2006

NOTE: Copyright (c) 1999-2001 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software Release 8.2 (TS2M0)
Licensed to KPMG CONSULTING INC LLC, Site 0038944001.
NOTE: This session is executing on the SunOS 5.9 platform.




This message is contained in the SAS news file, and is presented upon
initialization. Edit the files "news" in the "misc/base" directory to
display site-specific news and information in the program log.
The command line option "-nonews" will prevent this display.



NOTE: SAS initialization used:
real time 0.12 seconds
cpu time 0.02 seconds

1 libname pfam oracle user=pfam pw=XXXX schema=pfam path="pfam2"
2 preserve_tab_names=yes show_synonyms=yes;
NOTE: Libref PFAM was successfully assigned as follows:
Engine: ORACLE
Physical Name: pfam2
3 libname wkspace '/opt/pfam/workspace/pfam2004F';
NOTE: Libref WKSPACE was successfully assigned as follows:
Engine: V8
Physical Name: /opt/pfam/workspace/pfam2004F
4
5 data testvtemp;
6
7 set pfam.person;
ERROR: File PFAM.person.DATA does not exist.

NOTE: The SAS System stopped processing this step because of errors.
NOTE: SAS set option OBS=0 and will continue to check statements. This may cause NOTE: No observations in
data set.
WARNING: The data set WORK.TESTVTEMP may be incomplete. When this step was stopped there were 0 observat
ions and 0 variables.
NOTE: DATA statement used:
real time 0.05 seconds
cpu time 0.00 seconds


ERROR: Errors printed on page 1.

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 0.31 seconds
cpu time 0.07 seconds


[ PFAM2:/opt/pfam/dev/sas/pfamTEST ]
linnstdt@pfam01>

 

[klaz2002]

Jlaw10,
Simply, this error log states that the oracle table 'person' doesn't exist (not found). Perhaps your clone of the server didn't get all the data tables it should have.
You would have to see the old logs when the program ran before the data was migrated. The SAS library, PFAM, could have been made up of several Oracle databases and the 'person' table could have been one of the many aggragate data tables.

I hope this helps you,
Klaz