News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX forum The fetch type refresh...

Microsoft Dynamics AX forum

Answered

The fetch type refresh cannot be used with forward only cursors.

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hello all,

On my production environment I get the following error opening the Fixed Assets (AssetTable) form:

Cannot execute the required database operation.
The operation failed.

[Microsoft][SQL Server Native Client 10.0][SQL Server]fetch: The fetch type refresh cannot be used with forward only cursors.

This suddenly happened for all users. In our acceptance environment, which is completely the same, there is no problem. I can open the AssetTable from the AOT without any problems. There is no weird data in it.

Does this ring a bell with somebody? And that can help me with this error?

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: The fetch type refresh cannot be used with forward only cursors.

I've found the problem & solution:

A user has changed the Stringsize of an EDT AssetName where the Name field of the AssetTable was based on.

I've changed it back and it was solved.
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

RE: The fetch type refresh cannot be used with forward only cursors.

can you check this thread

community.dynamics.com/.../183270

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2

Martin Dráb 228,126 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans