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. ... View more

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. ... View more

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 ... View more

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. ... View more

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.   ... View more

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. ... View more

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..     ... View more

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 ... View more

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. ... View more

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.         ... View more