Error: "... Failed while executing Ad-hoc Report: Execution of the query '/report/adhocreports/queries/templatequeries/IssueDump' failed ..." When Running Issues Listing Report (Doc ID 2055862.1)

Last updated on JANUARY 08, 2016

Applies to:

Instantis EnterpriseTrack - Version 9.0.0.0 and later
Instantis EnterpriseTrack Cloud Service - Version 9.0.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the Issues Listing Report in the Adhoc Reports, the following error occurs.

Ad-hoc report error: Failed while executing Ad-hoc Report: Execution of the query '/report/adhocreports/queries/templatequeries/IssueDump' failed. The error was: You're trying to use a column value as a number, but it cannot be converted to a number. This can occur, for example when doing a numerical sort on a column that contains values that are not numbers or similarly when doing numerical operations in the "Select Rows Expression" on values that are in fact, not numbers.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms