Configure state database shutdown parameters

Configure a couple of appSettings parameters in the Ampla service configuration file to specify a cache limit or a timeout limit to stop the AVEVA Production Management service.

To configure the state database shutdown parameters

1. Open the SE.SPO.AmplaService.exe.config file from this location: <Drive>\Program Files\AVEVA\AVEVA Production Management.

2. Go through the appSettings section of the file and update either or both of the following parameters, depending on how you want to set up the automated shutdown.

   For these parameters to work, ensure that the StateDatabaseDisableBackground parameter is set to false.

   • StateDatabaseShutdownCacheLength: This corresponds to the number of payloads on queue in the Performance Monitor. It accepts only a whole number, where the default is 500000.

     Important It is recommended to use a maximum value of 4000000 (4M) for this parameter since the number you specify here can exponentially increase the AVEVA Production Management service start time.

   • StateDatabaseShutdownTimer: This accepts only the given format of HH:mm:ss, where the default is 01:00:00 (1 hour).

     If you don't want to automatically shutdown the service, set the cache limit to 0 and the timer to 00:00:00.

     Note The automated shutdown feature is enabled only after the AVEVA Production Management service has processed all of its backlog items.

Related topics

• Remote state database configuration for graceful shutdown

• About SQL Server maintenance