When importing a SAS package to SAS DI Studio, the Metadata become unrepsonsive. For example, it is not possible for users to connect to their Metadata profile in SMC or Enterprise Guide and existing sessions become unresponsive. As soon as the import is finished, it all comes back to life and works again. This happens when importing any SAS packages, even small ones with just a couple of jobs in.
This is only happening in the levs where we have grid launched sessions turned on for workspace sessions and not in those where we do not. This doesn't seem to make much sense to me though as this setting should only affect the connection to SASComp1, I wouldn't expect that this setting affects connecting to a metadata profile or importing a package, both of which I expect are only client - metadata connections.
From the look of the metadata logs the connection attempts are getting queued up while the import is happening and then being processed after the import is complete e.g. this 8 minute wait for the credential to be obtained for userid 8786746:
545903 2017-03-20T18:50:02,668 TRACE [00033530] 245:8786746 - IOM CALL {compRef:11122bc00}->OMI::GetMetadataObjects():
552416 2017-03-20T18:58:11,394 TRACE [00033530] 245:8786746 - Credential obtained for 8786746.
We also see from netstat that there are a lot more connections to the metadata server during the import process and some 'closed wait' connections:
normally:
$ netstat -an |grep 9561 | grep -i established | wc -l
1559
$ netstat -an |grep 9561 | grep -i close | wc -l
0
when importing:
$ netstat -an |grep 9561 | grep -i close | wc -l
185
$ netstat -an |grep 9561 | grep -i established | wc -l
3328
Server side is SAS 9.4 on Unix AIX 7.1 with LSF grid. Client side DI Studio 4.9 and Enterprise Guide 6.1 on Windows 7.
We have tried restarting everything of course and as suggested by SAS have ensured that various Unix limits such as nofiles and somaxconn are sufficiently high.
Any ideas why this is happening?
Thanks