Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / DBMS: 515 Error me...
Microsoft Dynamics GP (Archived)

DBMS: 515 Error message

(0) ShareShare
ReportReport
Posted on by Community Member

Good day all:

 Here is my issue of the day...

I have a GP user that is getting an error message when they go to do a "receivables transaction inquiry" by customer in Dynamics 10.

Details:

Only occurs in this one company and only for this one user, tried a different user and no errors.

So when this user goes to run a "receivables transaction inquiry by customer" and inputs the customer number and then tabs out to see the results they get the following error:

[Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'ORTRXAMT',table 'tempdb.dbo.##1760642', column does not allow nulls. INSERT fails.

 =============================================================================

Then the following appears right after that error message:

The stored procedure rmTransactionInquiry returned the following results: DBMS 515, Microsoft Dynamics GP: 0.

===================================================================================

Here is the weird part..This only occurs for this one user login in this one company, and nobody else has any issues doing a customer inquiry...Plus this user has the same issue on any workstation they use....

If anyone has heard or seen this issue before it would be greatly appreciated to have some kind of answer as to why this is happening...

Thanks

*This post is locked for comments

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,267 on at
    RE: DBMS: 515 Error message

    Hello Lisa,

    FYI- I was able to resolve the issue.  One of the Multi Currency transaction was not found in 'MC020102' table.  I have deleted original transaction and recreated.  No more error.

    Thanks much

    Sandip

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,267 on at
    RE: DBMS: 515 Error message

    Hello Lisa,

    Much appreciated for your quick response.  We do have MultiCurrency Module registered.  So the above solution won't going to help.

    Any other suggestions?

    Thanks much

    Sandip

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 604 on at
    RE: DBMS: 515 Error message

    If the keyboard shortcuts I mentioned earlier in this discussion don't work, the information in this blog helped for a client with a multi-currency error (but not DBMS error) when trying to print:

    You must be viewing by Functional or Originating currency to print a document error - Dynamics GP | Microsoft Learn

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,267 on at
    RE: DBMS: 515 Error message

    Hello, How you found the missing record?  Any help on this issue? I am getting the exact error as below:

    pastedimage1665434273310v1.png

    Thanks much
    Sandip

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: DBMS: 515 Error message

    I had this issue occur today and ran a SQL trace.   I found that there was a missing record in the MC020102 table.  I inserted the missing record and the error no longer occurs for either currency view, functional or originating.

  • Syrus Profile Picture
    Syrus 4,156 on at
    RE: DBMS: 515 Error message

    Amazing, started in 2009 and until 2016 (7 years) the issue still exists and people have to ask for help while Microsoft did not try to fix this, neither a reason why it can't be resolved.

  • Community Member Profile Picture
    Community Member on at
    RE: DBMS: 515 Error message

    If you are not using multi-currency and having the user press Control-R doesn't fix the issue, you should be able to use the script below to tell the system to display the information for this user in the reporting currency (run this against the company database, substituting the actual user's ID):

    update MC40500

    set viewtype=3

    where viewtype<>3 and userid='user1'

  • Brian Girard Profile Picture
    Brian Girard 440 on at
    RE: DBMS: 515 Error message

    Can you send me the sql script to change the VIEWTYPE? Thank you.

  • Community Member Profile Picture
    Community Member on at
    RE: DBMS: 515 Error message

    Thanks Allen, that fixed it for me too.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: DBMS: 515 Error message

    Lisa Blair - your solution was spot on for me. We're running 2015R2. The user doesn't use keyboard short cuts, but I suspected she hit the keys inadvertently while doing something else. Sure enough...we brought up the inquiry, we clicked through the error message, hit the ctrl+R key and the results displayed as normal.

    Thank you so very much!

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,403 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans