Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
KB12463 - Wireless application push fails and displays: Transaction Id already queued
 
  #1 (permalink)  
Old 06-23-2009, 11:15 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default 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} {[email protected], 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:
  1. Back up the BlackBerry Configuration Database.
  2. 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/
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 08-03-2009, 06:09 AM
BES Activated
 
Join Date: Aug 2009
Location: India
Posts: 2
Post "Transaction Id already queued for package ###"

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
Reply With Quote
  #3 (permalink)  
Old 08-03-2009, 11:09 AM
BES Activated
 
Join Date: Aug 2009
Location: India
Posts: 2
Wink Issue is resolved

My issue is resolved.

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

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
BES 4.0.7.13 Application Push Issue robcpeters Port 3101: The BES Admin Bar & Grill 7 05-26-2010 11:46 AM
KB14348 - Application push does not complete due to missing entries in the device.xml hdawg Featured BlackBerry KB Articles 1 09-02-2009 10:43 PM
how to prevent carrier to push application download siffleu Port 3101: The BES Admin Bar & Grill 9 07-15-2009 06:12 PM
KB15782 - Software configuration push fails due to BlackBerry Policy Service warning hdawg Featured BlackBerry KB Articles 1 05-26-2009 10:36 AM
KB17725 - BlackBerry Manager displays incorrect Application Status message hdawg Featured BlackBerry KB Articles 0 05-26-2009 12:06 AM


All times are GMT -4. The time now is 09:21 PM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2019, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2