Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Friday, June 19, 2015

Analytical Accounting Distribution Query Wizard "Login Failed for User" - Resolved with GP 2015 R2


We have witnessed an issue with the analytical accounting module when using the "Distribution Query Wizard", apparently this inquiry works only for the "sa" user and it gives a login failed error for any other user, including DYNSA or even a user with database sys admin role. Pretty interesting isn't it ?

Symptoms: 
You configure the distribution query wizard going through the steps to create a dynamic analytical accounting report with the "sa" user. The query can be tested and exported perfectly without a single issue. 
Once trying to either create a new query or execute an existing one with any other user than the "sa", the query maintenance crashes while processing and gives the following error.



Query Maintenance Wizard Processing - Error  

  "Unhandled object exception:
[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'xxx'.

EXCEPTION_CLASS_OBJECT_EXCEPTION
ExceptionSubClass:-2147217843
"

"Unhandled object exception:
Operation is not allowed when the object is closed.

EXCEPTION_CLASS_OBJECT_EXCEPTION
ExceptionSubClass:-2146824584
            "

I have tested the exact same case on both GP 2015 RTM (14.00.0524) and March Hotfix (14.00.0061) with the same login failed error.

Resolution 
The resolution has seen the light with the release of GP 2015 R2 (14.00.0724) , it is mentioned in the product customer source, Service Pack, Hotfix, and Compliance Update Patch Releases forMicrosoft Dynamics GP 2015 

Dynamics GP 2015 Fix List - Analytical Accounting

Best Regards, 
Mahmoud M. AlSaadi

2 comments:

  1. Unfortunately, I am getting this message on 14.00.0898.

    ReplyDelete
  2. BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
    you can be to get the new PROGRAMMED blank ATM card that is capable of
    hacking into any ATM machine,anywhere in the world. I got to know about 
    this BLANK ATM CARD when I was searching for job online about a month 
    ago..It has really changed my life for good and now I can say I'm rich and 
    I can never be poor again. The least money I get in a day with it is about 
    $50,000.(fifty thousand USD) Every now and then I keeping pumping money 
    into my account. Though is illegal,there is no risk of being caught 
    ,because it has been programmed in such a way that it is not traceable,it 
    also has a technique that makes it impossible for the CCTVs to detect 
    you..For details on how to get yours today, email the hackers on : (
    atmmachinehackers1@gmail.com ). Tell your 
    loved once too, and start to live large. That's the simple testimony of how 
    my life changed for good...Love you all ...the email address again is ;
    atmmachinehackers1@gmail.com

    ReplyDelete