PostgreSQL Monitor Addition Fails with “Invalid value for parameter 'TimeZone'”
Error Message: 'FATAL: invalid value for parameter "TimeZone": "Asia/Calcutta"
Cause
This error occurs when the PostgreSQL server returns a timezone value that the AppManager JVM does not recognize.
Troubleshooting
Run the following query on the PostgreSQL server you are trying to add as a monitor:
SHOW TimeZone;
Resolution
Case 1:
If the result of the SHOW TimeZone query is Asia/Calcutta, update it to Asia/Kolkata, then try adding the PostgreSQL monitor again.
Case 2:
Set the correct timezone for the AppManager service:
- Open <AppManager_Home>/working/conf/wrapper.conf
- Add (or update) the following entry:wrapper.java.additional.33=-Duser.timezone=Asia/Kolkata
- Save the file and restart Applications Manager.
Verification
After restarting the service, try re-adding the PostgreSQL monitor. The connection should now succeed without the 'TimeZone' parameter error.
Ensure that:
- The server OS timezone,
- The PostgreSQL configuration (postgresql.conf → timezone), and
- The JVM timezone (in wrapper.conf)
are consistent and use valid timezone identifiers.
New to ADSelfService Plus?
Related Articles
Monitor Addition Fails with ‘Invalid Username & Password’ Error Despite Providing Correct Credentials
If your build version is 177300 or above, but below 178400, there is a known issue that causes Monitor Addition Failure due to invalid username or password. To resolve this, on the remote WebLogic server Version 12, navigate to <Weblogic ...Troubleshooting URL Monitor
When configuring a URL monitor in Applications Manager, you might encounter several errors related to accessibility, configuration, or server-side issues. Below are common errors along with step-by-step troubleshooting instructions to help you ...Real User Monitor (RUM) - Troubleshooting
If the monitor has not polled data for a long time, follow the below steps for troubleshooting. Step 1: Check the RUM Agent configuration Real User Monitor requires the RUM Agent to be installed and mapped to the Applications Manager. Refer this help ...How to get ISP and Region data in Real User Monitor?
The default setting of the Real User Monitor does not display ISP and region data for the end user. To obtain the data, you have the option to use a third-party Geolocation API. Currently, RUM exclusively supports APIs that provide responses in JSON ...DNS Monitor - Troubleshooting
Common DNS Monitor Errors and Troubleshooting Guide 1. Host Not Found Description: The DNS server was unable to locate the requested lookup address. Possible Causes: This may happen if the hostname is incorrect, the domain does not exist, or there is ...