Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Dynamics SL (Solomon) > SL - Installation and Administration
  New Posts New Posts RSS Feed - SQL Assertion Failure
  FAQ FAQ  Forum Search   Register Register  Login Login


SQL Assertion Failure

 Post Reply Post Reply
Author
Message
microdynsol17 View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: August 16 2012
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote microdynsol17 Quote  Post ReplyReply Direct Link To This Post Topic: SQL Assertion Failure
    Posted: August 16 2012 at 10:10am
We are using Microsoft Dynamics 2011 and all users are getting System Message 10232, SQL assertion failure multiple times per day.  Once this message is received, the user is no longer able to connect to the database and only a reboot will allow the user to work again. 
 
Our consultant has been no help in this matter and we are left with multiple reboots per day. 
 
Can you give me any direction to attempt to troublshoot these errors?
 
I am suspecting it is due to customized screens.  How can I find what customizations are causing the problems? 
 
Then I can go back to my consultant and tell them that it is their customizations that are causing the problems in the first place.
Back to Top
Sponsored Links


Back to Top
syng83 View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: May 05 2006
Status: Offline
Points: 16
Post Options Post Options   Thanks (0) Thanks(0)   Quote syng83 Quote  Post ReplyReply Direct Link To This Post Posted: August 17 2012 at 8:37am
1. Is this happen on all PC?
2. have try uninstall the SL 2011, and clear the folder and install again?
3. Is using SL 2011 or SL 2011 SP1?
4. It happen on one screen or all the screen?
5. Is standard screen + customization? or new screen?
6. if is standard screen, what is the screen name & number.
7. the screen contain grid?


Back to Top
microdynsol17 View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: August 16 2012
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote microdynsol17 Quote  Post ReplyReply Direct Link To This Post Posted: August 17 2012 at 8:54am
1.  Yes, happens on all PCs.
2.  I just did a new clean install this week on my PC and cleared out the folder before installing again.  Have needed to reboot after message twice this week, which is better than the last several weeks with multiple reboots in a day. 
3.  Here is the version - 8.01.21108.01
4.  Happens on variety of screens
5.  Appears to be customized screen.  Reboot is always required after it happens as you can't switch to standard and check.  Hard to test in standard since we need the customized screen to enter data. 
7.  Yes, many of our screens contain grids. 
 
I appreciate your time and any suggestions you may have. 
Back to Top
syng83 View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: May 05 2006
Status: Offline
Points: 16
Post Options Post Options   Thanks (0) Thanks(0)   Quote syng83 Quote  Post ReplyReply Direct Link To This Post Posted: August 17 2012 at 9:11am

did you install any hotfix after install the SL 2011 with SP1?

if no, maybe you can ask your consultant any hotfixes can apply?


because i had faced some problem on customization. but after apply following hotfixes.
the problems were solved.


23997

2652870

HSL2011SP1_24026SY

12/7/2011

Fields are no longer visible in grid view when a screen is customized

24401

2733768

HSL2011SP1_24401ALL

7/10/2012

A shipper is not created if a Sales Order is bound to a Purchase Order and there are both stock and non-stock items on the order

Microsoft Dynamics SL 2011 Service Pack 1 (SP1)

Changed filesDateFile version
0425000.exe15-Mar-20128.01.30315.00
0460000.exe15-Mar-20128.01.30315.00
1225000.exe15-Mar-20128.01.30315.00
4010000.exe15-Mar-20128.01.30315.00
4011000.exe15-Mar-20128.01.30315.00
4011500.exe15-Mar-20128.01.30315.00
4011700.exe15-Mar-20128.01.30315.00
4017000.exe15-Mar-20128.01.30315.00
4040000.exe15-Mar-20128.01.30315.00
4060000.exe15-Mar-20128.01.30315.00
4060001.exe15-Mar-20128.01.30315.00
4061000.exe15-Mar-20128.01.30315.00
4061001.exe15-Mar-20128.01.30315.00
4069002.exe15-Mar-20128.01.30315.00
SD64100.exe15-Mar-20128.01.30315.00
SD64200.exe15-Mar-20128.01.30315.00
SD65100.exe15-Mar-20128.01.30315.00
SN64100.exe15-Mar-20128.01.30315.00
SN64200.exe15-Mar-20128.01.30315.00
SN65100.exe15-Mar-20128.01.30315.00
0801000.exe15-Mar-20128.01.30315.00
0860010.exe15-Mar-20128.01.30315.00
0876010.exe15-Mar-20128.01.30315.00
2101000.exe15-Mar-20128.01.30315.00
2120000.exe15-Mar-20128.01.30315.00
4440100.exe15-Mar-20128.01.30315.00
4440500.exe15-Mar-20128.01.30315.00
4440700.exe15-Mar-20128.01.30315.00
6040000.exe15-Mar-20128.01.30315.00
5040200.exe15-Mar-20128.01.30315.00
5040500.exe15-Mar-20128.01.30315.00
BICNP00.exe15-Mar-20128.01.30315.00
BIINV00.exe15-Mar-20128.01.30315.00
BUBRM00.exe15-Mar-20128.01.30315.00
BUINQ00.exe15-Mar-20128.01.30315.00
CNCON00.exe15-Mar-20128.01.30315.00
CNSTE00.exe15-Mar-20128.01.30315.00
CNSUB00.exe15-Mar-20128.01.30315.00
IQPAS00.exe15-Mar-20128.01.30315.00
PAPND00.exe15-Mar-20128.01.30315.00
PAPRJ00.exe15-Mar-20128.01.30315.00
Bug23970OM.sql01-Dec-2011







Back to Top
microdynsol17 View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: August 16 2012
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote microdynsol17 Quote  Post ReplyReply Direct Link To This Post Posted: August 17 2012 at 9:14am
I appreciate your information.
 
I will research those hotfixes and will see if we find any improvements. 
 
Thanks.
Back to Top
syng83 View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com Member


Joined: May 05 2006
Status: Offline
Points: 16
Post Options Post Options   Thanks (0) Thanks(0)   Quote syng83 Quote  Post ReplyReply Direct Link To This Post Posted: August 17 2012 at 9:18am
:) welcome.


i just remember has another hotfix maybe you will need it. 

23978

2648444

HSL2011SP1_23978SY

11/23/2011

You cannot enter or save today's date in a date field where the date does not default


hope these information can help you to solve the problem.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down


Copyright 2013 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com