Investigating Why it Happened

System Monitor

This will often happen if the ServiceOptimizer software has been upgraded but DBInstall has not been run.

The port numbers that are being used are held in the database. SQL for finding the ports in use is given below - look for the entries for the appropriate component

select sp400.component_id, sp409.port_no
from sp400_components sp400, sp409_component_ports sp409
where sp400.component_no = sp409.component_no;

Ensure the ports allocated are not in use elsewhere.

The username that the API Agent uses to connect to other processes (such as authenticating to an FRU) does not exist. There is an sp083_system_parameters value that holds the username that the API agent uses to connect to the FRU processes.  to give the user id that is needed.  NB. A default is set up, but this value may be changed if required.

select value from sp083_system_parameters where name = 'apia_spuserid';
select user_id from sp085_users;

The travel matrix is not set up correctly. See Travel Time Estimates.

The value of the travel_matrix parameter will give the file name (including extension) and the full path to the travel matrix .tm2 file.   SQL to find where the Travel Matrix is expected to be found is given below

select value from sp083 where name = 'travel_matrix'; //Check the global set up for Travel Matrix
 
select resp_unit_ref, value from sp213, sp058 where sp058.resp_unit_no = sp213.resp_unit_no
AND name = 'travel_matrix'; //Check if there are any per FRU overrides in place.

Verify that the travel matrix full path and name matches the relevant database entry.  If they do not, either the DB should be updated or the travel matrix file moved.