Could not read a hi value - You need to populate spt_syslog_event_sequence , spt_prv_trans_sequence

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

8.4

Hi Everyone

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

Any pointers on it?

2

Hi @2022Sandeep123,

can you share the entire trace of the error?

3

Solved: The error was due to the incorrect database schema imported. Some of the tables were imported with the incorrect value.

Solution: Look at the log carefully and analyze the tables that appear in the logs. Populate them with the value 1 and restart IIQ

4

this is not the solution, It is the basis :rofl:

what are you referring to, can you explain better?

5

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.

1 Like
6

no problem, the important thing is that you solved the problem :wink:

but putting a complete description of the solution could help others with the same problem (even if most open a new topic directly :disappointed:)