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.

I have the same question (0)

All responses (4)

Answers (0)

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Where exactly is the error thrown from?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Dean Stegmiller on at

Like (0)

Report

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

Was this reply helpful? Yes No