Clarity Service Management

Expand all | Collapse all

Getting 'AHD05800' error when using timespan in stored query

Jump to Best Answer
  • 1.  Getting 'AHD05800' error when using timespan in stored query

    Posted 07-11-2017 03:14 AM

    I created a timespan with +1 as trigger time and +3 as end time.

    When I use this timespan in a stored query as 'sched_start_date < EndAtTime(\'Next_3Days\')', I get error 'AHD05800:Bad where clause. invalid constraint. Check data types of referenced attributes'.

    Any ideas what could be causing this?



  • 2.  Re: Getting 'AHD05800' error when using timespan in stored query

    Posted 07-11-2017 03:30 AM

    Is this a typo ? Shoudn't it be sched_start_date < EndAtTime(\'Next_3Days\') ?

    What is the error message in the stdlog say ?



  • 3.  Re: Getting 'AHD05800' error when using timespan in stored query

    Posted 07-11-2017 03:51 AM

    Sorry, that was typo. Have edited it now.

    This is the error in the stdlog. 

    timespan.c             314 Unable to locate timespan (Next_3Days) index; (0)

    I double checked and the timespan with the mentioned name does exist.



  • 4.  Re: Getting 'AHD05800' error when using timespan in stored query

     
    Posted 07-11-2017 04:54 AM

    Hi,

     

    Please attach a screenshot of the timespan definition.

     

    Regards,

    James



  • 5.  Re: Getting 'AHD05800' error when using timespan in stored query

    Posted 07-11-2017 08:08 AM



  • 6.  Re: Getting 'AHD05800' error when using timespan in stored query

    Posted 07-11-2017 09:20 AM

    have you tried to use code then?

    sched_start_date < EndAtTime(\'TSPAN3DAY\')


  • 7.  Re: Getting 'AHD05800' error when using timespan in stored query

    Posted 07-11-2017 09:23 AM

    Yes. Gives the same error.



  • 8.  Re: Getting 'AHD05800' error when using timespan in stored query
    Best Answer

    Posted 07-11-2017 09:37 AM

    oh, as a last hope, have you tried to rename timespan? maybe symbol have spaces or any other invisible chars?



  • 9.  Re: Getting 'AHD05800' error when using timespan in stored query

    Posted 07-12-2017 04:01 AM

     

    This worked. Should have checked for the spaces. Completely missed it.

    Thanks for pointing it out!



  • 10.  Re: Getting 'AHD05800' error when using timespan in stored query

    Posted 07-11-2017 10:11 AM

    I got the same error message when I clicked <save>, but I retyped the Where Clause and copied & pasted Time Span Symbol from the created Time Span Detail screen, it was fixed. If Time Span Symbol name is not exactly same as the created one, the error will appear. As Timur mentioned, the Time Span symbol may contain space or invisible characters... you should try to recreate the Time Span.

     

    Kind regards,

    Kaori



  • 11.  Re: Getting 'AHD05800' error when using timespan in stored query

    Posted 07-13-2017 02:20 PM