Error - Cannot select a record in Table. SQL Database has issued an error

(0) Share

Report

Posted on by Community Member

Hi Community,

can anybody give me a good tip on how to fix this Problem ?

I synchronized, compiled and restored the table. Closed and opened AX. Restarted the AOS, but this Problem won't go away.

14830.Error1.PNG

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Heinz Schweda 1,367 on at

Like (1)

Report

Hello, i'm not sure, bute maybe "return" is marked as a reserved word, and you are not allowed to create a field named "return". Try to rename your field.

Was this reply helpful? Yes No
Verified answer

Amir Kaftari 210 on at

Like (1)

Report

See this links :

https://community.dynamics.com/ax/f/33/t/245646

dynamicsuser.net/.../direct-sql-cannot-select-a-record-in-the-sql-database-has-issued-an-error

Was this reply helpful? Yes No
Crisanto Bugarin 20 on at

Like (0)

Report

Check same query in SQL, maybe it returns error because of some reason ex. field not exist

Was this reply helpful? Yes No