Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

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

(0) ShareShare
ReportReport
Posted on by

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
    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
    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
    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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans