Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184

    Unanswered: ROW_NUMBER function fails sometimes with SQL0440N

    The below SQL executes some times and does not execute at other times but fails with SQL0440N error.

    select row_number() over(order by last_reset_timestamp) as number, snapshot_timestamp, last_reset_timestamp, table_schema, table_name, table_type, rows_read, rows_written, overflow_accesses, page_reorgs from snapshot.snapshot_table order by last_reset_timestamp;

    Any idea why?

    TIA.

  2. #2
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    The SQL fails after the system clock of the database server is changed to about 1 year before the current date. After the system clock is switched back to current date, the SQL succeeds.

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Gnanaraj, Thanks for taking time to update the forum.

    Your thoughfulnesss is much appreciated.

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •