Data Source Error Ncwdatasourceexception
Technote (troubleshooting) Problem(Abstract) AEL does not display consistent number of events or appears to be having performance issues. Symptom AEL may display the following message: DATASOURCE_ERROR: A datasource error occurred during processing of Event Data Service request: 'NCWDataSourceException'. Cause One possible cause is that the ObjectServer may be busy. Diagnosing the problem Set WebGUI to debug and the ncw trace log may have entries such as this: [time] [pool-62-thread-13] com.micromuse.ncw.datasource.NCWSimpleOSConnection.handleSQLException SEVERE: HEMDA0240E=Caught an SQL exception. com.sybase.jdbc3.jdbc.SybSQLException [time] [pool-62-thread-13] com.micromuse.ncw.datasource.NCWSimpleOSConnection.handleSQLException FINE: HEMDA0240E com.sybase.jdbc3.jdbc.SybSQLException: ObjectServer is currently busy. Waiting for database locks to be released. at com.sybase.jdbc3.tds.Tds.processEed(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source) at com.micromuse.ncw.datasource.NCWConnectionRequestWorker.getResults(NCWConnectionRequestWorker.java:233) at com.micromuse.ncw.datasource.NCWSimpleSQLQueryConnectionRequestWorker.getSimpleQueryResultList(NCWSimpleSQLQueryConnectionRequestWorker.java:73) at com.micromuse.ncw.datasource.NCWSimpleSQLQueryConnectionRequestWorker.doQuery(NCWSimpleSQLQueryConnectionRequestWorker.java:45) at com.micromuse.ncw.datasource.NCWConnection.handleSimpleSQLQuery(NCWConnection.java:559) at com.micromuse.ncw.datasource.NCWConnection.doQuery(NCWConnection.java:530) at com.micromuse.ncw.datasource.NCWSSDataSource.getResult(NCWSSDataSource.java:1022) at com.micromuse.ncw.datasource.NCWSSDataSource.doQuery(NCWSSDataSource.java:488) at com.ibm.tivoli.ncw.aspect.event.EventSQLWorker.getRowResults(EventSQLWorker.java:333) at com.ibm.tivoli.ncw.aspect.event.TopNEventSQLWorker.run(TopNEventSQLWorker.java:116) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) [time] [pool-62-thread-13] com.micromuse.ncw.datasource.NCWSSDataSource.doQuery SEVERE: HEMDA0157E=A query on data source NCOMS failed. Resolving
subject ] [ author ] Hello Kiran, 1) Check the ncwDataSourceDefinitions.xml in webtop / webgui for the ObjectServer host and port defined. Also the ObjectServer login credentials provided for the same. 2) Check the AEL Preferences in TIP GUI, if the correct ObjectServer name has been selected in the ObjectServer drop down. 3) http://www.ibm.com/support/docview.wss?uid=swg21592541 Check $TIPHOME/properties/objectserver.properties and $TIPHOME/properties/tip.properties, if the credentials are correct. 4) If the problem still persists, then you may run $TIPHOME/bin/confvmm4ncos_full.sh by providing the ObjectServer credentials and restart TIP. See, if you are able to resolve the issue. Thanks & Regards, Ashish Krishnan On Mon, Jun https://netcoolusers.org/archives/users/2012-June/068145.html 11, 2012 at 1:49 PM, Kir at n
[ date ] [ thread ] [ subject ] [ author ] Hi Jeffri/Harin, https://netcoolusers.org/archives/users/2012-June/068237.html >From nco_sql, got the result for the command "select UniqueId_private in (select ChildUniqueId from custom.corr_rel_parent_child where ParentUniqueId='AGG_P:2387407'". and when I try from URL https://server1:16311/ibm/console/webtop/AELView?sql=UniqueId in (select ChildUniqueId from custom.correlation where ParentUniqueId ='AGG_P:2380407')&transientname= test&view=basic&datasource=AGG_V Below error is seen in ncw.0.log: ---------------- [2012-06-20T11:07:28]:INFO:HEMJS0289I:[WebContainer : 17]:Creating transient filter data source test [2012-06-20T11:07:28]:AUDIT:HEMFV0201A:[WebContainer : 17]:Transient Filter 'test' has been deleted by user 'oss'. [2012-06-20T11:07:28]:AUDIT:HEMFV0199A:[WebContainer : 17]:Transient Filter 'test' has been created by user 'oss'. [2012-06-20T11:07:28]:INFO:HEMDA0204I:[pool-49-thread-12]:(SQLException) with request: select Serial from alerts.status where UniqueId_private in (select ChildUniqueId from custom.corr_rel_parent_child where ParentUniqueId='AGG_P:2387407') ; in connection: jdbc:sybase:Tds:fm-tipv:4102 [2012-06-20T11:07:28]:SEVERE:HEMDA0240E:[pool-49-thread-12]:Caught an SQL data source error exception. com.sybase.jdbc3.jdbc.SybSQLException, message=ERROR=Object not found on line 1 of statement 'select Serial from alerts.status where UniqueId_private in (select ChildUniqueId from custom.corr_rel_parent_child where ParentUniqueId='AGG_P:2387407') ;', at or near 'corr_rel_parent_child' [2012-06-20T11:07:28]:SEVERE:HEMDP0032E:[pool-49-thread-12]:An exception was handled whilst processing the Aspect Service. The status code is 'DATASOURCE_ERROR' and the following error message was sent to the client: 'A datasource error occured during processing of Event Data Service request: 'NCWDataSourceException'' ----------------- But if I try this in URL, it works: https://server1:16311/ibm/console/webtop/AELView?sql=UniqueId_private in ('AGG_P:2306712','AGG_P:2665689')&transientname=test&view=basic&datasource=AGG_V regards, Kris On Tue, Jun 19, 2012 at 9:29 PM, Jeffri Abu Bakar