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

(0) Share

Report

Posted on by Community Member

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?

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Member 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.

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No