FAW Query Error - Provide End Users Meaningful Error Messages

User_FHEU5

When end users create FAW reports, they will frequently encounter issues that cause query errors.

For example. The user adds a column/row to a report that causes the following error:

"State: HY000. Code: 14081. [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references:"

This line will include information which reference(s) should be removed to allow the report to run.

That's fine for technical people who understand how to get to this information by clicking on the More Detail link.

An end user is not going to do this, but even if they did, clicking "More Detail" will overwhelm them.

To fix this error all the user needs to do is remove one of the data sets they added, but this is not presented in a way that is easy for them to understand.

A better experience would be if as well as the technical error message and link to more detail, the solution was listed on the same page.

For example, below the message "Query Error" you could list possible solutions:

You may be able resolve this error if you remove one of the following column references:
Balancing Segment.Balancing Segment Code
Balancing Segment.Balancing Segment Value Set Code
Cost Center.Cost Center Key
Cost Center.Cost Center Name
Cost Valuation Unit.Valuation Unit

In other words, something like this:

Instead of what they are shown now:

The idea behind this is end users would not have to contact an IT Department to find simple solutions to error messages.