itrprof SQL Analyzer 6.2.7 Error Codes Manual


info@ubTools.com
http://www.ubTools.com

 

 

itrprof SQL Analyzer Error Codes

Error Message Text
itp-01 [0,1] : Wrong value. Cause       : <error message>
Action      : Enter correct value.
itp-01 [4,5] : Wrong value. Cause       : Zero or negative value entered.
Action      : Enter pozitive value.
itp-02 [0] : Wrong file. Cause       : Main file name not entered.
Action      : Enter main file name.
itp-02 [1] : Wrong file. File name   : <file_name>
Cause       : Tried to analyzer non-exsisting file or file length is zero.
Action      : Analyze exsisting file or non-empty file.
itp-02 [2] : Wrong file. File name   : <file_name>
Causes      : - File is not an SQL_TRACE/Event10046 raw (unformatted) trace file.
             - File format is not a TEXT, ZIP or GZIP format.
             - There is no SQL statement in the trace file.
Action      : Analyze proper SQL_TRACE/Event10046 raw (unformatted) trace file.
itp-04 [0] : IO error. Causes      : <error message>
Actions     : - Re-try after fixing the error.
             - Contact support.
itp-04 [2..4] : IO error. File name   : <file_name>
Line        : <line>
Line Number : <line_number>
Cause       : <error message>
Actions     :- Re-try after fixing the error.
             - Contact support.
itp-04 [7] : IO error. Cause       : Unable to create directory on server side.
Action      : Contact support.
itp-04 [8] : IO error. Cause       : Unable to create output file on server side.
Action      : Contact support.
itp-05 [0]  : File corrupted. File name   : <file_name>
Cause       : SQL statement length is higher or file is truncated.
Actions     : - Increase MAX_DUMP_FILE_SIZE parameter.
              - Analyze proper file.
itp-05 [1..9,12]  : File corrupted. Causes      : - Non-numeric or too big value is encountered.
              - Line format is wrong.
Actions     : - If abnormally too big value is encountered, check Oracle bugs.
              - Analyze proper file.
itp-05 [10,11]  : File corrupted. File name   : <file_name>
Line        : <line>
Line Number : <line_number>
Causes      : - Non-numeric or too big value is encountered.
              - Line format is wrong.
Actions     : - If abnormally too big value is encountered, check Oracle bugs.
              - Analyze proper file.
itp-05 [13]  : File corrupted. Cause       : Bind has already got data type.
Action      : Analyze proper file.
itp-05 [14]  : File corrupted. Cause       : Cursor not found.
Actions     : - Don't enable trace from other session. If it's not possible, enable trace when session is idle.
              - Analyze proper file.
itp-05 [15,19]  : File corrupted. Cause       : No bind found.
Action      : Analyze proper file.
itp-05 [16]  : File corrupted. Cause       : Parent statistic id not found.
Action      : Analyze proper file.
itp-05 [17]  : File corrupted. Cause       : Bind has already got value.
Action      : Analyze proper file.
itp-05 [18]  : File corrupted. Cause       : Statistic id already exists.
Action      : Analyze proper file.
itp-05 [20]  : File corrupted. Cause       : No bind list found.
Action      : Analyze proper file.
itp-10 [0] : Internal error. Cause       : Unable to find uploaded file.
Action      : Contact support.
itp-10 [1] : Internal error. Cause       : Negative value encountered.
Action      : Contact support.
itp-10 [2] : Internal error. Cause       : Unknown class encountered.
Action      : Contact support.
itp-10 [3] : Internal error. File name   : <file_name>
Line        : <line>
Line Number : <line_number>
Cause       : Different lines have same line number.
Action      : Contact support.
itp-10 [4] : Internal error. File name   : <file_name>
Line        : <line>
Line Number : <line_number>
Cause       : Cursor operation does not have parent PARSING IN CURSOR.
Action      : Contact support.
itp-10 [6] : Internal error. File name   : <file_name>
Line        : <line>
Line Number : <line_number>
Cause       : Unable to access parsed statement definition.
Action      : Contact support.
itp-10 [7,8] : Internal error. File name   : <file_name>
Line        : <line>
Line Number : <line_number>
Cause       : Unable to remove the cursor.
Action      : Contact support.
itp-10 [13] : Internal error. File name   : <file_name>
Line        : <line>
Line Number : <line_number>
Cause       : Existing cursor not found.
Action      : Contact support.
itp-10 [14] : Internal error. File name   : <file_name>
Line        : <line>
Line Number : <line_number>
Cause       : Histogram count is zero, its time is not zero.
Action      : Contact support.
itp-10 [15] : Internal error. File name   : <file_name>
Line        : <line>
Line Number : <line_number>
Cause       : Wait count is zero, its time is not zero.
Action      : Contact support.
itp-10 [16,17] : Internal error. File name   : <file_name>
Line        : <line>
Line Number : <line_number>
Cause       : Existing histogram not found.
Action      : Contact support.
itp-10 [18,19] : Internal error. File name   : <file_name>
Line        : <line>
Line Number : <line_number>
Cause       : Existing wait not found.
Action      : Contact support.

 

 

itrprof SQL Analyzer 6.2.7 Error Codes Manual


info@ubTools.com
http://www.ubTools.com