I am trying to register new tables in metadata from a predefined Oracle library, not update the metadata of pre-existing tables.
When I use the Register Tables wizard in Management Console the new tables do not appear in the list of available tables.
When I use proc metalib to register the tables manually it produces the below error .
When I create an empty defintion in DI Studio and use the update metadata option, it produces the same error as when I run proc metalib manually.
error:
33 proc metalib;
34 omr(library=lpdw);
35 run;
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [METALIB ]
Segmentation Violation
Traceback of the Exception:
/sas94/software/dev/compute/SASFoundation/9.4/sasexe/sas() [0x52809e]
/sas94/software/dev/compute/SASFoundation/9.4/sasexe/sas() [0x41f08e]
/sas94/software/dev/compute/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x144) [0x2ac00c1d45d4]
/lib64/libpthread.so.0() [0x323720f790]
/sas94/software/dev/compute/SASFoundation/9.4/sasexe/sasmetas(fillTableType+0xb5) [0x2ac06c71c915]
/sas94/software/dev/compute/SASFoundation/9.4/sasexe/sasmetas(refmeta+0xab9) [0x2ac06c71b709]
/sas94/software/dev/compute/SASFoundation/9.4/sasexe/sasmetas(sasmetas+0x211c) [0x2ac06c71044c]
/sas94/software/dev/compute/SASFoundation/9.4/sasexe/sas(vvtentr+0x101) [0x41eca1]
/lib64/libpthread.so.0() [0x3237207a51]
2 The SAS System 13:37 Monday, January 25, 2016
/lib64/libc.so.6(clone+0x6d) [0x3236ee893d]
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE METALIB used (Total process time):
real time 0.31 seconds
cpu time 0.11 seconds
"Please contact technical support..."
I suggest that you do.
How is the pre-assignment done/defined?
What if you do a proc datastes from lets say EG, or DI Studio code editor, do you get a list of available tables?
Can you query any tables in the library?
What users are involved?
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.