07-21-2009, 05:30 PM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,238
|
|
KB16301 - BES 5.0 installation fails with the error "SQL query failed, see logs ..."
KB16301 - BlackBerry Enterprise Server version 5.0 installation fails with the following pop-up error "SQL query failed, see logs for more information"
Environment
- BlackBerry® Enterprise Server version 5.0
- SDR220985
- SDR220977
Overview
The BlackBerry Enterprise Server installation fails during the second half of the Server installation following the reboot of the computer that hosts the BlackBerry Enterprise Server. The following error is received:
SQL query failed, see logs for more information
Cause
The following log file snips show the possible causes:
Setup Log Error #1:
[40000] (10/24 11:50:55.717):{0x5F0} Connected to BONYTEST successfully.
[40000] (10/24 11:50:55.733):{0x5F0} Ignore on RemoveStandbyBESEntry as this is a primary BES.
[30000] (10/24 11:50:55.857):{0xBA4} <5>Oct 24 11:50:55 R85BES2 {0x5F0} 0250: (#30000) [PIPTOOL]: Attempting to remove the HA links.
[30000] (10/24 11:50:55.857):{0xBA4} <5>Oct 24 11:50:55 R85BES2 {0x5F0} 0251: (#30000) [PIPTOOL]: Using parameters: SQL2K5, BONYTEST, , , 0, 1433, R85BES2, False
[30000] (10/24 11:50:55.857):{0xBA4} <5>Oct 24 11:50:55 R85BES2 {0x5F0} 0252: (#30000) [PIPTOOL]: Could not remove HA links.
[30000] (10/24 11:50:55.857):{0xBA4} <4>Oct 24 11:50:55 R85BES2 {0x5F0} 0253: (#25111) ODBCRecord:: DoGetFirstValue: Duplicate entry exists
[30000] (10/24 11:50:55.857):{0xBA4} <4>Oct 24 11:50:55 R85BES2 {0x5F0} 0254: (#25000) ODBCRecord:: DoGetFirstValue: COM Error 0x80040E2F - IDispatch error #3119 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Cannot insert duplicate key row in object 'dbo.BASServiceInstances' with unique index 'IX_BASServiceInstances_Name'." - Command ""
[30000] (10/24 11:50:55.857):{0xBA4} <4>Oct 24 11:50:55 R85BES2 {0x5F0} 0255: (#20000) [ODBCRecord:: DoGetFirstValue] SQL = "calling proc BESAddStandby".
[30000] (10/24 11:50:55.857):{0xBA4} <4>Oct 24 11:50:55 R85BES2 {0x5F0} 0256: (#20000) [ODBCRecord:: DoGetFirstValue] DATA = "ServerConfigId[1] MachineName[R85BES2] ServiceName[CN=R85BES2/O=CSOC] ".
[30000] (10/24 11:50:55.857):{0xBA4} <3>Oct 24 11:50:55 R85BES2 {0x5F0} 0257: (#10000) [PIPTOOL]: Error! Unable to add stanby BES.
[40000] (10/24 11:56:18.185):{0xBA4} LogReceiver: Code on closing = 10038
[30000] (10/24 11:56:18.185):{0xBA4} [DIAG] EVENT=Unregister_thread, THREADID=0xBA4, THREADNAME="InstLogReceiver"
Setup Log Error #2:
[45059] (10/28 15:35:36.246):{0x14C4} {ConnectionPool::InitializePool()}: Using connection pool with limit of 100 connections
[30000] (10/28 15:35:36.662):{0x14C4} [ENV] [DB] Connection String = Server=WSOMDDVBES01;Database=BESMgmt;uid=besadmin;pwd=
[30000] (10/28 15:35:36.662):{0x14C4} [ENV] [DB] DBMS Name = Microsoft SQL Server; DBMS Version = 09.00.3042; Provider Name = sqloledb.dll; Provider Friendly Name = Microsoft OLE DB Provider for SQL Server; OLE DB Version = 02.70; Provider Version = 08.10.3959
[35019] (10/28 15:35:36.726):{0x14C4} [ENV] [DB] Database Schema Version: 5.0 EAP7 <5.0.2008.10.03>
[40000] (10/28 15:35:36.726):{0x14C4} Connected to BESMgmt successfully.
[30000] (10/28 15:35:36.790):{0x14C4} [PIPTOOL]: SELECT Id 2, FROM table IMConfig WHERE MachineName = WNPCPLUBLK07. DoGetValue = 1, fExists = 1.
[25000] (10/28 15:35:37.079):{0x14C4} ODBCRecord:: DoGetFirstValue: COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Unable to find ServiceInstanceId for ParentId = 2 with PluginId = 103." - Command ""
[20000] (10/28 15:35:37.079):{0x14C4} [ODBCRecord:: DoGetFirstValue] SQL = "calling proc ComponentIMAddHAActive".
[20000] (10/28 15:35:37.079):{0x14C4} [ODBCRecord:: DoGetFirstValue] DATA = "ServerInstanceId[51] ParentId[2] ".
[10000] (10/28 15:35:37.079):{0x14C4} Error calling ComponentIMAddHAActive
[30000] (10/28 15:35:37.079):{0x1580} <3>Oct 28 15:35:37 WNPCPLUBLK07 {0x14C4} 0173: (#10000) [PIPTOOL]: Failed to update the IM values
[40000] (10/28 15:35:37.079):{0x1580} LogReceiver: Code on closing = 10038
[30000] (10/28 15:35:37.079):{0x1580} [DIAG] EVENT=Unregister_thread, THREADID=0x1580, THREADNAME="InstLogReceiver"
Setup Log Error #3:
[45059] (10/28 15:35:36.246):{0x14C4} {ConnectionPool::InitializePool()}: Using connection pool with limit of 100 connections
[30000] (10/28 15:35:36.662):{0x14C4} [ENV] [DB] Connection String = Server=WSOMDDVBES01;Database=BESMgmt;uid=besadmin;pwd=
[30000] (10/28 15:35:36.662):{0x14C4} [ENV] [DB] DBMS Name = Microsoft SQL Server; DBMS Version = 09.00.3042; Provider Name = sqloledb.dll; Provider Friendly Name = Microsoft OLE DB Provider for SQL Server; OLE DB Version = 02.70; Provider Version = 08.10.3959
[35019] (10/28 15:35:36.726):{0x14C4} [ENV] [DB] Database Schema Version: 5.0 EAP7 <5.0.2008.10.03>
[40000] (10/28 15:35:36.726):{0x14C4} Connected to BESMgmt successfully.
[30000] (10/28 15:35:36.790):{0x14C4} [PIPTOOL]: SELECT Id 2, FROM table IMConfig WHERE MachineName = WNPCPLUBLK07. DoGetValue = 1, fExists = 1.
[25000] (10/28 15:35:37.079):{0x14C4} ODBCRecord:: DoGetFirstValue: COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Unable to find ServiceInstanceId for ParentId = 2 with PluginId = 103." - Command ""
[20000] (10/28 15:35:37.079):{0x14C4} [ODBCRecord:: DoGetFirstValue] SQL = "calling proc ComponentIMAddHAActive".
[20000] (10/28 15:35:37.079):{0x14C4} [ODBCRecord:: DoGetFirstValue] DATA = "ServerInstanceId[51] ParentId[2] ".
[10000] (10/28 15:35:37.079):{0x14C4} Error calling ComponentIMAddHAActive
[30000] (10/28 15:35:37.079):{0x1580} <3>Oct 28 15:35:37 WNPCPLUBLK07 {0x14C4} 0173: (#10000) [PIPTOOL]: Failed to update the IM values
[40000] (10/28 15:35:37.079):{0x1580} LogReceiver: Code on closing = 10038
[30000] (10/28 15:35:37.079):{0x1580} [DIAG] EVENT=Unregister_thread, THREADID=0x1580, THREADNAME="InstLogReceiver"
Resolution
To resolve this issue, complete the following steps that apply to the issue in your environment:
- Remove all the records in the 'BASServiceInstances' table that have an NT or Domino Name equivalent to the value in the 'Name' field.
- Remove all the records in the 'IMConfig' table that have an NT or Domino Name equivalent to the value in the 'MachineName' field.
- Remove all the records in the 'MDSConfig' table that have an NT or Domino Name equivalent to the value in the 'MachineName' field.
__________________
http://blog.port3101.org/hdawg/
The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.
|
Linear Mode
