BigFix 9.5 recently installed on RedHat, can't login to console

Usage and Config
1

Hello all

I just installed BigFix 9.5 on Red Hat Linux (RHEL Server 6), no errors during installation, all BES server services are running, the “Step 3 - Verifying Server Installation” from official documentation was performed and all is OK, then I installed BES Console on a Windows server but can’t login, the console throw this message:

Connection to server could not be completed. Diagnostic Message: Unexpected error: Database Error: [IBM][CLI Driver][DB2/LINUXX8664] SQLN0204N
“DBO.SITELOCK_ACTIONSITE” is an undefined name. SQLSTATE=42704

Also, from /var/log/BESRelay.log I get this:

Wed, 06 Apr 2016 15:41:28 +0800 - LDAPGroupMembershipRefresher (1767290624) - Will retry LDAP refresh in 00:15:00
Wed, 06 Apr 2016 15:56:28 +0800 - LDAPGroupMembershipRefresher (1767290624) - Database Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N “DBO.SITELOCK_USERINFO” is an undefined name. SQLSTATE=42704
(42704: 18446744073709551412)
Wed, 06 Apr 2016 15:56:28 +0800 - LDAPGroupMembershipRefresher (1767290624) - Will retry LDAP refresh in 00:15:00
Wed, 06 Apr 2016 16:07:04 +0800 - /data/analysis-property-mapping (1021290240) - Database Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N “DBO.SITELOCK_ACTIONSITE” is an undefined name. SQLSTATE=42704
(42704: 18446744073709551412)
Wed, 06 Apr 2016 16:10:23 +0800 - /data/analysis-property-mapping (1021290240) - Database Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N “DBO.SITELOCK_ACTIONSITE” is an undefined name. SQLSTATE=42704
(42704: 18446744073709551412)
Wed, 06 Apr 2016 16:11:28 +0800 - LDAPGroupMembershipRefresher (1767290624) - Database Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N “DBO.SITELOCK_USERINFO” is an undefined name. SQLSTATE=42704
(42704: 18446744073709551412)
Wed, 06 Apr 2016 16:11:28 +0800 - LDAPGroupMembershipRefresher (1767290624) - Will retry LDAP refresh in 00:15:00
Wed, 06 Apr 2016 16:16:39 +0800 - 893302528 - 1: GetURL failure on http://sync.bigfix.com/cgi-bin/bfgather/webui-common?Time=1459930589: HTTP Error 28: Timeout was reached: Connection time-out

I will really appreciate your help! Please…

2

I don’t have an answer for you, but the only time I have seen something of that ERROR code on DB2 was “enabling operating system security” (was enabled) on DB2 that was the root cause. I would really open a PMR –

1 Like
3

Thanks for your answer @dpowers1. I’ll try the security thing on DB2. The customer bought the product but somehow does not have official support yet.