Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Error when running OM Sales Journal Report (40690)

Posted on by 1,615

Hi there,

I have done a test upgrade of a client to SL2011.  When running the Sales Journal report (40690), I get the System Message 10205. Cannot perform requested operation on a row in the specified cursor. No current row has been set.  SQL SOSetup_all '0'

The report then still prints but I want to try and get rid of this error.

Can anyone tell me what this is?

*This post is locked for comments

  • Jo Wykerd Profile Picture
    Jo Wykerd 1,615 on at
    RE: Error when running OM Sales Journal Report (40690)

    Hi Cory,

    Yes I was getting the error with the standard report but I have actually fixed the error now.  Somehow the table SOSETUP had no index so I created it and it works fine now.

    Thank you for your reply

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error when running OM Sales Journal Report (40690)

    Hi Jo Wykerd,

    I am wondering if you receive the same message using the standard report. If you do not receive the System Message then it is an issue with the custom report.

    If the standard report work without issue you may want to custom the report once again, and test after each alteration. This way you will be able to determine which customization caused the issue.

    If the standard report still throws the error, you can try doing a SQL trace to figure out more information. You should be able to see the error within the trace.

    Here is a link for downloading the template that you will want to use:

    967955 How to use SQL Profiler in SQL Server 2008 and SQL Server 2008 R2 to trace database events in Microsoft Dynamics SL

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

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans