06-24-2009, 12:15 AM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,237
|
|
KB12463 - Wireless application push fails and displays: Transaction Id already queued
KB12463 - Wireless application push fails and displays "Transaction Id already queued for package" in the BlackBerry Policy Service log
Environment
- BlackBerry® Enterprise Server software version 4.1
- SDR102314
- SDR145833
- SDR154894
Overview
The wireless application push fails for all BlackBerry smartphone users. The BlackBerry Policy Service log(POLC) displays the following: [40000] (01/01 00:00:00):{0x970} {user@domain.com, PIN: XXXXXXXX, ID:4}RequestHandler::PollForMissingApps - Transaction Id already queued for package .
Cause
This issue may be caused by the GroupingNumber value in the ITAdminQueue table exceeding the maximum allowed integer value. This will result in negative values in the GroupingNumber field.
To check if this is the case, perform the following Structured Query Language (SQL) query: SELECT * FROM ITAdminQueue WHERE (GroupingNumber < 0)
If the query returns results with a negative GroupingNumber, complete the resolution or workaround specified below.
Resolution
Note: The following upgrades will fix new instances of negative grouping numbers. For any existing instances, the workaround should still be used.
To resolve this issue upgrade the BlackBerry Enterprise Server software to:
- BlackBerry® Enterprise Server 4.1 Service Pack 4 Maintenance Release 4 (4.1.4 MR4) or later for Microsoft® Exchange
- BlackBerry® Enterprise Server 4.1 Service Pack 4 Maintenance Release 3 (4.1.4 MR3) or later for IBM® Lotus® Domino®
Workaround
To workaround this issue, clear all pending transactions in the BlackBerry Configuration Database by completing the following steps:
- Back up the BlackBerry Configuration Database.
- Use the following SQL script to clear the pending transactions queue:
For BlackBerry Enterprise Server 4.1.3 and earlier
UPDATE ITAdminqueue SET GroupingNumber=0 WHERE command=3
DELETE FROM ITAdminQueue WHERE GroupingNumber <> 0
For BlackBerry Enterprise Server 4.1.4 and later
UPDATE syncserverstate SET State =1 WHERE Type ='PolicyServerLastGroupingNumber'
DELETE FROM ITAdminqueue WHERE GroupingNumber <> 0 The application push process will continue on the next configured polling interval.
__________________
http://blog.port3101.org/hdawg/
The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.
|