BookmarkSubscribeRSS Feed
Antonio84Pereira
Fluorite | Level 6

Good morning,

Since some weeks ago i'm getting errors on SAS programs that use SAS dictionary tables.

The code is really simple and was getting the right results before we get this errors:

 

Code:

proc sql;

      create table contador as

      select nobs as reg from

             dictionary.tables

      where upcase(libname)='FDIFDMDS' and upcase(memname)='DPRTGUNL';

quit;

 

Before 19th August the log returned this:

NOTE: Compression was disabled for data set WORK.CONTADOR because compression overhead would increase the size of the data set.

NOTE: Table WORK.CONTADOR created, with 1 rows and 1 columns.

 

After 19th August:

ERROR: File PTFCSNFC.MST_MEDIS_CONTAB_PAGOS_DET.DATA does not exist.

ERROR: File PTFCSNFC.MST_MEDIS_CONTAB_PAGOS_DET.DATA does not exist.

(the library PTFCSNFC isn't even used in the program itself!).

 

Another note is that before 19th August, when a connection was launched we got the message in log:

NOTE: Remote signon to SASPRD commencing (SAS Release 9.02.02M3P041310).

NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.

...

...

NOTE: SAS initialization used:

      real time           59.32 seconds

      cpu time            0.08 seconds

 

WARNING: No preassigned object definitions were found on the metadata server.

 

 

After 19th August:

NOTE: Remote signon to SASPRD commencing (SAS Release 9.02.02M3P041310).

NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.

...

...

NOTE: SAS initialization used:

      real time           59.32 seconds

      cpu time            0.08 seconds

NOTE: Libref FDC2PROB successfully assigned from logical server.

NOTE: Libref FDC2PRCB successfully assigned from logical server.

...

...

 

Which definitions may have been modified, so we started to get messages like these?

 

Thanks in advance.

António Pereira.

9 REPLIES 9
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Hi,

 

From what you have posted, it doesn't look like your using just Base SAS, but some server based software?  So I can't really tell what the problem is, other than something would have changed at the server end.  I would suggest you first consult with your IT group who installed and maintain that software, and if it continues go via the SAS helpdesk.

Antonio84Pereira
Fluorite | Level 6

Hi there,

We already checked with SAS Support this problem and the problem wasn't solved.

Yes you're right about something might have changed at the server end, but what could have been changed in configuration files to start writing the above messages in log?

I've been searching for same issue and there's always a reference to pre-assign libraries. We have our libraries pre-assigned since ever, so nothing changed on that. When the connection is made, it assigns the libraries by metadata resources. Where is this configured? Could we change it so?

 

Thanks.

 

António Pereira.

RW9
Diamond | Level 26 RW9
Diamond | Level 26

Am afraid if support can't help you there's not much I can do.  I have no ideas about how your system is setup, what files are used, processes, software installed etc.  

LinusH
Tourmaline | Level 20

Perhaps there are some server side assigned libnames with invalid search paths?

I think I had a similar issue once. Like @RW said, contact your SAS server admin and have them check the startup files on the server (config/autoexec) and metadata settings.

 

What does a

libanme _all_ list;

gives you?

Data never sleeps
Antonio84Pereira
Fluorite | Level 6

I'll have to check the startup files on the server like you said.

I've attached the log with the libname _all_ list results.

 

Thank you.

 

António Pereira.

Patrick
Opal | Level 21

"ERROR: File PTFCSNFC.MST_MEDIS_CONTAB_PAGOS_DET.DATA"

 

The log you've attached indicates that libref "PTFCSNFC" exists. I would assume that the error is caused by exactly what it says: The file doesn't exist but is called somewhere during startup of your session (may be withing some macro call as part of autoexec execution).

 

If my theory is correct then I would assume you get this error independent of what code you submit.

 

Kurt_Bremser
Super User

The error message about the non-existing file might be caused by symbolic links in the file system that point to files that are no longer there.

 

1) determine the physical path of library PTFCSNFC

2) log on the server and change to this directory

3) do ls -l mst_medis_contab_pagos_det.sas7bdat

 

This should give you a clue if the directory entry is there at all, and what type it is.

jakarman
Barite | Level 11

The error:

Check whether there are Views involved. SAS-views can point to a physical file that is not there.

 

The warning:

Ignore those messages on compressing. It is an advantage to have that active for big datasets. By not fogetting that as generic setting you can get notes on the very tiny datasets. Performance is important wiht thos big ones. Wiht those tiny ones there is no big deal.

 

---->-- ja karman --<-----
Antonio84Pereira
Fluorite | Level 6

Hello there,

First want to thank all for the reply.

 

About the issues i've noticed:

- The notes in log "NOTE: Libref FDC2PROB successfully assigned from logical server." is caused by having "-metaautoresources "SASApp"" in sasv9.cfg.

- The errors using dictionary tables i'll check the paths of the libraries and views to correct it. Then i'll try again using the submited code.

 

Kind regards,

António Pereira.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 9 replies
  • 2672 views
  • 4 likes
  • 6 in conversation