Siebel Tools >  SBL-DBX-00083: Unable to start due to incorrect system preference setting

SBL-DBX-00083: Unable to start due to incorrect system preference setting

This error has already been covered in another post here.

This time the error occurred again and the old solution did not work. It seems that there was something

wrong in our settings. Oracle support web says in Doc ID 477173.1

  1.  Go to "Administration - Application -> System Preferences"
  2.  Query for : "Docking: Transaction Logging" parameter and change the value to "True"
  3.  Restart the Siebel Server
  4.  Restart the "Transaction Processor" component.

 

Well I went to the screen and found that the settings were correct and we still had this error.

Siebel System Preferences

After some searching, I found that this screen shows results from table S_SYS_PREF.

So I ran this query

Select * from siebel.S_SYS_PREF where sys_pref_cd like 'Docking%';

Surprising, there were two rows. Both Parameter were the same except one had one extra empty space!

 

s_sys_pref 

 

And the new line was inserted by SADMIN by some automatic process!

Anyways the solution was to run an sql and update both parameters to TRUE.

 

update siebel.S_SYS_PREF

set val = 'TRUE' where sys_pref_cd like 'Docking%';

commit;

 

I still do not know what happened. It could be a siebel bug as there are others in the internet who had the same problem.