COUNT field incorrect or syntax error

(0) Share

Report

Posted on by Community Member

Good day, I am encountering the issue COUNT field incorrect or syntax error whenever I try to release products. The Form is customized but after debugging using AX debugger there are no errors that occurs because of the code, and it only happens on specific items which has many product variants.

Cannot select a record in <Cannot disclose the table name> Reference 0,0. The SQL database has issued an error.
SQL Error Description: [Microsoft][SQL Server Native Client 11.0]Count field incorrect or syntax error.

Is anyone familiar with this kind of issue? Any advise would be greatly appreciated.

All responses (4)

Answers (0)

Dean Stegmiller on at

Like (0)

Report

RE: COUNT field incorrect or syntax error

Hi Charos,

Were you able to figure this out? If so, please document the fix so if others encounter this it might help them resolve their issue.

Thanks
Martin Dráb 232,871 Most Valuable Professional on at

Like (0)

Report

RE: COUNT field incorrect or syntax error

What exactly do you mean by the end of init()? Isn't there a CoC method or a post-method event handler? And are you sure it's not something executed after init(), such as in run()?

I would start by checking the exception object in the debugger and examining its StackTrace property.
Community Member on at

Like (0)

Report

RE: COUNT field incorrect or syntax error

Hello good day,

The error occurs on the end of the method "init" in SysSetupFormRun class. There is no specific line of code which triggers the error message.
Martin Dráb 232,871 Most Valuable Professional on at

Like (0)

Report

RE: COUNT field incorrect or syntax error

Where exactly is the error thrown from?