System Message 10232

(0) Share

Report

Posted on by Cynthia Audain

1,348

I have just recently upgraded to Dynamics SL 2015 and on clicking off a customized screen I kept getting an assertion failure with the exact message as below:

System Message 10232

Assertion failure

File: sqlodbc.cpp

Line 9014

I am able to access the screen and run processes in standard mode, so it seems that the customization is the problem. Therefore, I removed the customization from the CustomVBA table and recreated the customization but I am still getting the same error message.

Has anyone experienced the same and found a solution for this issue?

Any suggestion will be greatly appreciated.

Regards

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

Lisa,

I have run into this same error in the past with screens created with the SL SDK (not quite the same as your issue) and found that the issue was resolved by checking if the Windows firewall is enabled on the server (not the workstation). If so, I let sqlserver.exe through the firewall and the issue went away.

This is a bit of a long short for your situation but something you might want to look at.

Was this reply helpful? Yes No
Cynthia Audain 1,348 on at

Like (0)

Report

Hi Rick

Thanks for the response. The windows firewall is enabled so I do not believe that, that is the problem. However, in doing some further research I realized that the vba code is what is giving some problems albeit on another screen.

I am getting some compilation errors after upgrading to 2015 and it is throwing the assertion error messages and system message 20217.

The below code worked fine in Dynamics 7.0 but for some reason it is not compiling in 2015 and it is pointing to "Dim CusType As CustomerType in the code as the error.

Coding is not my expertise, therefore could you throw some light on how to correct this code? Thanks for your help and suggestions.

Private Sub ccustid_0_Chk(ChkStrg As String, retval As Integer)

Dim SqlStr As String

Dim CustType As CustomerType

SqlStr = "Select User5 from Customer where custid = " + SParm(ChkStrg)

serr1 = SqlFetch1(c1, SqlStr, CustType, LenB(CustType))

CustStatus = Trim(CustType.ShowOnlyCost)

End Sub

Regards

Was this reply helpful? Yes No
Verified answer

Ram Peru 2,830 on at

Like (0)

Report
Hello Lisa,

I think CustomerType definition is missing in your customization. please follow the below steps to identify issue.

place the cursor in CustomerType

right mouse click on the CustomerType

System will open popup window

Click the definition

It will bring you to definition of CustomerType. If not, CustomerType definition is missing in your customization

You may have to add the CustomerType definition in VBA code like below

you will see the project properties on the Left side of VBA Editor

will see "Modules" and right click on Modules

go to Insert option and click Module

system will add Module1 and open the module1

Add the below code

Option Explicit

Type CustomerType
ShowOnlyCost As String * 10
End Type

Public bCustomerType As CustomerType, nCustomerType As CustomerType

Save the customization

Hope this will help. please let me know how it goes.

Was this reply helpful? Yes No
Cynthia Audain 1,348 on at

Like (0)

Report

Thanks Perumalsamy,

I was able to fix more than one customization in 2015.

Do you know what has changed from 7.0 to 2015, since the customizations were all working in 7.0? Is there a bug in VBA for 2015?

Regards

Was this reply helpful? Yes No
Ram Peru 2,830 on at

Like (0)

Report

Lisa,

I don't think VBA has bug. Sometimes your system upgrade has not been successfully completed. That may the reason behind this issue. And more thing you have to keep in mind about BSL customization while upgrading into SL 2015 since SL 2015 is the last version to support BSL customization. upcoming version of SL won't support BSL customization. This is for your kind information.

Was this reply helpful? Yes No