Yes, I have checked the system resources. It isn't running out of any of them. I have actually recreated the issue in every Lev now so have rules out anything to do with the grid - when overwriting existing metadata in the import, new connections to metadata hang. Once the import moves past 'creating metadata' and into 'analysing metadata' everything comes back to life. It takes a lot longer to do the 'create metadata' part when overwriting metadata as opposed to creating new metadata, even for the exact same package. But even while the creating new metadata is happening it doesn't seem to hang, just when overwriting metadata. I found the following 9.1.3 issue: http://support.sas.com/kb/31/894.html Obvioulsy we are on 9.4 so this 9.1.3 issue should be fixed but it still gives me some insight into how the file locks work for SAS on Unix - It seems like maybe whatever file locks are involved in an import that overwrites metadata, they prevent any other metadata requests from being processed until it is finished with those locks. I think our SAS track is going to Cary now so hoping they can shed some light on it....
... View more
