BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-08-2008, 10:59 AM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Jan 2007
Location: Tallahassee, FL USA
Model: 8830
Carrier: Verizon Wireless
Posts: 104
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Unable to save update to user statistics

Please Login to Remove!

Recently upgraded to SP6. Today I tried "Clear Statistics" from BB Manager and it gives a pop-up window with the error: Unable to save update to user statistics.
MNGR log has the following:
"SQL error: [0x80004005 Error executing extended stored procedure: Invalid number of parameters."
Any ideas what the problem/fix is?
Thanks!
__________________
Jose
BES 4.1.6, Domino 6.5.4, remote SQL2005
Offline  
Old 08-08-2008, 10:05 PM   #2 (permalink)
CrackBerry Addict
 
ashworth's Avatar
 
Join Date: Jun 2006
Location: Ontario, Canada
Model: 9000
OS: 4.6
Carrier: Rogers
Posts: 625
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

hmmm I would try it on another user and if you are able to repro with another user then go back to the first user and see if you can repro the issue.

If you can then I would call RIM support as it sounds like a bug... "Invalid number of parameters". Also does it clear the stats for the user???
__________________
Cheers,
Ash


My BlackBerry GPS Golf Application | Mileage Calculator
Offline  
Old 08-11-2008, 08:37 AM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Jan 2007
Location: Tallahassee, FL USA
Model: 8830
Carrier: Verizon Wireless
Posts: 104
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi, Ash,
Tried on several users - same error. Error is only with clearing user stats and it does NOT clear the stats.
I'm able to add and delete users without problems as well as clearing SERVER stats OK.
Contacted RIM (we have Tx1). So far only in the stages of answering some questions (BB Manager local on server or remote? answer=local) - then try remote and see if problem also happens - will install remote and try it.
We upgraded from 4.1.4 to 4.1.6 if that has anything to do with it.
Regards,
__________________
Jose
BES 4.1.6, Domino 6.5.4, remote SQL2005

Last edited by JGonzalezGUS : 08-11-2008 at 08:39 AM.
Offline  
Old 08-11-2008, 01:05 PM   #4 (permalink)
CrackBerry Addict
 
ashworth's Avatar
 
Join Date: Jun 2006
Location: Ontario, Canada
Model: 9000
OS: 4.6
Carrier: Rogers
Posts: 625
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hmmm maybe also bump up the MNGR logging to level 7 (via the registry) it will log all of the DB calls...
__________________
Cheers,
Ash


My BlackBerry GPS Golf Application | Mileage Calculator
Offline  
Old 08-11-2008, 04:01 PM   #5 (permalink)
Thumbs Must Hurt
 
Join Date: Jan 2007
Location: Tallahassee, FL USA
Model: 8830
Carrier: Verizon Wireless
Posts: 104
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Just tried your suggestions, Ash. I changed DebugLogLevel to 7 for Manager. Started Manager, tried Clear Stats (user) and closed Manager, then changed log level back to 3.
Nothing additional of interest: a bunch of SQL select, data = and ADO return success. Then the same errors (Error executing extended stored procedure: Invalid number of parameters...".
By the way, I installed BB Manager on my workstation (XP with SP3) as Tx1 suggested and tried it there; same error, it happens both on the local server and remote Manager.
I'm waiting to hear back from Tx1.
Regards,
__________________
Jose
BES 4.1.6, Domino 6.5.4, remote SQL2005
Offline  
Old 08-11-2008, 09:10 PM   #6 (permalink)
CrackBerry Addict
 
ashworth's Avatar
 
Join Date: Jun 2006
Location: Ontario, Canada
Model: 9000
OS: 4.6
Carrier: Rogers
Posts: 625
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

hmmmm I tested this on my server and it worked fine but I'm an Exchange shop... and I see in your sig your Domino...

Unless it is something wrong in your DB.

Anywone else running BESD 4.1.6 can you try to clear stats for a user to see if you can repro the issue?
__________________
Cheers,
Ash


My BlackBerry GPS Golf Application | Mileage Calculator
Offline  
Old 08-12-2008, 02:39 AM   #7 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by ashworth View Post
hmmmm I tested this on my server and it worked fine but I'm an Exchange shop... and I see in your sig your Domino...

Unless it is something wrong in your DB.

Anywone else running BESD 4.1.6 can you try to clear stats for a user to see if you can repro the issue?
BESD 4.1.4, yes I know it's not 4.1.6, clear stats worked fine for me from a remote Manager on my desktop. Haven't done the upgrade to 4.1.6 yet.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 08-14-2008, 04:00 PM   #8 (permalink)
Thumbs Must Hurt
 
Join Date: Jan 2007
Location: Tallahassee, FL USA
Model: 8830
Carrier: Verizon Wireless
Posts: 104
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks.
DavidAdams, let me know after you upgrade to 4.1.6 - we upgraded from 4.1.4 and this problem started after the upgrade to 4.1.6.
I discovered that if I "clear stats" for the same user a second time, then I don't get the error and the stat DO clear OK.
__________________
Jose
BES 4.1.6, Domino 6.5.4, remote SQL2005
Offline  
Closed Thread


Thread Tools

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

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





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.