Skip to main content
V
vikrams247
June 14, 2022
Question

Date out of Date out of range (-740126)

  • June 14, 2022
  • 4 replies
  • 1 view

Hi All,

We are using Orcle Database for our DB in Appian. Recently, our client want to display last updated record at the Top on Grid list. In order to fullfill this we introduce the UpdateOn[Oracle datatype date and Appian Datetime] column in our table, as we have more older record, it was hard to show updateOn date on them. We copied Created date[datatype Date in Oralce and  In Appian Datatime]. We see there are lot of record( more than 12000) which display date out of Range on updateOn column in Appian. Kindly see below.

Date out of range (-739921)

Date out of range (-739921)

3/10/2009 2:06 PM EDT

3/11/2009 3:10 PM EDT

Kindly help me here.

Regards,

    4 replies

    mikes0011
    mikes0011
    Brainy
    June 14, 2022

    In the DB itself, do those rows have valid dates?  As opposed to, say, NULL values?  In what manner was this data originally populated?  If you manually edit the value found in the target column of one of those rows, directly in the DB, does it fix the front-end output from Appian?

    The Expression Guru
    V
    vikrams247Author
    July 11, 2022

    Hi Mike,

    Thank you. This was Out DB issue and most was bad data. This has been take care by our DB team.

    davel001150
    davel001150
    June 14, 2022

    Since the values are different, I assume this has to be a casting or transformation error.  Perhaps it's presented to a rule in one format, saved in another, sent to the database in another, and then you try to cast it as a date, and Appian breaks. 

    What if, for instance, something misinterpreted 08/26/2008 as 8 divided by 26 further divided by 2008, or 8,262,008?  What if the timestamps rolled into some faulty calculation?  Are they a Date column in the database, or a Date and Time column?

    By the way, todate(-73992) comes out to a date in 1832, about 190 years ago.  So if Appian accepted these dates, they'd be somewhere in the first or second century AD, around 1900 years ago.

    V
    vikrams247Author
    July 11, 2022

    Thank you [mention:f392a8ed25f84233ae21b9c8ffc07b88:e9ed411860ed4f2ba0265705b8793d05] for your kind reply. this was happening due to bad data and has been taken care by our DB team.

    Terms & ConditionsAccessibility statement