2 Replies Latest reply on Dec 5, 2011 6:02 AM by AdamWilden

    Overflow Error

    Expert

      Hi,

       

      I've been trying this morning to create a grouped query showing average time to close for each Incident category.

       

      Whenever I run this on any real data I get "Results view encountered the following error and cannot run:  OCI-22053: overflow error"

       

      The query is set up on Incident Resolution and grouped by Incident Category Title.

       

      We have a Business hours to close attribute which is Int16 and we are trying to use this to get a mean figure.

       

      We have backfilled thsi attribute with "0" and if we run against any resolutions that are 0 it's OK.  But when we run againsta more recent resolutions which have real values (mostly between 0 and 100) we get the error.

       

      Query also runs fine if I simply remove the Mean aggregate function.

       

      Our Service Desk need this info fairly quickly so any help is much apprecieated.

       

      v7.4 on Oracle.