Question

Database Daily 'Replication'

  • 7 July 2020
  • 3 replies
  • 160 views

Userlevel 2
Badge +5

Hi!

 For every customer of ours, we provide a ‘Support Environment’, which consists of a dedicated app server and daily updated Oracle database (copy of Production database) for troubleshooting purposes.

 Until IFS V10, this processes ran automatically and our clients could access IFS without any intervention. With IFS V10, every time we copy our Production database (using datafiles from previous backup and archive logs) to Support database, we need to reconfigure the application so it can be accessible.

 Is there a way to automate this process?

 Thanks in advance!

Elaine


3 replies

Userlevel 6
Badge +18

Hi Elaine,

The Support environment should be accessible post database refresh without reconfiguration as long as the following criteria is met:

  1. Both PROD and SUPPORT are on same Update and Patch level
  2. IFS* System user passwords match

What error message do you get which requires a reconfiguration? Is this SSL certificate related by any chance?

Userlevel 5
Badge +7

There are a few entries in database tables and system parameters that would need to be updated and verified.

  • System Parameters
    • Crystal Reports web server
    • EOI base URL
    • Print Company Logo
    • REPDES_GRAPHICS
    • URL_EXT_SERVER
    • Workflow Server
    • Forecast Server (FORECAST_SERVER_SETUP_TAB)
    • etc.
  • Server configurations for SMTP, FTP, etc.
  • Clear out and reset printing. Do you really want stuck print jobs printing out again from a non-production database once you get it copied?
Userlevel 4
Badge +8

Don't forget about any document management respositories.

 

 

Reply