Hi , SAS 9.2 with Oracle 11. we have a scenarios where we have moved SAS Metadata/ compute and mid tier from one physical server to another ( config and binaries ) movement . we are able to make everything work expect the content server , currently. which in the old environment used Oracle Database as Content server. when i login to content server URL http://server:port/SASContentServer/dircontents.jsp  , i see sasfolders and sasdav folder with all the reports from the old environment , is it showing form the indexes on the file system or retrieving the data from Oracle content server ? 1) Now , my understanding is when  when a user / folder is created in SAS SMC it should make a corresponding folder in the content server database in which Table can i check this ? 2)we are also not able to open an existing reports which are currently  in Content server ( Web report ) , it gives back end service has error. 3) i saw in one of the notes we can check only the size of the table growing , is there any specific table we can check.when i see database i see SAS_SCS_DEFAULT_BINVAL , SAS_SCS_DEFAULT_BUNDLE table have lot of rows compared to other tables. Error when we are trying to save the report , message in  WRS log is as below . also we have changed the URL's to access the webreport / stored process 2014-09-02 11:49:13,473 [WebContainer : 6] ERROR [e317e7fdee947c95:715de5e1:1481d7f5434:-56cpgunti] com.sas.apps.citation.model.repository.adapter.PathHelper - Unexpected error accessing this user's personal application folder. Root Cause:   com.sas.report.repository.ContentException: '400:Bad Request' error while accessing 'https://XXXXX . XXX . XXX :443/SASContentServer/repository/ default/sasfolders/Users/<<User>>/Application Data'        at com.sas.report.repository.ContentProviderDAV.checkStatus(ContentProviderDAV.java:97)        at com.sas.report.repository.ContentProviderDAV.initialize(ContentProviderDAV.java:208)        at com.sas.report.repository.ContentProviderDAV.<init>(ContentProviderDAV.java:148)        at com.sas.report.repository.ContentFactory.initialize(ContentFactory.java:52)        at com.sas.report.repository.ContentFactory.create(ContentFactory.java:21)        at com.sas.report.repository.OMRDirectory.getContent(OMRDirectory.java:2937)        at com.sas.report.repository.OMRDirectory.createDirectory(OMRDirectory.java:255)        at com.sas.report.repository.OMRDirectory.ensurePath_p(OMRDirectory.java:2822)        at com.sas.report.repository.OMRDirectory.ensurePath_p(OMRDirectory.java:2826)        at com.sas.report.repository.OMRDirectory.ensurePath_p(OMRDirectory.java:2826)        at com.sas.report.repository.OMRDirectory.ensurePath(OMRDirectory.java:2764)        at com.sas.report.repository.OMRRepository.ensurePath(OMRRepository.java:602)        at com.sas.apps.citation.model.repository.adapter.RRBasedCitationRepository.getDirectory(RRBasedCitationRepository.java:1128)        at com.sas.apps.citation.model.repository.adapter.PathHelper.getUsersWRSProductDir(PathHelper.java:486)        at com.sas.apps.citation.model.user.history.HistoryStoreMetadataImpl.getHistFileUrl(HistoryStoreMetadataImpl.java:308)        at com.sas.apps.citation.model.user.history.HistoryStoreMetadataCachingImpl.loadCacheFromRepos(HistoryStoreMetadataCachingImpl.java:113)        at com.sas.apps.citation.model.user.history.HistoryStoreMetadataCachingImpl.getInputStream(HistoryStoreMetadataCachingImpl.java:63)        at com.sas.apps.citation.model.user.history.HistoryStoreStreamBase.load(HistoryStoreStreamBase.java:76)        at com.sas.apps.citation.model.user.history.UserHistoryManager.load(UserHistoryManager.java:140)        at com.sas.apps.citation.model.user.SessionScopeManager.noteLogonHasCompleted(SessionScopeManager.java:2521)        at com.sas.apps.citation.model.user.CitationLogonManager.notifySessionManagerOfLogon(CitationLogonManager.java:628)        at com.sas.apps.citation.model.user.CitationLogonManager.logonUserNow(CitationLogonManager.java:386)        at com.sas.apps.citation.model.user.CitationLogonManager.logonUser(CitationLogonManager.java:300)        at com.sas.apps.citation.controller.action.LogonAction._attemptLogon(LogonAction.java:347)        at com.sas.apps.citation.controller.action.LogonAction.doPerform(LogonAction.java:170)        at com.sas.apps.citation.controller.action.CitationAction._execute(CitationAction.java:191)        at com.sas.apps.citation.controller.action.CitationAction.execute(CitationAction.java:166)        at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)        [ 65 lines suppressed ] Which Caused: com.sas.apps.citation.model.repository.adapter.CitationRepositoryException: Could not get raw directory: SBIP://METASERVER/Users/<<User>>/ Application Data/SAS Web Report Studio(Folder)(Reason : Operation Failed) [ com.sas.report.repository.RepositoryException: '400:Bad Request' error while accessing 'https://XXXX.XXX.XXXX.XXX:443/SASContentServer/repository/default/sasfolders/Users/<<User>>/Application Data' [ com.sas.report.repository.ContentException: '400:Bad Request' error while accessing 'https://XXXX.XXX.XXXX.XXX:443/SASContentServer/repository/default/sasfolders/Users/<<User>>/Application Data' ]  ] can anybody help or having similar experience ? do we need to change the configuration in database server name in any files ?  we are using IBM Websphere as web application and configured database there and it working finr. THanks keds ... View more

Hi I want to take dataset as source and create a XML file as output which can be fed to downstream applicaitons. 1) My requirement is I want two different tags on same level from the dataset as source . i want to generate the XML file with nested tag upto level5. if it can done using xmlmapper or proc template can somebody guide me , very new to this . I want -<DestinationGuid> and -<Transactions> on same level. e.g. <Imports description="Teams of the National Hockey League"> -<IMPORT>       -<DestinationGuid>   some value       -</DestinationGuid>              -<Transactions>             -<Transaction>                   <NAME>Thrasher</NAME>                   <ABBRIV>ATL</ABBRIV>                   <CONFERENCE>Eastern</CONFERENCE>                   <DIVISION>Southeas</DIVISION>             </Transaction>       -</Transactions> -</IMPORT> 2) want to display tags on condition. E.g Suppose we have customer data and want to display  in ouput file under  3 tags <Insert>, <update> or <delete>    depending on criteria like , If new customer then under insert,if existing then under update and if for deactivation then delete. can above two things can be done ? Thanks Keds ... View more

Hi all i have these things in logs all the time ...A0000001.A5STQABL ... metadata ID. i want to map these things to some logical names. is there a way to get logical name for these metadata id. for instance , i had to go into the SMC to check that the above is mapped to "SAS Web Infrastructure Platform" i did something like below and it didnt work, dont know if i am doing this correctly . data _null_;     length id $20     type $256;     rc=metadata_resolve("omsobj:A0000001.A5STQABL",type,id);     put rc=;     put id=;     put type=; run; o/p is rc=0 ; id=;type=; can somebody let me know how to get around this ? Thanks Keds ... View more

Hi we have a scenarios where the VA server is getting stuck due to memory issue. is there a way by which we can see in the logs the dataset and there sizes  which are loaded into the memory  , so that we can go to user and tell to work on a smaller subset of data ? Thanks Keds ... View more

Hi all, Environment Details : SAS9.2 with IBM Websphere , Linux we a have a problem and we don't know how to get around this. We have 3 tier Installation of Compute / Metadata and Mid Tier. And our Mid tier is corrupt and we have data from the CONFIG folder .But the SASHOME folder which has the deployment manager is corrupt and unfortunately we don't have a Backup. so will not be able to un configure the old metadata id entries related to SAS Mid tier Have a lot of Question ,so request your advice 1. can we flush out all the mid tier folders( mean remove )  and install and Config SAS mid tier components  from FRESH ? 2. in doing so will it create a duplicate metadata id entries for Mid tier components in metadata server ?  like webreportstudio ( old env metadata id ) and webreportsudio1 ( new environment metadata id ) 3. we are not so concerned:  about the duplicate entries so we can live with it . But will it create any problem to endusers ? 4. will there be any metadata configuration needed on the newly created webreportstudio1 or in any of the other metadata object id's ? 5. will there be any syncronozation needed ? between metadata and mid tier , or the deployment wizard takes care Have anybody faced this kind of scenario . would be very eager to hear from your experience . Question like : what all problems we could face if we go with approach of installing from fresh the mid tier to the existing metadata ?                       what all typical metadata configuration we need to do in this scenario ? Thanks Keds ... View more

Hi , I have been working around with integrating SAS Stored Process in Visual Analytic. I have written a Stored Proc which expects a Value from the VA Designer to process and return the result back. Scenario is  : i am filtering the records based on "Name of a person" from the drop down using "Controls" . I have a city column in source table . so the corresponding City for the filtered "Name of a person"   needs to be passed as a parameter/macro variable to the Stored Process. Can we perform this ? or is there a a work around for this ? Thanks Keds ... View more