SST Operations Bridge Troubleshooting Guide, Version 1.1

Troubleshooting SST/OB Application Server 13
3-4 Increasing the Log File Size
The log file size should be increased if the SST/OB database has a large number of update, delete, or insert
transactions. Use the SST/OB Configuration Client to increase the maximum log file size.
Select the parameter Maximum Logfile Size (KB) and change the Value to the required log file size in the Settings
area. Click on the Save button to save the changes.
Changes will be effective only after restarting the service.
3-5 Gather Service Log Warning Message
This topic provides information on how to troubleshoot the Gather Service Log tag mismatch warning message
from the host.
Incoming message from host: \ABCS7:69.111.111.111:7816 has a tag mismatch. Discarded
This warning message id displayed when the backend receives a data request from two front-end Gather
services. To remove the warning, stop the Gather service running on the machine on which the warning is
received.
3-6 Processor Service Error Message
Follow the steps provided below to troubleshoot the following error messages in the Processor Service:
For Policy View
Jun 08, 2009 14:54:29 003EC0 ERROR SLA: Unable to execute SQL. Details: (
Return code: -1 -> State: S0002, Native: 208) : [Microsoft][ODBC SQL Server
Driver][SQL Server]Invalid object name 'CENTRALVIEW_17'.
This message means that an inactive view has been created, i.e., while creating a view the Inactive option was
selected.
For Local View
Jun 08, 2009 15:12:58 003EC0 WARNING Deadlock was detected (policy execution).
retrying execution for 1 time(s). The SQL being executed: INSERT INTO
#ATMPOLRESULTSET SELECT DISTINCT FAULTS.[AtmKey] AS 'AtmKey' FROM
ATMPROFILES,FAULTS WHERE ATMPROFILES.AtmKey = FAULTS.AtmKey AND ( ( (
FAULTS.[FaultId] ) IN ( 1051104800004,1050105000177,1051104800003 ) ) AND ( (
FAULTS.[FaultStatus] ) = ( '1' ) ) AND ( ( ATMPROFILES.[BlackListed] ) = ( '0'
) ) )
The correspondingly Gather Service will log the following message:
Jun 08, 2009 17:55:39 00365C ERROR Error in ProcessDeletedATMs: Failed to
execute query for for delete(policy views). More information: Error during query
execution(qrt). More information: State:S0002,Native:208,Origin:[Microsoft][ODBC
SQL Server Driver][SQL Server]
, Invalid object name 'CENTRALVIEW_17'.
Jun 08, 2009 17:55:39 00365C ERROR Failed to process deleted terminals for
node: \ABCS7.
To resolve the problem follow the steps below:
1. Login to SST/OB Client.
2. Select the View/Policy configured as Inactive.
3. Modify the Inactive View/Policy to Active.
4. Restart the Processor service to check the response immediately, otherwise, the information will be updated
in a few minutes and no more error messages will be logged in the Processor service.
Troubleshooting SST/OB Application Server