Salesforce

Slow Adminserver startup and mergeprop execution times

« Go Back

Information

 
TitleSlow Adminserver startup and mergeprop execution times
URL Name000047174
Article Number000146441
EnvironmentProduct: OpenEdge
Version: 10.x, 11.x
OS: All Operating Systems
Question/Problem Description
Adminserver takes a long time to start
It takes several minutes before OpenEdge Explorer or Management becomes available
The fathom-plugin takes a long time to load

MERGEPROP takes a long time to complete
MERGEPROP execution times increase over time
$   mergeprop -action update -type database -delta newdb.properties -nobackup -validate
Steps to Reproduce
Clarifying Information
Changes to configured Database Resources are made through the OpenEdge Console or mergeprop
The AdminServer has been stopped and restarted several times
The conmgr.properties file is a lot larger than it should be for the configured database content (several MB)

admserv.log file shows several minutes delay between:
"Using user provided properties file DLC\properties\conmgr.properties. (8250)" and
"Loading configuration file... (7385)

conmgr.properties contains many Header lines and Trailer blocks:
Header Line: # Connection Manager Properties File
Trailer block starting: # prosqltrc=nnnnnnnnnnn
Error Message
Defect NumberDefect PSC00307819, PSC00364532
Enhancement Number
Cause
The Header Line and Trailer Block are added to the DLC\properties\conmgr.properties file during the first modification of a database resource configuration through the OpenEdge Console after the AdminServer is started, not when mergeprop is run. Any monitored property file (conmgr.properties ubroker.properties / pasmgr.properties) that has starting or trailing comments in which an edit outside of OEM, followed by an edit using OEM will trigger this. When comments are saved, the existing set of comments is preserved, but the file is reloaded.  This causes the "existing" comments from the first load to be merged in with the comments freshly loaded from the file, causing duplication when it is written back.

The larger the related conmgr.properties file becomes as a result of the added Header/Trailer comments over time:
  • MERGEPROP takes longer to parse the current conmgr.properties and
  • The Adminserver takes longer to read through the current properties when starting as each and every line in the properties file is read and checked if it starts with a comment (#).
  • The Fathom-plugin and Fathom WebServer can only initialise once the conmgr.properties file (and related other managed resource properties) have been loaded.
Resolution
Upgrade to OpenEdge 11.7.3. 

The properties file discards header and footer comments currently stored for the previous loaded version of the properties file and respects the header and footer comments in the file when the properties are reloaded for managed resources (warmstart for example). 
Workaround
Open the DLC\properties\conmgr.properties file in a text editor and remove duplicate the Header lines and Trailer Blocks with # (comments).

The Header : 
# Connection Manager Properties File

The Trailer Block: 
# prosqltrc=nnnnnnnnnnn # turn on various levels of SQL tracing
# reportinginterval=1 # -rpint (4gl only)
# serverexe=<4gl server location> # _mprosrv (4gl only)
# type=both # n/a
# host=localhost # -H
# initialservers=0 # n/a
# maxclientsperserver=0 # -Ma (calculated value)
# maxdynamicport=5000 # -maxport (5000 for NT; 2000 for UNIX)
# messagebuffersize=350 # -Mm (4gl only)
# minclientsperserver=1 # -Mi
# mindynamicport=3000 # -minport (3000 for NT; 1025 for UNIX)
# networkclientsupport=true # false for self-service
# numberofservers=0 # -Mpb
# port=0 # -S ; Must be non-zero
# when networkclientsupport=true

 
Alternatively, the conmgr.properties file can be parsed to remove the lines containing a # character. For example on Windows, FINDSTR /v # can be used.
 
COPY %DLC%\properties\conmgr.properties %DLC%\properties\backup_%date:~10,4%%date:~7,2%%date:~4,2%_%time:~0,2%%time:~3,2%_conmgr.properties
MOVE %DLC%\properties\conmgr.properties %DLC%\properties\temp_conmgr.properties
TYPE %DLC%\properties\temp_conmgr.properties | FINDSTR /v '#' > %DLC%\properties\conmgr.properties
DEL %DLC%\properties\temp_conmgr.properties >nul 2>&1

 
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:09 AM

Powered by