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

 

Hi,

 

i'm currently using SAS 9.4 with Windows 7.

 

When I try to open a table, I get the following error message :

 

ERROR: Could not query the specified values from the registry.

 

I also get error message in the log :

 

ERROR: Attempt to get a string value from a list when the item was a number.
Arguments passed to GETNITEMC:
  1 itemlist = 11447
  2 (Character Literal) = 'Headers'
  3 (Numeric Literal) = 1
  4 (Numeric Literal) = 1
  5 (Character Literal) = 'LABELS'
Program returning prematurely at line 2558
AF Program: SASHELP.FSP.DATAVIEW.SCL
*** Line 1310: [ERROR:  #114]  Unable to perform requested function
Parameters passed to method _LOADMODEL:
Program returning prematurely at line 1310
AF Program: SASHELP.FSP.DATAVIEW.SCL
*** Line 662: [ERROR:  #114]  Unable to perform requested function
Parameters passed to method _OPENTABLE:
  1 table = 'test.Base'
  2 mode = ''
  3 access = ''
Program returning prematurely at line 662
AF Program: SASHELP.FSP.DATAVIEW.SCL
*** Line 486: [ERROR:  #114]  Unable to perform requested function
ERROR: Call to _SETUP_ failed. Unable to send event SETUP to obj1.
Parameters passed to method _SENDEVENT:
  1 (Character Literal) = 'SETUP'
  2 command_list = 9795
Program returning prematurely at line 486
AF Program: SASHELP.FSP.VTFRAME.SCL
*** Line 108: [ERROR:  #114]  Unable to perform requested function
Parameters passed to method CMDARGS:
Program returning prematurely at line 108
AF Program: SASHELP.FSP.VTFRAME.SCL

 

What can I do ?

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

Did you inspect the directory with Windows Explorer?

If yes, my next step would be to completely remove the SASUSER directory and all its contents, so SAS can create a new one on startup.

If that does not fix your problem, you should raise an issue with SAS technical support.

View solution in original post

6 REPLIES 6
RahulG
Barite | Level 11

Can you describe a bit what type of table is it?

 

It seems, a view has been created and you are trying to open the view.

Kurt_Bremser
Super User

Searching for the text of the error message on google leads me to http://www.hollandnumerics.co.uk/sasfaq/SASFAQ12.HTM, which suggests that deleting your registry.sas7bitm file in your SASUSER (while SAS is not running) might help you.

alka54
Fluorite | Level 6

Thanks for your answer.

 

It concerns every table I want to vizualize. The problem appeared suddendly without any action on my part.

 

I didn't find a registry.sas7bitm file in my SASUSER. Can it be the cause of the problem ?

 

Kurt_Bremser
Super User

Did you inspect the directory with Windows Explorer?

If yes, my next step would be to completely remove the SASUSER directory and all its contents, so SAS can create a new one on startup.

If that does not fix your problem, you should raise an issue with SAS technical support.

alka54
Fluorite | Level 6

thank you, i removed the SASUSER directory and it fixed the problem..

employee_brian
Calcite | Level 5

The SASUSER directory (Server 2012 R2, SAS 9.4) is the C:\Users\<username>\Documents\My SAS Files\ 9.4 folder. Deleting the 9.4 folder resolved this issue for me. 

 

*Just a note for those who may not know where the SASUSER dir is. 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 5115 views
  • 11 likes
  • 4 in conversation