MSS SQL Server is basically a self tuning system.
Be sure there is adequate space for Transaction logs based on your backup schedule
Run the following on a weekly basis:
|
• |
$prod is used to represent the selected product |
|
• |
$prodTop is used to represent the directory for the selected product |
|
• |
$lang is used to represent the selected language. |
|
Consider following directories using first where file is found | |
|
Consider following directories using first where file is found | |
|
- $prodTop/reports/$lang/*.rdf if exists, otherwise $prodTop/reports/*.rdf | |
|
$prodTop/reports/$lang if exists, otherwise $prodTop/reports | |
|
$prodTop/reports/$lang if exists, otherwise $prodTop/reports | |
|
Consider following directories using first where file is found | |
|
XMLExporter is used to extract the xml file from MDS Repository. | |
|
XMLImporter is used to deploy the xml file to MDS Repository of target | |
|
FNDLoad is used to extract the data source from XDO_DS_DEFINITIONS table | |
|
FNDLoad is used to deploy the data source to XDO_DS_DEFINITIONS table of target environment | |
|
If $prodTop/patch/115/xdf directory exists and xdfcmp.pl is used to deploy the xdf file to the target environment | |
Typical port and firewall conflicts include:
If you have port conflicts, the server will display one or more error messages, such as:
The Stat Central Agent utilizes a set of ports that are already defined.
These values are defined for a default port offset of zero which is set in a variable called jboss.socket.binding.port-offset in standalone.conf.bat or standalone.conf file. If there is a conflict situation or a second or third agent is necessary, you may change the jboss.socket.binding.port-offset in standalone.conf.bat or standalone.conf file. The value for offset is added to all the default values.
|
2 |
Open <STAT_HOME>\app\bin\standalone.conf.bat with Notepad or other text editor. For Stat Central Agent on Unix, you need to open the <STAT_HOME>/app/bin/standalone.conf file. |
|
3 |
Search for the setting: -Djboss.socket.binding.port-offset=0 |
|
4 |
Change the setting to a proper offset. For example, -Djboss.socket.binding.port-offset=10 |
The http port is the only port that needs to be opened on existing firewalls.
################################################################################
################################################################################
stat.db.jdbc_driver:oracle.jdbc.driver.OracleDriver
stat.db.server:<stat repository server name/ip> <-- Natted IP Address