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
[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
"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
Unfortunately, I am getting this message on 14.00.0898.
ReplyDeleteBE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast
ReplyDeleteyou 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