The messages that are output are as follows:
At Template Builder window operation:
ERROR VSYS10098 SQL error.[Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.]
At Template Builder command operation:
TPLCnnnnn:<Message>(VSYS10098) (*)
* Note: nnnnn is the message number. Refer to "Chapter 19 Messages Starting with TPLC" in the "Messages" for details.
Cause
The cause is one of the following:
The database is not started.
A WorkUnit (RCXCT_VSYS) of the L-Platform Management function API was probably started while the database was stopped.
The database is not started.
In the state where a WorkUnit is started, probably only the database has been stopped.
Action
Take action 1 in response to cause 1 and action 2 in response to cause 2.
Check whether the following message has been output to the trace log (vsys_trace_log) of the L-Platform management function:
1) VSYS10098 and VSYS00000 have been output alternately, and 2) After 1), VSYS00001 has been output, and 3) After 2), VSYS00003 has been output.
Example
[2012-05-25 11:24:17,428] ERROR VSYS10098 SQL error.[Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.] [2012-05-25 11:24:17,428] WARN VSYS00000 Failed to connect to the database. Retrying... ... (VSYS10098 and VSYS00000 are repeatedly output alternately) ... [2012-05-25 11:26:41,441] ERROR VSYS10098 SQL error.[Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.] [2012-05-25 11:26:41,441] ERROR VSYS00001 Failed retry. The database may not be ready. [2012-05-25 11:26:41,441] ERROR VSYS00003 VSYS API Startup is terminated.
Start the database according to the action in "VSYS00001" in the "Messages"
Check whether the following message has been output to the trace log (vsys_trace_log) in the L-Platform management window:
1) VSYS10098 has been output, and 2) "Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections." has been output as a detailed error message of 1), and 3) After 1), a Java exception display (stack trace) has been output.
Example
[2012-05-25 11:45:13,648] ERROR VSYS10098 SQL error.[Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.] org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:136) ... (Java stack trace is output.) ...
Start the database according to the action in "VSYS00001" in the "Messages".
