Technote (troubleshooting)
Problem(Abstract)
Data fetchers hung after running for a while.
Symptom
We are seeing messages like below for the 'hung' data fetchers:-
| 030312 192508: Fetching from TRX_APN has started on Sat Mar 03 19:25:08 EST 2012 Not able to run fetch now or delete on these data fetchers as well. |
The following error is displayed:-
| 030412 212848: Error: Fetching in progress. Please wait until the fetching is done before running on demand fetch again. |
Diagnosing the problem
The following can be observed in the trace.log file:-
| 00000024 databrowser 1 com.micromuse.sla.databrowser.DataBrowserImpl executeQuery ENTER^^T^Error with SQL Syntax or Resync...Io exception: Software caused connection abort: socket write error |
Resolving the problem
The APAR IV01122 allows TBSM to free up connections if they are bad. Even though it was addressed for Oracle connections, it could be applied to any RDBMS as well.
More info can be found here:-
http://www-01.ibm.com/support/docview.wss?uid=swg1IV01122
In this case, you will need to install FP3 & IF3 in order to get this issue resolved.
Details can be found here -> https://www-304.ibm.com/support/docview.wss?uid=swg24028263
You may contact IBM Support for further info/assistance.
Product Alias/Synonym
TBSM
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.