10-02-2017 06:07 AM
I am trying to test the load_table.sas for Automating Load for Multiple Tables in SAS Base. I have declared the Metadata Connection string at the beginning of my script, and had successfully assigned the VALIBLA and ODBCLIB library. However, I am having this error:
ERROR: Unable to connect to Metadata Server.
ERROR: Write access to member VALIBLA.datasetname.data is denied.
I have used the LASR admin account to run this, however, it prompts the same error as above. How do I resolve this issue?
10-02-2017 09:32 PM
The only error I can see from the log is:
WARN [unknown unknown] com.atomikos.jdbc.JdbcConnectionProxyHelper - Error delegating 'createClob' call java.sqk.SQLFeautreNoteSupportedException: Method org.postgresql.jdbc4.Jdbc4Connection.createClob() is not yet implemented.
10-03-2017 06:58 AM
That message can be ignored. If you see nothing else there, that means "proc lasr" or SASIOLA engine, whichever you using, was not able to connect to LASR Authorization Service.
Have you recently made any changes on the middle tier? For an example, maybe you've configured HTTPS (SSL)? Also, make sure that you have specified a valid META options.
10-04-2017 08:26 AM
Yes, if you didn't update the "External Connection" informatiobn for the LASR Authorization Service in SAS Management Console. Check the current value in Application Management -> Configuration Manager -> SAS Application Infrastructure -> Visual Analytics 7.<X> -> Visual Analytics Services 7.<X> -> right-click on the LASR Authorization Service 7.<X> -> Properties -> External Connection.
10-06-2017 09:24 AM
This sounds like something I've experienced before. In our case, the permissions needed to be changed on the physical directory (and possibly the specific table within that directory) via the Linux operating system. Despite having and admin account, I could not resolve this through Management Console, which operates on metadata.
10-06-2017 09:36 AM
several things I would like to mention here.
1- For fixing the problem, I think we are overestimating and having as a given here that the LASR admin account actually has the permissions. I would start from this point.
Just to be clear, the successful asignment of the libraries, means that you have RM (Read Metadata) on those libraries, but perhaps you do not have Read, Write Metadata or Write on those libraries, of the SAS folders where the tables are going to be registered.
2- In your case, I would use AutoLoad or ReloadOnStart. Have you checked those functionalities on the VA Administration guide?
(Specially, since you use Public LASR Library, it would make sense to me if you use AutoLoad)
This approach would help you to not re-invent the wheel. If there is something maintained by SAS, why should you? I mean, custom code is always an option and that is why SAS leaves it open, but AutoLoad works really well.
I hope it helps.