Hello,

Looks like a transaction log perfspi.log is corrupted. Does the file exist and what is its size/permissions?

# ls -l /var/opt/OV/NNMPerformanceSPI/database/perfspi.log
-rw-------. 1 root root 771883008 Jun 1 16:18 /var/opt/OV/NNMPerformanceSPI/database/perfspi.log

This is normal output from this file

# $SYB64PATH/dblog  $NPSDataDir/database/perfspi.log
SQL Anywhere Transaction Log Utility Version 16.0.0.2805
File "/var/opt/OV/NNMPerformanceSPI/database/perfspi.log" is a transaction log file
File version is 41
Log starts at offset 0001321835
Log ends at offset 0772953450
Log contains 188448 pages with a page size of 4096 bytes
771631615 bytes in use (99.97%), 251393 bytes free (0.03%)
Current timeline GUID: be85011e-26bd-11ee-8000-d1888df26721
Current timeline UTC creation time: 2023-07-20 19:24:48.211+00:00
Current transaction log GUID: c7ab38a8-26bd-11ee-8000-9f86f2b6bd10
Previous transaction log GUID: be8c7b2e-26bd-11ee-8000-d1888df26721

The best option to solve is to restore a good DB backup if it exists. If backup is not available, I am afraid the only other option is to reset DB which will also destroy all data.

Since DB cannot be started you can run resetSPI.ovpl and choose the option 5. After recreating the DB you could run again resetSPI.ovpl with the option 2 to restore data from archives (/var/opt/OV/NNMPerformanceSPI/EP-Name/archives/metric). The files from archives will be placed back to NNMi shared drive for re-processing. If you have 2 weeks data in archive at least 2 weeks data will be restored.

Best regards,
Sergey