Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

BlackBerry® Enterprise Service 10

Reply
New Developer
Posts: 68
Registered: ‎04-16-2009
My Device: Not Specified

BES upgrade error - An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement

Hi guys,

 

I was trying to upgrade BES and during upgrading the Database i.e. BESMgmt it shows an error message and installation fails.

 

An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement.

 

I have tried a few KBS from btsc but didnt work

 

KB15451

 

Environment:

BES current version: 4.1.6

To be upgraded to  BES 5 SP2

Lotus Domino 7

 

Highlighted
Contributor
Posts: 12
Registered: ‎12-21-2010
My Device: 9700 bold
My Carrier: Rogers

Re: BES upgrade error - An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement

Backup your database first.

 

Try this KB first: http://www.blackberry.com/btsc/KB26363

 

If it does not work then try this one: http://www.blackberry.com/btsc/KB25012

 

Hope it will work.

New Developer
Posts: 68
Registered: ‎04-16-2009
My Device: Not Specified

Re: BES upgrade error - An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement

Hi abbassctg,

 

Thanks for your reply, both KB articles does not apply to my environment i.e. BES 4.1.6.

 

waiting for the appropriate reply.

 

thanks anyway

Forums Advisor III
Posts: 1,173
Registered: ‎08-29-2008
My Device: Blackberry Classic
My Carrier: Swisscom

Re: BES upgrade error - An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement

The error message "An error occurred while executing an SQL statement" is very generic. You have to look in the setup log in the installer directory to find a more detailed SQL related error message. Please post it here.

New Developer
Posts: 68
Registered: ‎04-16-2009
My Device: Not Specified

Re: BES upgrade error - An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement

PFB.

 

UTF-8 encoded
[30000] (11/15 16:45:12.296):{0xB54} Current Date: 2012/11/15
[30000] (11/15 16:45:12.296):{0xB54} [DIAG] EVENT=Thread_report, THREADID=0xB54, THREADNAME="DebugLogger"
[30000] (11/15 16:45:12.296):{0xB54} [DIAG] EVENT=Thread_report, THREADID=0xB58, THREADNAME="InstLogReceiver"
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Current Process: D:\BES 5 SP2\Setup.exe
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Current Process logged on as: BBESERVER\Administrator, Start Time: Nov 15 2012 16:45:12, Uptime (seconds): 0
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Current Process id: 2728
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Computer Host Name: bbeserver, OS Version: 5.2, Build number 3790, ServicePack Major 2, ServicePack Minor 0
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Processor Identifier: x86 Family 6 Model 23 Stepping 6
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Processor Vendor Identifier: GenuineIntel
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Processor Name String: Intel(R) Xeon(R) CPU           E5410  @ 2.33GHz
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Number of Processors: 4
[30000] (11/15 16:45:12.296):{0xB54} [ENV] 21 percent of memory in use.
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Total size of physical memory: 2091852 KB
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Size of physical memory available: 1638848 KB
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Size of the committed memory limit: 4036112 KB
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Size of available memory to commit: 3739800 KB
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Total size of the user mode portion of the virtual address space of the BES process: 2097024 KB
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Size of unreserved and uncommitted memory in the user mode portion of the virtual address space of the BES process: 2016584 KB
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Size of private memory of the BES process: 6592 KB
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Total HD bytes: 118847037440, Total free bytes = 77393502208
[30000] (11/15 16:45:12.296):{0xB54} [ENV] System up time: 0 days 00 hrs 38 mins 52 secs
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Local Time Zone: West Asia Standard Time (GMT+05:00)
[30000] (11/15 16:45:12.296):{0xB54} [ENV] TCP/IP provider (Winsock) File Version: 5.2.3790.0 (C:\WINDOWS\System32\wsock32.dll)
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Local machine IP Address = 172.16.28.13
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Winsock2 file: Tcpip, Version: 5.2.3790.3959 (C:\WINDOWS\System32\mswsock.dll)
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Winsock2 file: NTDS, Version: 5.2.3790.3959 (C:\WINDOWS\System32\winrnr.dll)
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Winsock2 file: Network Location Awareness (NLA) Namespace, Version: 5.2.3790.3959 (C:\WINDOWS\System32\mswsock.dll)
[30000] (11/15 16:45:12.296):{0xB54} [ENV] Microsoft XML Parser 6.0: C:\WINDOWS\system32\msxml6.dll, Version: 6.10.1129.0
[30000] (11/15 16:45:12.437):{0xB54} [ENV] MSSQL OLEDB provider is available: [SQLOLEDB]
[30000] (11/15 16:45:12.437):{0xB54} [ENV] MDAC version: 2.82.3959.0
[30000] (11/15 16:45:12.437):{0xB54} [ENV] MSADO15.DLL: C:\Program Files\Common Files\System\ado\msado15.dll, Version: 2.82.3959.0
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: System, ID: 4
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: smss.exe, ID: 308
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: csrss.exe, ID: 356
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: winlogon.exe, ID: 384
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: services.exe, ID: 432
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: lsass.exe, ID: 444
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: svchost.exe, ID: 656
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: svchost.exe, ID: 720
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: svchost.exe, ID: 792
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: svchost.exe, ID: 832
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: svchost.exe, ID: 848
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: spoolsv.exe, ID: 996
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: msdtc.exe, ID: 1020
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: svchost.exe, ID: 1140
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: mnmsrvc.exe, ID: 1172
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: sqlservr.exe, ID: 1200
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: rundll32.exe, ID: 1208
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: NTRtScan.exe, ID: 1228
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: svchost.exe, ID: 1268
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: snmp.exe, ID: 1296
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: TmListen.exe, ID: 1468
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: wdfmgr.exe, ID: 1536
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: svchost.exe, ID: 1936
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: CNTAoSMgr.exe, ID: 2116
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: UA7B5.EXE, ID: 2152
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: csrss.exe, ID: 2388
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: winlogon.exe, ID: 2416
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: rdpclip.exe, ID: 2620
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: explorer.exe, ID: 2736
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: PccNTMon.exe, ID: 2868
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: jusched.exe, ID: 2876
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: sqlmangr.exe, ID: 2892
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: wmiprvse.exe, ID: 3104
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: jucheck.exe, ID: 3696
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: logon.scr, ID: 3864
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: wmiprvse.exe, ID: 2372
[30000] (11/15 16:45:12.437):{0xB54} [ENV] Running Process: Setup.exe, ID: 2728
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xB30} 0000: (#40000) [DIAG] EVENT=Syslog_connected, EVENTMSG="Connected to 127.0.0.1"
[30000] (11/15 16:45:12.703):{0xB58} <5>Nov 15 16:45:12 bbeserver  {0xAC8} 0001: (#30000) [PIPTOOL]: Automated install option was not specified for PIPTool via /s command-line parameter.
[30000] (11/15 16:45:12.703):{0xB58} <5>Nov 15 16:45:12 bbeserver  {0xAC8} 0002: (#30000) [PIPTOOL]: IsAutomatedInstall set to [0] in PIPToolDlg.
[30000] (11/15 16:45:12.703):{0xB58} <5>Nov 15 16:45:12 bbeserver  {0xAC8} 0003: (#30000) [PIPTOOL]: Automation script set to length=[0] in PIPToolDlg.
[30000] (11/15 16:45:12.703):{0xB58} <5>Nov 15 16:45:12 bbeserver  {0xAC8} 0004: (#30000) [PIPTool]: The installing product info: type [Domino], product version [5.0.2 (Bundle 36)].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0005: (#40000) [PIPTOOL]: Successfully added [Server] to the feature list. Component [BlackBerry Enterprise Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0006: (#40000) [PIPTOOL]: Successfully added [BlackBerryController] to the feature list. Component [BlackBerry Enterprise Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0007: (#40000) [PIPTOOL]: Successfully added [BES_SQLAuth] to the feature list. Component [BlackBerry Enterprise Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0008: (#40000) [PIPTOOL]: Successfully added [AttachServer_Local] to the feature list. Component [BlackBerry Enterprise Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0009: (#40000) [PIPTOOL]: Successfully added [CEDLL] to the feature list. Component [BlackBerry Enterprise Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0010: (#40000) [PIPTOOL]: Successfully added [SyncServer] to the feature list. Component [BlackBerry Enterprise Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0011: (#40000) [PIPTOOL]: Successfully added [ITAdmin] to the feature list. Component [BlackBerry Enterprise Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0012: (#40000) [PIPTOOL]: Successfully added [SlipStream] to the feature list. Component [BlackBerry Enterprise Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0013: (#40000) [PIPTOOL]: Successfully added [MSS] to the feature list. Component [BlackBerry Enterprise Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0014: (#40000) [PIPTOOL]: Successfully added [BESConfig] to the feature list. Component [BlackBerry Enterprise Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0015: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [BlackBerry Enterprise Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0016: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [BlackBerry Enterprise Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0017: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [BlackBerry Enterprise Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0018: (#40000) [PIPTOOL]: Successfully added [AdminService] to the feature list. Component [BlackBerry administration].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0019: (#40000) [PIPTOOL]: Successfully added [CEDLL] to the feature list. Component [BlackBerry administration].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0020: (#40000) [PIPTOOL]: Successfully added [BESConfig] to the feature list. Component [BlackBerry administration].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0021: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [BlackBerry administration].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0022: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [BlackBerry administration].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0023: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [BlackBerry administration].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0024: (#40000) [PIPTOOL]: Successfully added [BASDesktop] to the feature list. Component [BlackBerry Web Desktop Manager].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0025: (#40000) [PIPTOOL]: Successfully added [BESConfig] to the feature list. Component [BlackBerry Web Desktop Manager].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0026: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [BlackBerry Web Desktop Manager].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0027: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [BlackBerry Web Desktop Manager].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0028: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [BlackBerry Web Desktop Manager].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0029: (#40000) [PIPTOOL]: Successfully added [BMSA] to the feature list. Component [BlackBerry Monitoring Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0030: (#40000) [PIPTOOL]: Successfully added [CEDLL] to the feature list. Component [BlackBerry Monitoring Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0031: (#40000) [PIPTOOL]: Successfully added [BESConfig] to the feature list. Component [BlackBerry Monitoring Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0032: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [BlackBerry Monitoring Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0033: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [BlackBerry Monitoring Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0034: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [BlackBerry Monitoring Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0035: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [BlackBerry SIP Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0036: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [BlackBerry SIP Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0037: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [BlackBerry SIP Server].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0038: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [BlackBerry SIP Connector].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0039: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [BlackBerry SIP Connector].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0040: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [BlackBerry SIP Connector].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0041: (#40000) [PIPTOOL]: Successfully added [MDSS] to the feature list. Component [BlackBerry MDS Integration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0042: (#40000) [PIPTOOL]: Successfully added [CEDLL] to the feature list. Component [BlackBerry MDS Integration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0043: (#40000) [PIPTOOL]: Successfully added [BlackBerryController] to the feature list. Component [BlackBerry MDS Integration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0044: (#40000) [PIPTOOL]: Successfully added [BESConfig] to the feature list. Component [BlackBerry MDS Integration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0045: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [BlackBerry MDS Integration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0046: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [BlackBerry MDS Integration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0047: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [BlackBerry MDS Integration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0048: (#40000) [PIPTOOL]: Successfully added [BES_SQLAuth] to the feature list. Component [BlackBerry Manager].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0049: (#40000) [PIPTOOL]: Successfully added [Utilities] to the feature list. Component [BlackBerry Manager].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0050: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [BlackBerry Manager].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0051: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [BlackBerry Manager].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0052: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [BlackBerry Manager].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0053: (#40000) [PIPTOOL]: Successfully added [AttachServer_Remote] to the feature list. Component [BlackBerry Attachment Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0054: (#40000) [PIPTOOL]: Successfully added [BlackBerryController] to the feature list. Component [BlackBerry Attachment Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0055: (#40000) [PIPTOOL]: Successfully added [BESConfig] to the feature list. Component [BlackBerry Attachment Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0056: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [BlackBerry Attachment Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0057: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [BlackBerry Attachment Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0058: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [BlackBerry Attachment Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0059: (#40000) [PIPTOOL]: Successfully added [BES_SQLAuth] to the feature list. Component [BlackBerry Router].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0060: (#40000) [PIPTOOL]: Successfully added [Router] to the feature list. Component [BlackBerry Router].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0061: (#40000) [PIPTOOL]: Successfully added [CEDLL] to the feature list. Component [BlackBerry Router].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0062: (#40000) [PIPTOOL]: Successfully added [BlackBerryController] to the feature list. Component [BlackBerry Router].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0063: (#40000) [PIPTOOL]: Successfully added [BESConfig] to the feature list. Component [BlackBerry Router].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0064: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [BlackBerry Router].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0065: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [BlackBerry Router].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0066: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [BlackBerry Router].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0067: (#40000) [PIPTOOL]: Successfully added [MDSCS] to the feature list. Component [BlackBerry MDS Connection Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0068: (#40000) [PIPTOOL]: Successfully added [CEDLL] to the feature list. Component [BlackBerry MDS Connection Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0069: (#40000) [PIPTOOL]: Successfully added [BlackBerryController] to the feature list. Component [BlackBerry MDS Connection Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0070: (#40000) [PIPTOOL]: Successfully added [BESConfig] to the feature list. Component [BlackBerry MDS Connection Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0071: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [BlackBerry MDS Connection Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0072: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [BlackBerry MDS Connection Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0073: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [BlackBerry MDS Connection Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0074: (#40000) [PIPTOOL]: Successfully added [BBIM] to the feature list. Component [IBM® Lotus® Sametime®].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0075: (#40000) [PIPTOOL]: Successfully added [CEDLL] to the feature list. Component [IBM® Lotus® Sametime®].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0076: (#40000) [PIPTOOL]: Successfully added [BlackBerryController] to the feature list. Component [IBM® Lotus® Sametime®].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0077: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [IBM® Lotus® Sametime®].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0078: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [IBM® Lotus® Sametime®].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0079: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [IBM® Lotus® Sametime®].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0080: (#40000) [PIPTOOL]: Successfully added [BBIM] to the feature list. Component [Novell® GroupWise® Messenger].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0081: (#40000) [PIPTOOL]: Successfully added [CEDLL] to the feature list. Component [Novell® GroupWise® Messenger].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0082: (#40000) [PIPTOOL]: Successfully added [BlackBerryController] to the feature list. Component [Novell® GroupWise® Messenger].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0083: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [Novell® GroupWise® Messenger].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0084: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [Novell® GroupWise® Messenger].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0085: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [Novell® GroupWise® Messenger].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0086: (#40000) [PIPTOOL]: Successfully added [BBIM] to the feature list. Component [Microsoft® Office Live Communications Server 2005 (Office Communicator)].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0087: (#40000) [PIPTOOL]: Successfully added [CEDLL] to the feature list. Component [Microsoft® Office Live Communications Server 2005 (Office Communicator)].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0088: (#40000) [PIPTOOL]: Successfully added [BlackBerryController] to the feature list. Component [Microsoft® Office Live Communications Server 2005 (Office Communicator)].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0089: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [Microsoft® Office Live Communications Server 2005 (Office Communicator)].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0090: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [Microsoft® Office Live Communications Server 2005 (Office Communicator)].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0091: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [Microsoft® Office Live Communications Server 2005 (Office Communicator)].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0092: (#40000) [PIPTOOL]: Successfully added [BBIM] to the feature list. Component [BlackBerry Collaboration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0093: (#40000) [PIPTOOL]: Successfully added [CEDLL] to the feature list. Component [BlackBerry Collaboration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0094: (#40000) [PIPTOOL]: Successfully added [BlackBerryController] to the feature list. Component [BlackBerry Collaboration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0095: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [BlackBerry Collaboration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0096: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [BlackBerry Collaboration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0097: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [BlackBerry Collaboration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0098: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [BlackBerry Mail Store Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0099: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [BlackBerry Mail Store Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0100: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [BlackBerry Mail Store Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0101: (#40000) [PIPTOOL]: Successfully added [BMSU] to the feature list. Component [BlackBerry Monitoring Console].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0102: (#40000) [PIPTOOL]: Successfully added [CEDLL] to the feature list. Component [BlackBerry Monitoring Console].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0106: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [BlackBerry Monitoring Console].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0108: (#40000) [PIPTOOL]: Successfully added [CEDLL] to the feature list. Component [Microsoft® Office Communications Server 2007].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0110: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [Microsoft® Office Communications Server 2007].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0112: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [Microsoft® Office Communications Server 2007].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0114: (#40000) [PIPTOOL]: Successfully added [BESConfig] to the feature list. Component [MDS Admin Console Link].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0115: (#40000) [PIPTOOL]: Successfully added [BMSI] to the feature list. Component [MDS Admin Console Link].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0117: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [MDS Admin Console Link].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0119: (#40000) [PIPTOOL]: Successfully added [BESConfig] to the feature list. Component [BlackBerry Administration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0121: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [BlackBerry Administration Service].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0123: (#40000) [PIPTOOL]: Successfully added [BASActiveDir] to the feature list. Component [Use Active Directory authentication].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0125: (#40000) [PIPTOOL]: Successfully added [Docs] to the feature list. Component [Use Active Directory authentication].
[30000] (11/15 16:45:12.703):{0xB58} <6>Nov 15 16:45:12 bbeserver  {0xAC8} 0126: (#40000) [PIPTOOL]: Successfully added [Mandatory] to the feature list. Component [Use Active Directory authentication].
[30000] (11/15 16:45:12.703):{0xB58} <5>Nov 15 16:45:12 bbeserver  {0xAC8} 0128: (#30000) [PIPTOOL]: The setup program could not detect Java Version on the system.
[30000] (11/15 16:45:12.703):{0xB58} <5>Nov 15 16:45:12 bbeserver  {0xAC8} 0130: (#30000) [PIPTOOL]Smiley FrustratedtopAdAVI - The Ad is either not loaded, not playing, or the Ad control is not visible
[30000] (11/15 16:45:14.531):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0133: (#30000) [PIPTOOL]: CLanguagePopup - Language selected is [English]
[30000] (11/15 16:45:14.531):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0134: (#30000) [PIPTOOL]: Leaving CLanguagePopup.
[30000] (11/15 16:45:14.531):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0135: (#30000) CountEachFeatureRequiredSize: Starting to count for each feature's required size.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0136: (#30000) CountEachFeatureRequiredSize: Required size for 'Server' feature and its children. 25326080 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0137: (#30000) CountEachFeatureRequiredSize: Required size for 'BlackBerryController' feature and its children. 1427968 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0138: (#30000) CountEachFeatureRequiredSize: Required size for 'BES_SQLAuth' feature and its children. 512 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0139: (#30000) CountEachFeatureRequiredSize: Required size for 'AttachServer_Local' feature and its children. 4245504 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0140: (#30000) CountEachFeatureRequiredSize: Required size for 'CEDLL' feature and its children. 517632 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0141: (#30000) CountEachFeatureRequiredSize: Required size for 'SyncServer' feature and its children. 10087936 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0142: (#30000) CountEachFeatureRequiredSize: Required size for 'ITAdmin' feature and its children. 4019200 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0143: (#30000) CountEachFeatureRequiredSize: Required size for 'SlipStream' feature and its children. 1433600 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0144: (#30000) CountEachFeatureRequiredSize: Required size for 'MSS' feature and its children. 1710080 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0145: (#30000) CountEachFeatureRequiredSize: Required size for 'BESConfig' feature and its children. 4651008 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0146: (#30000) CountEachFeatureRequiredSize: Required size for 'BMSI' feature and its children. 1413120 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0147: (#30000) CountEachFeatureRequiredSize: Required size for 'Docs' feature and its children. 8192 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0148: (#30000) CountEachFeatureRequiredSize: Required size for 'Mandatory' feature and its children. 27648 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0149: (#30000) CountEachFeatureRequiredSize: Required size for 'AdminService' feature and its children. 151549952 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0150: (#30000) CountEachFeatureRequiredSize: Required size for 'BASDesktop' feature and its children. 17133568 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0151: (#30000) CountEachFeatureRequiredSize: Required size for 'BMSA' feature and its children. 84441600 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0152: (#30000) CountEachFeatureRequiredSize: Required size for 'MDSS' feature and its children. 14843904 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0153: (#30000) CountEachFeatureRequiredSize: Required size for 'Utilities' feature and its children. 0 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0154: (#30000) CountEachFeatureRequiredSize: Required size for 'AttachServer_Remote' feature and its children. 52745728 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0155: (#30000) CountEachFeatureRequiredSize: Required size for 'Router' feature and its children. 4260352 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0156: (#30000) CountEachFeatureRequiredSize: Required size for 'MDSCS' feature and its children. 40461312 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0157: (#30000) CountEachFeatureRequiredSize: Required size for 'BBIM' feature and its children. 29442048 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0158: (#30000) CountEachFeatureRequiredSize: Required size for 'BMSU' feature and its children. 59724800 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0159: (#30000) CountEachFeatureRequiredSize: Required size for 'MDSAdminConLink' feature and its children. 8192 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0160: (#30000) CountEachFeatureRequiredSize: Required size for 'BASConsole' feature and its children. 33292288 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0161: (#30000) CountEachFeatureRequiredSize: Required size for 'BASActiveDir' feature and its children. 307200 bytes. Added to the list.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0162: (#30000) CountEachFeatureRequiredSize: Finishing to count for each feature's required size.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0163: (#30000) Successfully counted the component's required sizes.
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0164: (#30000) [PIPTOOL]Smiley FrustratedtopAdAVI - The Ad is either not loaded, not playing, or the Ad control is not visible
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0165: (#30000) [PIPTOOL]Smiley FrustratedwapAdAVIToImage - The static image is already visible
[30000] (11/15 16:45:14.937):{0xB58} <5>Nov 15 16:45:14 bbeserver  {0xAC8} 0166: (#30000) [PIPTOOL]: Entering init dialog for CAccountPopup
[30000] (11/15 16:45:16.359):{0xB58} <5>Nov 15 16:45:16 bbeserver  {0xAC8} 0167: (#30000) [PIPTOOL]: Leaving CAccountPopup.
[30000] (11/15 16:45:17.375):{0xB58} <5>Nov 15 16:45:17 bbeserver  {0xAC8} 0168: (#30000) [PIPTOOL]: The exit code of the decompression of included Ads is [259].
[30000] (11/15 16:45:17.578):{0xB58} <6>Nov 15 16:45:17 bbeserver  {0xAC8} 0169: (#40000) [PIPTOOL]: Successfully downloaded [BESN_Ads.ini], [C:\Program Files\BES_Inst_Temp\Downloaded\\BESN_Ads.ini].
[30000] (11/15 16:45:17.578):{0xB58} <6>Nov 15 16:45:17 bbeserver  {0xAC8} 0170: (#40000) [PIPTOOL]: Successfully downloaded [BESN_Ads_en.exe], [C:\Program Files\BES_Inst_Temp\Downloaded\\BESN_Ads_en.exe].
[30000] (11/15 16:45:17.578):{0xB58} <5>Nov 15 16:45:17 bbeserver  {0xAC8} 0171: (#30000) [PIPTOOL]: The exit code of the decompression of downloaded Ads is [259].
[30000] (11/15 16:45:17.578):{0xB58} <5>Nov 15 16:45:17 bbeserver  {0xAC8} 0172: (#30000) [PIPTOOL]: Banner AVI file loaded successfully from C:\Program Files\BES_Inst_Temp\banner.avi
[30000] (11/15 16:45:17.578):{0xB58} <5>Nov 15 16:45:17 bbeserver  {0xAC8} 0173: (#30000) GetProdInfo: Found the existing product info. Product GUID: {4F02A8A9-8C94-4088-BDD2-59080ABC9BED}, version: 4.1.0061.
[30000] (11/15 16:45:17.578):{0xB58} <5>Nov 15 16:45:17 bbeserver  {0xAC8} 0174: (#30000) Component [BlackBerry Enterprise Server] has been selected.  Ref count: 1
[30000] (11/15 16:45:17.578):{0xB58} <5>Nov 15 16:45:17 bbeserver  {0xAC8} 0175: (#30000) Component [BlackBerry Manager] has been selected.  Ref count: 1
[30000] (11/15 16:45:17.578):{0xB58} <5>Nov 15 16:45:17 bbeserver  {0xAC8} 0176: (#30000) Component [BlackBerry Attachment Service] has been selected.  Ref count: 1
[30000] (11/15 16:45:17.578):{0xB58} <5>Nov 15 16:45:17 bbeserver  {0xAC8} 0177: (#30000) Component [BlackBerry Router] has been selected.  Ref count: 1
[30000] (11/15 16:45:17.578):{0xB58} <5>Nov 15 16:45:17 bbeserver  {0xAC8} 0178: (#30000) Component [BlackBerry MDS Connection Service] has been selected.  Ref count: 1
[30000] (11/15 16:45:17.578):{0xB58} <5>Nov 15 16:45:17 bbeserver  {0xAC8} 0179: (#30000) [PIPTOOL]: Setup determined that this is an upgrade.  Setting the ConfigDbExists flag by default.
[30000] (11/15 16:45:17.984):{0xB58} <5>Nov 15 16:45:17 bbeserver  {0xAC8} 0180: (#30000) CBESDBInstaller::CBESDBInstaller - working directory is [C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1]
[30000] (11/15 16:45:18.593):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0181: (#30000) ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:18.593):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0182: (#30000) ADO ConnectionTimeout for re-initalizing the pool = 45s
[30000] (11/15 16:45:18.593):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0183: (#30000) ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:18.593):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0184: (#30000) ADO ConnectionTimeout for re-initalizing the pool = 45s
[30000] (11/15 16:45:18.796):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0185: (#30000) ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:18.796):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0186: (#30000) ADO ConnectionTimeout for re-initalizing the pool = 45s
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0187: (#30000) ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0188: (#30000) ADO ConnectionTimeout for re-initalizing the pool = 45s
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0189: (#30000) IsDbCurrent - Version from Database: 4.1.2
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0190: (#30000) Scripts loading from: D:\BES 5 SP2\Database\DBInstallScripts\SqlServer\
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0191: (#30000) IsDbCurrent - No.  DBVersion is [4.1.2], script version is [5.0]
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0192: (#30000) [Infostore::isDBCurrent]: IsDbCurrent returned 0, IsDbCurrent flag = 0.
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0193: (#30000) [PIPTOOL]: Found the correct GUID in the database.
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0194: (#30000) [PIPTOOL]: Succeeded to check/update the GUID.
[30000] (11/15 16:45:19.000):{0xB58} <4>Nov 15 16:45:18 bbeserver  {0xAC8} 0195: (#25110) ODBCRecord:Smiley Very HappyoGetFirstValue: No table found
[30000] (11/15 16:45:19.000):{0xB58} <4>Nov 15 16:45:18 bbeserver  {0xAC8} 0196: (#25000) ODBCRecord:Smiley Very HappyoGetFirstValue: COM Error 0x80040E37 - IDispatch error #3127 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Microsoft OLE DB Provider for SQL Server" - Command "ODBCRecord:Smiley Very HappyoGetFirstValue"
[30000] (11/15 16:45:19.000):{0xB58} <4>Nov 15 16:45:18 bbeserver  {0xAC8} 0197: (#20000) [ODBCRecord:Smiley Very HappyoGetFirstValue] SQL = "SELECT State FROM ServerInstanceV WHERE MachineName = ?".
[30000] (11/15 16:45:19.000):{0xB58} <4>Nov 15 16:45:18 bbeserver  {0xAC8} 0198: (#20000) [ODBCRecord:Smiley Very HappyoGetFirstValue] DATA = "MachineName[BBESERVER] ".
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0199: (#30000) [PIPTOOL]: Cannot detect Standby Mode from the database due to no match record found in ServerInstanceV. Set to active mode before comparing the machine names in ServerConfig table.
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0200: (#30000) [PIPTOOL]: Set StandBy to false.
[30000] (11/15 16:45:19.000):{0xB58} <4>Nov 15 16:45:18 bbeserver  {0xAC8} 0201: (#25110) ODBCRecord:Smiley Very HappyoGetFirstValue: No table found
[30000] (11/15 16:45:19.000):{0xB58} <4>Nov 15 16:45:18 bbeserver  {0xAC8} 0202: (#25000) ODBCRecord:Smiley Very HappyoGetFirstValue: COM Error 0x80040E37 - IDispatch error #3127 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Microsoft OLE DB Provider for SQL Server" - Command "ODBCRecord:Smiley Very HappyoGetFirstValue"
[30000] (11/15 16:45:19.000):{0xB58} <4>Nov 15 16:45:18 bbeserver  {0xAC8} 0203: (#20000) [ODBCRecord:Smiley Very HappyoGetFirstValue] SQL = "SELECT DisplayName FROM ServerInstanceV WHERE MachineName = ?".
[30000] (11/15 16:45:19.000):{0xB58} <4>Nov 15 16:45:18 bbeserver  {0xAC8} 0204: (#20000) [ODBCRecord:Smiley Very HappyoGetFirstValue] DATA = "MachineName[BBESERVER] ".
[30000] (11/15 16:45:19.000):{0xB58} <3>Nov 15 16:45:18 bbeserver  {0xAC8} 0205: (#10000) [PIPTOOL]: Could not get the BES Display Name from the database.
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0206: (#30000) [PIPTOOL]: Cannot detect Standby Mode by comparing database to current BES Name []. Set to active mode.
[30000] (11/15 16:45:19.000):{0xB58} <6>Nov 15 16:45:18 bbeserver  {0xAC8} 0207: (#40000) [PIPTOOL]: Set Component BlackBerry Manager to Disabled.
[30000] (11/15 16:45:19.000):{0xB58} <3>Nov 15 16:45:18 bbeserver  {0xAC8} 0208: (#10000) File [C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe] not exists
[30000] (11/15 16:45:19.000):{0xB58} <4>Nov 15 16:45:18 bbeserver  {0xAC8} 0209: (#20000) Cannot read value [DefaultCollationName] registry [Software\Microsoft\MSSQLSERVER\MSSQLServer]
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0210: (#30000) [PIPTOOL]: GetSQLServerVersion: Found a local SQL server. Edition [], Version [8.00.761]. Instance Name [MSSQLSERVER].
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0211: (#30000) [PIPTOOL]: GetSQLServerVersion: Found the currently used default local instance [MSSQLSERVER].
[30000] (11/15 16:45:19.000):{0xB58} <3>Nov 15 16:45:18 bbeserver  {0xAC8} 0212: (#10000) [PIPTOOL]: xml version : [Msxml2.DOMDocument.6.0].
[30000] (11/15 16:45:19.000):{0xB58} <3>Nov 15 16:45:18 bbeserver  {0xAC8} 0213: (#10000) [PIPTOOL]: XML Path : [C:\WINDOWS\system32\msxml6.dll].
[30000] (11/15 16:45:19.000):{0xB58} <3>Nov 15 16:45:18 bbeserver  {0xAC8} 0214: (#10000) [PIPTOOL]: XML Version : [6.10.1129.0].
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0215: (#30000) BNISb Sequence is: [V1 StepSeq: [LicenseSmiley Tonguerogress|] StepCurr: [LicenseSmiley Tonguerogress]]
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0216: (#30000) BSTS Sequence is: [V1 StepSeq: [LicenseSmiley Tonguerogress|DBInfo:NoState|DBAdvInfo:NoState|WhichDlg:NoState|] StepCurr: [LicenseSmiley Tonguerogress]]
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0217: (#30000) PIPToolDialogStepSequence adds step [LicenseSmiley Tonguerogress] to end of sequence
[30000] (11/15 16:45:19.000):{0xB58} <5>Nov 15 16:45:18 bbeserver  {0xAC8} 0218: (#30000) BNISb Sequence is: [V2 StepSeq: [LicenseSmiley Tonguerogress|] StepCurr: [LicenseSmiley Tonguerogress]]
[30000] (11/15 16:45:19.812):{0xB58} <5>Nov 15 16:45:19 bbeserver  {0xAC8} 0219: (#30000) ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:19.812):{0xB58} <5>Nov 15 16:45:19 bbeserver  {0xAC8} 0220: (#30000) ADO ConnectionTimeout for re-initalizing the pool = 45s
[30000] (11/15 16:45:19.812):{0xB58} <5>Nov 15 16:45:19 bbeserver  {0xAC8} 0221: (#30000) [PIPTOOL]: Main dialog attempting to initialize CALKeySettings container

 

few more lines from logs;

 

[30000] (11/15 16:45:47.140):{0xC70} CBESDBInstaller::CBESDBInstaller - working directory is [D:\Program Files\Installer]
[30000] (11/15 16:45:47.703):{0xC70} Setting time zone offset in DB to:  5
[30000] (11/15 16:45:48.125):{0xC70} ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:48.125):{0xC70} ADO ConnectionTimeout for re-initalizing the pool = 45s
[45059] (11/15 16:45:48.125):{0xC70} {ConnectionPool:Smiley TongueostConnectWork()}: Using connection pool with limit of 2 connections
[30000] (11/15 16:45:48.125):{0xC70} [ENV] [DB] Connection String = Server=bbeserver,1433;Database=master;Network=dbmssocn;Trusted_Connection=Yes
[30000] (11/15 16:45:48.125):{0xC70} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.0760;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.3959
[30000] (11/15 16:45:48.265):{0xC70} ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:48.265):{0xC70} ADO ConnectionTimeout for re-initalizing the pool = 45s
[45059] (11/15 16:45:48.265):{0xC70} {ConnectionPool:Smiley TongueostConnectWork()}: Using connection pool with limit of 2 connections
[30000] (11/15 16:45:48.265):{0xC70} [ENV] [DB] Connection String = Server=bbeserver,1433;Database=master;Network=dbmssocn;Trusted_Connection=Yes
[30000] (11/15 16:45:48.265):{0xC70} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.0760;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.3959
[30000] (11/15 16:45:49.250):{0xC70} CBESDBInstaller::CBESDBInstaller - working directory is [D:\Program Files\Installer]
[30000] (11/15 16:45:50.093):{0xC70} ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:50.093):{0xC70} ADO ConnectionTimeout for re-initalizing the pool = 45s
[45059] (11/15 16:45:50.093):{0xC70} {ConnectionPool:Smiley TongueostConnectWork()}: Using connection pool with limit of 2 connections
[30000] (11/15 16:45:50.093):{0xC70} [ENV] [DB] Connection String = Server=bbeserver,1433;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
[30000] (11/15 16:45:50.093):{0xC70} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.0760;  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] (11/15 16:45:50.093):{0xC70} [ENV] [DB] Database Schema Version:  4.1.6 <4.1.2.2008.05.07>
[30000] (11/15 16:45:50.093):{0xC70} ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:50.093):{0xC70} ADO ConnectionTimeout for re-initalizing the pool = 45s
[30000] (11/15 16:45:50.796):{0xC70} ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:50.796):{0xC70} ADO ConnectionTimeout for re-initalizing the pool = 45s
[45059] (11/15 16:45:50.796):{0xC70} {ConnectionPool:Smiley TongueostConnectWork()}: Using connection pool with limit of 2 connections
[30000] (11/15 16:45:50.796):{0xC70} [ENV] [DB] Connection String = Server=bbeserver,1433;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
[30000] (11/15 16:45:50.796):{0xC70} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.0760;  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] (11/15 16:45:50.796):{0xC70} [ENV] [DB] Database Schema Version:  4.1.6 <4.1.2.2008.05.07>
[30000] (11/15 16:45:50.890):{0xB58} <5>Nov 15 16:45:50 bbeserver  {0xC70} 0311: (#30000) Error reading BASTrait IS_SMALL_BUSINESS_SERVER_TRAIT.
[30000] (11/15 16:45:50.937):{0xC70} ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:50.937):{0xC70} ADO ConnectionTimeout for re-initalizing the pool = 45s
[45059] (11/15 16:45:50.937):{0xC70} {ConnectionPool:Smiley TongueostConnectWork()}: Using connection pool with limit of 2 connections
[30000] (11/15 16:45:50.937):{0xC70} [ENV] [DB] Connection String = Server=bbeserver,1433;Database=master;Network=dbmssocn;Trusted_Connection=Yes
[30000] (11/15 16:45:50.937):{0xC70} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.0760;  Provider Name = sqloledb.dll;  Provider Friendly Name = Microsoft OLE DB Provider for SQL Server;  OLE DB Version = 02.70;  Provider Version = 08.10.3959
[30000] (11/15 16:45:51.078):{0xC70} ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:51.078):{0xC70} ADO ConnectionTimeout for re-initalizing the pool = 45s
[45059] (11/15 16:45:51.078):{0xC70} {ConnectionPool:Smiley TongueostConnectWork()}: Using connection pool with limit of 2 connections
[30000] (11/15 16:45:51.078):{0xC70} [ENV] [DB] Connection String = Server=bbeserver,1433;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
[30000] (11/15 16:45:51.078):{0xC70} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.0760;  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] (11/15 16:45:51.078):{0xC70} [ENV] [DB] Database Schema Version:  4.1.6 <4.1.2.2008.05.07>
[30000] (11/15 16:45:51.218):{0xC70} ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:51.218):{0xC70} ADO ConnectionTimeout for re-initalizing the pool = 45s
[45059] (11/15 16:45:51.218):{0xC70} {ConnectionPool:Smiley TongueostConnectWork()}: Using connection pool with limit of 2 connections
[30000] (11/15 16:45:51.218):{0xC70} [ENV] [DB] Connection String = Server=bbeserver,1433;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
[30000] (11/15 16:45:51.234):{0xC70} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.0760;  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] (11/15 16:45:51.234):{0xC70} [ENV] [DB] Database Schema Version:  4.1.6 <4.1.2.2008.05.07>
[30000] (11/15 16:45:51.234):{0xC70} ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:51.234):{0xC70} ADO ConnectionTimeout for re-initalizing the pool = 45s
[30000] (11/15 16:45:51.234):{0xC70} [PIPTOOL]: SELECT MailStoreType Notes, FROM table ServerConfig. DoGetValue = 1, bExists = 1.
[30000] (11/15 16:45:51.375):{0xC70} ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:51.375):{0xC70} ADO ConnectionTimeout for re-initalizing the pool = 45s
[45059] (11/15 16:45:51.375):{0xC70} {ConnectionPool:Smiley TongueostConnectWork()}: Using connection pool with limit of 2 connections
[30000] (11/15 16:45:51.375):{0xC70} [ENV] [DB] Connection String = Server=bbeserver,1433;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
[30000] (11/15 16:45:51.375):{0xC70} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.0760;  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] (11/15 16:45:51.375):{0xC70} [ENV] [DB] Database Schema Version:  4.1.6 <4.1.2.2008.05.07>
[30000] (11/15 16:45:51.515):{0xC70} ADO ConnectionTimeout value = 30s
[30000] (11/15 16:45:51.515):{0xC70} ADO ConnectionTimeout for re-initalizing the pool = 45s
[45059] (11/15 16:45:51.515):{0xC70} {ConnectionPool:Smiley TongueostConnectWork()}: Using connection pool with limit of 2 connections
[30000] (11/15 16:45:51.515):{0xC70} [ENV] [DB] Connection String = Server=bbeserver,1433;Database=BESMgmt;Network=dbmssocn;Trusted_Connection=Yes
[30000] (11/15 16:45:51.515):{0xC70} [ENV] [DB] DBMS Name = Microsoft SQL Server;  DBMS Version = 08.00.0760;  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] (11/15 16:45:51.515):{0xC70} [ENV] [DB] Database Schema Version:  4.1.6 <4.1.2.2008.05.07>
[30000] (11/15 16:45:51.515):{0xC70} IsDbCurrent - Version from Database: 4.1.2
[30000] (11/15 16:45:51.515):{0xC70} Scripts loading from: D:\BES 5 SP2\Database\DBInstallScripts\SqlServer\
[30000] (11/15 16:45:51.515):{0xC70} IsDbCurrent - No.  DBVersion is [4.1.2], script version is [5.0]
[30000] (11/15 16:45:51.515):{0xC70} IsDbCurrent returned 0, IsDbCurrent flag = 0

 

A few more lines::


[30000] (11/15 16:46:19.937):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_UserComponentAffinity_User' AND type = 'F')
    AND EXISTS (SELECT * FROM sysobjects WHERE name = 'UserComponentAffinity' AND type = 'U')
        ALTER TABLE UserComponentAffinity ADD CONSTRAINT FK_UserComponentAffinity_User FOREIGN KEY (UserConfigId)
            REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.937):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.937):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_UserComponentMap_UserConfig' AND type = 'F')
    AND EXISTS (SELECT * FROM sysobjects WHERE name = 'UserComponentMap' AND type = 'U')
        ALTER TABLE UserComponentMap ADD CONSTRAINT FK_UserComponentMap_UserConfig FOREIGN KEY (UserConfigId)
            REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.953):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.953):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_UserITPolicy_UserConfig' AND type = 'F')
    AND EXISTS (SELECT * FROM sysobjects WHERE name = 'UserITPolicy' AND type = 'U')
        ALTER TABLE UserITPolicy ADD CONSTRAINT FK_UserITPolicy_UserConfig FOREIGN KEY (UserConfigId)
            REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.953):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.953):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_UserStats_UserConfig' AND type = 'F')
    ALTER TABLE UserStats ADD CONSTRAINT FK_UserStats_UserConfig FOREIGN KEY (UserConfigId)
        REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.953):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.953):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_WLANUserConfigSets_UserConfig' AND type = 'F')
    AND EXISTS (SELECT * FROM sysobjects WHERE name = 'WLANUserConfigSets' AND type = 'U')
        ALTER TABLE WLANUserConfigSets ADD CONSTRAINT FK_WLANUserConfigSets_UserConfig FOREIGN KEY (UserConfigId)
            REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.953):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.953):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_WorkQueue_UserConfig' AND type = 'F')
    ALTER TABLE WorkQueue ADD CONSTRAINT FK_WorkQueue_UserConfig FOREIGN KEY (UserConfigId)
        REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.953):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.953):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_MbMailReconcile_UserConfig' AND type = 'F')
    AND EXISTS (SELECT * FROM sysobjects WHERE name = 'MbMailReconcile' AND type = 'U')
        ALTER TABLE MbMailReconcile ADD CONSTRAINT FK_MbMailReconcile_UserConfig FOREIGN KEY (UserConfigId)
                 REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.953):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.953):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_MbAddressLookup_UserConfigId' AND type = 'F')
    AND EXISTS (SELECT * FROM syscolumns WHERE object_name(id) = 'MbAddressLookup' AND name = 'UserConfigId')
        ALTER TABLE MbAddressLookup ADD CONSTRAINT FK_MbAddressLookup_UserConfigId FOREIGN KEY (UserConfigId)
                 REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.968):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.968):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_MbCalReconcile_UserConfig' AND type = 'F')
    AND EXISTS (SELECT * FROM sysobjects WHERE name = 'MbCalReconcile' AND type = 'U')
        ALTER TABLE MbCalReconcile ADD CONSTRAINT FK_MbCalReconcile_UserConfig FOREIGN KEY (UserConfigId)
                 REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.968):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.968):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_SyncFolderUserList_UserConfig' AND type = 'F')
    AND EXISTS (SELECT * FROM sysobjects WHERE name = 'SyncFolderUserList' AND type = 'U')
        ALTER TABLE SyncFolderUserList ADD CONSTRAINT FK_SyncFolderUserList_UserConfig FOREIGN KEY (UserConfigId)
                 REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.968):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.968):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_SIPUser_UserConfig' AND type = 'F')
    AND EXISTS (SELECT * FROM sysobjects WHERE name = 'SIPUser' AND type = 'U')
        ALTER TABLE SIPUser ADD CONSTRAINT FK_SIPUser_UserConfig FOREIGN KEY (UserConfigId)
                 REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.968):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.968):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_BBASEnterpriseActivationStatus_UserConfig' AND type = 'F')
    AND EXISTS (SELECT * FROM sysobjects WHERE name = 'BASEnterpriseActivationStatus' AND type = 'U')
        ALTER TABLE BASEnterpriseActivationStatus ADD CONSTRAINT FK_BBASEnterpriseActivationStatus_UserConfig FOREIGN KEY (UserConfigId)
                 REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.968):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.968):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_SyncPersDistList_UserConfig' AND type = 'F')
    AND EXISTS (SELECT * FROM sysobjects WHERE name = 'SyncPersDistList' AND type = 'U')
        ALTER TABLE SyncPersDistList ADD CONSTRAINT FK_SyncPersDistList_UserConfig FOREIGN KEY (UserConfigId)
                 REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.984):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.984):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_UserSync_UserConfig' AND type = 'F')
    AND EXISTS (SELECT * FROM sysobjects WHERE name = 'UserSync' AND type = 'U')
        ALTER TABLE UserSync ADD CONSTRAINT FK_UserSync_UserConfig FOREIGN KEY (UserConfigId)
                 REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.984):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.984):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE name = 'ITPolicyKeyMapping' AND type = 'U')
BEGIN
    DELETE
        FROM ITPolicyKeyMapping
        WHERE UserConfigId NOT IN (SELECT Id FROM UserConfig)
END
[30000] (11/15 16:46:19.984):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.984):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'FK_ITPolicyKeyMapping_UserConfig' AND type = 'F')
    AND EXISTS (SELECT * FROM sysobjects WHERE name = 'ITPolicyKeyMapping' AND type = 'U')
        ALTER TABLE ITPolicyKeyMapping ADD CONSTRAINT FK_ITPolicyKeyMapping_UserConfig FOREIGN KEY (UserConfigId)
                 REFERENCES UserConfig(Id) ON DELETE CASCADE ON UPDATE CASCADE
[30000] (11/15 16:46:19.984):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.984):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE name = 'TempPreventDeleteUserConfigTrigger' AND type = 'TR')
    AND EXISTS (SELECT * FROM sysindexes WHERE name = 'PK_UserConfig' AND INDID = 1)
        DROP TRIGGER dbo.TempPreventDeleteUserConfigTrigger
[30000] (11/15 16:46:19.984):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.984):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE name = 'vHandheldInfo' AND type = 'V')
    DROP VIEW dbo.vHandheldInfo
[30000] (11/15 16:46:19.984):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.984):{0x9A0} SQL being executed:
 
CREATE VIEW dbo.vHandheldInfo AS
    SELECT s.Id, u.Id AS UserConfigId, u.ServerConfigId, u.MailboxDN, u.DisplayName, u.PIN,
           s.TableId, s.RecordTimeStamp,  s.Data, s.ServerTime, 1 AS Active
    FROM UserConfig u JOIN SyncDeviceMgmt s ON s.UserConfigID = u.Id
[30000] (11/15 16:46:19.984):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.984):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysindexes WHERE name = 'IX_SyncExchangeState_UserTypFold')
    CREATE INDEX IX_SyncExchangeState_UserTypFold
        ON SyncExchangeState (UserConfigId, Type, Folder)
[30000] (11/15 16:46:19.984):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:19.984):{0x9A0} SQL being executed:
 
IF NOT EXISTS (SELECT * FROM sysindexes WHERE name = 'IX_ITAdminQueue_UserConfigId_Status')
    CREATE INDEX IX_ITAdminQueue_UserConfigId_Status
        ON ITAdminQueue (UserConfigId, Status)
[30000] (11/15 16:46:20.000):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.000):{0x9A0} SQL being executed:
 

IF EXISTS (SELECT name FROM sysobjects WHERE name = 'BASTraitsHistory' AND type = 'P')
    DROP PROCEDURE dbo.BASTraitsHistory
[30000] (11/15 16:46:20.000):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.000):{0x9A0} SQL being executed:
 CREATE PROCEDURE dbo.BASTraitsHistory
     @Operation         CHAR(1)
    ,@TraitKey          INT
    ,@Lurnum            BINARY(8)
    ,@TraitId           INT
    ,@PlugInId          INT
    ,@PrimaryObjectId   INT
    ,@SecondaryObjectId INT
AS
BEGIN
SET NOCOUNT ON

DECLARE @BAS                                    INT,
        @EXCHANGE                               INT,
        @DOMINO                                 INT,
        @GROUPWISE                              INT,
        @DISPATCHER                             INT,
        @POLICY                                 INT,
        @HA_STATE                               INT,
        @SMART_SYNC                             INT,
        @POLICY_SRP_WHITELIST                   INT,
        @DISPATCHER_TRAITS                      INT,
        @DOCUMENT_THROTTLE_MAX_DOC_OPEN_TRAIT   INT,
        @err                                    INT
       
SET @BAS            = 0
SET @DISPATCHER     = 1
SET
[30000] (11/15 16:46:20.000):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.000):{0x9A0} SQL being executed:
 
ALTER TRIGGER dbo.HistoryBASTraitsTrigger ON BASTraits
FOR INSERT, UPDATE
NOT FOR REPLICATION
AS

SET NOCOUNT ON

DECLARE  @Operation         CHAR(1)
        ,@TraitKey          INT
        ,@Lurnum            BINARY(8)
        ,@TraitId           INT
        ,@PlugInId          INT
        ,@PrimaryObjectId   INT
        ,@SecondaryObjectId INT       
        ,@err               INT
       
IF EXISTS (SELECT * FROM deleted)
BEGIN
    SET @Operation = 'U'
END
ELSE
BEGIN
    SET @Operation = 'I'
END
        

DECLARE CursorBASTraitsHistory CURSOR LOCAL FORWARD_ONLY READ_ONLY FOR
    SELECT TraitKey, Lurnum, TraitId, PlugInId, PrimaryObjectId, SecondaryObjectId
        FROM inserted
OPEN CursorBASTraitsHistory
FETCH NEXT FROM CursorBASTraitsHistory INTO
    @TraitKey, @Lurnum, @TraitId, @PlugInId, @PrimaryObjectId, @SecondaryObjectId
   
WHILE @@fetch_status = 0
BEGIN  
    EXEC @err =  BASTraitsHistory @Operation, @TraitKey, @Lurnum, @TraitId, @
[30000] (11/15 16:46:20.000):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.000):{0x9A0} SQL being executed:
 
ALTER TRIGGER dbo.HistoryDeleteBASTraitsTrigger ON BASTraits
FOR DELETE
NOT FOR REPLICATION
AS

SET NOCOUNT ON

DECLARE  @Operation         CHAR(1)
        ,@TraitKey          INT
        ,@Lurnum            BINARY(8)
        ,@TraitId           INT
        ,@PlugInId          INT
        ,@PrimaryObjectId   INT
        ,@SecondaryObjectId INT
        ,@err               INT

SET @Operation = 'D'
 
DECLARE CursorBASTraitsHistoryDel CURSOR LOCAL FORWARD_ONLY READ_ONLY FOR
    SELECT TraitKey, Lurnum, TraitId, PlugInId, PrimaryObjectId, SecondaryObjectId
        FROM deleted
OPEN CursorBASTraitsHistoryDel
FETCH NEXT FROM CursorBASTraitsHistoryDel INTO
    @TraitKey, @Lurnum, @TraitId, @PlugInId, @PrimaryObjectId, @SecondaryObjectId
   
WHILE @@fetch_status = 0
BEGIN  
    EXEC @err = BASTraitsHistory @Operation, @TraitKey, @Lurnum, @TraitId, @PlugInId, @PrimaryObjectId, @SecondaryObjectId

    IF @err <> 0
    BEGIN
        ROLLBACK
    END   
 
[30000] (11/15 16:46:20.000):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.000):{0x9A0} SQL being executed:
 IF EXISTS(SELECT * FROM sysobjects WHERE NAME = 'GetHostName' AND XTYPE = 'P')
  BEGIN
      DROP PROC dbo.GetHostName
  END
[30000] (11/15 16:46:20.000):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.000):{0x9A0} SQL being executed:
 -- get host name of machine where located MSSQL server
CREATE PROCEDURE dbo.GetHostName
AS
  BEGIN
SET NOCOUNT ON

DECLARE @hostname sysname, @name sysname, @domain sysname
 SET @hostname='SYSTEM\\ControlSet001\\Services\\Tcpip\\Parameters'
 CREATE TABLE #tChkKey (KeyExist int)
 INSERT INTO #tChkKey EXEC master..xp_regread 'HKEY_LOCAL_MACHINE', @hostname
 IF EXISTS(SELECT * FROM #tChkKey WHERE KeyExist = 1)
 BEGIN
 EXEC master..xp_regread 'HKEY_LOCAL_MACHINE' ,@hostname, 'hostname', @name OUTPUT
 EXEC master..xp_regread 'HKEY_LOCAL_MACHINE' ,@hostname, 'domain', @domain OUTPUT
END
EXEC master..xp_getnetname @hostname OUTPUT
SELECT @name+N'.'+@domain AS [HOSTNAME],
       CAST(serverproperty('machinename') AS sysname) AS [MACHINENAME], @hostname AS [COMPUTERNAME]
END
[30000] (11/15 16:46:20.000):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.000):{0x9A0} SQL being executed:
 IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'GetAgentUserListWithMaxHistId' AND type = 'P')
    DROP PROCEDURE dbo.GetAgentUserListWithMaxHistId
[30000] (11/15 16:46:20.000):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.000):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.GetAgentUserListWithMaxHistId @LastHistoryId bigint, @ServerConfigId int, @AgentId int, @MaxHistoryId bigint output
AS
SET NOCOUNT ON
BEGIN
    SET @MaxHistoryId = IDENT_CURRENT('ServerConfigHistory')

    CREATE TABLE #UserIdList ( UserConfigId int not null PRIMARY KEY )
    -- make the id's list of last User changes
    INSERT INTO #UserIdList
        SELECT DISTINCT UserConfigId
            FROM ServerConfigHistory WITH (NOLOCK)
            WHERE Id > @LastHistoryId AND Id <= @MaxHistoryId AND ObjectDefnId = 200
                AND Operation = 'U' AND ServerConfigId = @ServerConfigId

     SELECT  DisplayName, MailboxDN, ServerDN,   DeviceType, PIN, RedirectionState, ExtServicesState,   CalendarEnableState, 
          OTAFMUserConfig, OTAFMConflictResolution,  OTAFMState, OverrideSMTPAddr, OTAPIMState,   lurnum, MailboxSMTPAddr, ServerConfigId,
          PendingServerConfigId,   PendingKey, CurrentKey, PreviousKey, Creatio
[30000] (11/15 16:46:20.000):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.000):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryGetMaxId' AND type = 'P')
    DROP PROCEDURE dbo.HistoryGetMaxId
[30000] (11/15 16:46:20.000):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.000):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryGetMaxId
AS
    SET NOCOUNT ON
    SELECT IDENT_CURRENT('ServerConfigHistory')
[30000] (11/15 16:46:20.000):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.000):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollDisp' AND type = 'P')
    DROP PROCEDURE dbo.HistoryPollDisp
[30000] (11/15 16:46:20.015):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.015):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollDisp
    @LastMaxId  BIGINT
AS
    SET NOCOUNT ON
   
    SELECT Id, ObjectDefnId, ServerConfigId, Operation, Details
        FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId
            AND ObjectDefnId IN ( 100   --ServerConfig
                                 ,175   --GlobalSettings           
                                 ,200   --UserConfig
                                 ,1300  --EnterpriseServicePolicy
                                 ,2020  --HealthScoreMap
                                 ,3010  --BASServiceInstanceData                                
                                 ,3100  --DispatcherInstance
                                 ,4010  --HAMapping                                
                                 ,4040  --DispatcherTraits
                                )
        ORDER BY Id
[30000] (11/15 16:46:20.015):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.015):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollAgentX' AND type = 'P')
    DROP PROCEDURE dbo.HistoryPollAgentX
[30000] (11/15 16:46:20.015):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.015):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollAgentX
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
    SET NOCOUNT ON
       
    SELECT Id, ObjectDefnId, ConfigId, ServerConfigId, Operation, Details, UserConfigId
        FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId AND Id <= @CurrMaxId
            AND (
                    -- Events specific to this BES
                    (
                      ServerConfigId = @ServerConfigId
                          AND ObjectDefnId IN ( 100     --ServerConfig
                                               ,170     --ServerCapabilities
                                               ,185     --ServerBBRMap
                                               ,210     --UserStats
                                              )
                    )
                    -- Global Events
                    OR ObjectDefnId IN ( 175            --GlobalSettings
    
[30000] (11/15 16:46:20.015):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.015):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollDeviceMgmt' AND type = 'P')
    DROP PROCEDURE dbo.HistoryPollDeviceMgmt
[30000] (11/15 16:46:20.015):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.015):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollDeviceMgmt
    @LastMaxId  BIGINT
AS
    SET NOCOUNT ON

    SELECT Id, UserConfigId, ObjectDefnId, ConfigId, Operation, Details
        FROM ServerConfigHistory  WITH (NOLOCK)
        WHERE Id > @LastMaxId
            AND ObjectDefnId IN ( 326   --SyncDeviceConfigData
                                 ,327   --SyncDeviceConfig
                                )
        ORDER BY Id
[30000] (11/15 16:46:20.015):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.015):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollSync' AND type = 'P')
    DROP PROCEDURE dbo.HistoryPollSync
[30000] (11/15 16:46:20.015):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.015):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollSync
    @LastMaxId      BIGINT,
    @ServerConfigId INT
AS
    SET NOCOUNT ON

    SELECT Id, ServerConfigId, UserConfigId, ObjectDefnId, ConfigId, Operation, Details
        FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId
            AND (
                   -- Server Level events
                   (
                      ServerConfigId = @ServerConfigId
                        AND (
                               (ObjectDefnId = 200 -- UserConfig
                                  AND (Operation IN ('I', 'D')
                                       OR (Operation = 'U'
                                              AND (Details LIKE 'OTAPIMState%' OR Details LIKE 'PIN%')
                                          )
                                      )
                               )
                               OR  ObjectDefnId = 300 -- SyncConfig
                               OR (ObjectD
[30000] (11/15 16:46:20.015):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.015):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollAgentD' AND type = 'P')
    DROP PROCEDURE dbo.HistoryPollAgentD
[30000] (11/15 16:46:20.015):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.015):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollAgentD
     @LastMaxId         BIGINT
    ,@ServerConfigId    INT
AS
    SET NOCOUNT ON
       
    SELECT Id, ObjectDefnId, ConfigId, ServerConfigId, UserConfigId, Operation, Details
        FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId
            AND (
                    -- Events specific to this BES
                    (
                      ServerConfigId = @ServerConfigId
                          AND ObjectDefnId IN ( 100     --ServerConfig
                                               ,160     --ServerStats
                                               ,170     --ServerCapabilities
                                               ,185     --ServerBBRMap
                                               ,210     --UserStats
                                               ,1100    --NotesConfig
                                              )
                    )
                    -- Gl
[30000] (11/15 16:46:20.015):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.015):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolServiceBookServer' AND type = 'P')   
DROP PROCEDURE dbo.HistoryPollPolServiceBookServer
[30000] (11/15 16:46:20.015):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.015):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolServiceBookServer
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
SET NOCOUNT ON

IF EXISTS  (SELECT *
                FROM ServerConfigHistory WITH (NOLOCK)
                WHERE Id > @LastMaxId AND Id <= @CurrMaxId
                    AND ServerConfigId = @ServerConfigId
                    AND (     ObjectDefnId = 185  --ServerBBRMap
                          OR (ObjectDefnId = 100  --ServerConfig
                                AND Operation = 'U'
                                    AND (Details LIKE '%SRPId%' OR
                                         Details LIKE '%MailStoreType%'
                                        )
                             )
                        )
            )
BEGIN
    SELECT Id, PIN, DeviceType, MailboxSMTPAddr, HandheldConfigId, ITPolicy2Id, DeviceCapabilities
        FROM Userconfig
        WHERE ServerConfigId = @ServerConfi
[30000] (11/15 16:46:20.031):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.031):{0x9A0} SQL being executed:
 

IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolServiceBookUser' AND type = 'P')   
DROP PROCEDURE dbo.HistoryPollPolServiceBookUser
[30000] (11/15 16:46:20.031):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.031):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolServiceBookUser
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
SET NOCOUNT ON

DECLARE @UserIdList TABLE ( UserConfigId INT NOT NULL PRIMARY KEY )

    INSERT INTO @UserIdList
        SELECT DISTINCT UserConfigId
            FROM ServerConfigHistory WITH (NOLOCK)
            WHERE Id > @LastMaxId AND Id <= @CurrMaxId
                AND ObjectDefnId = 200  --UserConfig
                AND ServerConfigId = @ServerConfigId
                AND (    Operation = 'I'
                     OR (Operation = 'U'
                            AND (Details LIKE '%CurrentKey%'          OR
                                 Details LIKE '%PIN%'                 OR
                                 Details LIKE '%ServiceBookName%'     OR
                                 Details LIKE '%DataSourceId%'        OR
                                 Details LIKE '%CalendarEnableState%' OR
       
[30000] (11/15 16:46:20.031):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.031):{0x9A0} SQL being executed:
 

IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolPeerToPeerUser' AND type = 'P')   
DROP PROCEDURE dbo.HistoryPollPolPeerToPeerUser
[30000] (11/15 16:46:20.031):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.031):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolPeerToPeerUser
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
SET NOCOUNT ON

DECLARE @UserIdList TABLE ( UserConfigId INT NOT NULL PRIMARY KEY )

    INSERT INTO @UserIdList
        SELECT DISTINCT UserConfigId
            FROM ServerConfigHistory WITH (NOLOCK)
            WHERE Id > @LastMaxId AND Id <= @CurrMaxId
                AND ObjectDefnId = 200  --UserConfig
                AND ServerConfigId = @ServerConfigId
                AND (    Operation = 'I'
                     OR (Operation = 'U'
                            AND (Details LIKE '%PIN%' OR
                                 Details LIKE '%CurrentKey%'
                                )
                        )
                    )
            ORDER BY UserConfigId

    IF @@rowcount > 0
    BEGIN
        SELECT Id, PIN, DeviceType, MailboxSMTPAddr, HandheldConfigId, ITPolicy2Id, DeviceCapabilities
  
[30000] (11/15 16:46:20.031):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.031):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolPeerToPeerGlobal' AND type = 'P')   
DROP PROCEDURE dbo.HistoryPollPolPeerToPeerGlobal
[30000] (11/15 16:46:20.031):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.031):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolPeerToPeerGlobal
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
SET NOCOUNT ON

IF EXISTS  (SELECT *
                FROM ServerConfigHistory WITH (NOLOCK)
                WHERE Id > @LastMaxId AND Id <= @CurrMaxId
                    AND ObjectDefnId = 175  --GlobalSettings
                    AND Operation = 'U'
                    AND Details LIKE '%PeerToPeerKeyData%')
BEGIN
    SELECT Id, PIN, DeviceType, MailboxSMTPAddr, HandheldConfigId, ITPolicy2Id, DeviceCapabilities
        FROM Userconfig
        WHERE ServerConfigId = @ServerConfigId
END
[30000] (11/15 16:46:20.031):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.031):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolServiceBooksServerLog' AND type = 'P')
    DROP PROCEDURE dbo.HistoryPollPolServiceBooksServerLog
[30000] (11/15 16:46:20.031):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.031):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolServiceBooksServerLog
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
SET NOCOUNT ON

SELECT Id, ObjectDefnId, ConfigId, ServerConfigId,
            UserConfigId, Operation, Details, ChangeDateTime
    FROM ServerConfigHistory
    WHERE Id > @LastMaxId AND Id <= @CurrMaxId
        AND ServerConfigId = @ServerConfigId
        AND (    ObjectDefnId = 185
             OR (ObjectDefnId = 100
                    AND Operation = 'U'
                    AND (Details LIKE '%SRPId%' OR
                         Details LIKE '%MailStoreType%'
                        )
                )
            )
[30000] (11/15 16:46:20.031):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.031):{0x9A0} SQL being executed:
 

IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolServiceBooksUserLog' AND type = 'P')
    DROP PROCEDURE dbo.HistoryPollPolServiceBooksUserLog
[30000] (11/15 16:46:20.046):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.046):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolServiceBooksUserLog
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
SET NOCOUNT ON

SELECT Id, ObjectDefnId, ConfigId, ServerConfigId,
            UserConfigId, Operation, Details, ChangeDateTime
    FROM ServerConfigHistory
    WHERE Id > @LastMaxId AND Id <= @CurrMaxId
        AND ServerConfigId = @ServerConfigId
        AND ObjectDefnId = 200
        AND (    Operation = 'I'
             OR (Operation = 'U'
                    AND (Details LIKE '%CurrentKey%' OR
                         Details LIKE '%PIN%' OR
                         Details LIKE '%ServiceBookName%' OR
                         Details LIKE '%DataSourceId%' OR
                         Details LIKE '%CalendarEnableState%' OR
                         Details LIKE '%ExtServicesState%'
                        )
                )
            )   
    ORDER BY UserConfigId
[30000] (11/15 16:46:20.046):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.046):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolPeerToPeerLog' AND type = 'P')
    DROP PROCEDURE dbo.HistoryPollPolPeerToPeerLog
[30000] (11/15 16:46:20.046):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.046):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolPeerToPeerLog
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
SET NOCOUNT ON

SELECT Id, ObjectDefnId, ConfigId, ServerConfigId,
            UserConfigId, Operation, Details, ChangeDateTime
    FROM ServerConfigHistory
    WHERE Id > @LastMaxId AND Id <= @CurrMaxId
        AND ServerConfigId = @ServerConfigId
        AND (   (ObjectDefnId = 200
                    AND (  (Operation = 'U'
                               AND (Details LIKE '%PIN%' OR Details LIKE '%CurrentKey%')
                           )
                         OR Operation = 'I'
                        )
                )
             OR (ObjectDefnId = 175 AND Operation = 'U' AND Details LIKE '%PeerToPeerKeyData%')
            )
    ORDER BY UserConfigId
[30000] (11/15 16:46:20.046):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.046):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolDeletedOrMovedUsers' AND type = 'P')
    DROP PROCEDURE dbo.HistoryPollPolDeletedOrMovedUsers
[30000] (11/15 16:46:20.046):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.046):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolDeletedOrMovedUsers
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
    SET NOCOUNT ON

    SELECT DISTINCT UserConfigId FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId AND Id <= @CurrMaxId
            AND ObjectDefnId = 200  --UserConfig
            AND (   (Operation = 'D'
                    )
                 OR (Operation ='U'                           
                        AND (Details LIKE 'ServerConfigId%' OR Details LIKE '%,ServerConfigId%')  --exclude PendingServerConfigId
                        AND ServerConfigId <> @ServerConfigId
                    )
                )                
        ORDER BY UserConfigId
[30000] (11/15 16:46:20.046):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.046):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolMovedUsers' AND type = 'P')
    DROP PROCEDURE dbo.HistoryPollPolMovedUsers
[30000] (11/15 16:46:20.046):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.046):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolMovedUsers
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
    SET NOCOUNT ON

    SELECT DISTINCT UserConfigId FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId AND Id <= @CurrMaxId
            AND ServerConfigId = @ServerConfigId
            AND ObjectDefnId = 200  --UserConfig
            AND Operation ='U' AND Details LIKE '%ServerConfigId%'
        ORDER BY UserConfigId
[30000] (11/15 16:46:20.046):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.046):{0x9A0} SQL being executed:
 

IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolOTASLChanges' AND type = 'P')
    DROP PROCEDURE dbo.HistoryPollPolOTASLChanges
[30000] (11/15 16:46:20.046):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.046):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolOTASLChanges
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
    SET NOCOUNT ON

    SELECT DISTINCT ConfigId FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId AND Id <= @CurrMaxId
            AND ServerConfigId = @ServerConfigId
            AND ObjectDefnId = 1820 --DSUPRequest
            AND Operation ='I'
        ORDER BY ConfigId
[30000] (11/15 16:46:20.046):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.046):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolBESChanges' AND type = 'P')   
    DROP PROCEDURE dbo.HistoryPollPolBESChanges
[30000] (11/15 16:46:20.046):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.046):{0x9A0} SQL being executed:
 CREATE PROCEDURE dbo.HistoryPollPolBESChanges
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT   
AS
SET NOCOUNT ON

SELECT Id, ObjectDefnId, ConfigId, ServerConfigId,
            UserConfigId, Operation, Details, ChangeDateTime
    FROM ServerConfigHistory WITH (NOLOCK)
    WHERE Id > @LastMaxId AND Id <= @CurrMaxId
        AND (
                (    ObjectDefnId = 100     -- ServerConfig
                        AND (    Operation IN ('D', 'I')
                             OR (Operation = 'U' AND Details LIKE '%SRPid%')
                            )
                )
                OR (ObjectDefnId = 510      -- ITPolicy2
                        AND (    Operation = 'I'
                             OR (Operation = 'U'
                                    AND (   Details LIKE '%HandheldBlob%'
                                         OR Details LIKE '%DesktopBlob%'
                                       
[30000] (11/15 16:46:20.062):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.062):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolDisableCDITPolicyBlobChanges' AND type = 'P')   
    DROP PROCEDURE dbo.HistoryPollPolDisableCDITPolicyBlobChanges
[30000] (11/15 16:46:20.062):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.062):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolDisableCDITPolicyBlobChanges
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
SET NOCOUNT ON

DECLARE @ITPolicy2IdList TABLE ( ITPolicy2Id INT NOT NULL PRIMARY KEY )

INSERT INTO @ITPolicy2IdList
    SELECT DISTINCT ConfigId
        FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId AND Id <= @CurrMaxId
            AND ObjectDefnId = 510      --ITPolicy2               
            AND (    Operation = 'I'
                 OR (Operation = 'U'
                        AND (Details LIKE '%HandheldBlob%')
                    )
                )

IF @@rowcount > 0
BEGIN
    SELECT Id, PIN, DeviceType, MailboxSMTPAddr, HandheldConfigId, u.ITPolicy2Id, DeviceCapabilities
        FROM Userconfig u
            JOIN @ITPolicy2IdList l
                ON u.ITPolicy2Id = l.ITPolicy2Id
        WHERE ServerConfigId = @ServerConfigId
END
[30000] (11/15 16:46:20.062):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.062):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolDisableCDITPolicyUserConfigChanges' AND type = 'P')   
    DROP PROCEDURE dbo.HistoryPollPolDisableCDITPolicyUserConfigChanges
[30000] (11/15 16:46:20.062):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.062):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolDisableCDITPolicyUserConfigChanges
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
SET NOCOUNT ON

DECLARE @UserIdList TABLE ( UserConfigId INT NOT NULL PRIMARY KEY )

INSERT INTO @UserIdList
    SELECT DISTINCT UserConfigId
        FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId AND Id <= @CurrMaxId
            AND ObjectDefnId = 200  --UserConfig
            AND ServerConfigId = @ServerConfigId
            AND (    Operation = 'I'
                 OR (Operation = 'U'
                        AND (Details LIKE '%PIN%'                   OR
                             Details LIKE '%ITPolicy2Id%'           OR
                             Details LIKE '%CurrentKey%'            OR
                             Details LIKE '%HandheldConfigId%'      OR
                             Details LIKE '%DeviceCapabilities%'
                            )
      
[30000] (11/15 16:46:20.062):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.062):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolDisableCDITPolicyHHConfigChanges' AND type = 'P')   
    DROP PROCEDURE dbo.HistoryPollPolDisableCDITPolicyHHConfigChanges
[30000] (11/15 16:46:20.062):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.062):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolDisableCDITPolicyHHConfigChanges
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
SET NOCOUNT ON

DECLARE @HandheldConfigList TABLE ( HandheldConfigId INT NOT NULL PRIMARY KEY )

INSERT INTO @HandheldConfigList
    SELECT DISTINCT ConfigId
        FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId AND Id <= @CurrMaxId
            AND ObjectDefnId = 800      --HandheldConfig               
            AND (    Operation = 'I'
                 OR (Operation = 'U'
                        AND (Details LIKE '%AppControlPolicy%')
                    )
                )

IF @@rowcount > 0
BEGIN
    SELECT Id, PIN, DeviceType, MailboxSMTPAddr, u.HandheldConfigId, u.ITPolicy2Id, DeviceCapabilities
        FROM Userconfig u
            JOIN @HandheldConfigList l
                ON u.HandheldConfigId = l.HandheldConfigId
        WHERE ServerConfigId = @ServerCo
[30000] (11/15 16:46:20.062):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.062):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolDisableCDITPolicyWLANBaseChanges' AND type = 'P')   
    DROP PROCEDURE dbo.HistoryPollPolDisableCDITPolicyWLANBaseChanges
[30000] (11/15 16:46:20.062):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.062):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolDisableCDITPolicyWLANBaseChanges
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
SET NOCOUNT ON

DECLARE @WLANBaseConfigSetsList TABLE ( WLANBaseConfigSetsId INT NOT NULL PRIMARY KEY )

INSERT INTO @WLANBaseConfigSetsList
    SELECT DISTINCT ConfigId
        FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId AND Id <= @CurrMaxId
            AND ObjectDefnId = 1510      --WLANBaseConfigSets               
            AND (    Operation = 'I'
                 OR (Operation = 'U'
                        AND (Details LIKE '%DataBlob%')
                    )
                )

IF @@rowcount > 0
BEGIN
    SELECT u.Id, PIN, DeviceType, MailboxSMTPAddr, u.HandheldConfigId, u.ITPolicy2Id, DeviceCapabilities
        FROM Userconfig u
            JOIN WLANUserConfigSets ucs
                ON u.Id = ucs.UserConfigId
            JOIN @WLANBaseConfigSetsList l 
[30000] (11/15 16:46:20.062):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.062):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolDisableCDITPolicyWLANUserChanges' AND type = 'P')   
    DROP PROCEDURE dbo.HistoryPollPolDisableCDITPolicyWLANUserChanges
[30000] (11/15 16:46:20.078):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.078):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolDisableCDITPolicyWLANUserChanges
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
SET NOCOUNT ON

DECLARE @WLANUserConfigSetsList TABLE ( WLANUserConfigSetsId INT NOT NULL PRIMARY KEY )

INSERT INTO @WLANUserConfigSetsList
    SELECT DISTINCT ConfigId
        FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId AND Id <= @CurrMaxId
            AND ObjectDefnId = 1520      --WLANUserConfigSets
            AND (    Operation = 'I'
                 OR (Operation = 'U'
                        AND (Details LIKE '%UserDataBlob%' OR
                             Details LIKE '%WLANBaseConfigSetsId%'
                            )
                    )
                )

IF @@rowcount > 0
BEGIN
    SELECT u.Id, PIN, DeviceType, MailboxSMTPAddr, u.HandheldConfigId, u.ITPolicy2Id, DeviceCapabilities
        FROM Userconfig u
            JOIN WLANUserConfigSets ucs

[30000] (11/15 16:46:20.078):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.078):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolDisableCDITPolicyWLANUserChangesDelete' AND type = 'P')   
    DROP PROCEDURE dbo.HistoryPollPolDisableCDITPolicyWLANUserChangesDelete
[30000] (11/15 16:46:20.078):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.078):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollPolDisableCDITPolicyWLANUserChangesDelete
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
SET NOCOUNT ON

DECLARE @WLANUserConfigSetsList TABLE ( UserConfigId INT NOT NULL PRIMARY KEY )

INSERT INTO @WLANUserConfigSetsList
    SELECT DISTINCT UserConfigId
        FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId AND Id <= @CurrMaxId
            AND ObjectDefnId = 1520      --WLANUserConfigSets
            AND Operation = 'D'

IF @@rowcount > 0
BEGIN
    SELECT u.Id, PIN, DeviceType, MailboxSMTPAddr, u.HandheldConfigId, u.ITPolicy2Id, DeviceCapabilities
        FROM Userconfig u
            JOIN @WLANUserConfigSetsList l               
                ON u.Id = l.UserConfigId
        WHERE ServerConfigId = @ServerConfigId
END
[30000] (11/15 16:46:20.078):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.078):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollPolLogging' AND type = 'P')   
    DROP PROCEDURE dbo.HistoryPollPolLogging
[30000] (11/15 16:46:20.078):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.078):{0x9A0} SQL being executed:
 CREATE PROCEDURE dbo.HistoryPollPolLogging
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
SET NOCOUNT ON

SELECT h.Id, h.ObjectDefnId, h.ConfigId, u.ServerConfigId,
            u.Id, h.Operation, h.Details, h.ChangeDateTime
    FROM ServerConfigHistory h WITH (NOLOCK)
        ,UserConfig u
    WHERE h.Id > @LastMaxId AND h.Id <= @CurrMaxId
        AND (
                (    ObjectDefnId = 510      -- ITPolicy2
                        AND (    Operation = 'I'
                             OR (Operation = 'U'
                                    AND Details LIKE '%HandheldBlob%')
                            )
                )
                OR (ObjectDefnId = 200      -- UserConfig
                        AND (    Operation = 'I'
                             OR (Operation = 'U'
                                    AND (   Details LIKE '%PIN%'
                                         OR Details LIKE '%IT
[30000] (11/15 16:46:20.078):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.078):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollXMLSBGlobal' AND type = 'P')
    DROP PROCEDURE dbo.HistoryPollXMLSBGlobal
[30000] (11/15 16:46:20.078):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.078):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollXMLSBGlobal
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ObjectDefnId      INT
AS
    SET NOCOUNT ON
       
    SELECT ObjectDefnId, Operation, Details
        FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId AND Id <= @CurrMaxId
            AND ObjectDefnId = @ObjectDefnId
        ORDER BY Id
[30000] (11/15 16:46:20.078):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.078):{0x9A0} SQL being executed:
 
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'HistoryPollXMLSBUser' AND type = 'P')
    DROP PROCEDURE dbo.HistoryPollXMLSBUser
[30000] (11/15 16:46:20.078):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.078):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.HistoryPollXMLSBUser
     @LastMaxId         BIGINT
    ,@CurrMaxId         BIGINT
    ,@ServerConfigId    INT
AS
    SET NOCOUNT ON
       
    SELECT UserConfigId, ObjectDefnId, Operation, Details
        FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId AND Id <= @CurrMaxId
            AND ServerConfigId = @ServerConfigId
            AND ObjectDefnId = 200
        ORDER BY Id
[30000] (11/15 16:46:20.078):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.078):{0x9A0} SQL being executed:
 
/******************************************************************************************************************

 This stored procedure can be used to create and insert a policy
 
 
 ******************************************************************************************************************/

IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'Policy4xInsert' AND type = 'P')
    DROP PROCEDURE dbo.Policy4xInsert
[30000] (11/15 16:46:20.093):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.093):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.Policy4xInsert
     @Name          VARCHAR(128)
    ,@Description   VARCHAR(512)
    ,@HandheldBlob  IMAGE
    ,@DesktopBlob   IMAGE = 0x01
AS

SET NOCOUNT ON

DECLARE @err        INT

BEGIN TRAN

IF NOT EXISTS (SELECT * FROM ITPolicy2 WHERE PolicyName = @Name)
BEGIN
    INSERT INTO ITPolicy2 (PolicyName, Description, HandheldBlob, DesktopBlob)
        VALUES (@Name, @Description, @HandheldBlob, @DesktopBlob)
    SELECT @err = @@error
    IF @err <> 0
    BEGIN
        ROLLBACK TRANSACTION
        RETURN @err
    END
END   
   
COMMIT
[30000] (11/15 16:46:20.093):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.093):{0x9A0} SQL being executed:
 

/******************************************************************************************************************
 
 This stored procedure can be used to update an existing policy.  This procedure was primarily created for BPS and
 Magellan thus the SMB in the name. 
 
 The policy will be inserted if it does not exist.
 
 To handle the upgrade case from BPS (where policies were not localized) pass in both the english and localized
 version.  If the english version exists in the DB, it will be updated, otherwise the localized variables will be
 used.
 
 ******************************************************************************************************************/
IF EXISTS (SELECT * FROM sysobjects WHERE NAME = 'SMBPolicy4xUpsert' AND type = 'P')
    DROP PROCEDURE dbo.SMBPolicy4xUpsert
[30000] (11/15 16:46:20.093):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.093):{0x9A0} SQL being executed:
 
CREATE PROCEDURE dbo.SMBPolicy4xUpsert
     @EnglishName   VARCHAR(128)
    ,@EnglishDescription VARCHAR(512)
    ,@EnglishHandheldBlob IMAGE
 ,@LocalizedName   VARCHAR(128)
 ,@LocalizedDescription VARCHAR(512)
 ,@LocalizedHandheldBlob IMAGE
    ,@DesktopBlob   IMAGE = 0x01
AS

SET NOCOUNT ON

DECLARE @size int
SET @size = DATALENGTH (@EnglishHandheldBlob)
IF @size > 8000
BEGIN
 RAISERROR('SMBPolicy4xUpsert - English HandheldBlob size exceeds limit of 8,000.  Size = [%d]',16,1,@size)
 RETURN
END

SET @size = DATALENGTH (@LocalizedHandheldBlob)
IF @size > 8000
BEGIN
 RAISERROR('SMBPolicy4xUpsert - Localized HandheldBlob size exceeds limit of 8,000.  Size = [%d]',16,1,@size)
 RETURN
END

DECLARE  @err   INT
  ,@Name   VARCHAR(128)
  ,@Description VARCHAR(512)
  ,@HandheldBlob VARBINARY(8000)

BEGIN TRAN

IF EXISTS (SELECT * FROM ITPolicy2 WHERE PolicyName = @EnglishName)
BEGIN
 SET @Name = @EnglishName
 SET @Description = @EnglishDescription
 SET @Hand
[30000] (11/15 16:46:20.093):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.093):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.093):{0x9A0} Processing file 4.1.2\UpgradeV99990101.sql
[30000] (11/15 16:46:20.093):{0x9A0} Scripts loading from: D:\BES 5 SP2\Database\DBInstallScripts\SqlServer\
[30000] (11/15 16:46:20.093):{0x9A0} Replacing variables in [D:\BES 5 SP2\Database\DBInstallScripts\SqlServer\4.1.2\UpgradeV99990101.sql]
[30000] (11/15 16:46:20.093):{0x9A0} Progress update 500.  Current position is 2500 of 51000 = 4%
[30000] (11/15 16:46:20.093):{0x9A0} Executing file [D:\Program Files\Installer\BES_SQL_Generated\UpgradeV99990101V121115164620.sql]
[30000] (11/15 16:46:20.093):{0x9A0} SQL being executed:
 /****************************************************************************
 UpgradeV99990101.sql
 
 This SQL script will migrate the tables from this release to the latest as
 of this file.
 

 Notes:


 (C) 1997-2009 Research In Motion Limited.
 ****************************************************************************/

/*
 *   Database is "BESMgmt"
 */

SET NOCOUNT ON
[30000] (11/15 16:46:20.093):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.093):{0x9A0} SQL being executed:
 
ALTER PROCEDURE HistoryPollSync
    @LastMaxId      BIGINT,
    @ServerConfigId INT
AS
    SET NOCOUNT ON

    SELECT Id, ServerConfigId, UserConfigId, ObjectDefnId, ConfigId, Operation, Details
        FROM ServerConfigHistory WITH (NOLOCK)
        WHERE Id > @LastMaxId
            AND (
                   -- Server Level events
                   (
                      ServerConfigId = @ServerConfigId
                        AND (
                               (ObjectDefnId = 200 -- UserConfig
                                  AND (Operation IN ('I', 'D')
                                       OR (Operation = 'U'
                                              AND (    Details LIKE 'OTAPIMState%'
                                                    OR Details LIKE '%,OTAPIMState%'
                                                    OR Details LIKE 'PIN%'
                                                    OR Details LIKE '%,PIN%'
              
[30000] (11/15 16:46:20.093):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.093):{0x9A0} Processing file 4.1.2\Security.sql
[30000] (11/15 16:46:20.093):{0x9A0} Scripts loading from: D:\BES 5 SP2\Database\DBInstallScripts\SqlServer\
[30000] (11/15 16:46:20.093):{0x9A0} Replacing variables in [D:\BES 5 SP2\Database\DBInstallScripts\SqlServer\4.1.2\Security.sql]
[30000] (11/15 16:46:20.109):{0x9A0} Progress update 500.  Current position is 3000 of 51000 = 5%
[30000] (11/15 16:46:20.109):{0x9A0} Executing file [D:\Program Files\Installer\BES_SQL_Generated\SecurityV121115164620.sql]
[30000] (11/15 16:46:20.109):{0x9A0} SQL being executed:
 /****************************************************************************
 role.sql
 
 This SQL script will create the security roles for the BlackBerry Admin Server tables.
 

 Notes:


 (C) 1997-2004 Research In Motion Limited.
 ****************************************************************************/

/*
 *   Switch to the BESMgmt database 
 */
USE "BESMgmt"
[40000] (11/15 16:46:20.109):{0x9A0} [CBESDBInstaller::executeRetryDDL] Changed database context to 'BESMgmt'.
[30000] (11/15 16:46:20.109):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.109):{0x9A0} SQL being executed:
 
if not exists (select name from sysusers where name = 'rim_db_bes_server')
    exec sp_addrole 'rim_db_bes_server'

/*
 * define permissions for the various groups/tables
 * more general is defined first then we get into more
 * specific rules
 */

-- all RIM roles can read from any table
exec sp_addrolemember 'db_datareader', 'rim_db_bes_server'
[40000] (11/15 16:46:20.109):{0x9A0} [CBESDBInstaller::executeRetryDDL] 'rim_db_bes_server' added to role 'db_datareader'.
[30000] (11/15 16:46:20.109):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.109):{0x9A0} SQL being executed:
 
-- allow the following RIM groups to write to any table
exec sp_addrolemember 'db_datawriter', 'rim_db_bes_server'
[40000] (11/15 16:46:20.109):{0x9A0} [CBESDBInstaller::executeRetryDDL] 'rim_db_bes_server' added to role 'db_datawriter'.
[30000] (11/15 16:46:20.109):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.109):{0x9A0} SQL being executed:
 
revoke all on vGetDate from public
[30000] (11/15 16:46:20.109):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.109):{0x9A0} SQL being executed:
 revoke all on fn_DayDiff from public
[30000] (11/15 16:46:20.109):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.109):{0x9A0} SQL being executed:
 
--
--  grant execute to rim_db_bes_server for all procs/functions
--
EXEC GrantExecProcToBES
[30000] (11/15 16:46:20.156):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.156):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.156):{0x9A0} Processing file 4.1.2\LoadWorkDefns.sql
[30000] (11/15 16:46:20.156):{0x9A0} Scripts loading from: D:\BES 5 SP2\Database\DBInstallScripts\SqlServer\
[30000] (11/15 16:46:20.156):{0x9A0} Replacing variables in [D:\BES 5 SP2\Database\DBInstallScripts\SqlServer\4.1.2\LoadWorkDefns.sql]
[30000] (11/15 16:46:20.156):{0x9A0} Progress update 500.  Current position is 3500 of 51000 = 6%
[30000] (11/15 16:46:20.156):{0x9A0} Executing file [D:\Program Files\Installer\BES_SQL_Generated\LoadWorkDefnsV121115164620.sql]
[30000] (11/15 16:46:20.156):{0x9A0} SQL being executed:
 /****************************************************************************
LoadWorkDefns.sql

This SQL script will load the WorkQueue object definitions

NOTE: any previously loaded definitions are removed


(C) 1997-2004 Research In Motion Limited.
****************************************************************************/

/*
*  Switch to the database
*/
USE "BESMgmt"
[40000] (11/15 16:46:20.156):{0x9A0} [CBESDBInstaller::executeRetryDDL] Changed database context to 'BESMgmt'.
[30000] (11/15 16:46:20.156):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.156):{0x9A0} SQL being executed:
 
if not exists(select id from WorkDefn where Id = 1)
begin
    insert into WorkDefn (Id, Type, Description) values (1, 'CMIME', 'OTAFM stale commands')
end
[30000] (11/15 16:46:20.171):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.171):{0x9A0} SQL being executed:
 if not exists(select id from WorkDefn where Id = 10)
begin
    insert into WorkDefn (Id, Type, Description) values (10, 'MigrateServiceName', 'Migrates Service Name into user''s mailbox completing the migration process')
end
[30000] (11/15 16:46:20.171):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.171):{0x9A0} SQL being executed:
 if not exists(select id from WorkDefn where Id = 20)
begin
    insert into WorkDefn (Id, Type, Description) values (20, 'ReloadUsers', 'Reload Users')
end
[30000] (11/15 16:46:20.171):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.171):{0x9A0} SQL being executed:
 if not exists(select id from WorkDefn where Id = 21)
begin
    insert into WorkDefn (Id, Type, Description) values (21, 'WipeUserDatabases', 'Removes BlackBerry information from the user''s mailstore after deleting the user from the BES.')
end
[30000] (11/15 16:46:20.171):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.171):{0x9A0} SQL being executed:
 if not exists(select id from WorkDefn where Id = 22)
begin
    insert into WorkDefn (Id, Type, Description) values (22, 'ClearCradleFlag', 'Clears the In-Cradle flag for a specified user')
end
[30000] (11/15 16:46:20.171):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.171):{0x9A0} SQL being executed:
 if not exists(select id from WorkDefn where Id = 23)
begin
    insert into WorkDefn (Id, Type, Description) values (23, 'CalendarSlowSync', 'Calendar Slow Sync')
end
[30000] (11/15 16:46:20.171):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.171):{0x9A0} SQL being executed:
 if not exists(select id from WorkDefn where Id = 100)
begin
    insert into WorkDefn (Id, Type, Description) values (100, 'NewItemsFromMailstore', '')
end
[30000] (11/15 16:46:20.171):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.171):{0x9A0} SQL being executed:
 if not exists(select id from WorkDefn where Id = 101)
begin
    insert into WorkDefn (Id, Type, Description) values (101, 'NewItemsFromDevice', '')
end
[30000] (11/15 16:46:20.171):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.171):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.171):{0x9A0} Processing file 4.1.2\LoadGlobalResource.sql
[30000] (11/15 16:46:20.171):{0x9A0} Scripts loading from: D:\BES 5 SP2\Database\DBInstallScripts\SqlServer\
[30000] (11/15 16:46:20.171):{0x9A0} Replacing variables in [D:\BES 5 SP2\Database\DBInstallScripts\SqlServer\4.1.2\LoadGlobalResource.sql]
[30000] (11/15 16:46:20.296):{0x9A0} Progress update 500.  Current position is 4000 of 51000 = 7%
[30000] (11/15 16:46:20.296):{0x9A0} Executing file [D:\Program Files\Installer\BES_SQL_Generated\LoadGlobalResourceV121115164620.sql]
[30000] (11/15 16:46:20.296):{0x9A0} SQL being executed:
 /****************************************************************************
 LoadGlobalResource.sql
 
 This SQL script will load the Language Resource mappings
 

 Notes:


 (C) 1997-2006 Research In Motion Limited.
 ****************************************************************************/

/*
 *   Switch to the BESMgmt database 
 */
USE "BESMgmt"
[40000] (11/15 16:46:20.296):{0x9A0} [CBESDBInstaller::executeRetryDDL] Changed database context to 'BESMgmt'.
[30000] (11/15 16:46:20.296):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.296):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'en' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('en', '4.1', '')
End
[30000] (11/15 16:46:20.296):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.296):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- Original Message -----"/>
<s i="2" v="From:"/>
<s i="3" v="Sent:"/>
<s i="4" v="To:"/>
<s i="5" v="Cc:"/>
<s i="6" v="Subject:"/>
<s i="7" v="[You are not allowed to copy this message]&#x0D;&#x0A;"/>
<s i="8" v="Could not find original message"/>
<s i="9" v="Could not convert attachment to device readable format"/>
<s i="10" v="Could not save attachment data to file"/>
<s i="11" v="Could not read from attachment file"/>
<s i="12" v="Exception processing more request (original message %lu, user %s)"/>
<s i="13" v="[Unable to get entire message body]"/>
<s i="14" v="[Sent by:"/>
<s i="15" v="[This message was encrypted by the sender]"/>
<s i="16" v="Your message:&#x0A;&#x0A;TO:"/>
<s i="17" v="has been delivered to the recipient&apos;s BlackBerry Handheld.&#x0A;"/>
<s i="18" v="BlackBerry Service Message"/>
<s i="19" v="The BlackBerry Enterprise Server was u
[30000] (11/15 16:46:20.296):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.296):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'fr' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('fr', '4.1', '')
End
[30000] (11/15 16:46:20.296):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.296):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- Message d&apos;origine -----"/>
<s i="2" v="De :"/>
<s i="3" v="Envoy&#xE9; :"/>
<s i="4" v="&#xC0; :"/>
<s i="5" v="Cc :"/>
<s i="6" v="Objet :"/>
<s i="7" v="[Vous n&apos;&#xEA;tes pas autoris&#xE9; &#xE0; copier ce message]&#x0D;&#x0A;"/>
<s i="8" v="Message d&apos;origine introuvable"/>
<s i="9" v="Impossible de convertir la pi&#xE8;ce jointe en un format lisible par l&apos;appareil"/>
<s i="10" v="Impossible d&apos;enregistrer les donn&#xE9;es de la pi&#xE8;ce jointe dans le fichier"/>
<s i="11" v="Impossible de lire &#xE0; partir du fichier joint"/>
<s i="12" v="Exception lors du traitement de demandes suppl&#xE9;mentaires (message d&apos;origine %lu, utilisateur %s)"/>
<s i="13" v="[Impossible d&apos;obtenir l&apos;int&#xE9;gralit&#xE9; du corps du message]"/>
<s i="14" v="[Envoy&#xE9; par :"/>
<s i="15" v="[Ce message a &#xE9;t&#xE9; crypt&#xE9; pa
[30000] (11/15 16:46:20.296):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.296):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'it' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('it', '4.1', '')
End
[30000] (11/15 16:46:20.296):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.296):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- Messaggio originale -----"/>
<s i="2" v="Da:"/>
<s i="3" v="Inviato:"/>
<s i="4" v="A:"/>
<s i="5" v="Cc:"/>
<s i="6" v="Oggetto:"/>
<s i="7" v="[Copia del messaggio non consentita]&#x0D;&#x0A;"/>
<s i="8" v="Impossibile trovare il messaggio originale"/>
<s i="9" v="Impossibile convertire gli allegati in formato leggibile dal dispositivo"/>
<s i="10" v="Impossibile salvare i dati dell&apos;allegato al file"/>
<s i="11" v="Impossibile leggere il file allegato"/>
<s i="12" v="Eccezione durante l&apos;elaborazione di altre richieste (messaggio originale %lu, utente %s)"/>
<s i="13" v="[Impossibile visualizzare l&apos;intero corpo del messaggio]"/>
<s i="14" v="[Inviato da:"/>
<s i="15" v="[Messaggio crittografato dal mittente]"/>
<s i="16" v="Il messaggio:&#x0A;&#x0A;A:"/>
<s i="17" v="&#xE8; stato inviato al destinatario del palmare BlackBerry.&#x0A;"/>
<s i
[30000] (11/15 16:46:20.312):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.312):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'de' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('de', '4.1', '')
End
[30000] (11/15 16:46:20.312):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.312):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- Originalnachricht -----"/>
<s i="2" v="Von:"/>
<s i="3" v="Gesendet:"/>
<s i="4" v="An:"/>
<s i="5" v="Cc:"/>
<s i="6" v="Betreff:"/>
<s i="7" v="[Diese Nachricht darf nicht kopiert werden]&#x0D;&#x0A;"/>
<s i="8" v="Urspr&#xFC;ngliche Nachricht konnte nicht gefunden werden"/>
<s i="9" v="Anlage konnte nicht in ein maschinenlesbares Format konvertiert werden"/>
<s i="10" v="Die Anlagendaten konnten nicht in eine Datei gespeichert werden"/>
<s i="11" v="Aus der Anlagendatei konnte nicht gelesen werden"/>
<s i="12" v="Ausnahme bei Verarbeitung von weiterer Anforderung (urspr&#xFC;ngliche Nachricht %lu, Benutzer %s)"/>
<s i="13" v="[Nachrichtentext konnte nicht vollst&#xE4;ndig abgerufen werden]"/>
<s i="14" v="[Gesendet von:"/>
<s i="15" v="[Diese Nachricht wurde vom Sender verschl&#xFC;sselt]"/>
<s i="16" v="Ihre Nachricht:&#x0A;&#x0A;AN:"/>
<s i="17" v="wu
[30000] (11/15 16:46:20.312):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.312):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'es' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('es', '4.1', '')
End
[30000] (11/15 16:46:20.312):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.312):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- Mensaje original -----"/>
<s i="2" v="De:"/>
<s i="3" v="Enviado:"/>
<s i="4" v="Para:"/>
<s i="5" v="CC:"/>
<s i="6" v="Asunto:"/>
<s i="7" v="[No tiene autorizaci&#xF3;n para copiar este mensaje]&#x0D;&#x0A;"/>
<s i="8" v="No se pudo encontrar el mensaje original"/>
<s i="9" v="No se pudo convertir el archivo adjunto a un formato de lectura apto para el dispositivo"/>
<s i="10" v="No se pudieron guardar los datos adjuntos en el archivo"/>
<s i="11" v="No se pudo leer el archivo adjunto"/>
<s i="12" v="Excepci&#xF3;n al procesar m&#xE1;s solicitudes (mensaje original %lu, usuario %s)"/>
<s i="13" v="[No se pudo obtener el cuerpo completo del mensaje]"/>
<s i="14" v="[Enviado por:"/>
<s i="15" v="[El remitente cifr&#xF3; este mensaje]"/>
<s i="16" v="El mensaje:&#x0A;&#x0A;PARA:"/>
<s i="17" v="se ha entregado al dispositivo de bolsillo BlackBerry del dest
[30000] (11/15 16:46:20.312):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.312):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'ca' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('ca', '4.1', '')
End
[30000] (11/15 16:46:20.312):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.312):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- Missatge original -----"/>
<s i="2" v="De:"/>
<s i="3" v="Enviat:"/>
<s i="4" v="Per a:"/>
<s i="5" v="Cc:"/>
<s i="6" v="Tema:"/>
<s i="7" v="[No esteu autoritzats a copiar aquest missatge]&#x0D;&#x0A;"/>
<s i="8" v="No s&#x2019;ha pogut trobar el missatge original"/>
<s i="9" v="No s&#x2019;ha pogut convertir el fitxer adjunt a un format que pugui llegir el dispositiu"/>
<s i="10" v="No s&#x2019;han pogut desar les dades adjuntes al fitxer"/>
<s i="11" v="No s&#x2019;ha pogut llegir del fitxer adjunt"/>
<s i="12" v="S&#x2019;ha produ&#xEF;t una excepci&#xF3; en processar m&#xE9;s sol&#xB7;licituds (missatge original %lu, usuari %s)"/>
<s i="13" v="[No es pot obtenir tot el cos del missatge]"/>
<s i="14" v="[Enviat per:"/>
<s i="15" v="[L&#x2019;emissor ha encriptat aquest missatge]"/>
<s i="16" v="El vostre missatge:&#x0A;&#x0A;PER A:"/>
<s i="17" v="s&#
[30000] (11/15 16:46:20.312):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.312):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'da' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('da', '4.1', '')
End
[30000] (11/15 16:46:20.312):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.312):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- Oprindelig meddelelse -----"/>
<s i="2" v="Fra:"/>
<s i="3" v="Sendt:"/>
<s i="4" v="Til:"/>
<s i="5" v="Cc:"/>
<s i="6" v="Emne:"/>
<s i="7" v="[Du har ikke tilladelse til at kopiere denne meddelelse]&#x0D;&#x0A;"/>
<s i="8" v="Den oprindelige meddelelse blev ikke fundet"/>
<s i="9" v="Den vedh&#xE6;ftede fil kunne ikke konverteres til et format, der kan l&#xE6;ses af enheden"/>
<s i="10" v="Dataene i den vedh&#xE6;ftede fil kunne ikke gemmes i en fil"/>
<s i="11" v="Der kunne ikke l&#xE6;ses fra den vedh&#xE6;ftede fil"/>
<s i="12" v="Der opstod en uventet undtagelse under behandling af flere anmodninger (oprindelige meddelelse %lu, bruger %s)"/>
<s i="13" v="[Det var ikke muligt at hente hele br&#xF8;dteksten]"/>
<s i="14" v="[Sendt af:"/>
<s i="15" v="[Denne meddelelse var krypteret af afsenderen]"/>
<s i="16" v="Meddelelsen:&#x0A;&#x0A;TIL:"/>
<s i="1
[30000] (11/15 16:46:20.312):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.312):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'nl' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('nl', '4.1', '')
End
[30000] (11/15 16:46:20.312):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.312):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- Oorspronkelijk bericht -----"/>
<s i="2" v="Van:"/>
<s i="3" v="Verzonden:"/>
<s i="4" v="Aan:"/>
<s i="5" v="Cc:"/>
<s i="6" v="Onderwerp:"/>
<s i="7" v="[Dit bericht mag niet worden gekopieerd]&#x0D;&#x0A;"/>
<s i="8" v="Kan het oorspronkelijke bericht niet vinden"/>
<s i="9" v="Kan de bijlage niet converteren naar een door het apparaat leesbare indeling"/>
<s i="10" v="Kan de gegevens uit de bijlage niet als bestand opslaan"/>
<s i="11" v="Kan het bijlagebestand niet lezen"/>
<s i="12" v="Uitzondering bij het verwerken van aanvraag (oorspronkelijk bericht %lu, gebruiker %s)"/>
<s i="13" v="[Kan niet de volledige berichttekst verkrijgen]"/>
<s i="14" v="[Verzonden door:"/>
<s i="15" v="[Dit bericht is gecodeerd door de afzender]"/>
<s i="16" v="Uw bericht:&#x0A;&#x0A;AAN:"/>
<s i="17" v="is bezorgd bij de BlackBerry van de geadresseerde.&#x0A;"/>
<s i="1
[30000] (11/15 16:46:20.312):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.312):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'sv' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('sv', '4.1', '')
End
[30000] (11/15 16:46:20.312):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.328):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- Ursprungligt meddelande ----"/>
<s i="2" v="Fr&#xE5;n:"/>
<s i="3" v="Skickat:"/>
<s i="4" v="Till:"/>
<s i="5" v="Kopia:"/>
<s i="6" v="&#xC4;mne:"/>
<s i="7" v="[Du har inte r&#xE4;tt att kopiera detta meddelande]&#x0D;&#x0A;"/>
<s i="8" v="Det gick inte att hitta det ursprungliga meddelandet"/>
<s i="9" v="Det gick inte att konvertera bilagan till l&#xE4;sbart format f&#xF6;r enheten"/>
<s i="10" v="Det gick inte att spara bifogade data till fil"/>
<s i="11" v="Det gick inte att l&#xE4;sa fr&#xE5;n bifogad fil"/>
<s i="12" v="Undantag vid bearbetning av ytterligare beg&#xE4;ran (ursprungsmeddelande %lu, anv&#xE4;ndare %s)"/>
<s i="13" v="[Det gick inte att h&#xE4;mta hela meddelandetexten]"/>
<s i="14" v="[Skickat av:"/>
<s i="15" v="[Detta meddelande har krypterats av avs&#xE4;ndaren]"/>
<s i="16" v="Meddelande:&#x0A;&#x0A;TILL:"/>
<s i="17" v="har lev
[30000] (11/15 16:46:20.328):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.328):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'af' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('af', '4.1', '')
End
[30000] (11/15 16:46:20.328):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.328):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="Oorspronklike Boodskap"/>
<s i="2" v="Van: "/>
<s i="3" v="Verstuur:"/>
<s i="4" v="Na:"/>
<s i="5" v="Cc:"/>
<s i="6" v="Onderwerp:"/>
<s i="7" v="[U mag nie hierdie boodskap kopieer nie]&#x0D;&#x0A;"/>
<s i="8" v="Kon nie oorspronklike boodskap vind nie"/>
<s i="9" v="Kon nie aanhegsel na leesbare formaat vir toestel omskakel nie"/>
<s i="10" v="Kon nie aanhegseldata in l&#xEA;er stoor nie"/>
<s i="11" v="Kon nie uit die aanhegsell&#xEA;er lees nie"/>
<s i="12" v="Versoek vir meer uitsonderingverwerking (oorspronklike boodskap %lu, gebruiker %s)  "/>
<s i="13" v="[Kan nie volledige boodskaplyf kry nie] "/>
<s i="14" v="[Gestuur deur:"/>
<s i="15" v="[Hierdie boodskap is deur die afsender ge&#xEB;nkripteer]"/>
<s i="16" v="Jou boodskap:&#x0A;&#x0A;TO:"/>
<s i="17" v="is na die ontvanger se BlackBerry Handtoestel afgelewer.&#x0A;"/>
<s i="18" v="BlackBerry Diens
[30000] (11/15 16:46:20.328):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.328):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'ar' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('ar', '4.1', '')
End
[30000] (11/15 16:46:20.328):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.328):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- &#x627;&#x644;&#x631;&#x633;&#x627;&#x644;&#x629; &#x627;&#x644;&#x623;&#x635;&#x644;&#x64A;&#x629; -----"/>
<s i="2" v="&#x627;&#x644;&#x645;&#x631;&#x633;&#x644;:"/>
<s i="3" v="&#x62A;&#x627;&#x631;&#x64A;&#x62E; &#x627;&#x644;&#x625;&#x631;&#x633;&#x627;&#x644;:"/>
<s i="4" v="&#x625;&#x644;&#x649;:"/>
<s i="5" v="&#x646;&#x633;&#x62E;&#x629;:"/>
<s i="6" v="&#x627;&#x644;&#x645;&#x648;&#x636;&#x648;&#x639;:"/>
<s i="7" v="[&#x63A;&#x64A;&#x631; &#x645;&#x633;&#x645;&#x648;&#x62D; &#x644;&#x643; &#x646;&#x633;&#x62E; &#x647;&#x630;&#x647; &#x627;&#x644;&#x631;&#x633;&#x627;&#x644;&#x629;]&#x0D;&#x0A;"/>
<s i="8" v="&#x62A;&#x639;&#x630;&#x651;&#x631; &#x627;&#x644;&#x639;&#x62B;&#x648;&#x631; &#x639;&#x644;&#x649; &#x627;&#x644;&#x631;&#x633;&#x627;&#x644;&#x629; &#x627;&#x644;&#x623;&#x635;&#x644;&#x64A;&#x629;"/>
<s i="9" v="&#x62A;&#x639;&#x630;&#x6
[30000] (11/15 16:46:20.328):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.328):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'zhCN' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('zhCN', '4.1', '')
End
[30000] (11/15 16:46:20.328):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.328):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- &#x539F;&#x59CB;&#x6D88;&#x606F; -----"/>
<s i="2" v="&#x53D1;&#x4EF6;&#x4EBA;&#xFF1A;"/>
<s i="3" v="&#x53D1;&#x9001;&#x65F6;&#x95F4;&#xFF1A;"/>
<s i="4" v="&#x6536;&#x4EF6;&#x4EBA;&#xFF1A;"/>
<s i="5" v="&#x6284;&#x9001;&#xFF1A;"/>
<s i="6" v="&#x4E3B;&#x9898;&#xFF1A;"/>
<s i="7" v="[&#x4E0D;&#x5141;&#x8BB8;&#x590D;&#x5236;&#x6B64;&#x6D88;&#x606F;]&#x0D;&#x0A;"/>
<s i="8" v="&#x65E0;&#x6CD5;&#x627E;&#x5230;&#x539F;&#x59CB;&#x6D88;&#x606F;"/>
<s i="9" v="&#x65E0;&#x6CD5;&#x5C06;&#x9644;&#x4EF6;&#x8F6C;&#x6362;&#x4E3A;&#x8BBE;&#x5907;&#x53EF;&#x8BFB;&#x53D6;&#x7684;&#x683C;&#x5F0F;"/>
<s i="10" v="&#x65E0;&#x6CD5;&#x5C06;&#x9644;&#x4EF6;&#x6570;&#x636E;&#x4FDD;&#x5B58;&#x81F3;&#x6587;&#x4EF6;"/>
<s i="11" v="&#x65E0;&#x6CD5;&#x4ECE;&#x9644;&#x4EF6;&#x6587;&#x4EF6;&#x8BFB;&#x53D6;"/>
<s i="12" v="&#x5904;&#x7406;&#x66F4;&#x591A;&#x8BF7;&#x6C42;&#x65F6;&#x51
[30000] (11/15 16:46:20.343):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.343):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'zhHK' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('zhHK', '4.1', '')
End
[30000] (11/15 16:46:20.343):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.343):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- &#x539F;&#x59CB;&#x8A0A;&#x606F; -----"/>
<s i="2" v="&#x5BC4;&#x4EF6;&#x8005;&#xFF1A;"/>
<s i="3" v="&#x5BC4;&#x4EF6;&#x6642;&#x9593;&#xFF1A;"/>
<s i="4" v="&#x6536;&#x4EF6;&#x8005;&#xFF1A;"/>
<s i="5" v="&#x526F;&#x4EF6;&#xFF1A;"/>
<s i="6" v="&#x4E3B;&#x65E8;&#xFF1A;"/>
<s i="7" v="[&#x60A8;&#x7121;&#x6CD5;&#x8907;&#x88FD;&#x672C;&#x8A0A;&#x606F;]&#x0D;&#x0A;"/>
<s i="8" v="&#x627E;&#x4E0D;&#x5230;&#x539F;&#x59CB;&#x8A0A;&#x606F;"/>
<s i="9" v="&#x7121;&#x6CD5;&#x5C07;&#x9644;&#x4EF6;&#x8F49;&#x63DB;&#x70BA;&#x88DD;&#x7F6E;&#x53EF;&#x8B80;&#x53D6;&#x4E4B;&#x683C;&#x5F0F;"/>
<s i="10" v="&#x7121;&#x6CD5;&#x5C07;&#x9644;&#x4EF6;&#x8CC7;&#x6599;&#x5B58;&#x6210;&#x6A94;&#x6848;"/>
<s i="11" v="&#x7121;&#x6CD5;&#x8B80;&#x53D6;&#x9644;&#x4EF6;&#x6A94;&#x6848;"/>
<s i="12" v="&#x8655;&#x7406;&#x66F4;&#x591A;&#x8981;&#x6C42;&#x6642;&#x767C;&#x751F;&#x4F8B;&#x59
[30000] (11/15 16:46:20.343):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.343):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'cs' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('cs', '4.1', '')
End
[30000] (11/15 16:46:20.343):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.343):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- P&#x16F;vodn&#xED; zpr&#xE1;va -----"/>
<s i="2" v="Od:"/>
<s i="3" v="Odesl&#xE1;no:"/>
<s i="4" v="Komu:"/>
<s i="5" v="Kopie:"/>
<s i="6" v="P&#x159;edm&#x11B;t:"/>
<s i="7" v="[Nem&#xE1;te opr&#xE1;vn&#x11B;n&#xED; kop&#xED;rovat tuto zpr&#xE1;vu]&#x0D;&#x0A;"/>
<s i="8" v="Nelze naj&#xED;t p&#x16F;vodn&#xED; zpr&#xE1;vu"/>
<s i="9" v="Nelze p&#x159;ev&#xE9;st p&#x159;&#xED;lohu do form&#xE1;tu &#x10D;iteln&#xE9;ho pro za&#x159;&#xED;zen&#xED;"/>
<s i="10" v="Nelze ulo&#x17E;it data p&#x159;&#xED;lohy do souboru"/>
<s i="11" v="Nelze &#x10D;&#xED;st ze souboru p&#x159;&#xED;lohy"/>
<s i="12" v="V&#xFD;jimka zpracov&#xE1;n&#xED; dal&#x161;&#xED;ho po&#x17E;adavku (p&#x16F;vodn&#xED; zpr&#xE1;va %lu, u&#x17E;ivatel %s)"/>
<s i="13" v="[Nelze z&#xED;skat cel&#xE9; t&#x11B;lo zpr&#xE1;vy]"/>
<s i="14" v="[Odeslal:"/>
<s i="15" v="[Tato zpr&#xE1;va byla &#x
[30000] (11/15 16:46:20.343):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.343):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'fy' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('fy', '4.1', '')
End
[30000] (11/15 16:46:20.343):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.343):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- &#x67E;&#x64A;&#x627;&#x645; &#x627;&#x635;&#x644;&#x64A; -----"/>
<s i="2" v=":&#x641;&#x631;&#x633;&#x62A;&#x646;&#x62F;&#x647;"/>
<s i="3" v=":&#x627;&#x631;&#x633;&#x627;&#x644;"/>
<s i="4" v=":&#x6AF;&#x64A;&#x631;&#x646;&#x62F;&#x647;"/>
<s i="5" v=":&#x6AF;&#x64A;&#x631;&#x646;&#x62F;&#x647; &#x643;&#x67E;&#x64A;"/>
<s i="6" v=":&#x645;&#x648;&#x636;&#x648;&#x639;"/>
<s i="7" v="&#x200C;&#x200D;&#x200C;&#x0D;&#x0A;[&#x645;&#x62C;&#x627;&#x632; &#x628;&#x647; &#x643;&#x67E;&#x64A; &#x643;&#x631;&#x62F;&#x646; &#x627;&#x64A;&#x646; &#x67E;&#x64A;&#x627;&#x645; &#x646;&#x64A;&#x633;&#x62A;&#x64A;&#x62F;]"/>
<s i="8" v="&#x67E;&#x64A;&#x627;&#x645; &#x627;&#x635;&#x644;&#x64A; &#x64A;&#x627;&#x641;&#x62A; &#x646;&#x634;&#x62F;"/>
<s i="9" v="&#x645;&#x648;&#x631;&#x62F; &#x636;&#x645;&#x64A;&#x645;&#x647; &#x634;&#x62F;&#x647; &#x628;&#x647; &#x642;&#x6
[30000] (11/15 16:46:20.359):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.359):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'el' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('el', '4.1', '')
End
[30000] (11/15 16:46:20.359):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.359):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- &#x391;&#x3C1;&#x3C7;&#x3B9;&#x3BA;&#x3CC; &#x3BC;&#x3AE;&#x3BD;&#x3C5;&#x3BC;&#x3B1; -----"/>
<s i="2" v="&#x391;&#x3C0;&#x3CC;:"/>
<s i="3" v="&#x391;&#x3C0;&#x3BF;&#x3C3;&#x3C4;&#x3BF;&#x3BB;&#x3AE;:"/>
<s i="4" v="&#x3A0;&#x3C1;&#x3BF;&#x3C2;:"/>
<s i="5" v="Cc:"/>
<s i="6" v="&#x398;&#x3AD;&#x3BC;&#x3B1;:"/>
<s i="7" v="[&#x394;&#x3B5;&#x3BD; &#x3B5;&#x3C0;&#x3B9;&#x3C4;&#x3C1;&#x3AD;&#x3C0;&#x3B5;&#x3C4;&#x3B1;&#x3B9; &#x3B7; &#x3B1;&#x3BD;&#x3C4;&#x3B9;&#x3B3;&#x3C1;&#x3B1;&#x3C6;&#x3AE; &#x3B1;&#x3C5;&#x3C4;&#x3BF;&#x3CD; &#x3C4;&#x3BF;&#x3C5; &#x3BC;&#x3B7;&#x3BD;&#x3CD;&#x3BC;&#x3B1;&#x3C4;&#x3BF;&#x3C2;]&#x0D;&#x0A;"/>
<s i="8" v="&#x394;&#x3B5;&#x3BD; &#x3BC;&#x3C0;&#x3BF;&#x3C1;&#x3B5;&#x3AF; &#x3BD;&#x3B1; &#x3B5;&#x3BD;&#x3C4;&#x3BF;&#x3C0;&#x3B9;&#x3C3;&#x3C4;&#x3B5;&#x3AF; &#x3C4;&#x3BF; &#x3B1;&#x3C1;&#x3C7;&#x3B9;&#x3BA;&#x3CC; &#x3BC;&#
[30000] (11/15 16:46:20.375):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.375):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'he' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('he', '4.1', '')
End
[30000] (11/15 16:46:20.375):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.375):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="---- &#x5D4;&#x5D5;&#x5D3;&#x5E2;&#x5D4; &#x5DE;&#x5E7;&#x5D5;&#x5E8;&#x5D9;&#x5EA; -----"/>
<s i="2" v="&#x5DE;&#x5D0;&#x5EA;:"/>
<s i="3" v="&#x5E0;&#x5E9;&#x5DC;&#x5D7;:"/>
<s i="4" v="&#x5D0;&#x5DC;:"/>
<s i="5" v="&#x5E2;&#x5D5;&#x5EA;&#x5E7;:"/>
<s i="6" v="&#x5E0;&#x5D5;&#x5E9;&#x5D0;:"/>
<s i="7" v="[&#x5D0;&#x5D9;&#x5E0;&#x5DA; &#x5DE;&#x5D5;&#x5E8;&#x5E9;&#x5D4; &#x5DC;&#x5D4;&#x5E2;&#x5EA;&#x5D9;&#x5E7; &#x5D4;&#x5D5;&#x5D3;&#x5E2;&#x5D4; &#x5D6;&#x5D5;]&#x0D;&#x0A;"/>
<s i="8" v="&#x5D0;&#x5D9;&#x5DF; &#x5D0;&#x5E4;&#x5E9;&#x5E8;&#x5D5;&#x5EA; &#x5DC;&#x5D0;&#x5EA;&#x5E8; &#x5D0;&#x5EA; &#x5D4;&#x5D4;&#x5D5;&#x5D3;&#x5E2;&#x5D4; &#x5D4;&#x5DE;&#x5E7;&#x5D5;&#x5E8;&#x5D9;&#x5EA;"/>
<s i="9" v="&#x5D0;&#x5D9;&#x5DF; &#x5D0;&#x5E4;&#x5E9;&#x5E8;&#x5D5;&#x5EA; &#x5DC;&#x5D4;&#x5DE;&#x5D9;&#x5E8; &#x5D0;&#x5EA; &#x5D4;&#x5E7;&#x5D5;&#x5D1;&#x5E5; &#x5D4;&
[30000] (11/15 16:46:20.375):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.375):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'hu' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('hu', '4.1', '')
End
[30000] (11/15 16:46:20.375):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.375):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="------ Eredeti &#xFC;zenet ------"/>
<s i="2" v="Felad&#xF3;:"/>
<s i="3" v="Elk&#xFC;ldve:"/>
<s i="4" v="C&#xED;mzett:"/>
<s i="5" v="M&#xE1;solat:"/>
<s i="6" v="T&#xE1;rgy:"/>
<s i="7" v="[Nem jogosult az &#xFC;zenetet m&#xE1;sol&#xE1;s&#xE1;ra]&#x0D;&#x0A;"/>
<s i="8" v="Az eredeti &#xFC;zenet nem tal&#xE1;lhat&#xF3;"/>
<s i="9" v="A csatolt &#xE1;llom&#xE1;nyt nem siker&#xFC;lt az eszk&#xF6;z &#xE1;ltal olvashat&#xF3; form&#xE1;tumba &#xE1;talak&#xED;tani"/>
<s i="10" v="A csatolt adatok ment&#xE9;se a f&#xE1;jlba sikertelen"/>
<s i="11" v="Nem lehet olvasni a csatolt f&#xE1;jlb&#xF3;l"/>
<s i="12" v="A tov&#xE1;bbi k&#xE9;r&#xE9;sek feldolgoz&#xE1;sakor kiv&#xE9;tel t&#xF6;rt&#xE9;nt (eredeti &#xFC;zenet: %lu, felhaszn&#xE1;l&#xF3;: %s)"/>
<s i="13" v="[A teljes &#xFC;zenett&#xF6;rzs lek&#xE9;r&#xE9;se sikertelen]"/>
<s i="14" v="[Felad&#xF3;:"/>
<s i="15
[30000] (11/15 16:46:20.375):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.375):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'ja' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('ja', '4.1', '')
End
[30000] (11/15 16:46:20.375):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.390):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- &#x30AA;&#x30EA;&#x30B8;&#x30CA;&#x30EB;&#x30E1;&#x30C3;&#x30BB;&#x30FC;&#x30B8; -----"/>
<s i="2" v="&#x5DEE;&#x51FA;&#x4EBA;: "/>
<s i="3" v="&#x65E5;&#x6642;: "/>
<s i="4" v="&#x5B9B;&#x5148;: "/>
<s i="5" v="Cc: "/>
<s i="6" v="&#x4EF6;&#x540D;: "/>
<s i="7" v="[&#x3053;&#x306E;&#x30E1;&#x30C3;&#x30BB;&#x30FC;&#x30B8;&#x3092;&#x30B3;&#x30D4;&#x30FC;&#x3059;&#x308B;&#x3053;&#x3068;&#x306F;&#x3067;&#x304D;&#x307E;&#x305B;&#x3093;]&#x0D;&#x0A;"/>
<s i="8" v="&#x30AA;&#x30EA;&#x30B8;&#x30CA;&#x30EB;&#x30E1;&#x30C3;&#x30BB;&#x30FC;&#x30B8;&#x304C;&#x898B;&#x3064;&#x304B;&#x308A;&#x307E;&#x305B;&#x3093;&#x3067;&#x3057;&#x305F;&#x3002;"/>
<s i="9" v="&#x8AAD;&#x307F;&#x53D6;&#x308A;&#x53EF;&#x80FD;&#x306A;&#x5F62;&#x5F0F;&#x306B;&#x6DFB;&#x4ED8;&#x30D5;&#x30A1;&#x30A4;&#x30EB;&#x3092;&#x5909;&#x63DB;&#x3067;&#x304D;&#x307E;&#x305B;&#x3093;&#x3067;&#x3057;&#x3
[30000] (11/15 16:46:20.390):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.390):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'ko' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('ko', '4.1', '')
End
[30000] (11/15 16:46:20.390):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.390):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- &#xC6D0;&#xBCF8; &#xBA54;&#xC2DC;&#xC9C0; ---"/>
<s i="2" v="&#xBCF4;&#xB0B8; &#xC0AC;&#xB78C;:"/>
<s i="3" v="&#xBCF4;&#xB0B8; &#xB0A0;&#xC9DC;:"/>
<s i="4" v="&#xBC1B;&#xB294; &#xC0AC;&#xB78C;:"/>
<s i="5" v="&#xCC38;&#xC870;:"/>
<s i="6" v="&#xC81C;&#xBAA9;:"/>
<s i="7" v="[&#xC774; &#xBA54;&#xC2DC;&#xC9C0;&#xB97C; &#xBCF5;&#xC0AC;&#xD560; &#xC218; &#xC5C6;&#xC74C;]&#x0D;&#x0A;"/>
<s i="8" v="&#xC6D0;&#xBCF8; &#xBA54;&#xC2DC;&#xC9C0;&#xB97C; &#xCC3E;&#xC744; &#xC218; &#xC5C6;&#xC74C;"/>
<s i="9" v="&#xCCA8;&#xBD80; &#xD30C;&#xC77C;&#xC744; &#xC7A5;&#xCE58;&#xC5D0;&#xC11C; &#xC77D;&#xC744; &#xC218; &#xC788;&#xB294; &#xD615;&#xC2DD;&#xC73C;&#xB85C; &#xBCC0;&#xD658;&#xD560; &#xC218; &#xC5C6;&#xC74C;"/>
<s i="10" v="&#xCCA8;&#xBD80; &#xD30C;&#xC77C; &#xB370;&#xC774;&#xD130;&#xB97C; &#xD30C;&#xC77C;&#xB85C; &#xC800;&#xC7A5;&#xD560; &#xC218; &#xC5C6;&#xC74C;"
[30000] (11/15 16:46:20.390):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.390):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'pl' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('pl', '4.1', '')
End
[30000] (11/15 16:46:20.390):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.390):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- Wiadomo&#x15B;&#x107; oryginalna -----"/>
<s i="2" v="Od:"/>
<s i="3" v="Wys&#x142;ano:"/>
<s i="4" v="Do:"/>
<s i="5" v="DW:"/>
<s i="6" v="Temat:"/>
<s i="7" v="[Nie masz pozwolenia na skopiowanie tej wiadomo&#x15B;ci]&#x0D;&#x0A;"/>
<s i="8" v="Nie odnaleziono oryginalnej wiadomo&#x15B;ci"/>
<s i="9" v="Nie uda&#x142;o si&#x119; przekonwertowa&#x107; za&#x142;&#x105;cznika na format odczytywany przez urz&#x105;dzenie"/>
<s i="10" v="Nie uda&#x142;o si&#x119; zapisa&#x107; danych za&#x142;&#x105;cznika do pliku"/>
<s i="11" v="Nie uda&#x142;o si&#x119; odczyta&#x107; pliku za&#x142;&#x105;cznika"/>
<s i="12" v="Wyj&#x105;tek podczas przetwarzania &#x17C;&#x105;dania (wiadomo&#x15B;&#x107; oryginalna %lu, u&#x17C;ytkownik %s)"/>
<s i="13" v="[Nie mo&#x17C;na pobra&#x107; ca&#x142;ej tre&#x15B;ci wiadomo&#x15B;ci]"/>
<s i="14" v="[Wys&#x142;ane przez:"/>
<
[30000] (11/15 16:46:20.390):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.390):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'ptBR' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('ptBR', '4.1', '')
End
[30000] (11/15 16:46:20.390):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.406):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- Mensagem original -----"/>
<s i="2" v="De:"/>
<s i="3" v="Enviada em:"/>
<s i="4" v="Para:"/>
<s i="5" v="Cc:"/>
<s i="6" v="Assunto:"/>
<s i="7" v="[A c&#xF3;pia desta mensagem n&#xE3;o &#xE9; permitida]&#x0D;&#x0A;"/>
<s i="8" v="N&#xE3;o foi poss&#xED;vel localizar a mensagem original"/>
<s i="9" v="N&#xE3;o foi poss&#xED;vel converter o anexo em um formato leg&#xED;vel pelo dispositivo"/>
<s i="10" v="N&#xE3;o foi poss&#xED;vel salvar os dados do anexo em um arquivo"/>
<s i="11" v="N&#xE3;o foi poss&#xED;vel ler o arquivo do anexo"/>
<s i="12" v="Ocorreu uma exce&#xE7;&#xE3;o ao processar a solicita&#xE7;&#xE3;o Mais (mensagem original %lu, usu&#xE1;rio %s)"/>
<s i="13" v="[N&#xE3;o foi poss&#xED;vel obter todo o corpo da mensagem]"/>
<s i="14" v="[Enviada por:"/>
<s i="15" v="[Esta mensagem foi criptografada pelo remetente]"/>
<s i="16" v="Sua mensage
[30000] (11/15 16:46:20.406):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.406):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'pt' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('pt', '4.1', '')
End
[30000] (11/15 16:46:20.406):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.406):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- Mensagem Original -----"/>
<s i="2" v="De:"/>
<s i="3" v="Enviado:"/>
<s i="4" v="Para:"/>
<s i="5" v="Cc:"/>
<s i="6" v="Assunto:"/>
<s i="7" v="[N&#xE3;o pode copiar esta mensagem]&#x0D;&#x0A;"/>
<s i="8" v="N&#xE3;o foi poss&#xED;vel encontrar a mensagem original"/>
<s i="9" v="N&#xE3;o foi poss&#xED;vel converter o anexo para um formato compat&#xED;vel com o dispositivo"/>
<s i="10" v="N&#xE3;o foi poss&#xED;vel guardar os dados do anexo para um ficheiro"/>
<s i="11" v="N&#xE3;o foi poss&#xED;vel ler o ficheiro de anexo"/>
<s i="12" v="Excep&#xE7;&#xE3;o ao processar mais pedidos (mensagem original %lu, utilizador %s)"/>
<s i="13" v="[N&#xE3;o foi poss&#xED;vel obter todo o corpo da mensagem]"/>
<s i="14" v="[Enviado por:"/>
<s i="15" v="[Esta mensagem foi encriptada pelo remetente]"/>
<s i="16" v="A sua mensagem:&#x0A;&#x0A;PARA:"/>
<s i="17" v="foi e
[30000] (11/15 16:46:20.406):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.406):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'ru' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('ru', '4.1', '')
End
[30000] (11/15 16:46:20.406):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.406):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- &#x418;&#x441;&#x445;&#x43E;&#x434;&#x43D;&#x43E;&#x435; &#x441;&#x43E;&#x43E;&#x431;&#x449;&#x435;&#x43D;&#x438;&#x435; -----"/>
<s i="2" v="&#x41E;&#x442;:"/>
<s i="3" v="&#x41F;&#x43E;&#x441;&#x43B;&#x430;&#x43D;&#x43E;:"/>
<s i="4" v="&#x41A;&#x43E;&#x43C;&#x443;:"/>
<s i="5" v="&#x41A;&#x43E;&#x43F;&#x438;&#x44F;:"/>
<s i="6" v="&#x422;&#x435;&#x43C;&#x430;:"/>
<s i="7" v="[&#x412;&#x430;&#x43C; &#x43D;&#x435; &#x440;&#x430;&#x437;&#x440;&#x435;&#x448;&#x435;&#x43D;&#x43E; &#x43A;&#x43E;&#x43F;&#x438;&#x440;&#x43E;&#x432;&#x430;&#x442;&#x44C; &#x44D;&#x442;&#x43E; &#x441;&#x43E;&#x43E;&#x431;&#x449;&#x435;&#x43D;&#x438;&#x435;]&#x0D;&#x0A;"/>
<s i="8" v="&#x418;&#x441;&#x445;&#x43E;&#x434;&#x43D;&#x43E;&#x435; &#x441;&#x43E;&#x43E;&#x431;&#x449;&#x435;&#x43D;&#x438;&#x435; &#x43D;&#x435; &#x43D;&#x430;&#x439;&#x434;&#x435;&#x43D;&#x43E;"/>
<s i="9" v=
[30000] (11/15 16:46:20.421):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.421):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'th' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('th', '4.1', '')
End
[30000] (11/15 16:46:20.421):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.421):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- &#xE02;&#xE49;&#xE2D;&#xE04;&#xE27;&#xE32;&#xE21;&#xE15;&#xE49;&#xE19;&#xE09;&#xE1A;&#xE31;&#xE1A; -----"/>
<s i="2" v="&#xE08;&#xE32;&#xE01;:"/>
<s i="3" v="&#xE2A;&#xE48;&#xE07;:"/>
<s i="4" v="&#xE16;&#xE36;&#xE07;:"/>
<s i="5" v="&#xE2A;&#xE33;&#xE40;&#xE19;&#xE32;&#xE16;&#xE36;&#xE07;:"/>
<s i="6" v="&#xE40;&#xE23;&#xE37;&#xE48;&#xE2D;&#xE07;:"/>
<s i="7" v="[&#xE04;&#xE38;&#xE13;&#xE44;&#xE21;&#xE48;&#xE44;&#xE14;&#xE49;&#xE23;&#xE31;&#xE1A;&#xE2D;&#xE19;&#xE38;&#xE0D;&#xE32;&#xE15;&#xE43;&#xE2B;&#xE49;&#xE04;&#xE31;&#xE14;&#xE25;&#xE2D;&#xE01;&#xE02;&#xE49;&#xE2D;&#xE04;&#xE27;&#xE32;&#xE21;&#xE19;&#xE35;&#xE49;]&#x0D;&#x0A;"/>
<s i="8" v="&#xE44;&#xE21;&#xE48;&#xE2A;&#xE32;&#xE21;&#xE32;&#xE23;&#xE16;&#xE04;&#xE49;&#xE19;&#xE2B;&#xE32;&#xE02;&#xE49;&#xE2D;&#xE04;&#xE27;&#xE32;&#xE21;&#xE15;&#xE49;&#xE19;&#xE09;&#xE1A;&#xE31;&#xE1A;&#xE44;&#xE14;&#x
[30000] (11/15 16:46:20.421):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.421):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'tr' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('tr', '4.1', '')
End
[30000] (11/15 16:46:20.421):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.421):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- Orijinal Mesaj -----"/>
<s i="2" v="Kimden:"/>
<s i="3" v="G&#xF6;nderme Zaman&#x131;:"/>
<s i="4" v="Kime:"/>
<s i="5" v="Bilgi:"/>
<s i="6" v="Konu:"/>
<s i="7" v="[Bu mesaj&#x131; kopyalaman&#x131;za izin verilmiyor]&#x0D;&#x0A;"/>
<s i="8" v="Orijinal mesaj bulunamad&#x131;"/>
<s i="9" v="Ek, cihaz taraf&#x131;ndan okunabilir bir bi&#xE7;ime d&#xF6;n&#xFC;&#x15F;t&#xFC;r&#xFC;lemedi"/>
<s i="10" v="Ek verileri dosyaya kaydedilemedi"/>
<s i="11" v="Ek dosyas&#x131;ndan okunamad&#x131;"/>
<s i="12" v="Daha fazla istek i&#x15F;lenirken &#xF6;zel durum ortaya &#xE7;&#x131;kt&#x131; (orijinal mesaj %lu, kullan&#x131;c&#x131; %s)"/>
<s i="13" v="[Mesaj g&#xF6;vdesinin t&#xFC;m&#xFC; al&#x131;nam&#x131;yor]"/>
<s i="14" v="[G&#xF6;nderen:"/>
<s i="15" v="[Bu mesaj, g&#xF6;nderen taraf&#x131;ndan &#x15F;ifrelendi]"/>
<s i="16" v="Mesaj&#x131;n&#x131;z:&#x0A;&#
[30000] (11/15 16:46:20.437):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.437):{0x9A0} SQL being executed:
 if not exists (select * from GlobalResource where LanguageId = 'vi' and Version = '4.1')
begin
insert into GlobalResource (LanguageId, Version, Data) values ('vi', '4.1', '')
End
[30000] (11/15 16:46:20.437):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.437):{0x9A0} SQL being executed:
 update GlobalResource set Data =
'<?xml version="1.0" encoding="UTF-8"?>
<Res>
<s i="1" v="----- Tin Nh&#x1EAF;n G&#xF4;&#x301;c -----"/>
<s i="2" v="T&#x1B0;&#x300;:"/>
<s i="3" v="Th&#x1EDD;i gian g&#x1B0;&#x309;i:"/>
<s i="4" v="&#x110;&#xEA;&#x301;n:"/>
<s i="5" v="Cc:"/>
<s i="6" v="Chu&#x309; &#x111;&#xEA;&#x300;:"/>
<s i="7" v="[Ba&#x323;n kh&#xF4;ng &#x111;&#x1B0;&#x1A1;&#x323;c phe&#x301;p sao che&#x301;p tin nh&#x1EAF;n na&#x300;y]&#x0D;&#x0A;"/>
<s i="8" v="Kh&#xF4;ng th&#xEA;&#x309; ti&#x300;m th&#xE2;&#x301;y tin nh&#x1EAF;n g&#xF4;&#x301;c"/>
<s i="9" v="Kh&#xF4;ng th&#xEA;&#x309; chuy&#xEA;&#x309;n &#x111;&#xF4;&#x309;i t&#xE2;&#x323;p tin &#x111;i&#x301;nh ke&#x300;m sang loa&#x323;i &#x111;i&#x323;nh da&#x323;ng co&#x301; th&#xEA;&#x309; &#x111;o&#x323;c &#x111;&#x1B0;&#x1A1;&#x323;c b&#x1EDF;i thi&#x1EBF;t b&#x1ECB;"/>
<s i="10" v="Kh&#xF4;ng th&#xEA;&#x309; l&#x1B0;u d&#x1B0;&#x303; li&#xEA;&#x323;u &#x111;i&#x301;nh ke&#x300;m sang
[30000] (11/15 16:46:20.437):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.437):{0x9A0} SQL being executed:
 -- INSTALL_PROGRESS_BAR=10000
[30000] (11/15 16:46:20.437):{0x9A0} SQL executed successfully
[30000] (11/15 16:46:20.437):{0x9A0} Processing file 4.1.2\LoadServiceBookTemplates.sql
[30000] (11/15 16:46:20.437):{0x9A0} Scripts loading from: D:\BES 5 SP2\Database\DBInstallScripts\SqlServer\
[30000] (11/15 16:46:20.437):{0x9A0} Replacing variables in [D:\BES 5 SP2\Database\DBInstallScripts\SqlServer\4.1.2\LoadServiceBookTemplates.sql]
[30000] (11/15 16:46:20.453):{0x9A0} Progress update 500.  Current position is 4500 of 51000 = 8%
[30000] (11/15 16:46:20.453):{0x9A0} Executing file [D:\Program Files\Installer\BES_SQL_Generated\LoadServiceBookTemplatesV121115164620.sql]
[30000] (11/15 16:46:20.453):{0x9A0} SQL being executed:
 /********************************************************************
    LoadServiceBookTemplates.sql

    SQL Script to load the service book data & application templates
    into the BESMgmt database.

    (C) 1997-2007 Research In Motion Ltd.
********************************************************************/
/*
 * Create the data template for the XML Service books
 */
UPDATE GlobalSettings SET ServiceBookDataTemplate = N'<?xml version="1.0" encoding="utf-8"?><DataTemplate><ServiceBookData version="1"><lookup_item><name>IMType</name><value type="integer"><sources><database><table type="view" base="imconfig">vimconfig</table><column>type</column></database><server_cap><service>BBIM_SB</service><element>imtype</element></server_cap></sources></value></lookup_item><lookup_item><name>MDS_ServerURL</name><value type="string"><sources><database><table type="view" base="mdsagconfig">vmdsagservicebook</table><column>deviceurl</column></database><server_
[20000] (11/15 16:46:20.453):{0x9A0} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Unable to set MDSPushMaxStoredMessages as this feature is disabled for MSDE" Native error = 50000
[20000] (11/15 16:46:20.453):{0x9A0} [CBESDBInstaller::executeRetryDDL] SQL Error for:
/********************************************************************
    LoadServiceBookTemplates.sql

    SQL Script to load the service book data & application templates
    into the BESMgmt database.

    (C) 1997-2007 Research In Motion Ltd.
********************************************************************/
/*
 * Create the data template for the XML Service books
 */
UPDATE GlobalSettings SET ServiceBookDataTemplate = N'<?xml version="1.0" encoding="utf-8"?><DataTemplate><ServiceBookData version="1"><lookup_item><name>IMType</name><value type="integer"><sources><database><table type="view" base="imconfig">vimconfig</table><column>type</column></database><server_cap><service>BBIM_SB</service><element>imtype</element></server_cap></sources></value></lookup_item><lookup_item><name>MDS_ServerURL</name><value type="string"><sources><database><table type="view" base="mdsagconfig">vmdsagservicebook</table><column>deviceur
[10000] (11/15 16:46:20.453):{0x9A0} An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement.
[30000] (11/15 16:46:20.546):{0xB58} <3>Nov 15 16:46:20 bbeserver  {0xAC8} 0353: (#10000) [PIPTOOL]: Pause banner animation (CaptionedMessageBox) for CDBInfoDlg
[30000] (11/15 16:46:22.984):{0xB58} <3>Nov 15 16:46:22 bbeserver  {0xAC8} 0354: (#10000) [PIPTOOL]: Play banner animation (CaptionedMessageBox) for CDBInfoDlg
[30000] (11/15 16:46:24.406):{0xB58} <3>Nov 15 16:46:24 bbeserver  {0xAC8} 0355: (#10000) [PIPTOOL]: Pause banner animation (CaptionedMessageBox) for CDBInfoDlg
[30000] (11/15 16:46:25.484):{0xB58} <3>Nov 15 16:46:25 bbeserver  {0xAC8} 0356: (#10000) [PIPTOOL]: Play banner animation (CaptionedMessageBox) for CDBInfoDlg
[30000] (11/15 16:46:25.484):{0xB58} <5>Nov 15 16:46:25 bbeserver  {0xAC8} 0357: (#30000) [PIPTOOL]: Cancelling PIPTool from CDBInfoDlg.
[30000] (11/15 16:46:25.484):{0xB58} <3>Nov 15 16:46:25 bbeserver  {0xAC8} 0358: (#10000) [PIPTOOL]: Executing stop from CDBInfoDlg.
[40000] (11/15 16:46:25.484):{0xB58} LogReceiver: Code on closing = 10038
[30000] (11/15 16:46:25.484):{0xB58} [DIAG] EVENT=Unregister_thread, THREADID=0xB58, THREADNAME="InstLogReceiver"

 

TiA

Forums Advisor III
Posts: 1,173
Registered: ‎08-29-2008
My Device: Blackberry Classic
My Carrier: Swisscom

Re: BES upgrade error - An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement

The problem seems to be:

 

  • "Unable to set MDSPushMaxStoredMessages as this feature is disabled for MSDE"

 

Are you using MSDE as a Database? That should be upgraded.

 

Also, see section 11 of KB03569:

 

http://btsc.webapps.blackberry.com/btsc/viewContent.do?externalId=KB03569&sliceId=1

 

 

New Developer
Posts: 68
Registered: ‎04-16-2009
My Device: Not Specified

Re: BES upgrade error - An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement

Thanks for your reply Freakinvibe,

 

BES database is local and its on MS SQL server 2005,  but one thing might be worth mentioning that I had performed cutover migration 2 years back from other hardware machine to this.

Forums Advisor III
Posts: 1,173
Registered: ‎08-29-2008
My Device: Blackberry Classic
My Carrier: Swisscom

Re: BES upgrade error - An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement

To resolve this issue, update the MDSPushMaxStoredMessages column to a value of zero in the GlobalSettings table of the BlackBerry Configuration Database. At the command prompt, type the following commands in the specified order:

osql -S <BlackBerry_Enterprise_Server_name> -E

1> use <database>

2> go

1> update globalsettings set MDSPushMaxStoredMessages = 0

2> go

 

Be sure to make a backup of the DB beforehand.

Guru III
Posts: 31,431
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BES upgrade error - An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement

Not sure if realted but 4.1.6 should be upgraded to SP7 before going to BES 5

 

 

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


New Developer
Posts: 68
Registered: ‎04-16-2009
My Device: Not Specified

Re: BES upgrade error - An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement

As per RIM BES 4.1.6 can be upgraded to BES 5 SP2 at a maximum.