I have a setup of IIQ 8.4 with p1 and working on it but it’s showing strange behaviour while starting the application and while aggregating the tasks. I am getting a logs like below
Could not read a hi value - You need to populate spt_syslog_event_sequence , spt_prv_trans_sequence
I messed up the setup, and later I started getting errors in the terminal with some tables, such as spt_syslog_event_sequence and spt_prv_trans_sequence, showing the message “Could not read Hi value - You need to populate the tables.” At first, I wasn’t sure what this meant or what was causing the issue.
Afterward, I analyzed the logs one by one and discovered that some tables were generating this error. I then logged into the database, selected the values from the tables, and found that the schema was available, but only the next_value column existed, with no other columns populated.
I listed the tables with unpopulated data, inserted the value “1” in the relevant column, and this action helped populate the tables. Afterward, I was able to resolve the error.
Apologies for not being specific when posting the solution earlier.