Integration between Spectrum and Service Desk stops working, but starts working again after some time, or after recycle of Spectrum Tomcat Service.
Aug 21, 2015 14:30:15.207 - Error occurred while attempting to create a ticket in Service Desk.
Manually trying to open tickets, receives error:
SPC-OCC-10262: Error launching
And under catalina.out/stdout.log file found following error msg:
Aug 21, 2015 15:12:45.646 - Error occurred while creating a request/problem/incident. AxisFault
After enable debug at Service Desk side, it shows following error under log file:
09/04 16:31:23:36 PRDSDMSC1 domsrvr 9552 ERROR sec_mgr.c 4475
Error in DomSession 538612839 in method session_registered: 10 register_session_user failed;
This is usually related to the session_log table having a session number which had already been used previously.
In case it is not possible to run an archive/purge on session_log table, the following is suggested:
1. Install the following variable in NX.ENV:
This setting disables sesssion_log table entries - that is, any new logins will not be added to the table.
2. Here are the commands to be executed at Service Desk side:
pdm_options_mgr -c -s SESSION_LOG_EXCLUDE -v ALL -a pmd_option.inst
pdm_options_mgr -c -s SESSION_LOG_EXCLUDE -v ALL -a pmd_option.inst -t
3. Service Desk must be restarted after running these commands.