Topic
2 replies Latest Post - ‏2012-12-17T09:10:06Z by SystemAdmin
SystemAdmin
SystemAdmin
1632 Posts
ACCEPTED ANSWER

Pinned topic Problems with query tuner java exception

‏2012-11-06T13:27:02Z |
Using DS 311 full clent on windows and trying to tune the following query .
USing Zlinux 64 .
akasfed is a nickname

I get the following , Any idea thks
amr

SELECT ano.ano_uuid
FROM akasfed.t_anomalies ano,
a012.t524 occLine
WHERE ano.lifecycle_stage != 'R'
AND occLine.atceta IN ( '3', '4' )
AND Substr(ano.brv_code, 1, 5) = 'OCC_E'
AND ano.detector = 'BATCH'
AND EXISTS (SELECT 1
FROM akasfed.t_anomalies_param param
WHERE param.ano_uuid = ano.ano_uuid
AND param.name = '$occupationId'
AND Integer(param.VALUE) = Integer(occLine.atnsco))

Index advisor failed

Exception Message:
java.lang.reflect.InvocationTargetException

Exception Stack Trace:
java.lang.reflect.InvocationTargetException

at com.ibm.datatools.dsoe.ui.wf.review.ReviewSingleQuerySummaryReportView$GenerateSummaryReportProgress.run(Unknown Source)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(Unknown Source)

Caused by: java.lang.Exception: java.lang.Exception: Failed to generate the tuning summary report.
Refer to Error Log for more information.
Input stream to SCAN error

at com.ibm.datatools.dsoe.tuningreport.api.TuneAndReport.runApi(Unknown Source)

... 2 more

Caused by: java.lang.Exception: Failed to generate the tuning summary report.
Refer to Error Log for more information.
Input stream to SCAN error

at com.ibm.datatools.dsoe.tuningreport.htmlgenerator.HTMLReport.<init>(Unknown Source)

... 3 more

Caused by: java.lang.Exception: Input stream to SCAN error

at com.ibm.datatools.dsoe.tuningreport.htmlgenerator.HTMLReport.loadExplainReport(Unknown Source)

at com.ibm.datatools.dsoe.tuningreport.htmlgenerator.HTMLReport.loadAnalysisResults(Unknown Source)

... 4 more

Caused by: com.ibm.datatools.dsoe.tuningreport.exception.JoinReportException

at com.ibm.datatools.dsoe.tuningreport.accessoperation.impl.JoinOperationImpl.getJoinInfo(Unknown Source)

at com.ibm.datatools.dsoe.tuningreport.accessoperation.impl.JoinOperationImpl.generateJoinTableInfo(Unknown Source)

at com.ibm.datatools.dsoe.tuningreport.reportgenerator.ReportGenerator.generateJoinOperationReportLUW(Unknown Source)

at com.ibm.datatools.dsoe.tuningreport.reportgenerator.ReportGenerator.generateAllReportsLUW(Unknown Source)

... 6 more

java.lang.Exception: java.lang.Exception: Failed to generate the tuning summary report.
Refer to Error Log for more information.
Input stream to SCAN error

at com.ibm.datatools.dsoe.tuningreport.api.TuneAndReport.runApi(Unknown Source)

at com.ibm.datatools.dsoe.ui.wf.review.ReviewSingleQuerySummaryReportView$GenerateSummaryReportProgress.run(Unknown Source)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(Unknown Source)

Caused by: java.lang.Exception: Failed to generate the tuning summary report.
Refer to Error Log for more information.
Input stream to SCAN error

at com.ibm.datatools.dsoe.tuningreport.htmlgenerator.HTMLReport.<init>(Unknown Source)

... 3 more

Caused by: java.lang.Exception: Input stream to SCAN error

at com.ibm.datatools.dsoe.tuningreport.htmlgenerator.HTMLReport.loadExplainReport(Unknown Source)

at com.ibm.datatools.dsoe.tuningreport.htmlgenerator.HTMLReport.loadAnalysisResults(Unknown Source)

... 4 more

Caused by: com.ibm.datatools.dsoe.tuningreport.exception.JoinReportException

at com.ibm.datatools.dsoe.tuningreport.accessoperation.impl.JoinOperationImpl.getJoinInfo(Unknown Source)

at com.ibm.datatools.dsoe.tuningreport.accessoperation.impl.JoinOperationImpl.generateJoinTableInfo(Unknown Source)

at com.ibm.datatools.dsoe.tuningreport.reportgenerator.ReportGenerator.generateJoinOperationReportLUW(Unknown Source)

at com.ibm.datatools.dsoe.tuningreport.reportgenerator.ReportGenerator.generateAllReportsLUW(Unknown Source)

... 6 more
Updated on 2012-12-17T09:10:06Z at 2012-12-17T09:10:06Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1632 Posts
    ACCEPTED ANSWER

    Re: Problems with query tuner java exception

    ‏2012-11-06T18:29:18Z  in response to SystemAdmin
    Hi,

    Is it possible for you to send me the DDLs using in your query? Please send to mjou@us.ibm.com.

    Thanks,

    Michelle
  • SystemAdmin
    SystemAdmin
    1632 Posts
    ACCEPTED ANSWER

    Re: Problems with query tuner java exception

    ‏2012-12-17T09:10:06Z  in response to SystemAdmin
    Sorry for late response. We weren't able to reproduce your problem based on your DDLs. If the problem is still here, would you help get the access plan for further analysis? And an entire trace would be much helpful.
    1. Collect the access plan.
    1) If you can run Access Plan Graph successfully, it's simple to get the access plan file by using the "save" button on the screenshot (attached)
    2) Send the .xml file to liuljun@cn.ibm.com
    2. collect the trace file.
    1) Open the Data Studio client that you use for query tuning.
    2) Open the Query Tuner preferences page by clicking Window > Preferences > Data Management > Query Tuner.
    3) Ensure that the trace option is enabled, click Clear Trace to remove previous trace information, and specify a directory for the trace files.
    4) Remove all existing Query Tuner trace information by clicking Clear Trace.
    5) Specify a directory to store the trace files and then click OK.
    6) Re-create the Query Tuner problem to record the Query Tuner trace information.
    7) Open the directory which shown in the preference page, sort the files by "Date Modified" to find the latest trace file, then send the file to liuljun@cn.ibm.com (It is better to compress the file in zip format).