BookmarkSubscribeRSS Feed
Swethajava23
Calcite | Level 5

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

1 REPLY 1
LinusH
Tourmaline | Level 20

"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?

Data never sleeps

sas-innovate-white.png

Special offer for SAS Communities members

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.

 

View the full agenda.

Register now!

How to connect to databases in SAS Viya

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.

Discussion stats
  • 1 reply
  • 1164 views
  • 0 likes
  • 2 in conversation