Featured Post

Dynamics GP 2016 R2 is Now Available .. and #MSDynGP will Always be Avilable

The Microsoft Dynamics GP team announced today that Microsoft Dynamics GP 2016 R2 has released . Dynamics GP 2016 R2 continues the grea...

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

1 comment:

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

    ReplyDelete