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

Reply
Contributor
AndreasP
Posts: 17
Registered: ‎04-07-2011
My Device: Bold 9780

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

Please use plain text.
New Contributor
Erwann
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.

Please use plain text.
Guru III
knottyrope
Posts: 30,622
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless 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


Please use plain text.
New Contributor
itsnag
Posts: 2
Registered: ‎03-08-2013
My Device: bold9700

Re: BMSStore Database growing exponentially

is your issue resolved? i am also experiencing same issue while performing this
Please use plain text.
New Contributor
itsnag
Posts: 2
Registered: ‎03-08-2013
My Device: bold9700

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)

Please use plain text.