topic Re: ERROR: Incorrect length in SAS Metadata Repository in SAS Programming

ERROR: Incorrect length in SAS Metadata Repository

DavidPhillips2 — Mon, 08 Oct 2018 17:55:25 GMT

Today I receive:

ERROR: Incorrect length in SAS Metadata Repository for column DISBURSEMENT_COMMENT.
ERROR: SQL View SASHELP.VCOLUMN could not be processed.

when I run:

data temp; set sashelp.vcolumn;
run;

Yesterday this worked.

Re: ERROR: Incorrect length in SAS Metadata Repository

DavidPhillips2 — Mon, 08 Oct 2018 18:09:46 GMT

SAS: Please fix this bug. I restarted Enterprise Guide and the Error went away.

Re: ERROR: Incorrect length in SAS Metadata Repository

SASKiwi — Mon, 08 Oct 2018 19:11:43 GMT

If you want to officially report what you think is a SAS bug then you need to raise a track with SAS Tech Support.

Re: ERROR: Incorrect length in SAS Metadata Repository

DavidPhillips2 — Mon, 08 Oct 2018 19:20:40 GMT

I did they just closed the ticket for no reason though.

Re: ERROR: Incorrect length in SAS Metadata Repository

SASKiwi — Mon, 08 Oct 2018 19:32:07 GMT

Ask for an explanation then?

Re: ERROR: Incorrect length in SAS Metadata Repository

DavidPhillips2 — Tue, 09 Oct 2018 19:25:29 GMT

SAS replied:

The common issue for this behavior is when the table registered in Metadata does not have the same column length as the physical table. To solve the problem, update table metadata so that it matches the physical data. Do this by running Update Metadata within SAS Management Console. From the Plug-ins tab, select the library containing the table Right-click the table and select Update Metadata from the popup menu.

You can also run the PROC METALIB to update table metadata. Please see documentation for METALIB Procedure here

METALIB Procedure.

If this is not the case it is possible there was a loss of connection to the servers when the Enterprise Guide has been idle for a while and the restart reestablished the connection to SASApp.