This is one way to test.  When everything is working OK, I get a table with a dummy variable, no errors.   proc sql; connect to oracle as ora(user=&your_oracle_user. password=&your_oracle_pass. path="@your_path"); create table test as select * from connection to ora ( select * from dual ); disconnect from ora; quit;   ... View more

You are welcome. Did it help? ... View more

hi,   OK...We are discussing this topic with our Virtaul Packages team (SAS AMC PAckage should have more memory).     i hope this will resolve soon.I will keep you updated regarding status.   Now it is clear that issue with Java Memory.   Thank you so much all..for your great support.   i hope this will resolve soon.I will keep you updated regarding status. ... View more

Hi,   WRS reports run by default under the Pooled Workspace server, or under the Stored Process if they include anty STP. This means that your users work under sastrust@saspw (for your metadata and your content server) or under sassrv (for your operating system).   You will need to provide permissions to your content server to the required accounts, http://support.sas.com/documentation/cdl/en/bimtag/68217/HTML/default/viewer.htm#p02sxa8j5yn6j0n1ug8tbvxe9kt3.htm http://support.sas.com/documentation/cdl/en/bimtag/65708/HTML/default/viewer.htm#p1xs2pr75zp3b6n1h313qbcyhpuo.htm    If you log in to the SCS, with an unrestricted account, as sasadm@saspw, you will be able to add the permissions for determined files or folder on your SCS, which should be aligned with the authorizations on your SAS metadata. ... View more