News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) The operation is not v...

Microsoft Dynamics GP (Archived)

The operation is not valid for the state of the transaction.

(0) Share

Report

Report

Posted on by Matt Reamy

I keep getting this message: The operation is not valid for the state of the transaction.

It doesn't happen consistently. I'm importing product data from an old Database to GP 2010. Each time I run the app, this message appears, but not always in the same place or the same number of times.

I did a web search and saw that it might be the timeout, but I've added:

<

system.transactions><machineSettings maxTimeout="0:00:00"/></system.transactions>

to my .NET machine config as suggested in the results, but it didn't make a difference.

Any suggestions would be appreciated.

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: The operation is not valid for the state of the transaction.

You must have MSDTC configured on both the server and desktop and that the desktop should also be set to accept incoming transactions and a user who has sql server priveleges...I used a service account that has domain admin priveleges to be on the safe side. As soon as I properly configured the MSDTC on the client, it started to work as expected.

community.dynamics.com/.../61340
Community Member Microsoft Employee on at

Like (0)

Report

RE: The operation is not valid for the state of the transaction.

Did you ever get this resolved???

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans