The details of this SAS Note are for versions of SAS^® Financial Management prior to 5.4 running on WebLogic. Versions 5.4 and higher on the SAS^® 9.4 platform simply require a restart of SASServer3 and SASServer4 after the SASSDM is restored.

 

After you load a new SAS Solutions Data Mart (SASSDM) or other SAS Solutions database or to MySQL, the newly-loaded data is not visible in SAS Financial Management.

After you have loaded the SASSDM/MySQL database, you need to restart the WebLogic application servers and clear the application server cache, as follows:

 

1. For SAS Financial Management release 4.x:
2. Stop the SASManagedServer, SASODCSServer, and SAS Remote/Foundation Services (in that order).
3. To clear the cache:
   • On the mid-tier machine, navigate to:

     <drive>:\bea\user_projects\domains\SASSolutions\SASManagedServer\.wlnotdelete

     and delete the folders under this directory.
   • Next. navigate to:

     <drive>:\bea\user_projects\domains\SASSolutions\SASODCSServer\.wlnotdelete

     and delete the folders under this directory.
   • Finally, navigate to:

     <drive>:\bea\user_projects\domains\SASSolutions\odcs\facts

     and delete the entire contents of this directory.
   • It is also a good practice to clear (or archive) the existing log files so we have clean server logs when you re-start. To do so, you simply access the log files in the above SASManagedServer and SASODCSServer directories.
4. Restart the SAS Remote/Foundation Services, SASODCSServer, and the SASManagedServer (in that order).

 

 

 

 

1. For SAS Financial Management release 5.x:
2. Shut down the SAS Solutions Services (SASServer3, by default) application server and also shut down the ODCS (SASServer4, by default) application server.
3. Open a command window and change directory to WebLogic application server sub-directory for the SAS Solutions Server
   (for example: \sas\config\lev1\web\SASDomain\servers\SASServer3)
4. At a minimum, you need to clear the /TMP and /CACHE sub-directories by executing this command in your command window:

   rd /s /q tmp cache

   It is often a good practice to also delete (or archive) the contents of the \LOGS directory, so we have clean server logs when you re-start. To delete the server log files, you simply modify the above command to read:

   rd /s /q tmp cache logs

5. Repeat this process for ODCS/SASServer4
6. Use the WebLogic Server Administration console to restart the SAS Solutions Server (SASServer3) and the SAS ODCS Server (SASServer4). Access the WebLogic Server Administration Console on the mid-tier server via:

   http://:7501/console/login/LoginForm.jsp

   with default username of <weblogicadm> (for SAS Financial Management release 4.x)
   or <weblogic> (for release 5.x)
   and password of <AdminAdmin1>.

    

   Please note that these are the defaults and they might be different at your site.

For additional information on SAS Financial Management log files, please refer to SAS Note 20058.

 

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS Financial Management	Microsoft Windows Server 2003 Datacenter 64-bit Edition
		Microsoft Windows Server 2003 Enterprise 64-bit Edition
		Microsoft® Windows® for x64
		Microsoft Windows 2000 Advanced Server
		Microsoft Windows 2000 Datacenter Server
		Microsoft Windows 2000 Server
		Microsoft Windows 2000 Professional
		Microsoft Windows Server 2003 Datacenter Edition
		Microsoft Windows Server 2003 Enterprise Edition
		Microsoft Windows Server 2003 Standard Edition
		Microsoft Windows Server 2003 for x64
		Microsoft Windows Server 2008
		Microsoft Windows Server 2008 for x64
		64-bit Enabled AIX

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Instructions for how to reference a newly loaded database from SAS® Financial Management. These instructions are specific to WebLogic as the application server.

Type:	Usage Note
Priority:

Date Modified:	2011-01-19 11:48:26
Date Created:	2011-01-04 07:21:53