Register Metadata

Swethajava23 — Wed, 27 Jan 2016 09:08:31 GMT

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

Re: Register Metadata

LinusH — Wed, 27 Jan 2016 09:53:31 GMT

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