Helannivas Tracker

Re: SAS Autoexec usermods file

Helannivas — Fri, 27 Jul 2018 14:15:28 GMT

Hi,

Sorry for late response.

Macros has been updated in autoexec file of Batch server (not in Workspace or Stored Process server). I have rectified the issue by included the SAS users/groups in the SASApp --> logical Grid sever and in Grid Options Set Mappings.

But one thing I need to understand in 9.4 platform. So whenever I update the autoexec file under Batch server , I wont restart the object spawner.

But recently did one change in autoexec file under Stored Process server and it requires restart of Object spawner services and then I can able to access the macros.

Whether the same case of Workspace server as well???

SAS ODBC connection to SQl Server

Helannivas — Fri, 11 May 2018 14:16:57 GMT

Hi,

I have a requirement to connect to SQL Server database from SAS. So Before editing the odbc.ini, I have checked whether the SQL server database and port are opened from SAS servr.

cat < /dev/tcp/<Server_name>/<Port_no>.

And I haven't got connection refused output. So the database and port are opened in SQL server database and I think I can able to establish the connection.

Then I have edited the odbc.ini file and created a DSN. And created a SQL Server library in SAS SMC.

But while accessing the database , I have got a error that Connection refused ,verify hostname and port number .

Can anybody help me on this. Thanks in advance.

Clearing util files

Helannivas — Wed, 02 May 2018 14:40:38 GMT

Hi,

One quick clarification

Whether the cleanwork command will clear the orphange util files resides under /sas/util directories. If not, how to clear the util files?

Currently Im clearing the orphange work files by running the cleanwork command.

Thanks in advance.

LSF Access

Helannivas — Wed, 25 Apr 2018 11:26:54 GMT

Hi,

Just need to understand , how the user restriction for LSF to be defined in SMC.

Currently there are two users I have created in SMC. After scheduling the flow in SMC and in flow manager , I want one of the user can re run the job in LSF/flow manager and I don't want another user to re run the job if there is a failure. I want this user to view the login to flowmanager and view the schedule.

Is there any group already defined in SMC for this specific requirement?

Thank in Advance.

Platform Process Manager issue.

Helannivas — Tue, 27 Mar 2018 22:43:26 GMT

Hi,

Today there was a strange issue in my Platform Process manager.

I tried to execute the job and the job got failed in the environment i.e. in Platform Process Manger.

When I'm checking the logs, there were no errors in the log and even the data has been loaded into destination as expected.

What could be a potential reason for showing exit in Platform Process manager.Thanks in advance

Re: SAS Autoexec usermods file

Helannivas — Wed, 07 Mar 2018 23:04:55 GMT

We have defined the variable and the values in the file like user = sas pwd = xxx....While using the libname statement in jobs, we are using &user and &pwd, so that no need to change the jobs while switching over the environments..

Currently the autoexec_usermods files are available under app/sas/config/Lev1/Batch server.

The error happening in the workspace server...

SAS Autoexec usermods file

Helannivas — Tue, 06 Mar 2018 23:43:46 GMT

Hi,

I have configured all my macros variables in autoexec_usermods.sas file and when I query the macros by %put &macrovarivale, I cannot able to fetch the data from the file.

Throwing me Apparent Symbolic reference error. But the similar type of macros , I have written in other levels and I can able to access that.

I feel something is missing in one of the level while reading the data from autoexec_usermods file.

Can anyone please help me in that. Thanks in advance.

Re: SAS DB2 Connectivity

Helannivas — Sun, 18 Feb 2018 21:52:37 GMT

SAS Installed on Red hat Linux OS

SAS DB2 Connectivity

Helannivas — Sat, 17 Feb 2018 09:35:10 GMT

Hi,

I have to connect to DB2 database from SAS 9.4. Previously we have used odbc.ini file for the connection in older version of sas.

But in 9.4, we have SAS ACCESS to DB2 database installed. Is there is any specific file for db2 connection (same like tnsnames.ora for oracle) in SAS server to edit the database credentials.

Where we will create the dsn for DB2 connection??

Thanks in Advance.

Import of Metadata and the Order Level

Helannivas — Tue, 06 Feb 2018 15:42:05 GMT

Hi,

We have migrated the Environment from SAS 9.1.3 to SAS 9.4 and now the jobs/flows/catalog are migrated to Prod Environment(9.4).

Now I want to migrate all the metadata available in Prod to other Environment . I need to understand , what are all the metadata objects to be migrated?

1. Flows

2. Jobs

3. Catalog(if available)

4. Libraries

Is there any Order should be used to migrate and any other things should be added in the above list.

Note : Migration from 9.1.3 to 9.4 was done by others , so I didn't involve in that activities.Need to understand what activities should be carried out.

Re: SAS Lincese Warning Message

Helannivas — Mon, 15 Jan 2018 14:54:33 GMT

Hi,

We will be applying the License as soon as possible , as we have already purchased the license. We are in the process of understanding the license file. Business people keep on getting the warning message for the job run. Is something can we surpass for message for 15 days or something like that, so that we can have a smooth run.

SAS Lincese Warning Message

Helannivas — Mon, 15 Jan 2018 10:17:03 GMT

HI,

Our SAS 9.4 Lincese has been expired ans now we are in warning period.We are about to renew the license in the server's.

As we do have only one month time period, we are frequently getting warning message.

Is something can we surpass the warning message till we renew the license.Thanks in Advance..

Exclude Error from SAS DI job

Helannivas — Mon, 08 Jan 2018 16:36:55 GMT

Hi,

I have SAS DI job which usually reads the log file of other jobs and calculate the duration of the run.

There are few jobs in my schedule that will run for 24*7 and so the top SAS DI job trying to fetch the log file for the details ,its fails.

THe reason is due to File locking issue and aware the particular job is running.

Is there an option to exclude this failure and check the remaining files in SAS Data Integration Studio.

Thanks in Advance

Grid Manager in SAS Management Console 9.4

Helannivas — Mon, 18 Dec 2017 08:15:30 GMT

Hi,

We have an environment and that involves Grid Controller and Grid Nodes.

I have installed SAS Management console 9.4M4 to monitor the job slots available in the Grid. But I could not able to see Grid Manager Plugin in SAS Management Console.

But When I'm using the Grid via Web services (url) , I can able to see the information for my ID created in metadata.

Is something an additional permission has to be provided in order to view the plugin??

Thanks in Advance.

Performance Issue in Proc append

Helannivas — Thu, 09 Nov 2017 11:21:21 GMT

Hi,

We are using DI studio to load the data from Source to Netezza database. In our code , we are using Proc append to load the data from the work directory and into the table.

For Most of the days, the append is consuming less amount of time for 33 crores record (approx 8 mins) , but specifically on Monday, the proc append step consuming around 01 hr 15 mins. Im not sure about the reason for this high difference.

Could anybody please confirm the potential reason for this huge amount of consuming time. Thanks in advance.

Re: Platform Process Manager Flow Manager Issue

Helannivas — Fri, 03 Nov 2017 06:49:26 GMT

Ok Sure..Thanks for your Suggestion

Compare SAS Codes across environments

Helannivas — Fri, 03 Nov 2017 06:47:42 GMT

Hi,

Usually we will develop our SAS DI Job in Development Envrionment and then we will move to UAT and Prod Envrionment.

But during testing, we will change the code in UAT and sometime in Dev and then we will migrate to Prod.

Now all the Environments are not in Sync. I have a requirement to compare the codes available in all the Environments.

Usually the codes are having more than 1000 lines and Its really tough to compare the codes manually.

Is there any possible ways to compare the codes automaically?? Please advise.

Thanks in Advance.

Re: Platform Process Manager Flow Manager Issue

Helannivas — Fri, 03 Nov 2017 06:37:04 GMT

Hi,, Any sort of solution for the issue from your side????

Re: Platform Process Manager Flow Manager Issue

Helannivas — Thu, 05 Oct 2017 09:52:27 GMT

Thanks for the Support Track.

LSF_LOG_MASK = LOG_WARNING under lsf.conf file.

Re: Platform Process Manager Flow Manager Issue

Helannivas — Thu, 05 Oct 2017 09:22:08 GMT

Hi,

Let me try out the script when the issue persists again..Hopefully, it should not 🙂

We are migrating to 9.4 and will be completed soon.

So, that means there is no fix for this issue. Every time , we have to restart the application, if the issue occurs.