PlateSpin Recon report generation takes a long time to complete

  • Document ID:7005611
  • Creation Date:02-Apr-2010
  • Modified Date:26-Apr-2012
    • Micro Focus Products:
      PlateSpin Recon

Environment

PlateSpin Recon

Situation

Platespin Recon 3.6 and higher with PostgreSQL Database takes an excessive amount of time generating forecast reports, creating projects and scenarios.
 
 

Resolution

1. Navigate to following folder of your Recon Server:

 

   <Platspin Recon Server Installation Directory>\PlateSpin Recon 3.x Server\configs

 
    e.g., if Recon is installed on C:, the path will be "C:\Program Files\PlateSpin Recon 3.x Server\configs"

 

2. Open following files in notepad or any text editor:

 

    PlateSpin.Database.config

    PlateSpin.PowerRecon.Monitoring.Database.config

 

3. Modify the following line in both the files as specified:
 

    <add key="Custom" value="Pooling=False"></add> 
 
4. Set value for Pooling to True instead of False. It will look like this:

 

    <add key="Custom" value="Pooling=True"></add>

 

5. Save changes to both files and close them.