BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
DavidPhillips2
Rhodochrosite | Level 12

 

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.

1 ACCEPTED SOLUTION

Accepted Solutions
DavidPhillips2
Rhodochrosite | Level 12

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.

View solution in original post

5 REPLIES 5
DavidPhillips2
Rhodochrosite | Level 12

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

SASKiwi
PROC Star

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

DavidPhillips2
Rhodochrosite | Level 12

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

SASKiwi
PROC Star

Ask for an explanation then?

DavidPhillips2
Rhodochrosite | Level 12

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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 8512 views
  • 0 likes
  • 2 in conversation