Database Upgrade Fails

Started by murtalit, April 11, 2026, 05:32:12 AM

Previous topic - Next topic

murtalit

Hi,

when I tray to upgrade the database, I'll get the following error:

Upgrading database...
Upgrading from version 60.7 to 60.8
SQL query failed (BIGINT value is out of range in '`netxms`.`raw_dci_values`.`last_poll_time` * 1000'):
UPDATE raw_dci_values SET last_poll_time = last_poll_time * 1000, cache_timestamp = CASE WHEN cache_timestamp > 1 THEN cache_timestamp * 1000 ELSE cache_timestamp END
Rolling back last stage due to upgrade errors...
Database upgrade failed

How can I fix this ?
Thank you

Filipp Sudanov

Which database you are using?