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


Thank you for visiting the BlackBerry Support Community Forums.

BlackBerry will be closing the BlackBerry Support Community Forums Device Forums on April 1st (Developers, see below)

BlackBerry remains committed to providing excellent customer support to our customers. We are delighted to direct you to the CrackBerry Forums, a well-established and thorough support channel, for continued BlackBerry support. Please visit http://forums.crackberry.com or http://crackberry.com/ask. You can also continue to visit BlackBerry Support or the BlackBerry Knowledge Base for official support options available for your BlackBerry Smartphone.

"When we launched CrackBerry.com 10 years ago, we set out to make it a fun and useful destination where BlackBerry Smartphone owners could share their excitement and learn to unleash the full potential of their BlackBerry. A decade later, the CrackBerry community is as active and passionate as ever and I know our knowledgeable members and volunteers will be excited to welcome and assist more BlackBerry owners with their questions."

- Kevin Michaluk, Founder, CrackBerry.com

Developers, for more information about the BlackBerry Developer Community please review Join the Conversation on the BlackBerry Developer Community Forums found on Inside BlackBerry.


Reply
Contributor
Posts: 17
Registered: ‎04-07-2011
My Device: Bold 9780
My Carrier: T-Mobile DE

Re: BMSStore Database growing exponentially

[ Edited ]

Got warning message by mail that database is at 2.6GB. I tried to shrink the database as mentioned in the KB article.

The result ist kinda funny:

 

C:\Program Files (x86)\Research In Motion\BlackBerry Enterprise Server\Monitoring Service\tools>dcs_agent.exe trim
Traceback (most recent call last):
  File "dcs_agent.py", line 151, in <module>
  File "dcs_agent.py", line 148, in main
  File "dcs_agent.py", line 105, in run
  File "common\db\db.pyo", line 114, in execute
  File "common\db\db.pyo", line 90, in _run
  File "common\db\db_connection_manager.pyo", line 368, in run
  File "C:\Users\user\AppData\Local\Temp\3\gen_py\2.5\B691E011-1797-432E-907A-4D8C69339129x0x6x1.py", line 3278, in Execute
    , Parameters, Options)
  File "win32com\client\__init__.pyo", line 448, in _ApplyTypes_
pywintypes.com_error: (-2147352567, 'Ausnahmefehler aufgetreten.', (0, 'Microsoft SQL Native Client', 'Query timeout expired', None, 0, -214
7217871), None)

 

Now the datase is 3.7GB instead of being smaller.

The registry key "TargetSize" is set to 1280

New Contributor
Posts: 2
Registered: ‎07-02-2012
My Device: non-BlackBerry user

Re: BMSStore Database growing exponentially

Thanks knottyrope, I applied your solution, everything is fine now.

Guru III
Posts: 32,249
Registered: ‎06-25-2008
My Device:

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

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

Re: BMSStore Database growing exponentially


Erwann wrote:

Thanks knottyrope, I applied your solution, everything is fine now.


glad to hear it

 




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 Contributor
Posts: 2
Registered: ‎03-08-2013
My Device: bold9700
My Carrier: airtel

Re: BMSStore Database growing exponentially

is your issue resolved? i am also experiencing same issue while performing this
New Contributor
Posts: 2
Registered: ‎03-08-2013
My Device: bold9700
My Carrier: airtel

Re: BMSStore Database growing exponentially

we are executing it on bes 5.0 1

but got this output...

 

 

File "C:\DOCUME~1\SVC_BB~1\LOCALS~1\Temp\1\gen_py\2.5\2A75196C-D9EB-4129-B803-931327F72D5Cx0x2x8.py", line 1997, in Ex

ecute    , Parameters, Options)

  File "win32com\client\__init__.pyo", line 448, in _ApplyTypes_

pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, 'Microsoft SQL Native Client', 'Query timeout expired', None, 0, -2147217871), None)