During the process of re-configuring the SAS 9.2 Business Intelligence mid-tier server, you might encounter an error similar to the following during the configuration of SAS Shared Services

The following problem was encountered while configuring SAS Shared Services:  An
error has occurred.  Configuration script:
/install/lmsim/SAS/SASSharedServices/9.2/Config/biservmid_config.xml  For more
information please see the log file:
/install/lmsim/cmsas/Lev1/Logs/Configure/biservmid_startServer_2008-11-03-16.21.
20.log  Would you like to continue with the remaining configuration steps?

    [echo] url:
jdbc:sastkts://phvr6402.unx.sas.com:2171?CONSTRING=DRIVER=FIREBIRD;CATALOG=FIRE;
     [echo] dbname: /install/lmsim/cmsas/Lev1/SASTS/Content/SharedServices.fdb
[stCreateDatabase] TS host:phvr6402.unx.sas.com
[stCreateDatabase] TS portname:2171
[stCreateDatabase] TS port:2171
[stCreateDatabase] Bridge Server Complete
[stCreateDatabase] ConnectionFactoryConfiguration Complete
[stCreateDatabase] ConnectionFactoryInterface Complete
[stCreateDatabase] ConnectionInterface Complete
[stCreateDatabase] org.omg.CORBA.Object Complete:
com.sas.iom.orb.GenericObject:com.sas.iom.orb.brg.DelegateImpl@745c745c
[stCreateDatabase] Serve
admin:com.sas.SASTableServer._portable_stub_ITableServerAdministration:com.sas.i
om.orb.brg.DelegateImpl@745c745c
[stCreateDatabase] dbname is
/install/lmsim/cmsas/Lev1/SASTS/Content/SharedServices.fdb
[stCreateDatabase] dbqual is default character set UTF8
[stCreateDatabase] Executing: create database
'/install/lmsim/cmsas/Lev1/SASTS/Content/SharedServices.fdb' default character
set UTF8
[stCreateDatabase] EXCEPTION: I/O error for file
"/local/install/lmsim/cmsas/Lev1/SASTS/Content/SharedServices.fdb" - Error while
trying to create file - File exists
  [antcall] Exiting
/install/lmsim/SAS/SASSharedServices/9.2/Config/biservmid_config.xml.

BUILD FAILED
/install/lmsim/SAS/SASSharedServices/9.2/Config/biservmid_config.xml:181: The
following error occurred while executing this line:
/install/lmsim/SAS/SASSharedServices/9.2/Config/biservmid_config.xml:588: The
following error occurred while executing this line:
/install/lmsim/SAS/SASDeploymentManager/9.2/products/cfgwizard__92210__prt__xx__
sp0__1/Utilities/storageTasks.xml:103: org.apache.bsf.BSFException: The
application script threw an exception: java.sql.SQLException: I/O error for file
"/local/install/lmsim/cmsas/Lev1/SASTS/Content/SharedServices.fdb" - Error while
trying to create file - File exists BSF info: scriptdef_stCreateDatabase at
line: 0 column: columnNo

This occurs because the database configuration already exists due to this being a re-configuration of the SAS 9.2 Business Intelligence platform. The Software Deployment Wizard does not remove the existing database configuration because it might contain user-generated content.

To fully remove the exiting database configuration (data and metadata), perform the following steps:

1. Stop the TableServer process.
2. Start SAS Management Console and log on as a TableServer Administrator or unrestricted user.
3. Expand Table Server Manager > SASTS and select 'Data Source Names'.
4. In the right hand table, select the 'SharedServices' item, click your right mouse button and select 'delete'.
5. Expand Table Server Manager > SASTS > SAS Data and select the 'Transactional Databases' item.
6. In the right hand table, select the 'SharedServices' item, click your right mouse button and select 'delete'.
7. On the machine where TableServer is running, go to the

   <SAS_Config>/Lev{n}/SASTS/Content directory

   and delete (or rename) the SharedServices.fdb and SharedServices.fdb.lck files.
8. Restart the TableServer and continue / restart / start your configuration process.

This is marked as fixed in SAS 9.3.

Operating System and Release Information