When I changed Multi data source optimization to IN_CLAUSE from None then am able to register tables and able to open tables without any issues from EG. I did as per below steps For the Oracle Library under properties-->options-->Advanced options-->Optimization--->I selected to IN_CLAUSE from None for Multi data source optimization then am able to open the data sets from EG registering. I think it might have solved but i have one question when I got oracle connection information i have been given lower case schema "ph" not the upper case. but when am entering "ph" schema its not working, its working only when am entering it in upper case. so am not sure whether the user had given wrong information or oracle library wont accept schema in lower case ... View more

The schema was in lower case "ph" and I updated the schema for Oracle Library to upper case "PH" and am able to register the tables but when am trying to open the registered data sets its throwing below error. SAS Enterprise Guide cannot open the date file: "ORACLE CN_IW.PC_ADD_DAILY_DLOC Error opening data "PC_ADD_DAILY_DLOC". [Error] File CN_IW.PC_ADD_DAILY_DLOC does not exist. [Error] The datasource table CN_IW.PC_ADD_DAILY_DLOC does not exist. Libname statement is below I got from SMC for the Oracle Library LIBNAME GDIW ORACLE  PRESERVE_COL_NAMES=YES  PRESERVE_TAB_NAMES=YES  DBINDEX=YES  PATH=pde_pdiw  SCHEMA=PH  USER=pdrew  PASSWORD="{SAS002}9C943B50407B77954D67D4302E92999C" ; ... View more

I copied the libname statement of the library from SMC and ran it in EG and its assigning successfully without errors but tables are not registering. ... View more

I had ran the below code from EG to register the tables in Oracle library but still I don't see any tables even though it has executed without any errors. proc metalib; omr (library="ORACLE CN_IW"); run; This is the log file I got in the EG and am not sure where its still going wrong 1          ;*';*";*/;quit;run; 2          OPTIONS PAGENO=MIN; 3          %LET _CLIENTTASKLABEL='Program'; 4          %LET _CLIENTPROJECTPATH=''; 5          %LET _CLIENTPROJECTNAME=''; 6          %LET _SASPROGRAMFILE=; 7          8          ODS _ALL_ CLOSE; 9          OPTIONS DEV=ACTIVEX; NOTE: Procedures may not support all options or statements for all devices. For details, see the documentation for each procedure. 10         GOPTIONS XPIXELS=0 YPIXELS=0; 11         FILENAME EGSR TEMP; 12         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR STYLE=HtmlBlue 12       ! STYLESHEET=(URL="file:///C:/Program%20Files/SASHome9.3/SASEnterpriseGuide/5.1/Styles/HtmlBlue.css") NOGTITLE NOGFOOTNOTE 12       ! GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on"); NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 13         14         GOPTIONS ACCESSIBLE; 15         proc metalib; 16         omr(libraRy="ORACLE CN_IW"); 17         RUN; NOTE: A total of 0 tables were analyzed for library "ORACLE CN_IW". NOTE: Metadata for 0 tables was updated. NOTE: Metadata for 0 tables was added. NOTE: Metadata for 0 tables matched the data sources. NOTE: 0 other tables were not processed due to error or UPDATE_RULE. NOTE: PROCEDURE METALIB used (Total process time):       real time           0.34 seconds       cpu time            0.03 seconds       18         19         20         GOPTIONS NOACCESSIBLE; 21         %LET _CLIENTTASKLABEL=; 22         %LET _CLIENTPROJECTPATH=; 23         %LET _CLIENTPROJECTNAME=; 24         %LET _SASPROGRAMFILE=; 25         26         ;*';*";*/;quit;run; 27         ODS _ALL_ CLOSE; 28         29         30         QUIT; RUN; 31         ... View more

SO if i run below code from EG then all the tables will be registered from source. please let me know if there is anything wrong in the code. proc metalib; omr (library="My oracle library name"); run; ... View more

Thank you all for your prompt responses am using SAS 9.2 on Solaris 10 server and I did not setup anything new for ODBC connection I have just added connection entries in tnsnames.ora file for new data base requirement on Solaris machine. and I followed same steps I did for other oracle libraries before and am able to register tables for other oracle libraries but not for this library. so what steps I need to follow to overcome this issue now please help ... View more

Reeza thanks for the valuable information am completely new to the Unix Solaris, so am not sure how to create Daily report. so the same code you provided need to run as .sas program on solaris server to get the daily reports ... View more

I have already open sas track,they are not very helpful they are suggesting to contact Oracle DBA to find out the constraints on the Oracle table we are getting error. ... View more

It did not happened before reaching suddenly 100% and clearing immediately on its own, this has happened for the first time. can you help me with this Daily report please ... View more

Again we got space issues on our Server today morning, all of sudden sometimes the file system sas/saswork is reaching Max 100 % suddenly and there by all other mounting points are reaching 100%. We are using Solaris 5.10 And immediately after it reached 100% and the spaces are clearing and going back to normal. Today  morning it happened couple of times /saswork reached max 100% and which impacted other sas mounting points to reach 100% and cleared space on its own and again started slowly growing and reached 100% and again back to normal. whatever is causing the space to peak is happening very quickly and the critical condition is upon us by the time we get the alert.  I have checked the saswork directory and I can see only 2 users were working on the server at that time and they are not running any bigger jobs. And also there are no new datasets created recently that might have effected. I want to know in this situation what would be our immediate action, how can I check which job/process or user Is occupying more space and how can we bring it to normal. Which are all the file location we need to check for and how to check using commands ? So not sure why its behaving crazy. and I want daily report on files in the space sorted by size and then one sorted by last date accessed? I want to creatin a space management report in SAS. How can we do that ? We would really appreciate if anyone can help me with this ... View more

It works for all other users when they are updating but only its not working for one user, and even the user for whom its working he tried to connecte to the sas server with his credential and tried to update stored process from non working sas amo and its throwing same errors.so its not a permissions issue. ... View more

Yes the problem is with all below mounting points which reached 100 % /sas /sas/saswork /sas/sasutil ... View more

Thanks for your help your code looks like it will search each and every library,but without searching every library i want to find that particular data set is located in which library. here you are using as an example sashelp ... View more