How to debug a Build Forge server test connection

Answer

You can enable debugging and test server connections from the command prompt.

To manually run a "Test Connection" for a server you can run:

bfservertest <logical server name>

bfservertest is located in:

Windows default: C:\Program Files\IBM\Build Forge
UNIX default: /opt/buildforge/Platform

To enable debugging you will need to set the following variables:


BF_AGENT_DEBUG=1
BF_SERVERTEST_DEBUG=1  
BFDEBUG_SQL_PREPARE=1  
BFDEBUG_SQL_DO=1

To set the variables on Windows use the following format

For UNIX and Linux environments please review the man page for the following depending on your shell:

env

or

export

Example:
[root@dude Platform]# ./bfservertest dude
DO(7070):[USE build]  
7070 PRE:[SHOW TABLES]  
DO(7070):[USE build]  
7070 PRE:[SELECT * FROM bf_messageids]  
7070 PRE:[SELECT * FROM bf_strings WHERE bf_lang=?]
Subroutine BuildForge::Services::Connection::AF_INET6 redefined at  
/PerlApp/Exporter.pm line 65.
at (eval 253) line 2
7070 PRE:[SELECT c.bf_id from bf_component c, bf_engines e WHERE e.bf_id  
= c.bf_component_id AND e.bf_id=?]  
....
....
....