After Raptor DB migration list shows no data with timestamp out of range when using function field with datediff - Support and Troubleshooting

After Raptor DB migration list shows no data with timestamp out of range when using function field with datediff Issue .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Function field datediff fails with ERROR: timestamp out of range when the difference between the 2 values is very huge (e.g. 2025-12-05 and 9999-09-09) in Raptor DB.

Please note that the error might not be displayed on the list view. Please check localhost log as well.

localhost log:

2026-02-03 23:59:13 (985) Default-thread-115 CC9C60AA3B72F210A2394C8693E45ABF txid=6772386a3bb2 Table SEVERE *** ERROR *** query exception: com.glide.db.GlideSQLException: FAILED TRYING TO EXECUTE ON CONNECTION glide.0 (connpid=3756292): SELECT u_test_duration0."sys_id", u_test_duration0."u_d1", u_test_duration0."sys_updated_by", u_test_duration0."sys_created_on", u_test_duration0."sys_mod_count", u_test_duration0."sys_updated_on", u_test_duration0."sys_created_by", u_test_duration0."u_d2", /*db_function*/(DATE_TRUNC('SECOND', u_test_duration0."u_d1") - DATE_TRUNC('SECOND', u_test_duration0."u_d2") + to_timestamp('1970-01-01', 'YYYY-MM-DD HH24:MI:SS'))/*end_db_function*/ AS u_d3 FROM u_test_duration u_test_duration0 LIMIT 20 OFFSET 0 General Data Exception detected by database (ERROR: timestamp out of range)

Placeholders follow:

at com.glide.db.DBIError.wrapAndThrow(DBIError.java:169) at com.glide.db.DBIError.handleException(DBIError.java:102) at com.glide.db.DBI.executePreparedStatement(DBI.java:1158) at com.glide.db.DBQueryExecutor.executePrepared(DBQueryExecutor.java:507) at com.glide.db.DBQueryExecutor.executeStatement(DBQueryExecutor.java:380) at com.glide.db.DBQueryExecutor.executeStatement(DBQueryExecutor.java:369)

...

Facts .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Steps to reproduce:

1. Select All -> sys_db_object.LIST 2. Click New 3. Enter the following and click Submit Label: test_duration Name: u_test_duration

4. Select All -> sys_dictionary.LIST 5. Click New 6. Enter the following to create a date type field and click Submit Table: test_duration [u_test_duration] Type: Date Column label: d1 Column name: u_d1

7. Click New to create another date type field 8. Enter the following and click Submit Table: test_duration [u_test_duration] Type: Date Column label: d2 Column name: u_d2

9. Click New 10. Enter the following to create a function field and click Submit Table: test_duration [u_test_duration] Type: Duration Column label: d3 Column name: u_d3 Function field: Checked Function definition: glidefunction:datediff(u_d1,u_d2)

11. Select All -> u_test_duration.LIST 12. Enter the following and click Submit. d1: 2026-01-28 d2: 2026-01-27 13. Confirm that you can see the following in the list d1 d2 2026-01-28 2026-01-27

14. Click New again 15. Enter the following and click Submit. d1: 2026-01-27 d2: 9999-09-09

16. You can see no data was shown in the list.

Release .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } All Releases

Cause .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } The input 9999-09-09 is too big.

Resolution .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: #000000; } span { font-size: 12pt; font-family: Lato; color: #000000; } h2 { font-size: 24pt; font-family: Lato; color: black; } h3 { font-size: 18pt; font-family: Lato; color: black; } h4 { font-size: 14pt; font-family: Lato; color: black; } a { font-size: 12pt; font-family: Lato; color: #00718F; } a:hover { font-size: 12pt; color: #024F69; } a:target { font-size: 12pt; color: #032D42; } a:visited { font-size: 12pt; color: #00718f; } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Change 9999-09-09 which is too big to smaller value like 2999-09-09