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
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 ...IBM WebSphere Application Server v9 / IBM WebSphere MQ Broker Monitor Addition or Data Collection Fails Due to Missing JAR Files
Applicable Version: 181200 or later Problem When adding an IBM WebSphere Application Server v9 or IBM WebSphere MQ Broker monitor, or during data collection, the operation may fail if the required WebSphere client JAR files are not available in the ...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 ...Real User Monitor (RUM) - Troubleshooting guide
If your Real User Monitor has not collected data for an extended period, follow the steps below to troubleshoot the issue. Step 1: Verify the RUM Agent configuration Real User Monitoring requires the RUM Agent to be installed and mapped to ...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 ...