Query extended range failure: Right parenthesis expected near pos

(0) Share

Report

Posted on by Pranu

150

Hi,

Is anyone got or is getting errors when opening ledger posting setup (from Project management and accounting -> setup -> Categories -> Project categories -> Setup -> Ledger posting setup)??

I am getting couple of lines with the following error message:

Query extended range failure: Right parenthesis expected near pos 124

Can nay one suggest solution for this

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (2)

Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Press Control + F3 to open the advanced query filters while the form is selected, and see where do you have a query expression. That expression is either broken and missing parenthesis as the error message says, or too long to fit in the query range criteria field. If it does not show any query expressions in the filter screen, the range might be hidden.

In either case you need to get in touch with your technical team to fix it.

Was this reply helpful? Yes No
Pranu 150 on at

Like (0)

Report

Hi Vilmos thanks for the suggestion, i did same thing as you said. But query expression looks fine i guess

Can you please check the expression, let me know if its wrong

Was this reply helpful? Yes No
Vilmos Kintera 46,149 on at

Like (0)

Report

Why do you have 4 quotation marks at the second category relation? That does not seem right.

Was this reply helpful? Yes No
Pranu 150 on at

Like (0)

Report

It has to be 4 quotations, because if i remove 2 quotations then its going to effect on other place. And getting same issue in that place also. Any other solution?

Thanks,

Pranay

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Pranay Reddy,

Did you make some modifications to the project ledger posting framework?

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Hi,

I feel it's a bug on form projPosting as I have the same issue in my system(Ax2012 R3) and we don't have any customizations in this form. Query gets constructed in the method categoryCodeRange on this form.
In method categoryCodeRange, at line#28(as shown below - highlighted in yellow), due to the presence of double quotes, it's causing the issue. Not sure whether it's a known issue, if so please check for any hotfix (or) to fix the problem update the code by removing queryvalue() on variable categoryGroupId(at line#31 - highlighted in orange) :

So change code from

case TableGroupAll::GroupId: range += strFmt('((%1 == %2) && (%3 == "%4")) || ', fieldStr(ProjPosting, CategoryCode), enum2int(TableGroupAll::GroupId), fieldStr(ProjPosting, ProjCategoryRelation), queryValue(categoryGroupId));

to

case TableGroupAll::GroupId: range += strFmt('((%1 == %2) && (%3 == "%4")) || ', fieldStr(ProjPosting, CategoryCode), enum2int(TableGroupAll::GroupId), fieldStr(ProjPosting, ProjCategoryRelation), categoryGroupId);

Was this reply helpful? Yes No
Pranu 150 on at

Like (0)

Report

Agree with chaitanya it's a bug, we are getting this issue in standard AX only. we didn't make any customization on this form

Thanks chaitanya, will try your suggestion.

Thanks,

Pranay

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

What I would like to highlight here is that 4 quotation marks will obviously be interpreted incorrectly.

What you have there as criteria is like this:

IS Table.Field EQUAL to BLANKVALUEBLANKVALUE

It obviously does not make sense, you can only have a single quotation mark. Whatever is getting broken in "the other place", you need to fix it there then, maybe Chaitanya's suggestion will help.

Kindly make both answers as Verified.

Was this reply helpful? Yes No