K-Rise Systems

I am trying to use the database inquire service and when I add a group by selection I get the following exception:

System.Exception: ORA-00936: missing expression
ORA-00936: missing expression

When I review the logs it shows that the select statement is missing since I added the group by clause; however when I remove the group by clause the service runs without issue. Is the group by option not working in the inquire service? I did try it in the run query service and it works there so not sure why I get an error when trying to use the inquire service.

Hello Sheryl, I have created task 10493 to resolve this issue. This post will get updated with the revision number once it is done.

Hi Justin,

I just wanted to follow up on this to see if you had any eta on when this might be completed?

Thanks,
Sheryl

Hello Sheryl,

We currently do not have an eta on this issue. You should be able to use the RunQuery service in place of the Inquire service.

This issue was resolved by fixing the query setup. The columns in the Group By clauses needed to be in the results as well.