DATA Step, Macro, Functions and more

WARNING: Apparent symbolic reference irpaswd not resolved

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

WARNING: Apparent symbolic reference irpaswd not resolved

Hello Friends,

 

We are having an issue while launching a SAS program in JReview. The program throwing an error during runtime with the error "WARNING: Apparent symbolic reference irpaswd not resolved". It is failing at a step where we are trying to connect to database. It is able to fetch the iruser and irconnect values but not the irpaswd.

 

Could you please suggest? Please let me know if you need any other details.

 

Thanks,

Mahesh


Accepted Solutions
Solution
‎11-16-2017 04:20 PM
Super User
Posts: 23,237

Re: WARNING: Apparent symbolic reference irpaswd not resolved

Posted in reply to mahesh_s_26

Maybe you should talk to your SAS admin for help, or the person who wrote this. But the path to the autoexec is usually found in the SAS config file. It could also be something in the actual application call, so it's hard to say exactly where it's being set. 

 

If your need is urgent, you should contact SAS Tech support, that's why you pay the licensing fee after all. 

View solution in original post


All Replies
Super User
Posts: 13,293

Re: WARNING: Apparent symbolic reference irpaswd not resolved

Posted in reply to mahesh_s_26

Note much detail and no code...

 

The most likely cause of that warning is you have code with &irpaswd somewhere. But no value to a macro variable named irpaswd has had a value assigned using either a %let statement, passed as a parameter or created with one of the interfaces from data step code (call symput or call symputx) or Proc SQl (select into: ).

 

Best is to provide code up to the point you encounter the warning with the log.

Occasional Contributor
Posts: 6

Re: WARNING: Apparent symbolic reference irpaswd not resolved

[ Edited ]

Hi ballardw,

 

Thanks for the quick reply. Please find below code. This SAS program is being used for JReview reporting. We have even not initialized the variable iruser and connect, but they are picked during the run time except irpaswd. I have also attached the log file.

Occasional Contributor
Posts: 6

Re: WARNING: Apparent symbolic reference irpaswd not resolved

[ Edited ]
Posted in reply to mahesh_s_26

PFA log file.

 

Thanks,

Mahesh

Super User
Posts: 23,237

Re: WARNING: Apparent symbolic reference irpaswd not resolved

Posted in reply to mahesh_s_26

You should review the information you've posted and delete anything that may be confidential to your company. 

 

Anyways, you have declared iruser and irconnct, but there's no declaration for the password (line 8, line11) so, yes, it can't find it. 

You haven't included it somehow.

Occasional Contributor
Posts: 6

Re: WARNING: Apparent symbolic reference irpaswd not resolved

Thanks Reeza. I have already removed the company specific confidential information.

 

In the code we have not initialized the iruser and irconnect variables anywhere. But, it is showing in the log file. Could you please let me know how it is picking during the run time? This is what we are not able to find.

 

One more thing, usually the DB username and password should not be hard coded right? If we hard code those details the program works fine.

 

Thanks,

Mahesh

Super User
Posts: 23,237

Re: WARNING: Apparent symbolic reference irpaswd not resolved

Posted in reply to mahesh_s_26

Check for an autoexec file that may be setting those values by default. 

If you're running in EG there may project specific settings. 

 

Ideally you have single sign on set up and the account has access to the DB directly and doesn't need to pass a user name or password. 

 

 

Occasional Contributor
Posts: 6

Re: WARNING: Apparent symbolic reference irpaswd not resolved

Hi Reeza,

 

Where can I check the autoexec program? Basically, we are launching the program via JReview (UI) and internally JReview makes a call to SAS program. No where in the sas program we have these variables initialized. But, from somewhere it is bringing those values which we don't have a clue.

 

Please suggest.

 

Thanks,

Mahesh

Solution
‎11-16-2017 04:20 PM
Super User
Posts: 23,237

Re: WARNING: Apparent symbolic reference irpaswd not resolved

Posted in reply to mahesh_s_26

Maybe you should talk to your SAS admin for help, or the person who wrote this. But the path to the autoexec is usually found in the SAS config file. It could also be something in the actual application call, so it's hard to say exactly where it's being set. 

 

If your need is urgent, you should contact SAS Tech support, that's why you pay the licensing fee after all. 

Occasional Contributor
Posts: 6

Re: WARNING: Apparent symbolic reference irpaswd not resolved

Agreed! I have also raised it with SAS technical support.

 

Thanks much for all your support.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 9 replies
  • 277 views
  • 0 likes
  • 3 in conversation