Verifying site time zone settings
- Run the checksitetimezones.exe (located in the <installation_directory>\inform\bin\DBora folder) on the InForm application server using the following syntax:
checksitetimezones.exe <connection_string> <trialdb_user> <output_filename>
When prompted, enter the password for the trial database user.
For example:
checkSiteTimeZones.exe trialpdb1 pfst45uid Password123_ timezone.txt
The script reports on site time zone status in the file that you specify and also in a CSV file called Allsites.csv.
Note: If the script finds any bad time zones, it changes the output file name you specified to bad_<output_filename>, for example, bad_sitetimes.txt.
There are three options to run checksitetimezones.exe:
checkSiteTimeZones.exe <DBInstance> <TrialUID> <TrialPID> <outfile>
checkSiteTimeZones.exe <DBInstance> /accountparams:<filename> <outfile>
checkSiteTimeZones.exe <DBInstance> /prompt <outfile>
Where:
- <DBInstance>—Oracle Database Instance TNS name (for example, autoathena_dev1).
- <TrialUID> <TrialPID>—InForm Trial User ID and Password.
- /accountparams:<filename>—Optionally enclosed in quotes, filename is the name of a file containing the required account credentials.
The account parameter file format is:
- /prompt—Prompt for required account credentials.
- <outfile>—Name of file to write results to.
The account parameters file consists of the following key=value pairs:
- TrialUID=<UID>
- TrialPID=<PID>