KB12463 - Wireless application push fails and displays: Transaction Id already queued

hdawg · #1 (**permalink**) 06-24-2009, 12:15 AM

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.

hemant · #2 (**permalink**) 08-03-2009, 07:09 AM

Hello Mr. E,
I am also having the same Issue "Transaction Id already queued for package ###".

I am using BES 4.1.3.
And I tried to run the query suggested by you.
UPDATE ITAdminqueue SET GroupingNumber=0 WHERE command=3
-- Result -- No row affected
DELETE FROM ITAdminQueue WHERE GroupingNumber <> 0
-- Result -- Some number of rows affected

Again, after some time when BES poll for Missing Apps. POLC log again shows
"Transaction Id already queued for package ###"

Any idea what may be going wrong here?

Thanks and appreciate your reply,
Hemant

hemant · #3 (**permalink**) 08-03-2009, 12:09 PM

My issue is resolved.

Issue was, the BB user had removed the SIM card from the device.

Follow Us On

Forum Sponsors

Google Advertisements