Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

error in OM Sales Journal SL 2011 stating odbcStmtHandle!=SQL_NULL_HSTMT

Posted on by Microsoft Employee

When running OM Sales Journal System message 10232 with message

odbcStmTHandle != SQL_NULL_HSTMT

contact Microsoft with an eventlog

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: error in OM Sales Journal SL 2011 stating odbcStmtHandle!=SQL_NULL_HSTMT

    I was getting this error as well running the Sales Journal - the mentioned KB did not help me out.  The error expression was *pcursor> 0 and *pcursor <= MAXCURSORS.

    However, on reviewing the Event Log the error message indicated inadequate permissions on the view vs_SubXref.  I corrected this issue but the odd thing is this was in a test DB - a copy of the production DB - and in the production DB the permissions were different.  

    Hope this helps someone else.

    -Katherine

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: error in OM Sales Journal SL 2011 stating odbcStmtHandle!=SQL_NULL_HSTMT

    Hey Bo Boaz -- Long time no talk. Can't belive I'm finding you on this forum because I have the same error message when running a Sales Journal. Did you get this resolved?

  • Rachel Moore Profile Picture
    Rachel Moore on at
    Re: error in OM Sales Journal SL 2011 stating odbcStmtHandle!=SQL_NULL_HSTMT

    Hello Bo,

    I was able to find a KB article relating to this error

    871319

    Error message in various screens in Microsoft Dynamics SL: "System Message 10232 - Assertion failure"

    mbs.microsoft.com/.../KBDisplay.aspx

    I hope this helps your issue.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans